Neoview Guide to Stored Procedures in Java (R2.3, R2.4)

About This Document
This manual describes how to develop, deploy, and manage stored procedures in Java (SPJs) on
the Neoview Data Warehousing Platform for Business Intelligence.
Intended Audience
This manual is intended for application programmers who are writing and compiling Java code
for stored procedures and for database administrators who are deploying and managing stored
procedures in Java (SPJs) on the Neoview platform. The reader should know:
• The Java programming language
• JDBC and the HP Neoview JDBC Type 4 Driver
• Structured query language (SQL) and Neoview terms and concepts
Although not required, it helps to be familiar with the part of the ANSI SQL/Foundation standard
called SQL/JRT (Java Routines and Types) on which this implementation of stored procedures
is based.
If you are in HP Support, see additional information about SPJs in a chapter of the Neoview
Database Support Guide.
New and Changed Information in This Edition
New or Changed InformationChapter or Appendix
A new example shows version information for the Neoview Platform, N02.03.
See the “Required Software on the Neoview Platform” (page 23).
Chapter 2: Getting Started
SPJs now support SQL parameters that have NUMERIC data types with a
precision greater than 18 (that is, bignum). See Table 3-1 (page 26).
For java.sql.Connection objects, connection pooling is enabled by default.
See “Use of java.sql.Connection Objects” (page 30).
Chapter 3: Developing SPJ Methods
You can now pass character string data, other than ISO88591 and UCS2 encoded
data, to an SPJ. For more information, see the Neoview Character Sets
Administrator's Guide.
Chapter 5 (page 43) and Chapter 7
(page 63)
You can now display the execution plan of a CALL statement by using the
EXPLAIN command or function. See “Displaying an Execution Plan of a CALL
Statement” (page 73).
Chapter 8 (page 73)
The name of the Neoview Script product is now Neoview Command Interface
(NCI).
Book wide
Document Organization
This document is organized as follows:
Chapter 1: Introduction Defines what an SPJ is, describes the benefits of using SPJs
in a Neoview database, and lists steps for developing and
deploying SPJs on the Neoview platform.
Chapter 2: Getting Started Describes the software requirements for using SPJs on the
Neoview platform.
Chapter 3: Developing SPJ Methods Provides guidelines for writing and compiling a Java
method to be used as the body of a stored procedure.
Chapter 4: Deploying SPJ JAR Files
on the Neoview Platform
Explains how to deploy SPJ JAR files on the Neoview
platform.
Chapter 5: Creating SPJs in a
Neoview Database
Explains how to create, drop, and alter an SPJ in a Neoview
database.
Intended Audience 13