Progress Software Corporation supports a JDBC interface directly to the OpenEdge database. Some applications might benefit from using the direct JDBC interface to OpenEdge rather than SDOResultSets, and others might benefit more from using SDOResultSets.

JDBC access to the OpenEdge database should be used in the following cases:

  • There is no ABL business logic (such as ABL triggers) that must be used
  • Two-tier access (client/server) is sufficient
  • The client side application requires full JDBC support

SmartDataObject ResultSets should be used in the following cases:

  • ABL business logic is part of the application server application
  • N-tier configuration is required for performance or other reasons
  • Higher than JDBC 1 level of access is required. SDOResultSet, which is based on JDBC 2, is easier to use and does not require knowledge of SQL