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:
- 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 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.
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.
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 JDK14JREinclient).
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 machine 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 5.5, you should include
an entry similar to the following:
|
1 |
C:Program FilesSybaseSharedjConnect-5_5classesjconn2.jar |
For more information about configuring jConnect, see the jConnect
for JDBC documentation.