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

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.
New and Changed Information in This Edition
This manual is new.
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.
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.
Appendix A: Sample SPJs Provides examples of SPJ methods that demonstrate
business logic in a Neoview database.
Appendix B: Sample Database Describes the sample database on which the Sample SPJs
operate.
Notation Conventions
General Syntax Notation
This list summarizes the notation conventions for syntax presentation in this manual.
Intended Audience 13