Using DBIntegrator Client for JDBC

[Top] [Prev][Next][Bottom]



 

Installing DBIntegrator Client for JDBC

You can install DBIntegrator Client for JDBC to a hard drive, for use with a Java application or to bundle it with a Java applet for use over the Internet or your intranets.

Before You Begin

The client and server may not be ready to handle data access until these recommended steps have been taken. This checklist is a suggestion to minimize disruption to end users. 

Recommended server configuration:

Recommended client configuration:

Installing DBIntegrator Client for JDBC

To install DBIntegrator Client for JDBC perform the following steps:
 
1.  Insert the DBIntegrator Client for JDBC disk.

2.  Copy the files and directory structure onto your system according to the following guidelines.

If you are installing DBIntegrator Client for JDBC on an Internet server, place it in or below the document root directory. If you do not want the documentation or Sample Applet available on your web site, simply remove them.

If you are using a browser to run an applet, and you want the JDBC driver package to be loaded from your Internet/intranet server, install the simba/jdbc/*.class form of the package in the same location as your applet files.

Create a new directory, and copy the files into it using a recursive copy, such as "cp -r" or "xcopy /S".  This document assumes the files will reside in a directory named DBIntegrator_JDBC.

3.  If necessary, move or remove jdbc2_0-stdext.jar.

The JDBC Standard Extension Binary 2.0 package is required, and so it is provided with this release.  If you do not already have a copy of jdbc2_0-stdext.jar you may want to place it in your <java-home>/lib/ext directory (instead of using it in DBIntegrator_JDBC or some other directory), where <java-home> is determined as follows:
 

If the Java 2 SDK is installed in /home/user1/jdk1.3.1_01, then <java-home> is

/home/user1/jdk1.3.1_01/jre

Similarly for Windows, if the Java 2 SDK is installed in C:/jdk1_3_1_01, then <java-home> is

 
C:/jdk1_3_1_01/jre

If you leave file jdbc2_0-stdext.jar in the DBIntegrator_JDBC directory, or it resides somewhere other than described above, Java will not be able to find it automatically and you will need to add its full pathname to your CLASSPATH environment variable.  This document assumes it will remain in the DBIntegrator_JDBC directory.

Setting the CLASSPATH Variable

Before using DBIntegrator Client for JDBC's JDBC 2.1 driver, and the Sample Applet introduced in the next section, you need to update the CLASSPATH environment variable.  Remember, these instructions assume you installed the product files, including the JDBC Standard Extension Binary 2.0 package file, in a directory named DBIntegrator_JDBC.

The JDBC driver -- the simba.jdbc package -- is provided in two formats; simba/jdbc/*.class, and SimbaJDBC.jar.  These packages are identical.  When using the SimbaJDBC.jar file, add the full path including the filename SimbaJDBC.jar to the CLASSPATH.  For example, your CLASSPATH on Windows might include these entries in addition to the folder your application .class files are in:
 

C:/DBIntegrator_JDBC/SimbaJDBC.jar
C:/DBIntegrator_JDBC/jdbc2_0-stdext.jar
When using the simba/jdbc/*.class files instead of SimbaJDBC.jar, you would need the DBIntegrator_JDBC directory on your CLASSPATH. The example just above would become:
 
C:/DBIntegrator_JDBC
C:/DBIntegrator/jdbc2_0-stdext.jar

The following packages are also required to run your deployed JDBC application. Java finds them automatically under normal circumstances (let <jdk-home> represent the location of the Java 2 SDK):
 

<jdk-home>/jre/lib/rt.jar
<jdk-home>/jre/lib/i18n.jar
Similarly and in addition, the following package is required when you are developing your application:
 
<jdk-home>/lib/dt.jar

Testing Your Connection

To test your data source connection using the provided Sample Applet, see the Using the Sample Applet section.


[Top] [Prev][Next][Bottom]


csr@unify.com

Copyright © 1998-9, 2002, Unify Corporation. All rights reserved.