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

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 at least 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.5, this VERSION command returns the Neoview Platform

version, N02.05:

SQL>version

Neoview Platform : N02.05.00

Neoview Connectivity Services : T7970N29_18JUN2010_SRV_0706

Neoview JDBC Type 4 Driver : T1249_N29(R2.5)_18JUN10_HP_JDBCT4_2010_07_06

Neoview Command Interface : T0774N29_(R2.5)_18JUN10_HP_NCI_2010_06_30

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

version. 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.

HP Database Manager (HPDM)

HPDM 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.5 or a later

version of HPDM supports SPJs. For more information about installing HPDM, see the README

for the HP Database Manager (HPDM).

NOTE: Neoview DB Admin is no longer supported in Neoview Release 2.5.

Required Software on the Neoview Platform 21