Try OpenEdge Now
skip to main content
Java Open Clients
Using SmartDataObjects from Java Clients : Creating an SDOResultSet object : Setting and getting values on the SDOParameters object
 

Setting and getting values on the SDOParameters object

An SDOParameters object in com.progress.open4gl can be supplied as a parameter to the SDOResultSet factory method that allows you to control various ResultSet properties. You need to set only the values that differ from the defaults. The methods to set and get these values on the SDOParameters object follow.
The following method sets the row ID of the first row to be fetched from the created and opened SDOResultSet:
void setRowIdentity(String rowId)
A null rowId is equivalent to not calling setRowIdentity() (also see the reOpenQuery(String rowId) extended method in Miscellaneousmanagement methods. Usually, it is more efficient to use setRowIdentity() than to create the SDOResultSet and then call the extended method, absolute(String rowId), to reposition the cursor on the specified row.
If you create the SDOResultSet in PREFETCH scrolling mode, you cannot access rows before the rowId that you set with setRowIdentity(). For more information on PREFETCH, see Understanding SDOResultSet scrolling modes.
The rowId value is equivalent to the value returned by the ABL ROWID function and the SDOResultSet.getRowIdentity() method. For more information on ROWID, see OpenEdge Getting Started: ABL Essentials or the appropriate OpenEdge DataServer Guide for any DataServer accessed by the SmartDataObject. For more information on the SDOResultSet.getRowIdentity() method, see Miscellaneousmanagement methods.
The following method gets the row ID of the first row to be fetched from the created and opened SDOResultSet:
Syntax
String getRowIdentity()
The following method sets the number of rows the scrolling mechanism fetches each time it accesses the AppServer:
Syntax
void setFetchSize(int fetchsize)
The default is 200.
The following method gets the number of rows the scrolling mechanism fetches each time it accesses the AppServer:
Syntax
int getFetchSize()
The following method sets the Stateless mode for the SDOResultSet:
Syntax
void setStateless(boolean state)
Specify stateas true for a stateless SDOResultSet and false for a non-stateless SDOResultSet. For more information, see Understanding SDOResultSet stateless mode.
The following method gets the Stateless mode for the SDOResultSet:
Syntax
boolean getStateless()
For more information, see Understanding SDOResultSet stateless mode.
The following method sets the scrolling mode for the SDOResultSet specified as a class constant in com.progress.open4gl.SDOScrollingMode:
Syntax
void setScrollingMode(SDOScrollingMode constant)
If the SDOResultSet is Stateless, the default is SDOScrollingMode.PREFETCH; otherwise, the default is SDOScrollingMode.KEEP_ROWS. The other supported scrolling mode is SDOScrollingMode.FORWARD_ONLY. For more information, see Understanding SDOResultSet scrolling modes.
The following method gets the scrolling mode specified for the SDOResultSet, returned as a class constant in com.progress.open4gl.SDOScrollingMode:
Syntax
SDOScrollingMode getScrollingMode()
For more information, see Understanding SDOResultSet scrolling modes.
The following method sets the maximum number of rows to be fetched when the scrolling mode is SDOScrollingMode.PREFETCH:
Syntax
void setPrefetchMaxRows(int maxRows)
The setPrefetchMaxRows() method has no effect for scrolling modes other than SDOScrollingMode.PREFETCH. The default for this mode is to get all the rows of the SDOResultSet. For more information, see Understanding SDOResultSet scrolling modes and Understanding SDOResultSet stateless mode.
The following method gets the value for the maximum number of rows to be fetched when the scrolling mode is SDOScrollingMode.PREFETCH:
Syntax
int getPrefetchMaxRows()
For more information, see Understanding SDOResultSet scrolling modes and Understanding SDOResultSet stateless mode.