Release 10.1A: OpenEdge Development:
Java Open Clients

> ## Preparing and managing temp-table parameters

> Java clients can access 4GL `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.

> Progress 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 the "Passing a TABLE or TABLE-HANDLE as an INPUT parameter" section.

> 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 Progress fields, especially array fields, in a more Progress-like manner. For more information on how to access column and field values using the `ProResultSet` interface, see the "Accessing TABLE or TABLE-HANDLE parameters as OUTPUT" section.

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