Preparing to use the JDBC interface
Before you define the interface and connect to a database
via 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. - Verify that a Java VM is installed on your machine.
- Install the JDBC interface.
- Set the CLASSPATH environment variable.
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. Verify that the
PATH and CLASSPATH environment variables include the appropriate
directories for the JDBC driver and classes.The driver vendor’s documentation should provide
the driver name, URL format, and any driver-specific properties
you will need to specify in the database profile.
Configuring the jConnect driver Make sure to complete the configuration steps required by
the jConnect driver such as installing the JDBC stored procedures
in Adaptive Server databases.For more information about configuring jConnect, see the jConnect
for JDBC documentation. -
Make sure the required network software (such
as TCP/IP) is installed and running on your computer and
is properly configured so 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: verify the Java VM
Make sure the appropriate Java Virtual Machine is installed
and running on your client computer: Microsoft VM for Java 2.02
or Sun Java Runtime Environment (JRE) 1.1.7. Both VMs are available
free of charge from their respective vendors://www.microsoft.com/java/download.htm
and/java.sun.com/products
. If you are using JRE,
verify that the PATH and CLASSPATH environment variables include
the appropriate directories for the Java VM and classes.
Step 3: install the JDBC interface
When prompted to do so by the PowerBuilder Setup program, select
the appropriate JDBC interface.
For instructions, see the Installation
Guide
.
Step 4: set the CLASSPATH variable
Set the CLASSPATH environment variable to include an entry
to the directory containing the PowerBuilder Java package.