Java clients can access ABL TABLE or TABLE-HANDLE parameters using the following Java classes and interfaces:

  • INPUT parameters — Any class that implements the java.sql.ResultSet interface.
  • OUTPUT parameters — An instance of java.sql.ResultSetHolder, which contains a class that implements the com.progress.open4gl.ProResultSet interface, which extends the java.sql.ResultSet interface.
  • INPUT-OUTPUT parameters — An instance of the com.progress.open4gl.ResultSetHolder class that contains a reference to a client-supported java.sql.ResultSet object instance. On output, the ResultSetHolder contains an instance of com.progress.open4gl.ProResultSet.

For more information on the java.sql.ResultSet interface, see the relevant JavaSoft publications.

OpenEdge provides the abstract class, com.progress.open4gl.InputResultSet, which provides part of an implementation of java.sql.ResultSet. You can extend this class to implement your own input ResultSet objects. For more information, see Pass a TABLE or TABLE-HANDLE as an INPUT parameter.

The java.sql.ResultSet interface allows you to get the values of columns in the underlying temp-table. The extensions in the ProResultSet interface allow you to get the values of ABL fields, especially array fields, in a more ABL-like manner. For more information on how to access column and field values using the ProResultSet interface, see Access TABLE or TABLE-HANDLE parameters as OUTPUT.