SQL/MX Guide to Stored Procedures in Java (H06.04+, J06.03+)

Contents
HP NonStop SQL/MX Guide to Stored Procedures in Java—540433-003
ii
2. Getting Started
2. Getting Started
Software Requirements 2-1
NonStop Server for Java
2-2
JDBC/MX Driver
2-2
Verifying Software Versions
2-2
Verifying the SQL/MX UDR Server
2-3
Verifying the NonStop Server for Java
2-3
Verifying the JDBC/MX Driver
2-4
Configuring the SPJ Environment on Systems Running H-Series RVUs
2-5
JREHOME Setting for the NonStop Server for Java
2-5
Java Library Path for the JDBC/MX Native Library
2-5
UDR Extensions Class Path for the JDBC/MX JAR File
2-6
Controlling JVM Startup Options
2-6
JVM Startup Options for All Processes on a Node 2-6
JVM Startup Options for Each SPJ Caller 2-7
Using Multiple UDR_JAVA_OPTIONS Settings in One Application
2-10
Setting the JREHOME Location 2-13
Setting JREHOME by Using UDR_JAVA_OPTIONS
2-13
Setting the JREHOME Environment Variable
2-14
Setting the JDBC/MX Location 2-16
UDR Extensions Class Path 2-16
Setting the JDBC/MX Location by Using UDR_JAVA_OPTIONS
2-16
Setting the Class Path 2-18
Setting the Class Path by Using UDR_JAVA_OPTIONS 2-18
Setting the CLASSPATH Environment Variable
2-20
Installing JAR Files in NonStop SQL/MX 2-21
Establishing Java Security 2-22
Using UDR_JAVA_OPTIONS to Enable Java Security 2-22
SPJ Policy File and Required Permissions 2-23
3. Writing SPJ Methods
Guidelines for Writing SPJ Methods 3-1
Signature of the Java Method 3-1
Returning Output Values From the Java Method 3-2
Using the main() Method 3-5
Null Input and Output 3-6
Static Java Variables 3-6
Nested Java Method Invocations
3-7
Accessing SQL/MP and SQL/MX Databases 3-7