com.aspc.remote.jdbc

Class SoapResultSet

java.lang.Object

com.aspc.remote.database.internal.SResultSet

com.aspc.remote.jdbc.SoapResultSet

All Implemented Interfaces:

java.lang.AutoCloseable, java.sql.ResultSet, java.sql.Wrapper

public class SoapResultSet
extends SResultSet

SResultSet THREAD MODE: SINGLE-THREADED

Since:

29 September 2006

Author:

Nigel Leck

Field Summary

Fields inherited from class com.aspc.remote.database.internal.SResultSet

ALLOW_OVERFLOW, columnKeys, columns, currentData, rowOffset, rowPage

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

Constructors

Constructor and Description
SoapResultSet(org.w3c.dom.Document doc, int rsCount, Executor callback) the result set

Method Summary

Modifier and Type	Method and Description
void	close() In some cases, it is desirable to immediately release a ResultSet's database and JDBC resources instead of waiting for this to happen when it is automatically closed; the close method provides this immediate release.
protected Row	fetchRow(int row)
java.lang.Object[]	getAttributeNames(int columnIndex) Get the value of a column in the current row as a Java String.
java.lang.Object[]	getAttributeNames(java.lang.String columnName) Get the value of a column in the current row as a Java String.
java.lang.String	getAttributeValue(int columnIndex, java.lang.String key) Get the cellAttributes
java.lang.String	getAttributeValue(java.lang.String columnName, java.lang.String key) Get the cellAttributes
int	getFetchDirection() JDBC 2.0 Returns the fetch direction for this result set.
int	getFetchSize() JDBC 2.0 Returns the fetch size for this result set.
java.sql.ResultSetMetaData	getMetaData() The number, types and properties of a ResultSet's columns are provided by the getMetaData method.
SoapResultSet	getResultSet(int rsCount)
java.lang.Object[]	getRowAttributeNames() Get the rowAttributes
java.lang.String	getRowAttributevValue(java.lang.String key) Get the rowAttributes
int	getSetCount()
java.lang.String	getTitle(java.lang.String orginalCmds)
int	getUpdateCount()
boolean	hasResultSet(int rsCount)
boolean	isUpdateResult()
SoapResultSet	nextResultSet()
void	setFetchDirection(int fetchDirection)
void	setFetchSize(int rows) JDBC 2.0 Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this result set.

Methods inherited from class com.aspc.remote.database.internal.SResultSet

absolute, afterLast, beforeFirst, cancelRowUpdates, clear, clearWarnings, decodeTableData, deleteRow, findColumn, findColumnData, findColumnData, first, formatOutput, getArray, getArray, getAsciiStream, getAsciiStream, getBigDecimal, getBigDecimal, getBigDecimal, getBigDecimal, getBinaryStream, getBinaryStream, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getColumnCount, getColumnDisplaySize, getColumnName, getColumns, getColumnType, getConcurrency, getCursorName, getDate, getDate, getDate, getDate, getDouble, getDouble, getFloat, getFloat, getHoldability, getInt, getInt, getLong, getLong, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getObject, getObject, getObject, getRef, getRef, getRow, getRowId, getRowId, getShort, getShort, getSQLXML, getSQLXML, getStatement, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getType, getUnicodeStream, getUnicodeStream, getURL, getURL, getWarnings, insertRow, isAfterLast, isBeforeFirst, isClosed, isFirst, isLast, isNull, isNull, isWrapperFor, last, load, moveToCurrentRow, moveToInsertRow, next, previous, refreshRow, relative, rewind, rowDeleted, rowInserted, rowUpdated, setCurrentRow, sqlColumnNr, toString, unwrap, updateArray, updateArray, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBigDecimal, updateBigDecimal, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBoolean, updateBoolean, updateByte, updateByte, updateBytes, updateBytes, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateClob, updateClob, updateClob, updateClob, updateDate, updateDate, updateDouble, updateDouble, updateFloat, updateFloat, updateInt, updateInt, updateLong, updateLong, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateNull, updateNull, updateObject, updateObject, updateObject, updateObject, updateRef, updateRef, updateRow, updateRowId, updateRowId, updateShort, updateShort, updateSQLXML, updateSQLXML, updateString, updateString, updateTime, updateTime, updateTimestamp, updateTimestamp, validToGet, wasNull

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface java.sql.ResultSet

updateObject, updateObject, updateObject, updateObject

Constructor Detail

SoapResultSet

public SoapResultSet(org.w3c.dom.Document doc,
                     int rsCount,
                     Executor callback)
              throws java.lang.Exception

the result set

Parameters:

doc - the document

rsCount - the result count

callback - the call back

Throws:

java.lang.Exception - a serious problem

Method Detail

getRowAttributeNames

@CheckReturnValue
 @Nullable
public java.lang.Object[] getRowAttributeNames()
                                                                     throws java.sql.SQLException

Get the rowAttributes

Returns:

HashMap the map of attributes and its value.

Throws:

java.sql.SQLException - if a database-access error occurs.

getRowAttributevValue

@CheckReturnValue
 @Nullable
public java.lang.String getRowAttributevValue(@Nonnull
                                                                           java.lang.String key)
                                                                    throws java.sql.SQLException

Get the rowAttributes

Parameters:

key - the key

Returns:

HashMap the map of attributes and its value.

Throws:

java.sql.SQLException - if a database-access error occurs.

getAttributeNames

