Release 10.1A: OpenEdge Development:
Java Open Clients

> ## Choosing JDBC ResultSets or SDOResultSets to access Progress 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 4GL business logic (such as 4GL 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:

> - 4GL 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.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095