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

Introduction

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

1-9

Invoking Different Types of SPJs

The next subsections show the layers of code within an SQL/MX UDR server process

and how these layers interact when an application issues CALL statements that invoke

different types of SPJ methods.

Pure Java Method

An SPJ can be based on a Java method from a pure Java program (that is, one that

does not contain JDBC/MX method calls or SQLJ statements). A pure Java method

does not directly perform database access operations. This type of SPJ method is

loaded into the SPJ environment and executes its application logic by referring to its

own class, other application classes, and Java system and extension classes:

VST024.vsd

Application

NonStop

SQL/MX

CALL...

NonStop Server for Java

SQL/MX Language Manager

NonStop SQL/MX

JDBC/MX (C++)

Class File

Payroll.class

Java Method

SQL/MX UDR Server Process

JVM

JDBC/MX (Java)