JDBC Developer's Resource Readme

Go Back

	JDBC DEVELOPER'S RESOURCE

JDBC Readme

Install Software

Install the necessary software to create and run Java-JDBC applications under Windows 95. The software required is as follows.

Java JDK 1.02

JDBC-ODBC Bridge

Intersolv Data Direct Pack

Mojo Development Tool

Follow the instructions included with the packages. The packages are included on the CD-ROM in the following directories.

Software Directory

======================================

Java JDK 1.02 JDK102

JDBC-ODBC Bridge JDBC-ODBC-Bridge

Intersolv Data Direct Pack IvODBC

Mojo Development Tool Mojo

Software	Directory
======================================
Java JDK 1.02	JDK102
JDBC-ODBC Bridge	JDBC-ODBC-Bridge
Intersolv Data Direct Pack	IvODBC
Mojo Development Tool	Mojo

Create ODBC Data Source

An ODBC data source must be created for a Microsoft Access database and named 'msaccessdb'. (Another data source type would probably work, but this has not been specifically tested.) The data source name 'msaccessdb' is the data source name expected by the sample programs. Microsoft Access need not be installed on the machine.

For the stored procedure and transaction examples, a database that supports transactions and stored procedures is needed. The code samples were tested using an Intersolv 'informix5' driver and the Informix-Online database version 7.12, but any database that supports transactions and stored procedures should suffice. The data source name in the stored procedure and transactions code samples is 'informix5'.
Load Data

To create the necessary tables and load the data for the sample programs, the programs JDBCExample1 in the /JDBCExample directory and LoadData in the /LoadData directory must be run (not necessarily in that order). These programs will create the 'customers', 'table1', and 'loadtest' tables and load them with the necessary data.
ThreeTiered Application

The three-tiered application sample on the CD-ROM is currently written to run entirely under Windows 95; the application itself is three-tiered but, as currently configured, runs under a single network node. Moving the server-side application to another network node and making the appropriate change to the 'Naming.lookup' call would create a three-tiered application running over multiple network nodes.

Running the three-tiered example involves installing RMI libraries and runtime. The user should read the Three-tiered chapter in the text to become familiar with the operation of the sample application.

The table used for the application must be created and loaded using the LoadPguideData application in the /ThreeTiered directory. This will create the pguide table and load a few sample rows.

The RMI registry must be started first using the 'startregistry.bat' script in the /ThreeTiered directory. This should take several seconds to start. Next, the server-side application must be started using the 'startserver.bat' script in the /ThreeTiered directory. This may take a minute or so to start (under Windows 95) and, using the script, will use the MS-DOS window for output.

In another window, the applet can then be started using the 'startapplet.bat' script. This will take several minutes to start.

NOTE: As of this date (01/01/97), the RMI version currently available for use with JDK 1.02 will not operate in the current year. The current version of the JDK, Beta 1.1, will contain the RMI but this version is not supported by the JDBC-ODBC bridge.

These applications should all run under current and future releases of Java and JDBC, but, as of this writing, the code has not been compiled and tested under any release other than 1.002 of JDBC.

JDBC Class Libraries

The file 'Jdbc.zip' in the /JDBC directory contains a classes directory and under this directory are the Java class files for JDBC. Unzip this file in a directory visible to the 'CLASSPATH' environment variable.

Return to top of page

[About the book][Table of Contents][Readme][JDBC links][What's on the CD][Ordering Info]

Legal Statement