Choosing JDBC ResultSets or SDOResultSets to access OpenEdge data
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 AppServer 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
There is no ABL business logic (such as ABL triggers) that must be used