SQL/MX 3.2 Guide to Stored Procedures in Java (H06.25+, J06.14+)

Contents
HP NonStop SQL/MX Release 3.2 Guide to Stored Procedures in Java—691166-001
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-2
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-4
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-5
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-12
Setting JREHOME by Using UDR_JAVA_OPTIONS 2-12
Setting the JREHOME Environment Variable 2-13
Setting the JDBC/MX Location 2-15
UDR Extensions Class Path 2-15
Setting the JDBC/MX Location by Using UDR_JAVA_OPTIONS 2-15
Setting the Class Path 2-17
Setting the Class Path by Using UDR_JAVA_OPTIONS 2-17
Setting the CLASSPATH Environment Variable
2-19
Installing JAR Files in NonStop SQL/MX 2-20
Establishing Java Security
2-21
Using UDR_JAVA_OPTIONS to Enable Java Security
2-21
SPJ Policy File and Required Permissions
2-22
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-4
Null Input and Output
3-4
Static Java Variables
3-5
Nested Java Method Invocations 3-5