Neoview Guide to Stored Procedures in Java (R2.5)

Connection Pooling....................................................................................................................28
Using JDBC Method Calls...............................................................................................................29
Referring to Database Objects in an SPJ Method............................................................................30
Exception Handling.........................................................................................................................31
Handling Java Exceptions.....................................................................................................................31
User-Defined Exceptions.................................................................................................................31
Compiling and Packaging Java Classes................................................................................................31
4 Deploying SPJ JAR Files on the Neoview Platform....................................................33
Upload a JAR File..................................................................................................................................33
Download a JAR File.............................................................................................................................34
Rename a JAR File.................................................................................................................................34
Delete a JAR File...................................................................................................................................35
5 Creating SPJs in the Neoview Database...................................................................37
Required Privileges for Creating or Dropping an SPJ..........................................................................37
Create a Procedure................................................................................................................................37
Use the Create Procedure Dialog Box...................................................................................................39
Use a Method in a Procedure................................................................................................................39
Drop a Procedure..................................................................................................................................40
Display Procedures and Their Properties.............................................................................................41
Using HPDM to Display Procedures in a Schema..........................................................................41
Attributes Tab.............................................................................................................................42
Parameters Tab...........................................................................................................................43
Usage Tab...................................................................................................................................43
Privileges Tab.............................................................................................................................43
Using NCI to Display Procedures in a Schema...............................................................................44
Altering an SPJ and Its Java Bytecode..................................................................................................44
6 Granting Privileges for Executing SPJs.......................................................................47
Granting Privileges on an SPJ...............................................................................................................47
Granting Privileges on Referenced Database Objects..........................................................................48
Revoking Privileges on an SPJ..............................................................................................................48
Using Script Files to Grant and Revoke Privileges...............................................................................49
Script File for Granting Privileges...................................................................................................49
Script File for Revoking Privileges..................................................................................................49
7 Executing SPJs..............................................................................................................51
Required Privileges for Calling an SPJ.................................................................................................51
Transaction Behavior............................................................................................................................51
Transaction Statements or Methods in an SPJ Method...................................................................51
Committing or Rolling Back a Transaction.....................................................................................51
Multithreading......................................................................................................................................52
Using the CALL Statement...................................................................................................................52
Specifying the Name of the SPJ.......................................................................................................52
Listing the Parameter Arguments of the SPJ...................................................................................52
Data Conversion of Parameter Arguments................................................................................53
Input Parameter Arguments......................................................................................................53
Output Parameter Arguments...................................................................................................53
Result Sets...................................................................................................................................54
Calling SPJs in NCI...............................................................................................................................54
Using Named Parameters................................................................................................................54
4 Table of Contents