Class SDOResultSetImpl
- All Implemented Interfaces:
ProResultSet
,SDOResultSet
,Serializable
,AutoCloseable
,ResultSet
,Wrapper
- See Also:
-
Nested Class Summary
Nested Classes -
Field Summary
Fields inherited from interface java.sql.ResultSet
CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE
-
Constructor Summary
ConstructorsConstructorDescriptionSDOResultSetImpl
(SDOFactory appObject, String sdoName, String where, String sortBy, SDOParameters params) -
Method Summary
Modifier and TypeMethodDescriptionboolean
absolute
(int n) JDBC 2.0boolean
PROGRESS Extensionvoid
JDBC 2.0void
attachToAppObj
(SDOFactory appObject) PROGRESS Extensionvoid
JDBC 2.0void
PROGRESS Extensionvoid
JDBC 2.0void
void
close()
void
JDBC 2.0void
PROGRESS Extensionint
findColumn
(String colName) boolean
first()
JDBC 2.0getArray
(int i) getAsciiStream
(int colIx) getAsciiStream
(String colName) getBigDecimal
(int pos) JDBC 2.0getBigDecimal
(int columnIndex, int scale) Deprecated.getBigDecimal
(int field, int indx, int scale) getBigDecimal
(String columnName) JDBC 2.0getBigDecimal
(String field, int scale) Deprecated.getBigDecimal
(String field, int indx, int scale) getBinaryStream
(int colIx) getBinaryStream
(String colName) getBlob
(int pos) getBlob
(int field, int indx) boolean
getBoolean
(int pos) boolean
getBoolean
(int field, int indx) boolean
getBoolean
(String field) boolean
getBoolean
(String field, int indx) byte
getByte
(int colIx) byte
byte[]
getBytes
(int pos) byte[]
getBytes
(int field, int indx) byte[]
byte[]
Get column value by field name and index.getCharacterStream
(int columnIndex) getCharacterStream
(String columnName) getClob
(int pos) getClob
(int field, int indx) int
getDate
(int pos) getDate
(int field, int indx) double
getDouble
(int pos) double
getDouble
(int field, int indx) double
double
int
int
JDBC 2.0 Returns the fetch size for this result set.float
getFloat
(int colIx) float
getGregorianCalendar
(int pos) PROGRESS ExtensiongetGregorianCalendar
(int field, int indx) getGregorianCalendar
(String field) PROGRESS ExtensiongetGregorianCalendar
(String field, int indx) int
int
getInt
(int pos) int
getInt
(int field, int indx) int
int
long
getLong
(int pos) long
getLong
(int field, int indx) long
long
getNCharacterStream
(int columnIndex) getNCharacterStream
(String columnLabel) getNClob
(int columnIndex) getNString
(int columnIndex) getNString
(String columnLabel) getObject
(int i) getObject
(int field, int indx) <T> T
<T> T
getQuery()
PROGRESS ExtensiongetRef
(int i) int
getRow()
JDBC 2.0getRowId
(int columnIndex) PROGRESS ExtensionPROGRESS Extensionshort
getShort
(int colIx) short
getSQLXML
(int columnIndex) getString
(int pos) getString
(int field, int indx) getTime
(int colIx) getTimestamp
(int pos) getTimestamp
(int field, int indx) getTimestamp
(int columnIndex, Calendar cal) getTimestamp
(String field) getTimestamp
(String field, int indx) getTimestamp
(String columnName, Calendar cal) int
getType()
getUnicodeStream
(int colIx) Deprecated.getUnicodeStream
(String colName) Deprecated.getURL
(int columnIndex) boolean
inBatch()
PROGRESS Extensionvoid
JDBC 2.0boolean
JDBC 2.0boolean
PROGRESS Extensionboolean
JDBC 2.0boolean
isClosed()
boolean
isFirst()
JDBC 2.0boolean
isLast()
JDBC 2.0boolean
isWrapperFor
(Class<?> iface) boolean
last()
JDBC 2.0void
JDBC 2.0void
JDBC 2.0boolean
next()
boolean
previous()
JDBC 2.0void
JDBC 2.0boolean
relative
(int n) JDBC 2.0void
PROGRESS Extensionvoid
PROGRESS Extensionvoid
reOpenQuery
(String rowId) PROGRESS Extensionboolean
JDBC 2.0boolean
JDBC 2.0boolean
JDBC 2.0void
PROGRESS Extensionvoid
PROGRESS Extensionvoid
sendBatchAndReOpen
(String rowId) PROGRESS Extensionvoid
setFetchDirection
(int direction) void
setFetchSize
(int rows) void
PROGRESS Extension<T> T
void
updateArray
(int columnIndex, Array x) void
updateArray
(String columnName, Array x) void
updateAsciiStream
(int columnIndex, InputStream inputStream) void
updateAsciiStream
(int columnIndex, InputStream x, int length) void
updateAsciiStream
(int columnIndex, InputStream inputStream, long length) void
updateAsciiStream
(String columnLabel, InputStream inputStream) void
updateAsciiStream
(String columnName, InputStream x, int length) void
updateAsciiStream
(String columnLabel, InputStream inputStream, long length) void
updateBigDecimal
(int columnIndex, BigDecimal x) JDBC 2.0void
updateBigDecimal
(int columnNum, BigDecimal x, int indx) void
updateBigDecimal
(String columnName, BigDecimal x) JDBC 2.0void
updateBigDecimal
(String columnName, BigDecimal x, int indx) void
updateBinaryStream
(int columnIndex, InputStream inputStream) void
updateBinaryStream
(int columnIndex, InputStream x, int length) void
updateBinaryStream
(int columnIndex, InputStream inputStream, long length) void
updateBinaryStream
(String columnLabel, InputStream inputStream) void
updateBinaryStream
(String columnName, InputStream x, int length) void
updateBinaryStream
(String columnLabel, InputStream inputStream, long length) void
updateBlob
(int columnIndex, InputStream inputStream) void
updateBlob
(int columnIndex, InputStream inputStream, long length) void
updateBlob
(int columnIndex, Blob x) JDBC 2.0void
updateBlob
(int columnNum, Blob x, int indx) void
updateBlob
(String columnLabel, InputStream inputStream) void
updateBlob
(String columnLabel, InputStream inputStream, long length) void
updateBlob
(String columnName, Blob x) JDBC 2.0void
updateBlob
(String columnName, Blob x, int indx) void
updateBoolean
(int columnIndex, boolean x) JDBC 2.0void
updateBoolean
(int columnNum, boolean x, int indx) void
updateBoolean
(String columnName, boolean x) JDBC 2.0void
updateBoolean
(String columnName, boolean x, int indx) void
updateByte
(int columnIndex, byte x) void
updateByte
(String columnName, byte x) void
updateBytes
(int columnIndex, byte[] x) JDBC 2.0void
updateBytes
(int columnNum, byte[] x, int indx) void
updateBytes
(String columnName, byte[] x) JDBC 2.0void
updateBytes
(String columnName, byte[] x, int indx) void
updateCharacterStream
(int columnIndex, Reader reader) void
updateCharacterStream
(int columnIndex, Reader x, int length) void
updateCharacterStream
(int columnIndex, Reader reader, long length) void
updateCharacterStream
(String columnLabel, Reader reader) void
updateCharacterStream
(String columnName, Reader reader, int length) void
updateCharacterStream
(String columnLabel, Reader reader, long length) void
updateClob
(int columnIndex, Reader reader) void
updateClob
(int columnIndex, Reader reader, long length) void
updateClob
(int columnIndex, Clob x) JDBC 2.0void
updateClob
(int columnNum, Clob x, int indx) void
updateClob
(String columnLabel, Reader reader) void
updateClob
(String columnLabel, Reader reader, long length) void
updateClob
(String columnName, Clob x) JDBC 2.0void
updateClob
(String columnName, Clob x, int indx) void
updateDate
(int columnIndex, Date x) JDBC 2.0void
updateDate
(int columnNum, Date x, int indx) void
updateDate
(String columnName, Date x) JDBC 2.0void
updateDate
(String columnName, Date x, int indx) void
updateDouble
(int columnIndex, double x) JDBC 2.0void
updateDouble
(int columnNum, double x, int indx) void
updateDouble
(String columnName, double x) JDBC 2.0void
updateDouble
(String columnName, double x, int indx) void
updateFloat
(int columnIndex, float x) void
updateFloat
(String columnName, float x) void
updateGregorianCalendar
(int columnIndex, GregorianCalendar x) PROGRESS Extensionvoid
updateGregorianCalendar
(int columnNum, GregorianCalendar x, int indx) void
updateGregorianCalendar
(String columnName, GregorianCalendar x) PROGRESS Extensionvoid
updateGregorianCalendar
(String columnName, GregorianCalendar x, int indx) void
updateInt
(int columnIndex, int x) JDBC 2.0void
updateInt
(int columnNum, int x, int indx) void
JDBC 2.0void
void
updateLong
(int columnIndex, long x) JDBC 2.0void
updateLong
(int columnNum, long x, int indx) void
updateLong
(String columnName, long x) JDBC 2.0void
updateLong
(String columnName, long x, int indx) void
updateNCharacterStream
(int columnIndex, Reader reader) void
updateNCharacterStream
(int columnIndex, Reader reader, long length) void
updateNCharacterStream
(String columnLabel, Reader reader) void
updateNCharacterStream
(String columnLabel, Reader reader, long length) void
updateNClob
(int columnIndex, Reader reader) void
updateNClob
(int columnIndex, Reader reader, long length) void
updateNClob
(int columnIndex, NClob nClob) void
updateNClob
(String columnLabel, Reader reader) void
updateNClob
(String columnLabel, Reader reader, long length) void
updateNClob
(String columnLabel, NClob nClob) void
updateNString
(int columnIndex, String nString) void
updateNString
(String columnLabel, String nString) void
updateNull
(int columnIndex) JDBC 2.0void
updateNull
(int columnNum, int indx) void
updateNull
(String columnName) JDBC 2.0void
updateNull
(String columnName, int indx) void
updateObject
(int i, Object value) JDBC 2.0void
updateObject
(int columnNum, Object x, int indx) void
updateObject
(String columnName, Object x) JDBC 2.0void
updateObject
(String columnName, Object x, int indx) void
void
void
JDBC 2.0void
updateRowId
(int columnIndex, RowId x) void
updateRowId
(String columnLabel, RowId x) void
updateShort
(int columnIndex, short x) void
updateShort
(String columnName, short x) void
updateSQLXML
(int columnIndex, SQLXML xmlObject) void
updateSQLXML
(String columnLabel, SQLXML xmlObject) void
updateString
(int columnIndex, String x) JDBC 2.0void
updateString
(int columnNum, String x, int indx) void
updateString
(String columnName, String x) JDBC 2.0void
updateString
(String columnName, String x, int indx) void
updateTime
(int columnIndex, Time x) void
updateTime
(String columnName, Time x) void
updateTimestamp
(int columnIndex, Timestamp x) JDBC 2.0void
updateTimestamp
(int columnNum, Timestamp x, int indx) void
updateTimestamp
(String columnName, Timestamp x) JDBC 2.0void
updateTimestamp
(String columnName, Timestamp x, int indx) boolean
wasNull()
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
Methods inherited from interface java.sql.ResultSet
updateObject, updateObject, updateObject, updateObject
-
Constructor Details
-
SDOResultSetImpl
public SDOResultSetImpl(SDOFactory appObject, String sdoName, String where, String sortBy, SDOParameters params) throws Open4GLException, ProSQLException - Throws:
Open4GLException
ProSQLException
-
-
Method Details
-
isAttached
public boolean isAttached()Description copied from interface:SDOResultSet
PROGRESS Extensionis there an underlying appObject attached to the result set?
- Specified by:
isAttached
in interfaceSDOResultSet
- See Also:
-
detachFromAppObj
Description copied from interface:SDOResultSet
PROGRESS ExtensionDetach from the underlying appObject
A Stateless SDOResultSet object can be detached and re-attached from its AppObject using the detachFromAppObj() and attachToAppObj() methods. detachFromAppObj() allows the Java application to use the SDOResultSet without holding any server resources. When the application is ready to send data to the AppServer it calls attachToAppObj(appObject) to regain access to the AppServer.
- Specified by:
detachFromAppObj
in interfaceSDOResultSet
- Throws:
ProSQLException
-
attachToAppObj
Description copied from interface:SDOResultSet
PROGRESS ExtensionAttach to an appObject
- Specified by:
attachToAppObj
in interfaceSDOResultSet
- Throws:
ProSQLException
Open4GLException
- See Also:
-
getSDOInterface
Description copied from interface:SDOResultSet
PROGRESS ExtensionGets direct access the a subset of the underlying methods of the SDO.
- Specified by:
getSDOInterface
in interfaceSDOResultSet
- Throws:
ProSQLException
- if a SDO access error occurs- See Also:
-
releaseSDOInterface
Description copied from interface:SDOResultSet
PROGRESS ExtensionDeletes the underlying SDO after using the SDOInterface the getSDOInterface() method returned. releaseSDOInterface() must be called in stateless mode (see SDOParameters.setStateless) - it has no effect in non stateless mode.
- Specified by:
releaseSDOInterface
in interfaceSDOResultSet
- Throws:
ProSQLException
- if a SDO access error occurs- See Also:
-
startBatch
Description copied from interface:SDOResultSet
PROGRESS ExtensionStart a batch update session
SDOResultSet objects implement the startBatch() and sendBatch() methods. All the updates, deletes and inserts between a startBatch() statement and a sendBatch() ( or sendBatchAndReOpen() ) statement are sent to the AppServer together. Batch update improve performance significantly. cancelBatch() can be used to undo all the modifications that were performed since the last startBatch() statement.
- Specified by:
startBatch
in interfaceSDOResultSet
- Throws:
ProSQLException
- if a SDO access error occurs
-
cancelBatch
Description copied from interface:SDOResultSet
PROGRESS ExtensionCancel a batch
- Specified by:
cancelBatch
in interfaceSDOResultSet
- Throws:
ProSQLException
- if SDO access exception occurs- See Also:
-
inBatch
public boolean inBatch()Description copied from interface:SDOResultSet
PROGRESS ExtensionIs this SDO result set in batch mode?
- Specified by:
inBatch
in interfaceSDOResultSet
- See Also:
-
sendBatchAndReOpen
Description copied from interface:SDOResultSet
PROGRESS ExtensionSend the batch to the SDO on the server, end the batch session and reopen the query. sendBatchAndReOpen() is equivalent to: sendBatch(), close() and then reOpenQuery(), but it is more efficient in stateless mode (see SDOParameters.setStateless).
- Specified by:
sendBatchAndReOpen
in interfaceSDOResultSet
- Throws:
ProSQLException
- if a SDO access error occurs- See Also:
-
sendBatchAndReOpen
Description copied from interface:SDOResultSet
PROGRESS ExtensionSend the batch to the SDO on the server, end the batch session and reopen the query. sendBatchAndReOpen(rowId) is equivalent to: sendBatch(), close() and then reOpenQuery(rowId), but it is more efficient in stateless mode (see SDOParameters.setStateles s).
- Specified by:
sendBatchAndReOpen
in interfaceSDOResultSet
- Throws:
ProSQLException
- if a SDO access error occurs- See Also:
-
sendBatch
Description copied from interface:SDOResultSet
PROGRESS ExtensionSend the batch to the SDO on the server and end the batch session - inBatch() returns false after a sendBatch() call.
- Specified by:
sendBatch
in interfaceSDOResultSet
- Throws:
ProSQLException
- if a SDO access error occurs- See Also:
-
reOpenQuery
Description copied from interface:SDOResultSet
PROGRESS ExtensionReopen the query and position the cusrsor before the first row
- Specified by:
reOpenQuery
in interfaceSDOResultSet
- Throws:
ProSQLException
- if a SDO access error occurs
-
reOpenQuery
Description copied from interface:SDOResultSet
PROGRESS ExtensionReopen the query and position the cusrsor before on the rowId row If rowId is null then reposition before the first row.
- Specified by:
reOpenQuery
in interfaceSDOResultSet
- Parameters:
rowId
- the row identifier of the row to position on- Throws:
ProSQLException
- if a SDO access error occurs- See Also:
-
getQuery
Description copied from interface:SDOResultSet
PROGRESS ExtensionGet the 4GL query that created this SDO result set
- Specified by:
getQuery
in interfaceSDOResultSet
- Throws:
ProSQLException
- if a SDO access error occurs
-
getFetchSize
Description copied from interface:SDOResultSet
JDBC 2.0 Returns the fetch size for this result set.- Specified by:
getFetchSize
in interfaceResultSet
- Specified by:
getFetchSize
in interfaceSDOResultSet
- Returns:
- the current fetch size for this result set
- Throws:
ProSQLException
- if a database access error occurs
-
getRow
Description copied from interface:SDOResultSet
JDBC 2.0Retrieves the current row number. The first row is number 1, the second number 2, and so on.
- Specified by:
getRow
in interfaceResultSet
- Specified by:
getRow
in interfaceSDOResultSet
- Returns:
- the current row number; 0 if there is no current row
- Throws:
ProSQLException
- if a SDO access error occurs
-
updateRow
Description copied from interface:SDOResultSet
JDBC 2.0Updates the underlying SDO with the new contents of the current row. Cannot be called when on the insert row.
- Specified by:
updateRow
in interfaceResultSet
- Specified by:
updateRow
in interfaceSDOResultSet
- Throws:
ProSQLException
- if an SDO access error occurs or if called when on the insert row
-
rowDeleted
Description copied from interface:SDOResultSet
JDBC 2.0Indicates whether a row has been deleted. A deleted row may leave a visible "hole" in a result set. This method can be used to detect holes in a result set. The value returned depends on whether or not the result set can detect deletions.
- Specified by:
rowDeleted
in interfaceResultSet
- Specified by:
rowDeleted
in interfaceSDOResultSet
- Returns:
- true if a row was deleted and deletions are detected
- Throws:
ProSQLException
- if an SDO access error occurs
-
rowUpdated
Description copied from interface:SDOResultSet
JDBC 2.0Indicates whether the current row has been updated.
- Specified by:
rowUpdated
in interfaceResultSet
- Specified by:
rowUpdated
in interfaceSDOResultSet
- Returns:
- true if the current row was updated through this SDO and the update was not yet performed on the underlying SDO.
- Throws:
ProSQLException
- if a SDO access error occurs
-
rowInserted
Description copied from interface:SDOResultSet
JDBC 2.0Indicates whether the current row has had an insertion.
- Specified by:
rowInserted
in interfaceResultSet
- Specified by:
rowInserted
in interfaceSDOResultSet
- Returns:
- true if a row has had an insertion and the insertion was not yet performed on the underlying SDO.
- Throws:
ProSQLException
- if a SDO access error occurs
-
deleteRow
Description copied from interface:SDOResultSet
JDBC 2.0Deletes the current row from the result set and the underlying SDO. Cannot be called when on the insert row.
- Specified by:
deleteRow
in interfaceResultSet
- Specified by:
deleteRow
in interfaceSDOResultSet
- Throws:
ProSQLException
- if an SDO access error occurs or if called when on the insert row.
-
insertRow
Description copied from interface:SDOResultSet
JDBC 2.0Inserts the contents of the insert row into the result set and the SDO. Must be on the insert row when this method is called.
- Specified by:
insertRow
in interfaceResultSet
- Specified by:
insertRow
in interfaceSDOResultSet
- Throws:
ProSQLException
- if an SDO access error occurs, if called when not on the insert row, or if not all of non-nullable columns in the insert row have been given a value
-
cancelRowUpdates
Description copied from interface:SDOResultSet
JDBC 2.0Cancels the updates made to a row. This method may be called after calling an
updateXXX
method(s) and before callingupdateRow
to rollback the updates made to a row. If no updates have been made orupdateRow
has already been called, then this method has no effect.- Specified by:
cancelRowUpdates
in interfaceResultSet
- Specified by:
cancelRowUpdates
in interfaceSDOResultSet
- Throws:
ProSQLException
- if an SDO access error occurs or if called when on the insert row
-
moveToInsertRow
Description copied from interface:SDOResultSet
JDBC 2.0Moves the cursor to the insert row. The current cursor position is remembered while the cursor is positioned on the insert row. The insert row is a special row associated with an updatable result set. It is essentially a buffer where a new row may be constructed by calling the
updateXXX
methods prior to inserting the row into the result set. Only theupdateXXX
,getXXX
, andinsertRow
methods may be called when the cursor is on the insert row. All of the columns in a result set must be given a value each time this method is called before callinginsertRow
. The methodupdateXXX
must be called before agetXXX
method can be called on a column value.- Specified by:
moveToInsertRow
in interfaceResultSet
- Specified by:
moveToInsertRow
in interfaceSDOResultSet
- Throws:
ProSQLException
- if an SDO access error occurs or the result set is not updatable
-
moveToCurrentRow
Description copied from interface:SDOResultSet
JDBC 2.0Moves the cursor to the remembered cursor position, usually the current row. This method has no effect if the cursor is not on the insert row.
- Specified by:
moveToCurrentRow
in interfaceResultSet
- Specified by:
moveToCurrentRow
in interfaceSDOResultSet
- Throws:
ProSQLException
- if an SDO access error occurs or the result set is not updatable
-
previous
Description copied from interface:SDOResultSet
JDBC 2.0Moves the cursor to the previous row in the result set.
Note:
SDOResultSet.previous()
is not the same asSDOResultSet.relative(int)
because it makes sense to callSDOResultSet.previous()
when there is no current row.- Specified by:
previous
in interfaceResultSet
- Specified by:
previous
in interfaceSDOResultSet
- Returns:
- true if the cursor is on a valid row; false if it is off the result set
- Throws:
ProSQLException
- if an SDO access error occurs or the result scrolling mode is FORWARD_ONLY
-
relative
Description copied from interface:SDOResultSet
JDBC 2.0Moves the cursor a relative number of rows, either positive or negative. Attempting to move beyond the first/last row in the result set positions the cursor before/after the the first/last row. Calling
relative(0)
is valid, but does not change the cursor position.Note: Calling
relative(1)
is different from callingnext()
because is makes sense to callnext()
when there is no current row, for example, when the cursor is positioned before the first row or after the last row of the result set.- Specified by:
relative
in interfaceResultSet
- Specified by:
relative
in interfaceSDOResultSet
- Returns:
- true if the cursor is on a row; false otherwise
- Throws:
ProSQLException
- if an SDO access error occurs, there is no current row, or the scrolling mode is FORWARD_ONLY
-
absolute
Description copied from interface:SDOResultSet
PROGRESS ExtensionMoves the cursor to the given row identifier in the result set.
The row identifier is returned from the getRowIdentity() method.
- Specified by:
absolute
in interfaceSDOResultSet
- Parameters:
rowId
- the row identifier of the row to position on- Returns:
- true if the cursor is on the result set; false otherwise
- Throws:
ProSQLException
- if an SDO access error occurs or row is 0, or the scrolling mode is FORWARD_ONLY
-
absolute
Description copied from interface:SDOResultSet
JDBC 2.0Moves the cursor to the given row number in the result set.
If the row number is positive, the cursor moves to the given row number with respect to the beginning of the result set. The first row is row 1, the second is row 2, and so on.
If the given row number is negative, the cursor moves to an absolute row position with respect to the end of the result set. For example, calling
absolute(-1)
positions the cursor on the last row,absolute(-2)
indicates the next-to-last row, and so on.An attempt to position the cursor beyond the first/last row in the result set leaves the cursor before/after the first/last row, respectively.
Note: Calling
absolute(1)
is the same as callingfirst()
. Callingabsolute(-1)
is the same as callinglast()
.- Specified by:
absolute
in interfaceResultSet
- Specified by:
absolute
in interfaceSDOResultSet
- Returns:
- true if the cursor is on the result set; false otherwise
- Throws:
ProSQLException
- if an SDO access error occurs or row is 0, or the scrolling mode is FORWARD_ONLY
-
isBeforeFirst
Description copied from interface:SDOResultSet
JDBC 2.0Indicates whether the cursor is before the first row in the result set.
- Specified by:
isBeforeFirst
in interfaceResultSet
- Specified by:
isBeforeFirst
in interfaceSDOResultSet
- Returns:
- true if the cursor is before the first row, false otherwise. Returns false when the result set contains no rows.
- Throws:
ProSQLException
- if an SDO access error occurs
-
isAfterLast
Description copied from interface:SDOResultSet
JDBC 2.0Indicates whether the cursor is after the last row in the result set.
- Specified by:
isAfterLast
in interfaceResultSet
- Specified by:
isAfterLast
in interfaceSDOResultSet
- Returns:
- true if the cursor is after the last row, false otherwise. Returns false when the result set contains no rows.
- Throws:
ProSQLException
- if an SDO access error occurs
-
beforeFirst
Description copied from interface:SDOResultSet
JDBC 2.0Moves the cursor to the front of the result set, just before the first row. Has no effect if the result set contains no rows.
- Specified by:
beforeFirst
in interfaceResultSet
- Specified by:
beforeFirst
in interfaceSDOResultSet
- Throws:
ProSQLException
- if an SDO access error occurs or the scrolling mode is FORWARD_ONLY
-
isFirst
Description copied from interface:SDOResultSet
JDBC 2.0Indicates whether the cursor is on the first row of the result set.
- Specified by:
isFirst
in interfaceResultSet
- Specified by:
isFirst
in interfaceSDOResultSet
- Returns:
- true if the cursor is on the first row, false otherwise.
- Throws:
ProSQLException
- if a SDO access error occurs
-
first
Description copied from interface:SDOResultSet
JDBC 2.0Moves the cursor to the first row in the result set.
- Specified by:
first
in interfaceResultSet
- Specified by:
first
in interfaceSDOResultSet
- Returns:
- true if the cursor is on a valid row; false if there are no rows in the result set
- Throws:
ProSQLException
- if an SDO access error occurs or the scrolling mode is FORWARD_ONLY
-
afterLast
Description copied from interface:SDOResultSet
JDBC 2.0Moves the cursor to the end of the result set, just after the last row. Has no effect if the result set contains no rows.
- Specified by:
afterLast
in interfaceResultSet
- Specified by:
afterLast
in interfaceSDOResultSet
- Throws:
ProSQLException
- if an SDO access error occurs or the scrolling mode is FORWARD_ONLY
-
isLast
Description copied from interface:SDOResultSet
JDBC 2.0Indicates whether the cursor is on the last row of the result set. Note: Calling the method
isLast
may be expensive because the result set implementation might need to fetch ahead one row in order to determine whether the current row is the last row in the result set.- Specified by:
isLast
in interfaceResultSet
- Specified by:
isLast
in interfaceSDOResultSet
- Returns:
- true if the cursor is on the last row, false otherwise.
- Throws:
ProSQLException
- if a SDO access error occurs
-
last
Description copied from interface:SDOResultSet
JDBC 2.0Moves the cursor to the last row in the result set.
- Specified by:
last
in interfaceResultSet
- Specified by:
last
in interfaceSDOResultSet
- Returns:
- true if the cursor is on a valid row; false if there are no rows in the result set
- Throws:
ProSQLException
- if an SDO access error occurs or the scrolling mode is FORWARD_ONLY
-
updateObject
Description copied from interface:SDOResultSet
JDBC 2.0Updates a column with an Object value. The
updateXXX
methods are used to update column values in the current row, or the insert row. TheupdateXXX
methods do not update the row in the SDO; instead theupdateRow
orinsertRow
methods are called to pdate the row.- Specified by:
updateObject
in interfaceResultSet
- Specified by:
updateObject
in interfaceSDOResultSet
- Parameters:
i
- the first column is 1, the second is 2, ...value
- the new column value- Throws:
ProSQLException
- if an SDO access error occurs
-
updateNull
Description copied from interface:SDOResultSet
JDBC 2.0Updates a column with a null value. The
updateXXX
methods are used to update column values in the current row, or the insert row. TheupdateXXX
methods do not update the underlying SDO; instead theupdateRow
orinsertRow
methods are called to update the SDO.- Specified by:
updateNull
in interfaceResultSet
- Specified by:
updateNull
in interfaceSDOResultSet
- Parameters:
columnName
- the name of the column- Throws:
ProSQLException
- if a SDO access error occurs
-
updateBoolean
Description copied from interface:SDOResultSet
JDBC 2.0Updates a column with a boolean value. The
updateXXX
methods are used to update column values in the current row, or the insert row. TheupdateXXX
methods do not update the underlying SDO; instead theupdateRow
orinsertRow
methods are called to update the SDO.- Specified by:
updateBoolean
in interfaceResultSet
- Specified by:
updateBoolean
in interfaceSDOResultSet
- Parameters:
columnName
- the name of the columnx
- the new column value- Throws:
ProSQLException
- if a SDO access error occurs
-
updateInt
Description copied from interface:SDOResultSet
JDBC 2.0Updates a column with an integer value. The
updateXXX
methods are used to update column values in the current row, or the insert row. TheupdateXXX
methods do not update the underlying SDO; instead theupdateRow
orinsertRow
methods are called to update the SDO.- Specified by:
updateInt
in interfaceResultSet
- Specified by:
updateInt
in interfaceSDOResultSet
- Parameters:
columnName
- the name of the columnx
- the new column value- Throws:
ProSQLException
- if a SDO access error occurs
-
updateLong
Description copied from interface:SDOResultSet
JDBC 2.0Updates a column with a long value. The
updateXXX
methods are used to update column values in the current row, or the insert row. TheupdateXXX
methods do not update the underlying SDO; instead theupdateRow
orinsertRow
methods are called to update the SDO.- Specified by:
updateLong
in interfaceResultSet
- Specified by:
updateLong
in interfaceSDOResultSet
- Parameters:
columnName
- the name of the columnx
- the new column value- Throws:
ProSQLException
- if a SDO access error occurs
-
updateDouble
Description copied from interface:SDOResultSet
JDBC 2.0Updates a column with a double value. The
updateXXX
methods are used to update column values in the current row, or the insert row. TheupdateXXX
methods do not update the underlying SDO; instead theupdateRow
orinsertRow
methods are called to update the SDO.- Specified by:
updateDouble
in interfaceResultSet
- Specified by:
updateDouble
in interfaceSDOResultSet
- Parameters:
columnName
- the name of the columnx
- the new column value- Throws:
ProSQLException
- if a SDO access error occurs
-
updateBigDecimal
Description copied from interface:SDOResultSet
JDBC 2.0Updates a column with a BigDecimal value. The
updateXXX
methods are used to update column values in the current row, or the insert row. TheupdateXXX
methods do not update the underlying SDO; instead theupdateRow
orinsertRow
methods are called to update the SDO.- Specified by:
updateBigDecimal
in interfaceResultSet
- Specified by:
updateBigDecimal
in interfaceSDOResultSet
- Parameters:
columnName
- the name of the columnx
- the new column value- Throws:
ProSQLException
- if a SDO access error occurs
-
updateString
Description copied from interface:SDOResultSet
JDBC 2.0Updates a column with a String value. The
updateXXX
methods are used to update column values in the current row, or the insert row. TheupdateXXX
methods do not update the underlying SDO; instead theupdateRow
orinsertRow
methods are called to update the SDO.- Specified by:
updateString
in interfaceResultSet
- Specified by:
updateString
in interfaceSDOResultSet
- Parameters:
columnName
- the name of the columnx
- the new column value- Throws:
ProSQLException
- if a SDO access error occurs
-
updateBytes
Description copied from interface:SDOResultSet
JDBC 2.0Updates a column with a byte array value. The
updateXXX
methods are used to update column values in the current row, or the insert row. TheupdateXXX
methods do not update the underlying SDO; instead theupdateRow
orinsertRow
methods are called to update the SDO.- Specified by:
updateBytes
in interfaceResultSet
- Specified by:
updateBytes
in interfaceSDOResultSet
- Parameters:
columnName
- the name of the columnx
- the new column value- Throws:
ProSQLException
- if a SDO access error occurs
-
updateDate
Description copied from interface:SDOResultSet
JDBC 2.0Updates a column with a Date value. The
updateXXX
methods are used to update column values in the current row, or the insert row. TheupdateXXX
methods do not update the underlying SDO; instead theupdateRow
orinsertRow
methods are called to update the SDO.- Specified by:
updateDate
in interfaceResultSet
- Specified by:
updateDate
in interfaceSDOResultSet
- Parameters:
columnName
- the name of the columnx
- the new column value- Throws:
ProSQLException
- if a SDO access error occurs
-
updateTimestamp
Description copied from interface:SDOResultSet
JDBC 2.0Updates a column with a Timestamp value. The
updateXXX
methods are used to update column values in the current row, or the insert row. TheupdateXXX
methods do not update the underlying SDO; instead theupdateRow
orinsertRow
methods are called to update the SDO.- Specified by:
updateTimestamp
in interfaceResultSet
- Specified by:
updateTimestamp
in interfaceSDOResultSet
- Parameters:
columnName
- the name of the columnx
- the new column value- Throws:
ProSQLException
- if a SDO access error occurs
-
updateBlob
Description copied from interface:SDOResultSet
JDBC 2.0Updates a column with a Blob value. The
updateXXX
methods are used to update column values in the current row, or the insert row. TheupdateXXX
methods do not update the underlying SDO; instead theupdateRow
orinsertRow
methods are called to update the SDO.- Specified by:
updateBlob
in interfaceResultSet
- Specified by:
updateBlob
in interfaceSDOResultSet
- Parameters:
columnName
- the name of the columnx
- the new column value- Throws:
ProSQLException
- if a SDO access error occurs
-
updateClob
Description copied from interface:SDOResultSet
JDBC 2.0Updates a column with a Clob value. The
updateXXX
methods are used to update column values in the current row, or the insert row. TheupdateXXX
methods do not update the underlying SDO; instead theupdateRow
orinsertRow
methods are called to update the SDO.- Specified by:
updateClob
in interfaceResultSet
- Specified by:
updateClob
in interfaceSDOResultSet
- Parameters:
columnName
- the name of the columnx
- the new column value- Throws:
ProSQLException
- if a SDO access error occurs
-
updateObject
Description copied from interface:SDOResultSet
JDBC 2.0Updates a column with an Object value. The
updateXXX
methods are used to update column values in the current row, or the insert row. TheupdateXXX
methods do not update the underlying SDO; instead theupdateRow
orinsertRow
methods are called to update the SDO.- Specified by:
updateObject
in interfaceResultSet
- Specified by:
updateObject
in interfaceSDOResultSet
- Parameters:
columnName
- the name of the columnx
- the new column value- Throws:
ProSQLException
- if a SDO access error occurs
-
getBigDecimal
Deprecated.- Specified by:
getBigDecimal
in interfaceResultSet
- Throws:
ProSQLException
-
getBigDecimal
Description copied from interface:SDOResultSet
JDBC 2.0Gets the value of a column in the current row as a java.math.BigDecimal object with full precision.
- Specified by:
getBigDecimal
in interfaceResultSet
- Specified by:
getBigDecimal
in interfaceSDOResultSet
- Parameters:
columnName
- the column name- Returns:
- the column value (full precision); if the value is SQL NULL, the result is null
- Throws:
ProSQLException
- if an SDO access error occurs
-
refreshRow
Description copied from interface:SDOResultSet
JDBC 2.0Refreshes the current row with its most recent value in the SDO. Cannot be called when on the insert row. The
refreshRow
method provides a way for an application to explicitly tell the SDOResultSet to refetch a row(s) from the SDO. IfrefreshRow
is called after callingupdateXXX
, but before callingupdateRow
, then the updates made to the row are lost. Calling the methodrefreshRow
frequently will slow performance.- Specified by:
refreshRow
in interfaceResultSet
- Specified by:
refreshRow
in interfaceSDOResultSet
- Throws:
ProSQLException
- if a SDO access error occurs or if called when on the insert row
-
updateNull
Description copied from interface:SDOResultSet
JDBC 2.0Give a nullable column a null value. The
updateXXX
methods are used to update column values in the current row, or the insert row. TheupdateXXX
methods do not update the underlying SDO; instead theupdateRow
orinsertRow
methods are called to update the SDO.- Specified by:
updateNull
in interfaceResultSet
- Specified by:
updateNull
in interfaceSDOResultSet
- Parameters:
columnIndex
- the first column is 1, the second is 2, ...- Throws:
ProSQLException
- if a SDO access error occurs
-
updateBoolean
Description copied from interface:SDOResultSet
JDBC 2.0Updates a column with a boolean value. The
updateXXX
methods are used to update column values in the current row, or the insert row. TheupdateXXX
methods do not update the underlying SDO; instead theupdateRow
orinsertRow
methods are called to update the SDO.- Specified by:
updateBoolean
in interfaceResultSet
- Specified by:
updateBoolean
in interfaceSDOResultSet
- Parameters:
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value- Throws:
ProSQLException
- if a SDO access error occurs
-
updateInt
Description copied from interface:SDOResultSet
JDBC 2.0Updates a column with an integer value. The
updateXXX
methods are used to update column values in the current row, or the insert row. TheupdateXXX
methods do not update the underlying SDO; instead theupdateRow
orinsertRow
methods are called to update the SDO.- Specified by:
updateInt
in interfaceResultSet
- Specified by:
updateInt
in interfaceSDOResultSet
- Parameters:
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value- Throws:
ProSQLException
- if a SDO access error occurs
-
updateLong
Description copied from interface:SDOResultSet
JDBC 2.0Updates a column with a long value. The
updateXXX
methods are used to update column values in the current row, or the insert row. TheupdateXXX
methods do not update the underlying SDO; instead theupdateRow
orinsertRow
methods are called to update the SDO.- Specified by:
updateLong
in interfaceResultSet
- Specified by:
updateLong
in interfaceSDOResultSet
- Parameters:
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value- Throws:
ProSQLException
- if a SDO access error occurs
-
updateDouble
Description copied from interface:SDOResultSet
JDBC 2.0Updates a column with a Double value. The
updateXXX
methods are used to update column values in the current row, or the insert row. TheupdateXXX
methods do not update the underlying SDO; instead theupdateRow
orinsertRow
methods are called to update the SDO.- Specified by:
updateDouble
in interfaceResultSet
- Specified by:
updateDouble
in interfaceSDOResultSet
- Parameters:
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value- Throws:
ProSQLException
- if a SDO access error occurs
-
updateBigDecimal
Description copied from interface:SDOResultSet
JDBC 2.0Updates a column with a BigDecimal value. The
updateXXX
methods are used to update column values in the current row, or the insert row. TheupdateXXX
methods do not update the underlying SDO; instead theupdateRow
orinsertRow
methods are called to update the SDO.- Specified by:
updateBigDecimal
in interfaceResultSet
- Specified by:
updateBigDecimal
in interfaceSDOResultSet
- Parameters:
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value- Throws:
ProSQLException
- if a SDO access error occurs
-
updateString
Description copied from interface:SDOResultSet
JDBC 2.0Updates a column with a String value. The
updateXXX
methods are used to update column values in the current row, or the insert row. TheupdateXXX
methods do not update the underlying SDO; instead theupdateRow
orinsertRow
methods are called to update the SDO.- Specified by:
updateString
in interfaceResultSet
- Specified by:
updateString
in interfaceSDOResultSet
- Parameters:
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value- Throws:
ProSQLException
- if a SDO access error occurs
-
updateBytes
Description copied from interface:SDOResultSet
JDBC 2.0Updates a column with a byte array. The
updateXXX
methods are used to update column values in the current row, or the insert row. TheupdateXXX
methods do not update the underlying SDO; instead theupdateRow
orinsertRow
methods are called to update the SDO.- Specified by:
updateBytes
in interfaceResultSet
- Specified by:
updateBytes
in interfaceSDOResultSet
- Parameters:
columnIndex
- the name of the columnx
- the new column value- Throws:
ProSQLException
- if a SDO access error occurs
-
updateDate
Description copied from interface:SDOResultSet
JDBC 2.0Updates a column with a Date value. The
updateXXX
methods are used to update column values in the current row, or the insert row. TheupdateXXX
methods do not update the underlying SDO; instead theupdateRow
orinsertRow
methods are called to update the SDO.- Specified by:
updateDate
in interfaceResultSet
- Specified by:
updateDate
in interfaceSDOResultSet
- Parameters:
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value- Throws:
ProSQLException
- if a SDO access error occurs
-
updateTimestamp
Description copied from interface:SDOResultSet
JDBC 2.0Updates a column with a Timestamp value. The
updateXXX
methods are used to update column values in the current row, or the insert row. TheupdateXXX
methods do not update the underlying SDO; instead theupdateRow
orinsertRow
methods are called to update the SDO.- Specified by:
updateTimestamp
in interfaceResultSet
- Specified by:
updateTimestamp
in interfaceSDOResultSet
- Parameters:
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value- Throws:
ProSQLException
- if a SDO access error occurs
-
updateBlob
Description copied from interface:SDOResultSet
JDBC 2.0Updates a column with a Blob value. The
updateXXX
methods are used to update column values in the current row, or the insert row. TheupdateXXX
methods do not update the underlying SDO; instead theupdateRow
orinsertRow
methods are called to update the SDO.- Specified by:
updateBlob
in interfaceResultSet
- Specified by:
updateBlob
in interfaceSDOResultSet
- Parameters:
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value- Throws:
ProSQLException
- if a SDO access error occurs
-
updateClob
Description copied from interface:SDOResultSet
JDBC 2.0Updates a column with a Clob value. The
updateXXX
methods are used to update column values in the current row, or the insert row. TheupdateXXX
methods do not update the underlying SDO; instead theupdateRow
orinsertRow
methods are called to update the SDO.- Specified by:
updateClob
in interfaceResultSet
- Specified by:
updateClob
in interfaceSDOResultSet
- Parameters:
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value- Throws:
ProSQLException
- if a SDO access error occurs
-
getBytes
- Specified by:
getBytes
in interfaceResultSet
- Throws:
ProSQLException
-
getString
- Specified by:
getString
in interfaceResultSet
- Throws:
ProSQLException
-
getLong
- Specified by:
getLong
in interfaceResultSet
- Throws:
ProSQLException
-
getInt
- Specified by:
getInt
in interfaceResultSet
- Throws:
ProSQLException
-
getDouble
- Specified by:
getDouble
in interfaceResultSet
- Throws:
ProSQLException
-
getBigDecimal
Deprecated.- Specified by:
getBigDecimal
in interfaceResultSet
- Throws:
ProSQLException
-
getBoolean
- Specified by:
getBoolean
in interfaceResultSet
- Throws:
ProSQLException
-
getDate
- Specified by:
getDate
in interfaceResultSet
- Throws:
ProSQLException
-
getTimestamp
- Specified by:
getTimestamp
in interfaceResultSet
- Throws:
ProSQLException
-
getBlob
- Specified by:
getBlob
in interfaceResultSet
- Throws:
ProSQLException
-
getClob
- Specified by:
getClob
in interfaceResultSet
- Throws:
ProSQLException
-
getGregorianCalendar
Description copied from interface:SDOResultSet
PROGRESS ExtensionGets the value of a column in the current row as a java.util.GregorianCalendar object.
- Specified by:
getGregorianCalendar
in interfaceProResultSet
- Specified by:
getGregorianCalendar
in interfaceSDOResultSet
- Parameters:
field
- the SQL name of the column- Returns:
- the column value; if the value is SQL NULL, the result is null
- Throws:
ProSQLException
- if a SDO access error occurs
-
getObject
- Specified by:
getObject
in interfaceResultSet
- Throws:
ProSQLException
-
getBytes
- Specified by:
getBytes
in interfaceResultSet
- Throws:
ProSQLException
-
getString
- Specified by:
getString
in interfaceResultSet
- Throws:
ProSQLException
-
getLong
- Specified by:
getLong
in interfaceResultSet
- Throws:
ProSQLException
-
getInt
- Specified by:
getInt
in interfaceResultSet
- Throws:
ProSQLException
-
getDouble
- Specified by:
getDouble
in interfaceResultSet
- Throws:
ProSQLException
-
getBigDecimal
Description copied from interface:SDOResultSet
JDBC 2.0Gets the value of a column in the current row as a java.math.BigDecimal object with full precision.
- Specified by:
getBigDecimal
in interfaceResultSet
- Specified by:
getBigDecimal
in interfaceSDOResultSet
- Parameters:
pos
- the first column is 1, the second is 2, ...- Returns:
- the column value (full precision); if the value is SQL NULL, the result is null
- Throws:
ProSQLException
- if an SDO access error occurs
-
getBoolean
- Specified by:
getBoolean
in interfaceResultSet
- Throws:
ProSQLException
-
getDate
- Specified by:
getDate
in interfaceResultSet
- Throws:
ProSQLException
-
getTimestamp
- Specified by:
getTimestamp
in interfaceResultSet
- Throws:
ProSQLException
-
getClob
- Specified by:
getClob
in interfaceResultSet
- Throws:
ProSQLException
-
getBlob
- Specified by:
getBlob
in interfaceResultSet
- Throws:
ProSQLException
-
getGregorianCalendar
Description copied from interface:SDOResultSet
PROGRESS ExtensionGets the value of a column in the current row as a java.util.GregorianCalendar object.
- Specified by:
getGregorianCalendar
in interfaceProResultSet
- Specified by:
getGregorianCalendar
in interfaceSDOResultSet
- Parameters:
pos
- the first column is 1, the second is 2, ...- Returns:
- the column value; if the value is SQL NULL, the result is null
- Throws:
ProSQLException
- if a SDO access error occurs
-
getMetaData
- Specified by:
getMetaData
in interfaceResultSet
- Throws:
ProSQLException
-
getObject
- Specified by:
getObject
in interfaceResultSet
- Throws:
ProSQLException
-
wasNull
- Specified by:
wasNull
in interfaceResultSet
- Throws:
ProSQLException
-
clearWarnings
- Specified by:
clearWarnings
in interfaceResultSet
- Throws:
ProSQLException
-
findColumn
- Specified by:
findColumn
in interfaceResultSet
- Throws:
ProSQLException
-
getAsciiStream
- Specified by:
getAsciiStream
in interfaceResultSet
- Throws:
ProSQLException
-
getAsciiStream
- Specified by:
getAsciiStream
in interfaceResultSet
- Throws:
ProSQLException
-
getBinaryStream
- Specified by:
getBinaryStream
in interfaceResultSet
- Throws:
ProSQLException
-
getBinaryStream
- Specified by:
getBinaryStream
in interfaceResultSet
- Throws:
ProSQLException
-
getByte
- Specified by:
getByte
in interfaceResultSet
- Throws:
ProSQLException
-
getByte
- Specified by:
getByte
in interfaceResultSet
- Throws:
ProSQLException
-
getCursorName
- Specified by:
getCursorName
in interfaceResultSet
- Throws:
ProSQLException
-
getFloat
- Specified by:
getFloat
in interfaceResultSet
- Throws:
ProSQLException
-
getFloat
- Specified by:
getFloat
in interfaceResultSet
- Throws:
ProSQLException
-
getShort
- Specified by:
getShort
in interfaceResultSet
- Throws:
ProSQLException
-
getShort
- Specified by:
getShort
in interfaceResultSet
- Throws:
ProSQLException
-
getTime
- Specified by:
getTime
in interfaceResultSet
- Throws:
ProSQLException
-
getTime
- Specified by:
getTime
in interfaceResultSet
- Throws:
ProSQLException
-
getUnicodeStream
Deprecated.- Specified by:
getUnicodeStream
in interfaceResultSet
- Throws:
ProSQLException
-
getUnicodeStream
Deprecated.- Specified by:
getUnicodeStream
in interfaceResultSet
- Throws:
ProSQLException
-
getWarnings
- Specified by:
getWarnings
in interfaceResultSet
- Throws:
ProSQLException
-
next
- Specified by:
next
in interfaceResultSet
- Throws:
ProSQLException
-
close
- Specified by:
close
in interfaceAutoCloseable
- Specified by:
close
in interfaceResultSet
- Throws:
ProSQLException
-
getRowIdentity
Description copied from interface:SDOResultSet
PROGRESS ExtensionReturns the PROGRES ROWID of the row. If the row comes from a join then returns a comma separated list of identifiers.
- Specified by:
getRowIdentity
in interfaceSDOResultSet
- Throws:
ProSQLException
- if a SDO access error occurs
-
getBytes
- Specified by:
getBytes
in interfaceProResultSet
- Throws:
ProSQLException
-
getString
- Specified by:
getString
in interfaceProResultSet
- Throws:
ProSQLException
-
getLong
- Specified by:
getLong
in interfaceProResultSet
- Throws:
ProSQLException
-
getInt
- Specified by:
getInt
in interfaceProResultSet
- Throws:
ProSQLException
-
getDouble
- Specified by:
getDouble
in interfaceProResultSet
- Throws:
ProSQLException
-
getBigDecimal
- Specified by:
getBigDecimal
in interfaceProResultSet
- Throws:
ProSQLException
-
getBoolean
- Specified by:
getBoolean
in interfaceProResultSet
- Throws:
ProSQLException
-
getDate
- Specified by:
getDate
in interfaceProResultSet
- Throws:
ProSQLException
-
getTimestamp
- Specified by:
getTimestamp
in interfaceProResultSet
- Throws:
ProSQLException
-
getGregorianCalendar
- Specified by:
getGregorianCalendar
in interfaceProResultSet
- Throws:
ProSQLException
-
getBlob
- Specified by:
getBlob
in interfaceProResultSet
- Throws:
ProSQLException
-
getClob
- Specified by:
getClob
in interfaceProResultSet
- Throws:
ProSQLException
-
getObject
- Specified by:
getObject
in interfaceProResultSet
- Throws:
ProSQLException
-
getBytes
Get column value by field name and index.- Specified by:
getBytes
in interfaceProResultSet
- Throws:
ProSQLException
-
getString
- Specified by:
getString
in interfaceProResultSet
- Throws:
ProSQLException
-
getLong
- Specified by:
getLong
in interfaceProResultSet
- Throws:
ProSQLException
-
getInt
- Specified by:
getInt
in interfaceProResultSet
- Throws:
ProSQLException
-
getDouble
- Specified by:
getDouble
in interfaceProResultSet
- Throws:
ProSQLException
-
getBigDecimal
- Specified by:
getBigDecimal
in interfaceProResultSet
- Throws:
ProSQLException
-
getBoolean
- Specified by:
getBoolean
in interfaceProResultSet
- Throws:
ProSQLException
-
getDate
- Specified by:
getDate
in interfaceProResultSet
- Throws:
ProSQLException
-
getTimestamp
- Specified by:
getTimestamp
in interfaceProResultSet
- Throws:
ProSQLException
-
getGregorianCalendar
- Specified by:
getGregorianCalendar
in interfaceProResultSet
- Throws:
ProSQLException
-
getBlob
- Specified by:
getBlob
in interfaceProResultSet
- Throws:
ProSQLException
-
getClob
- Specified by:
getClob
in interfaceProResultSet
- Throws:
ProSQLException
-
getObject
- Specified by:
getObject
in interfaceProResultSet
- Throws:
ProSQLException
-
updateNull
- Throws:
ProSQLException
-
updateBoolean
- Throws:
ProSQLException
-
updateInt
- Throws:
ProSQLException
-
updateLong
- Throws:
ProSQLException
-
updateDouble
- Throws:
ProSQLException
-
updateBigDecimal
- Throws:
ProSQLException
-
updateString
- Throws:
ProSQLException
-
updateBytes
- Throws:
ProSQLException
-
updateDate
- Throws:
ProSQLException
-
updateTimestamp
- Throws:
ProSQLException
-
updateBlob
- Throws:
ProSQLException
-
updateClob
- Throws:
ProSQLException
-
updateObject
- Specified by:
updateObject
in interfaceResultSet
- Throws:
ProSQLException
-
updateNull
- Throws:
ProSQLException
-
updateBoolean
- Throws:
ProSQLException
-
updateInt
- Throws:
ProSQLException
-
updateLong
- Throws:
ProSQLException
-
updateDouble
- Throws:
ProSQLException
-
updateBigDecimal
- Throws:
ProSQLException
-
updateString
- Throws:
ProSQLException
-
updateBytes
- Throws:
ProSQLException
-
updateDate
- Throws:
ProSQLException
-
updateTimestamp
- Throws:
ProSQLException
-
updateBlob
- Throws:
ProSQLException
-
updateClob
- Throws:
ProSQLException
-
updateObject
- Specified by:
updateObject
in interfaceResultSet
- Throws:
ProSQLException
-
updateGregorianCalendar
Description copied from interface:SDOResultSet
PROGRESS ExtensionUpdates a column with a java.util.GregorianCalendar value. The
updateXXX
methods are used to update column values in the current row, or the insert row. TheupdateXXX
methods do not update the underlying SDO; instead theupdateRow
orinsertRow
methods are called to update the SDO.- Specified by:
updateGregorianCalendar
in interfaceSDOResultSet
- Parameters:
columnName
- the name of the columnx
- the new column value- Throws:
ProSQLException
- if a SDO access error occurs
-
updateGregorianCalendar
Description copied from interface:SDOResultSet
PROGRESS ExtensionUpdates a column with a java.util.GregorianCalendar value. The
updateXXX
methods are used to update column values in the current row, or the insert row. TheupdateXXX
methods do not update the underlying SDO; instead theupdateRow
orinsertRow
methods are called to update the SDO.- Specified by:
updateGregorianCalendar
in interfaceSDOResultSet
- Parameters:
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value- Throws:
ProSQLException
- if a SDO access error occurs
-
updateGregorianCalendar
public void updateGregorianCalendar(String columnName, GregorianCalendar x, int indx) throws ProSQLException - Throws:
ProSQLException
-
updateGregorianCalendar
public void updateGregorianCalendar(int columnNum, GregorianCalendar x, int indx) throws ProSQLException - Throws:
ProSQLException
-
getCharacterStream
- Specified by:
getCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
getCharacterStream
- Specified by:
getCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
setFetchDirection
- Specified by:
setFetchDirection
in interfaceResultSet
- Throws:
SQLException
-
getFetchDirection
- Specified by:
getFetchDirection
in interfaceResultSet
- Throws:
SQLException
-
setFetchSize
- Specified by:
setFetchSize
in interfaceResultSet
- Throws:
SQLException
-
getType
- Specified by:
getType
in interfaceResultSet
- Throws:
SQLException
-
getConcurrency
- Specified by:
getConcurrency
in interfaceResultSet
- Throws:
SQLException
-
updateByte
- Specified by:
updateByte
in interfaceResultSet
- Throws:
SQLException
-
updateShort
- Specified by:
updateShort
in interfaceResultSet
- Throws:
SQLException
-
updateFloat
- Specified by:
updateFloat
in interfaceResultSet
- Throws:
SQLException
-
updateTime
- Specified by:
updateTime
in interfaceResultSet
- Throws:
SQLException
-
updateAsciiStream
- Specified by:
updateAsciiStream
in interfaceResultSet
- Throws:
SQLException
-
updateBinaryStream
- Specified by:
updateBinaryStream
in interfaceResultSet
- Throws:
SQLException
-
updateCharacterStream
- Specified by:
updateCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
updateByte
- Specified by:
updateByte
in interfaceResultSet
- Throws:
SQLException
-
updateShort
- Specified by:
updateShort
in interfaceResultSet
- Throws:
SQLException
-
updateFloat
- Specified by:
updateFloat
in interfaceResultSet
- Throws:
SQLException
-
updateTime
- Specified by:
updateTime
in interfaceResultSet
- Throws:
SQLException
-
updateAsciiStream
- Specified by:
updateAsciiStream
in interfaceResultSet
- Throws:
SQLException
-
updateBinaryStream
- Specified by:
updateBinaryStream
in interfaceResultSet
- Throws:
SQLException
-
updateCharacterStream
- Specified by:
updateCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
getStatement
- Specified by:
getStatement
in interfaceResultSet
- Throws:
SQLException
-
getObject
- Specified by:
getObject
in interfaceResultSet
- Throws:
SQLException
-
getRef
- Specified by:
getRef
in interfaceResultSet
- Throws:
SQLException
-
getArray
- Specified by:
getArray
in interfaceResultSet
- Throws:
SQLException
-
getObject
- Specified by:
getObject
in interfaceResultSet
- Throws:
SQLException
-
getRef
- Specified by:
getRef
in interfaceResultSet
- Throws:
SQLException
-
getArray
- Specified by:
getArray
in interfaceResultSet
- Throws:
SQLException
-
getDate
- Specified by:
getDate
in interfaceResultSet
- Throws:
SQLException
-
getDate
- Specified by:
getDate
in interfaceResultSet
- Throws:
SQLException
-
getTime
- Specified by:
getTime
in interfaceResultSet
- Throws:
SQLException
-
getTime
- Specified by:
getTime
in interfaceResultSet
- Throws:
SQLException
-
getTimestamp
- Specified by:
getTimestamp
in interfaceResultSet
- Throws:
SQLException
-
getTimestamp
- Specified by:
getTimestamp
in interfaceResultSet
- Throws:
SQLException
-
getURL
- Specified by:
getURL
in interfaceResultSet
- Throws:
SQLException
-
getURL
- Specified by:
getURL
in interfaceResultSet
- Throws:
SQLException
-
updateArray
- Specified by:
updateArray
in interfaceResultSet
- Throws:
SQLException
-
updateArray
- Specified by:
updateArray
in interfaceResultSet
- Throws:
SQLException
-
updateRef
- Specified by:
updateRef
in interfaceResultSet
- Throws:
SQLException
-
updateRef
- Specified by:
updateRef
in interfaceResultSet
- Throws:
SQLException
-
updateNClob
- Specified by:
updateNClob
in interfaceResultSet
- Throws:
SQLException
-
updateNClob
- Specified by:
updateNClob
in interfaceResultSet
- Throws:
SQLException
-
updateNClob
- Specified by:
updateNClob
in interfaceResultSet
- Throws:
SQLException
-
updateNClob
- Specified by:
updateNClob
in interfaceResultSet
- Throws:
SQLException
-
updateNClob
- Specified by:
updateNClob
in interfaceResultSet
- Throws:
SQLException
-
updateNClob
- Specified by:
updateNClob
in interfaceResultSet
- Throws:
SQLException
-
updateClob
- Specified by:
updateClob
in interfaceResultSet
- Throws:
SQLException
-
updateClob
- Specified by:
updateClob
in interfaceResultSet
- Throws:
SQLException
-
updateClob
- Specified by:
updateClob
in interfaceResultSet
- Throws:
SQLException
-
updateClob
- Specified by:
updateClob
in interfaceResultSet
- Throws:
SQLException
-
getNClob
- Specified by:
getNClob
in interfaceResultSet
- Throws:
SQLException
-
getNClob
- Specified by:
getNClob
in interfaceResultSet
- Throws:
SQLException
-
updateBlob
- Specified by:
updateBlob
in interfaceResultSet
- Throws:
SQLException
-
updateBlob
- Specified by:
updateBlob
in interfaceResultSet
- Throws:
SQLException
-
updateBlob
public void updateBlob(String columnLabel, InputStream inputStream, long length) throws SQLException - Specified by:
updateBlob
in interfaceResultSet
- Throws:
SQLException
-
updateBlob
- Specified by:
updateBlob
in interfaceResultSet
- Throws:
SQLException
-
updateCharacterStream
- Specified by:
updateCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
updateCharacterStream
- Specified by:
updateCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
updateCharacterStream
public void updateCharacterStream(String columnLabel, Reader reader, long length) throws SQLException - Specified by:
updateCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
updateCharacterStream
- Specified by:
updateCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
updateNCharacterStream
- Specified by:
updateNCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
updateNCharacterStream
- Specified by:
updateNCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
updateNCharacterStream
public void updateNCharacterStream(String columnLabel, Reader reader, long length) throws SQLException - Specified by:
updateNCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
updateNCharacterStream
- Specified by:
updateNCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
updateBinaryStream
- Specified by:
updateBinaryStream
in interfaceResultSet
- Throws:
SQLException
-
updateBinaryStream
- Specified by:
updateBinaryStream
in interfaceResultSet
- Throws:
SQLException
-
updateBinaryStream
public void updateBinaryStream(String columnLabel, InputStream inputStream, long length) throws SQLException - Specified by:
updateBinaryStream
in interfaceResultSet
- Throws:
SQLException
-
updateBinaryStream
public void updateBinaryStream(int columnIndex, InputStream inputStream, long length) throws SQLException - Specified by:
updateBinaryStream
in interfaceResultSet
- Throws:
SQLException
-
updateAsciiStream
- Specified by:
updateAsciiStream
in interfaceResultSet
- Throws:
SQLException
-
updateAsciiStream
- Specified by:
updateAsciiStream
in interfaceResultSet
- Throws:
SQLException
-
updateAsciiStream
public void updateAsciiStream(String columnLabel, InputStream inputStream, long length) throws SQLException - Specified by:
updateAsciiStream
in interfaceResultSet
- Throws:
SQLException
-
updateAsciiStream
public void updateAsciiStream(int columnIndex, InputStream inputStream, long length) throws SQLException - Specified by:
updateAsciiStream
in interfaceResultSet
- Throws:
SQLException
-
updateNString
- Specified by:
updateNString
in interfaceResultSet
- Throws:
SQLException
-
updateNString
- Specified by:
updateNString
in interfaceResultSet
- Throws:
SQLException
-
getNString
- Specified by:
getNString
in interfaceResultSet
- Throws:
SQLException
-
getNString
- Specified by:
getNString
in interfaceResultSet
- Throws:
SQLException
-
getNCharacterStream
- Specified by:
getNCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
getNCharacterStream
- Specified by:
getNCharacterStream
in interfaceResultSet
- Throws:
SQLException
-
updateSQLXML
- Specified by:
updateSQLXML
in interfaceResultSet
- Throws:
SQLException
-
updateSQLXML
- Specified by:
updateSQLXML
in interfaceResultSet
- Throws:
SQLException
-
getSQLXML
- Specified by:
getSQLXML
in interfaceResultSet
- Throws:
SQLException
-
getSQLXML
- Specified by:
getSQLXML
in interfaceResultSet
- Throws:
SQLException
-
updateRowId
- Specified by:
updateRowId
in interfaceResultSet
- Throws:
SQLException
-
updateRowId
- Specified by:
updateRowId
in interfaceResultSet
- Throws:
SQLException
-
getRowId
- Specified by:
getRowId
in interfaceResultSet
- Throws:
SQLException
-
getRowId
- Specified by:
getRowId
in interfaceResultSet
- Throws:
SQLException
-
getHoldability
- Specified by:
getHoldability
in interfaceResultSet
- Throws:
SQLException
-
isClosed
- Specified by:
isClosed
in interfaceResultSet
- Throws:
SQLException
-
isWrapperFor
- Specified by:
isWrapperFor
in interfaceWrapper
- Throws:
SQLException
-
unwrap
- Specified by:
unwrap
in interfaceWrapper
- Throws:
SQLException
-
getObject
- Specified by:
getObject
in interfaceResultSet
- Throws:
SQLException
-
getObject
- Specified by:
getObject
in interfaceResultSet
- Throws:
SQLException
-