Consultor Eletrônico

Status: Verified

GOAL:

What are the components of the JDBC driver for Progress?

GOAL:

What is required of the JAVA client to have JDBC support?

GOAL:

Requirements to run Java Code through SQL-92 JDBC Driver

GOAL:

JDBC Components and Environmental Settings

FACT(s) (Environment):

Progress 9.x
OpenEdge 10.0x

FIX:

On OpenEdge 10.0B or earlier versions, the SQL-92 JDBC driver is a type 2 driver. It is a Native-API, partly-Java driver. That is, the driver converts JDBC calls into calls on the client API for Progress databases. It is written in a combination of Java and C/C++; this is because the driver must use a layer of C to make calls to the Progress libraries.

To have driver components, at least install SQL client access license.

The following are components of JDBC architecture:

Windows:

%DLC%\bin\procli92.dll
%DLC%\bin\JdbcProgress.dll
%DLC%\java\jdbc.zip (In Progress 9.1D this component has changed to jdbc.jar)

UNIX:

$DLC/lib/libprocli92.so(sl,a)
$DLC/lib/libJdbcProgress.so(sl, a)
$DLC/lib/libJdbcProgress_g.so(sl,a)
$DLC/java/jdbc.zip (Starting with Progress 9.1D this component has changed to jdbc.jar)

The following are environmental settings for the driver:

On the Server, the shared library path is set when you run proserve script for _sqlsrv2 within $DLC/bin/java_env

On WINDOWS clients, the following variables should be set:

set CLASSPATH=%DLC%\java\jdbc.zip;%CLASSPATH%
set PATH=%DLC%\bin;%PATH%

In Progress 9.1D this environment variable should be set as:
set CLASSPATH=%DLC%\java\jdbc.jar;%CLASSPATH%
set PATH=%DLC%\bin;%PATH%

On most UNIX clients, set:
CLASSPATH=$DLC/java/jdbc.zip:$CLASSPATH; export CLASSPATH
For LINUX, Solaris, True 64, SCO Openserver/UNIXware, DG UX:
LD_LIBRARY_PATH=$DLC/lib:$LD_LIBRARY_PATH; export LD_LIBRARY_PATH
For HP-UX:
SHLIB_PATH=$DLC/lib:$SHLIB_PATH; export SHLIB_PATH
For AIX:
LIBPATH=$DLC/lib:$LIBPATH; export LIBPATH