Kbase P115360: JDBC Components for OpenEdge 10.1A
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/3/2006 |
|
Status: Unverified
GOAL:
JDBC Components for OpenEdge 10.1A
GOAL:
Type 4 Progress JDBC driver Components
GOAL:
How do I set up OpenEdge 10.1A JDBC environment?
FACT(s) (Environment):
OpenEdge 10.1x
FIX:
The following are OpenEdge 10.1A JDBC components
On Windows:
%DLC%\java\openedge.jar
%DLC%\java\util.jar
%DLC%\java\base.jar
%DLC%\java\pool.jar
%DLC%\java\spy.jar
On UNIX including Sun Solaris SPARC (32 bit and 64 bit) , Compaq Tru64 UNIX , Linux X86, IBM AIX, HP-UX (32 bit and 64 bit)
$DLC/java/openedge.jar
$DLC/java/util.jar
$DLC/java/base.jar
$DLC/java/pool.jar
$DLC/java/spy.jar
The following need to be set in a character environment
CLASSPATH=$DLC/java/openedge.jar: $DLC/java/util.jar: $DLC/java/base.jar:$CLASSPATH
For a java call to load driver, use:
CLASS.FORNAME ( "com.ddtek.jdbc.openedge.OpenEdgeDriver");
Following is connection string:
This is ajava code sample that contains an example of a connection string:
Connection con = DriverManager.getConnection ( url );
String url;
url = new String (
"jdbc:datadirect:openedge://myhost:6718;databaseName=sports2000;
user = jones ; password = secret" );
Connection con = DriverManager.getConnection ( url );
jdbc:datadirect:openedge://host:port;databaseName=db_name;
servicename=service_name;
defaultSchema=schema_name;
statementCacheSize=CacheSize;