@CheckReturnValue
public java.lang.Object[] getAttributeNames(int columnIndex)
                                                       throws java.sql.SQLException

Get the value of a column in the current row as a Java String.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value; if the value is SQL NULL, the result is null

Throws:

java.sql.SQLException - if a database-access error occurs.

getAttributeNames

@CheckReturnValue
public java.lang.Object[] getAttributeNames(java.lang.String columnName)
                                                       throws java.sql.SQLException

Get the value of a column in the current row as a Java String.

Parameters:

columnName - the column name

Returns:

the column value; if the value is SQL NULL, the result is null

Throws:

java.sql.SQLException - if a database-access error occurs.

getAttributeValue

@CheckReturnValue
public java.lang.String getAttributeValue(int columnIndex,
                                                            java.lang.String key)
                                                     throws java.sql.SQLException

Get the cellAttributes

Parameters:

columnIndex - the first column is 1, the second is 2, ...

key - the key

Returns:

HashMap the map of attributes and its value.

Throws:

java.sql.SQLException - if a database-access error occurs.

getAttributeValue

@CheckReturnValue
public java.lang.String getAttributeValue(java.lang.String columnName,
                                                            java.lang.String key)
                                                     throws java.sql.SQLException

Get the cellAttributes

Parameters:

columnName - the column name

key - the key

Returns:

HashMap the map of attributes and its value.

Throws:

java.sql.SQLException - if a database-access error occurs.

getTitle

@CheckReturnValue
public java.lang.String getTitle(java.lang.String orginalCmds)

Parameters:

orginalCmds - the command

Returns:

the title

getSetCount

@CheckReturnValue
public int getSetCount()

Returns:

the set count

close

public void close()
           throws java.sql.SQLException

In some cases, it is desirable to immediately release a ResultSet's database and JDBC resources instead of waiting for this to happen when it is automatically closed; the close method provides this immediate release.

Note: A ResultSet is automatically closed by the Statement that generated it when that Statement is closed, re-executed, or is used to retrieve the next result from a sequence of multiple results. A ResultSet is also automatically closed when it is garbage collected.

Specified by:

close in interface java.lang.AutoCloseable

Specified by:

close in interface java.sql.ResultSet

Overrides:

close in class SResultSet

Throws:

java.sql.SQLException

nextResultSet

@CheckReturnValue
 @Nullable
public SoapResultSet nextResultSet()
                                                         throws java.lang.Exception

Returns:

the next result NULL if no next result set

Throws:

java.lang.Exception - a serious problem

getResultSet

@CheckReturnValue
 @Nullable
public SoapResultSet getResultSet(int rsCount)
                                                        throws java.lang.Exception

Parameters:

rsCount - the result set count

Returns:

the result set

Throws:

java.lang.Exception - a serious problem

hasResultSet

@CheckReturnValue
public boolean hasResultSet(int rsCount)

Parameters:

rsCount - the result set count

Returns:

true if we have a result set

getFetchDirection

@CheckReturnValue
public int getFetchDirection()
                                        throws java.sql.SQLException

JDBC 2.0 Returns the fetch direction for this result set.

Specified by:

getFetchDirection in interface java.sql.ResultSet

Overrides:

getFetchDirection in class SResultSet

Returns:

the value

Throws:

java.sql.SQLException

getMetaData

@CheckReturnValue
 @Nonnull
public java.sql.ResultSetMetaData getMetaData()
                                                                   throws java.sql.SQLException

The number, types and properties of a ResultSet's columns are provided by the getMetaData method.

Specified by:

getMetaData in interface java.sql.ResultSet

Overrides:

getMetaData in class SResultSet

Returns:

the description of a ResultSet's columns

Throws:

java.sql.SQLException - if a database-access error occurs.

setFetchDirection

public void setFetchDirection(int fetchDirection)
                       throws java.sql.SQLException

Specified by:

setFetchDirection in interface java.sql.ResultSet

Overrides:

setFetchDirection in class SResultSet

Parameters:

fetchDirection - the direction

Throws:

java.sql.SQLException - if a database-access error occurs.

getFetchSize

@CheckReturnValue
public int getFetchSize()
                                   throws java.sql.SQLException

JDBC 2.0 Returns the fetch size for this result set.

Specified by:

getFetchSize in interface java.sql.ResultSet

Overrides:

getFetchSize in class SResultSet

Returns:

the value

Throws:

java.sql.SQLException

setFetchSize

public void setFetchSize(int rows)
                  throws java.sql.SQLException

JDBC 2.0 Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this result set. If the fetch size specified is zero, the JDBC driver ignores the value and is free to make its own best guess as to what the fetch size should be. The default value is set by the statement that created the result set. The fetch size may be changed at any time.

Specified by:

setFetchSize in interface java.sql.ResultSet

Overrides:

setFetchSize in class SResultSet

Parameters:

rows - the number of rows to fetch

Throws:

java.sql.SQLException

fetchRow

@CheckReturnValue
 @Nullable
protected Row fetchRow(int row)
                                             throws java.sql.SQLException

Overrides:

fetchRow in class SResultSet

Parameters:

row - the row to use

Returns:

the value

Throws:

java.sql.SQLException

getUpdateCount

@CheckReturnValue
public int getUpdateCount()
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

isUpdateResult

@CheckReturnValue
public boolean isUpdateResult()
                                         throws java.sql.SQLException

Throws:

java.sql.SQLException