Neoview Guide to Stored Procedures in Java (R2.2)

1 Introduction
This chapter introduces stored procedures in Java (SPJs) in a Neoview database and covers these
topics:
• “What Is an SPJ?”
• “Benefits of SPJs” (page 19)
• “How Do I Use SPJs in a Neoview Database?” (page 21)
What Is an SPJ?
A stored procedure is a type of user-defined routine (UDR) that operates within a database server
and typically performs SQL operations on a database. The database server contains information
about the stored procedure and controls its execution. A client application executes a stored
procedure by issuing an SQL CALL statement. Unlike a user-defined function, which returns a
value directly to the calling application, a stored procedure returns each output value to a dynamic
parameter in its parameter list or returns a set of values to a result set array.
Neoview SQL supports stored procedures written in the Java programming language. The
Neoview implementation of stored procedures complies mostly, unless otherwise specified, with
SQL/JRT (Java Routines and Types), which extends the ANSI SQL/Foundation standard. A stored
procedure in Java (SPJ) is a Java method contained in a Java archive (JAR) file on the Neoview
platform, registered in the Neoview database, and executed by Neoview SQL when a client
application issues a CALL statement.
The body of a stored procedure consists of a public, static Java method that returns void.
These Java methods, called SPJ methods, are contained in classes within JAR files on the Neoview
platform. Using DB Admin, you can upload a JAR file containing an SPJ method from a client
workstation to the Neoview platform and register the SPJ method as a stored procedure in the
Neoview database. An SPJ method must be registered as a stored procedure in a Neoview
database before a client application can execute it with a CALL statement.
Benefits of SPJs
SPJs provide an efficient and secure way to implement business logic in a Neoview database.
SPJs offer these advantages:
• “Java Methods Callable From Neoview SQL” (page 20)
• “Common Packaging Technique” (page 20)
• “Security” (page 20)
• “Increased Productivity” (page 20)
• “Portability” (page 21)
What Is an SPJ? 19