Preparing to use the JDBC interface

Before you define the interface and connect to a database through the JDBC interface, follow these steps to prepare the database for use:

  1. Configure the database server for its JDBC connection and install its JDBC-compliant driver and network software.

  2. Install the JDBC driver.

  3. Set or verify the settings in the CLASSPATH environment variable and the Java tab of the System Options dialog box.

Step 1: Configure the database server

You must configure the database server to make JDBC connections as well as install the JDBC driver and network software.

StepsTo configure the database server for its JDBC connection:

  1. Make sure the database server is configured to make JDBC connections. For configuration instructions, see your database vendor’s documentation.

  2. 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”.

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

Step 2: Install the JDBC driver

In the PowerBuilder Setup program, select the Typical install, or select the Custom install and select the JDBC driver.

Step 3: Verify or set the settings in the CLASSPATH variable and Java tab

Verify that the settings in the PATH and CLASSPATH environment variables or the Classpaths list on the Java tab of the PowerBuilder System Options dialog box point to the appropriate, fully qualified file names, or set them.

If you are using the JDK installed with PowerBuilder, 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).

Configuring the jConnect driver

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 or the Classpaths list on the Java tab of the PowerBuilder System Options dialog box 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.