Preparing to use the JDBC interface – PB Docs 126

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.

proc.png To 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 Java VM packages in your CLASSPATH variable, but your PATH environment
variable must include an entry for the Java VM library, jvm.dll (for
example, path JDK15JREinclient).

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:

For more information about configuring jConnect, see the jConnect
for JDBC documentation.


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x