NonStop Server for Java 5.1 Programmer's Reference

Stored Procedures in Java
Stored procedures in Java (SPJs) provide an efficient and secure way to implement business logic in an
SQL/MX database. They allow you to write portable applications in Java and access an industry-standard
SQL database.
A SPJ is a type of user-defined routine (UDR) that operates within a database server. A UDR can be
either a stored procedure, which does not return a value directly to the caller, or a user-defined function,
which does return a value directly to the caller. (A stored procedure returns a value only to a host
variable or dynamic parameter in its parameter list.)
In the SQL/MX database, a SPJ is a Java method contained in a Java class, registered in SQL/MX, and
invoked by SQL/MX when an application issues a CALL statement to the method.
For detailed information on using SPJs, see the SQL/MX Guide to Stored Procedures in Java at
docs.hp.com.
Title Page | Contents | Index | Glossary | Prev | Next
NonStop Server for Java 5.1 Programmer's Reference (544819-004)
© 2010 Hewlett-Packard Development Company L.P. All rights reserved.