SQL/MX 3.2.1 Guide to Stored Procedures in Java (H06.26+, J06.15+)

Contents
About This Manual........................................................................................7
Supported Release Version Updates (RVUs)..................................................................................7
Audience.................................................................................................................................7
Related Documentation..............................................................................................................7
New and Changed Information..................................................................................................9
Changes to the 540433-001 Manual...................................................................................11
Document Organization..........................................................................................................11
Examples in This Manual.........................................................................................................11
Notation Conventions..............................................................................................................12
Hypertext Links..................................................................................................................12
General Syntax Notation....................................................................................................12
Notation for Messages.......................................................................................................14
Notation for Management Programming Interfaces.................................................................15
Change Bar Notation..............................................................................................................15
Publishing History...................................................................................................................15
HP Encourages Your Comments................................................................................................16
1 Introduction.............................................................................................17
What Is an SPJ?.....................................................................................................................17
How Do I Use SPJs?................................................................................................................18
Benefits of SPJs.......................................................................................................................19
Java Methods Callable From NonStop SQL/MX.....................................................................19
Common Packaging Technique............................................................................................20
Security............................................................................................................................20
Increased Productivity.........................................................................................................20
Portability.........................................................................................................................20
SPJs in NonStop SQL/MX........................................................................................................21
Effect of Registering an SPJ..................................................................................................21
Effect of Invoking an SPJ.....................................................................................................22
Invoking Different Types of SPJs............................................................................................23
The SPJ Environment................................................................................................................24
SQL/MX UDR Server Process...............................................................................................25
Multithreading in an SPJ Environment...................................................................................27
Class Loaders in an SPJ Environment....................................................................................28
Application Classes That an SPJ Can Access.........................................................................29
Maintaining Class and JAR Files in an SPJ Environment...........................................................30
2 Getting Started........................................................................................32
Software Requirements............................................................................................................32
NonStop Server for Java.....................................................................................................33
JDBC/MX Driver................................................................................................................33
Verifying Software Versions......................................................................................................33
Verifying the SQL/MX UDR Server.......................................................................................33
Verifying the NonStop Server for Java...................................................................................34
Verifying the JDBC/MX Driver..............................................................................................34
Configuring the SPJ Environment on Systems Running H-Series RVUs..............................................35
JREHOME Setting for the NonStop Server for Java.................................................................35
Java Library Path for the JDBC/MX Native Library..................................................................35
UDR Extensions Class Path for the JDBC/MX JAR File..............................................................36
Controlling JVM Startup Options...............................................................................................36
JVM Startup Options for All Processes on a Node..................................................................36
JVM Startup Options for Each SPJ Caller...............................................................................37
Contents 3