JDBC connection parameters

When connecting to an OpenEdge database using a JDBC driver, you can specify two optional connection parameters:

  • defaultSchema — The schema to be used during statement processing
  • statementCacheSize — The number of entries in the statement cache

Here is an example of how to specify these connection parameters:

jdbc:datadirect:openedge//myhost:6718;databaseName=sports2020;defaultSchema=schema1;statementCacheSize=10;

For a list of JDBC connection properties and their valid values, see Connection Properties.