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

Contents

HP NonStop SQL/MX Guide to Stored Procedures in Java—523727-004

2. Getting Started

Software Requirements 2-1

NonStop Server for Java 2-2

JDBC/MX Driver 2-2

Using SPJ-Incompatible Versions in the Java Environment 2-2

Verifying Software Versions 2-3

Verifying the SQL/MX UDR Server 2-3

Verifying the NonStop Server for Java 2-4

Verifying the JDBC/MX Driver 2-4

Relinking the SQL/MX UDR Server on Systems Running G-Series RVUs 2-5

Using the mxudrlink Script to Relink MXUDR 2-6

Using the Makefile to Relink MXUDR 2-10

Controlling JVM Startup Options 2-11

JVM Startup Options for All Processes on a Node 2-11

JVM Startup Options for Each SPJ Caller 2-12

Using Multiple UDR_JAVA_OPTIONS Settings in One Application 2-15

Setting the JREHOME Location 2-17

Setting JREHOME by Using UDR_JAVA_OPTIONS 2-17

Setting the JREHOME Environment Variable 2-18

Setting the JDBC/MX Location 2-20

UDR Extensions Class Path 2-20

Setting the JDBC/MX Location by Using UDR_JAVA_OPTIONS 2-20

Setting the Class Path 2-22

Setting the Class Path by Using UDR_JAVA_OPTIONS 2-22

Setting the CLASSPATH Environment Variable 2-24

Installing JAR Files in NonStop SQL/MX 2-25

Establishing Java Security 2-26

Using UDR_JAVA_OPTIONS to Enable Java Security 2-26

SPJ Policy File and Required Permissions 2-27

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