Kbase P127073: Where is the JDBC driver library in 10.1B?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
14/01/2009 |
|
Status: Verified
GOAL:
Where is the JDBC driver library in 10.1B?
GOAL:
What are the files required for JDBC connectivity in 10.1B?
GOAL:
How to load the JDBC class in 10.1B?
FACT(s) (Environment):
UNIX
Windows
OpenEdge 10.1B
FIX:
For the following platforms:
Windows
Sun Solaris SPARC (32 bit and 64 bit)
Compaq Tru64 UNIX
Linux X86
IBM AIX
HP-UX (32 bit and 64 bit)
The following files are part of the JDBC Driver / Support files:
openedge.jar
util.jar
base.jar
pool.jar
spy.jar
These files are located within the DLC/java directory within the 10.1B or later installation of OpenEdge.
On Windows, ensure the environment CLASSPATH includes:
%DLC%\java\openedge.jar;%DLC%\java\util.jar; %DLC%\java\base.jar
On UNIX, ensure the environment CLASSPATH includes:
$DLC/java/openedge.jar:$DLC/java/util.jar: $DLC/java/base.jar
The call to load and register the JDBC driver must use the Java function CLASS.FORNAME and the string should use the following Class reference:
com.ddtek.jdbc.openedge.OpenEdgeDriver
Example:
CLASS.FORNAME ( "com.ddtek.jdbc.openedge.OpenEdgeDriver");
The following URL options may be used to invoke a connection to a database:
jdbc:datadirect:openedge://host:port;databaseName=db_name;
servicename=service_name;
defaultSchema=schema_name;
statementCacheSize=Cachesize;
Simple Example:
jdbc:datadirect:openedge://myhostname:myportname;databaseName=my_database_name
or
jdbc:datadirect:openedge://myhostname: