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
If you install PowerBuilder using the PowerBuilder Installer (an online setup program), the JDBC driver is automatically installed.
If you install PowerBuilder using the downloaded installation package (an offline setup program), select JDBC Drivers from the list of components.
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.6 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, pathJDK16JREinclient).
Configuring the jConnect
driver
If you are using the SAP 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:
|
1 |
C:Program FilesSAPjConnect-6.05classesjconn3.jar |
For more information about configuring jConnect, see the jConnect
for JDBC documentation.