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

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 or later

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 NCI. For more

information about NCI, see the Neoview Command Interface (NCI) Guide.

For example, for Neoview Release 2.2, this VERSION command returns the Neoview Platform

version, N02.02:

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>

For Neoview Release 2.3, this VERSION command returns the Neoview platform version, N02.03:

SQL>version

Neoview Platform : N02.03.18.0

Neoview Connectivity Services : T7970N26_15FEB2008_AFC_SRV_1024

Neoview JDBC Type 4 Driver : T1249_N26(R2.3)_01NOV07_HP_JDBCT4_2007_09_26

Neoview Command Interface : T0774_N26(R2.3)_02NOV07_HP_NCI_2007_10_02

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

Required Software on the Neoview Platform 23