JDBC database interface

The PowerBuilder JDB interface supports the Sun Java Runtime Environment (JRE) versions 1.2 and later.

If your application or component uses JDBC connections, you must deploy the JDB driver as well as the appropriate Java package for the Java VM you are using. The Java virtual machine and a vendor-supplied JDBC-compliant driver, such as Sybase jConnect® for JDBC, must also be installed and configured on the computer that accesses the data source.

To specify which Java VM the driver should load, use the JavaVM DBParm. You should use the same setting for this DBParm in the development and deployment environments. See Connecting to Your Database for more information.

For more information about the Java VM, see “Java support”.

Table 41-11: PowerBuilder JDB files

Name

Description

PBJDB105.DLL

PowerBuilder JDBC Driver (JDB) for JRE 1.2 or later

pbjdbc12105.jar

Java package for PowerBuilder JDB driver and JRE 1.2 or later

Installed path \Program Files\Sybase\Shared\PowerBuilder

Deployment path Same directory as the application, in a directory on the system path, or in the App Path registry key.

Registry entries Make sure the CLASSPATH environment variable includes the PowerBuilder pbjdbc12105.jar file. For example:

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control
	\Session Manager\Environment]
"CLASSPATH"="C:\Program Files\sybase\shared\
	PowerBuilder\pbjdbc12105.jar;...

Notes See “PowerBuilder components on EAServer” and “Web DataWindow on EAServer”.