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

2 Getting Started

Before you can start using SPJs on the Neoview platform, verify that you have the required

software installed on the client workstation and the Neoview platform.

Required Software on the Neoview Platform

To use SPJs on the Neoview platform, you must have Neoview Release 2.2 (N02.02) or a later

version of the database software on the Neoview platform. The Neoview Release 2.2 platform

is delivered to you ready to use and preconfigured with the software required to support SPJs.

To check the version of the Neoview platform, run the VERSION command in Neoview Script.

For more information about Neoview Script, see the Neoview Script Guide. This VERSION command

returns the Neoview Platform version, N02.02.22.0:

SQL>version

Neoview Platform : N02.02.22.0

Neoview Connectivity Services : T7970N25_10AUG07_N25_SRV_0724

Neoview JDBC Type 4 Driver : T1249_N25(R2.2)_10AUG07_HP_JDBCT4_2007_07_17

Neoview Script : T0774_N25(R2.2)_10AUG07_HP_NVS_2007_07_05

SQL>

If the Neoview platform version is N02.0N, where N is 2 or greater, you have a version of the

Neoview database that supports SPJs. If N is less than 2, you have a version of the Neoview

database that does not support SPJs. To obtain Neoview Release 2.2 or a later version, contact

your HP account representative.

Required Software on the Client Workstation

Java Development Kit

To develop Java methods to be used as SPJs, you must have a Java Development Kit (JDK)

installed on the client workstation. The Java

2 Platform Standard Edition Development Kit

5.0 (J2SE 1.5.0), or an earlier version, is guaranteed to work with Neoview Release 2.2. To

download a JDK, see the Sun Developer Network (SDN) at http://java.sun.com.

NOTE: If you plan to install the Neoview JDBC Type 4 Driver on the client workstation, you

must have JDK 1.4.1 or higher installed on the client workstation.

Neoview DB Admin

Neoview DB Admin is a graphical management interface (GUI) that is required for uploading

SPJ code to the Neoview platform and for creating SPJs in a Neoview database. Neoview Release

2.2 or a later version of DB Admin supports SPJs. DB Admin runs in any Web browser but

requires the Sun Java Runtime Environment (JRE) plug-in version 1.4.2_01 or later to be installed

on the client workstation. For more information about installing the JRE plug-in and starting the

DB Admin tool, see the Neoview Database Administrator's Guide.

Recommend Software on the Client Workstation

Neoview Script

Neoview Script is a command-line interface in which you can run SQL statements, such as

GRANT EXECUTE and CALL statements, interactively or from script files. Neoview Release 2.2

or a later version of Neoview Script supports SPJs. To install Neoview Script on the client

workstation, see the Neoview Script Guide.

Required Software on the Neoview Platform 23