Java Client Components

The HP JDBC product must first be installed on the server host before the client can be installed. This is because the client files are bundled with the server product.

The HP Driver for JDBC components consist of the Driver Java class files and a sample JDBC client source file. These are the only components required on the client-side. The driver components are packaged in three formats (the same files contents are in each package), UNIX tape archive (TAR), Java archive (JAR), and Windows ZIP (ZIP).

Setting up HP Driver for JDBC client involves:

Downloading the appropriate HP JDBC archive file to a temporary directory.
Extracting the HP JDBC archive file onto your client platform.

Downloading the HP JDBC Archive File

On an HP-UX server the files are located in /opt/allbase/jdbc/driver with the following names:

driver.jar: Driver files in Java archive package.
driver.tar: Driver files in UNIX tape archive package.
driver.zip: Driver files in a Windows ZIP package.

On an MPE/iX server the files are located in @.JDBC.SYS with the following names:

DRIVERJ: Driver files in Java archive package.
DRIVERT: Driver files in UNIX tape archive package.
DRIVERZ: Driver files in a Windows ZIP package.

Using FTP.ARPA.SYS

For the HP 3000 server, use MANAGER.SYS,JDBC as the username:

From your client platform:

ftp mpe-server

>binary

>get DRIVERT: /* or DRIVERJ or DRIVERZ */

For the HP 9000 server, use any login as the username:

From your client platform:

ftp hpux-server

>binary

>get /opt/allbase/jdbc/driver.tar

/* or driver.jar or driver.zip */

Using Reflection Software

See the software description on how to transfer the appropriate file (transfer the file in binary mode).

Extracting the HP Driver for JDBC Class Files

The HP Driver for JDBC class files must be installed in your Java class path so that the Java compiler and the Java class loader can find them.

Example on the Win32 Platform

CLASSPATH=C:\JDK1.1.4\LIB;.

You would then install the HP Driver for JDBC class files in the directory:

C:\JDK1.1.4\LIB\

Each of the package formats include the directory information, so they should be copied into the class path directory.

Once the package is copied onto the client machine, extract the contents of the package by using the appropriate command or application for that package format.

For example:

tar command to unpack the TAR package: $tar xvf driver.tar
jar command to unpack the JAR package: $jar xvf driver.jar

UNZIP or WINZIP to unpack the ZIP package: Follow the unzip steps provided in the UNZIP/WINZIP package.

For the HP 3000 system, a job stream, I01IJDBC.JDBC.SYS, is provided to install the HP Driver for JDBC client under the /usr/local/java/latest/lib/ directory of the MPE/iX POSIX domain.

Example on HP 3000

CLASSPATH=/usr/local/java/latest/lib:.

In order to use the HP Driver for JDBC client on the MPE/iX system, you need to have the JAVA/iX installed. JAVA/iX is shipped with MPE/iX starting in Release 6.0.

The following sub-directories for the Driver class files should be automatically created:

com/hp/jdbc/allbase

com/hp/jdbc/allbase/samples

For a complete list of the files that are installed, please refer to Appendix E “HP ALLBASE/SQL JDBC File Lists”