Before you define the interface and connect to a database through the JDBC interface, follow these steps to prepare the database for use:
Configure the database server for its JDBC connection and install its JDBC-compliant driver and network software.
Install the JDBC driver.
Set or verify the settings in the CLASSPATH environment variable.
You must configure the database server to make JDBC connections as well as install the JDBC driver and network software.
To configure the database server for its JDBC
connection:
Make sure the database server is configured to make JDBC connections. For configuration instructions, see your database vendor’s documentation.
Make sure the appropriate JDBC driver software is installed and running on the database server.
The driver vendor’s documentation should provide the driver name, URL format, and any driver-specific properties you need to specify in the database profile. For notes about the jConnect driver, see “Configuring the jConnect driver”.
Make sure the required network software (such as TCP/IP) is installed and running on your computer and is properly configured so that you can connect to the database server at your site.
You must install the network communication driver that supports the network protocol and operating system platform you are using.
For installation and configuration instructions, see your network or database administrator.
In the InfoMaker Setup program, select the Typical install, or select the Custom install and select the JDBC driver.
Verify that the settings in the PATH and CLASSPATH environment variables point to the appropriate, fully qualified file names, or set them.
If you are using the JDK installed with InfoMaker, you do not need to make any changes to these environment variables.
If you are using JDK 1.2 or later, you do not need to include any Sun Java VM packages in your CLASSPATH variable, but your PATH environment variable must include an entry for the Sun Java VM library, jvm.dll (for example, path\ JDK15\JRE\bin\client).
If you are using the Sybase jConnect driver, make sure to complete the required configuration steps such as installing the JDBC stored procedures in Adaptive Server databases. Also, verify that the CLASSPATH environment variable on your computer includes an entry pointing to the location of the jConnect driver.
For example, if you are using jConnect 6.05, you should include an entry similar to the following:
C:\Program Files\Sybase\jConnect-6.05\classes\jconn3.jar
For more information about configuring jConnect, see the jConnect for JDBC documentation.
