Perform the following steps to configure the JDBC driver:
  1. Set CLASSPATH. On Windows, set CLASSPATH within the environment of your Java client. Some programs such as Tomcat may set Java classpath in the registry and may ignore environment variables. Review the necessary steps for the parent process of the JDBC connection to see how the Java classpath must be set.
    In this example, you can set the CLASSPATH by the following command in Linux:
    CLASSPATH=$DLC/java/openedge.jar:$CLASSPATH
  2. To load the JDBC driver, the application needs to load the class.
    "com.ddtek.jdbc.openedge.OpenEdgeDriver".
    For example, add the java call:
    Class.forName( "com.ddtek.jdbc.openedge.OpenEdgeDriver");
  3. Use DriverManager.getConnection for the connection string to establish a JDBC connection:
    Example 1 
    Connection con = DriverManager.getConnection ( url );
String url;
url = new String ( "jdbc:datadirect:openedge://host:port;databaseName=sports2000;user = jones;password = secret" );