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

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.05.
See the “Required Software on the Neoview Platform” (page 21).
Chapter 2: Getting Started
The HP Database Manager (HPDM) replaces Neoview DB Admin as the tool
required for uploading JAR files to the Neoview platform.
Chapter 4: Deploying SPJ JAR Files
on the Neoview Platform
HPDM replaces Neoview DB Admin as the tool required for creating procedures
in the Neoview database.
Chapter 5: Creating SPJs in the
Neoview Database
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 the
Neoview Database
Explains how to create, drop, and alter an SPJ in a Neoview
database.
Chapter 6: Granting Privileges for
Executing SPJs
Explains how to grant and revoke privileges for executing
SPJs in a Neoview database.
Chapter 7: Executing SPJs Explains how to execute an SPJ on the Neoview platform
by using the CALL statement.
Chapter 8: Performance and
Troubleshooting
Describes how to improve and monitor the performance
of SPJs and provides guidelines for troubleshooting
common problems.
Intended Audience 11