com.sybase.jdbcx
Interface SybResultSet

All Known Subinterfaces:
SybCursorResultSet
public abstract interface SybResultSet
extends ResultSet

Sybase implementation of the ResultSet interface. ResultSet objects obtained from jConnect may be downcast to this class to access Sybase-specific methods.

See Also:
ResultSet, Statement.executeQuery(java.lang.String), Statement.getResultSet(), ResultSetMetaData

Field Summary
static int CONCUR_READ_ONLY
          JDBC 2.0 constant for cursor concurrency - read-only.
static int CONCUR_UNKNOWN
           
static int CONCUR_UPDATABLE
          JDBC 2.0 constant for cursor concurrency - updatable.
static int TYPE_FORWARD_ONLY
          JDBC 2.0 constant for result set type - iteration direction.
 
Method Summary
 BigDecimal getBigDecimal(int columnIndex)
          JDBC 2.0 feature - Returns same scale as was sent from database, avoids the performance cost of rescaling.
 BigDecimal getBigDecimal(String columnName)
          JDBC 2.0 feature - Returns same scale as was sent from database, avoids the performance cost of rescaling.
 TextPointer getSybTextPointer(int columnIndex)
          Gets a text pointer which can be used to update the column, specifying the column by number.
 TextPointer getSybTextPointer(String columnName)
          Gets a text pointer which can be used to update the column, specifying the column by name.
 void updateBigDecimal(int columnIndex, BigDecimal x, int precision, int scale)
          JDBC 2.0 feature and Sybase extension to allow a jConnect JDBC application to explicitly set the precision and scale for the NUMERIC parameter value that will be sent to the Database as part of executing this update.
 void updateBigDecimal(String columnName, BigDecimal x, int precision, int scale)
          JDBC 2.0 feature and Sybase extension to allow a jConnect JDBC application to explicitly set the precision and scale for the NUMERIC parameter value that will be sent to the Database as part of executing this update.
 
Methods inherited from interface java.sql.ResultSet
absolute, afterLast, beforeFirst, cancelRowUpdates, clearWarnings, close, deleteRow, findColumn, first, getArray, getArray, getAsciiStream, getAsciiStream, getBigDecimal, getBigDecimal, getBinaryStream, getBinaryStream, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getConcurrency, getCursorName, getDate, getDate, getDate, getDate, getDouble, getDouble, getFetchDirection, getFetchSize, getFloat, getFloat, getInt, getInt, getLong, getLong, getMetaData, getObject, getObject, getObject, getObject, getRef, getRef, getRow, getShort, getShort, getStatement, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getType, getUnicodeStream, getUnicodeStream, getWarnings, insertRow, isAfterLast, isBeforeFirst, isFirst, isLast, last, moveToCurrentRow, moveToInsertRow, next, previous, refreshRow, relative, rowDeleted, rowInserted, rowUpdated, setFetchDirection, setFetchSize, updateAsciiStream, updateAsciiStream, updateBigDecimal, updateBigDecimal, updateBinaryStream, updateBinaryStream, updateBoolean, updateBoolean, updateByte, updateByte, updateBytes, updateBytes, updateCharacterStream, updateCharacterStream, updateDate, updateDate, updateDouble, updateDouble, updateFloat, updateFloat, updateInt, updateInt, updateLong, updateLong, updateNull, updateNull, updateObject, updateObject, updateObject, updateObject, updateRow, updateShort, updateShort, updateString, updateString, updateTime, updateTime, updateTimestamp, updateTimestamp, wasNull
 

Field Detail

TYPE_FORWARD_ONLY

public static final int TYPE_FORWARD_ONLY
JDBC 2.0 constant for result set type - iteration direction.

CONCUR_UNKNOWN

public static final int CONCUR_UNKNOWN

CONCUR_READ_ONLY

public static final int CONCUR_READ_ONLY
JDBC 2.0 constant for cursor concurrency - read-only.

CONCUR_UPDATABLE

public static final int CONCUR_UPDATABLE
JDBC 2.0 constant for cursor concurrency - updatable.
Method Detail

getBigDecimal

public BigDecimal getBigDecimal(int columnIndex)
                                   throws SQLException
JDBC 2.0 feature - Returns same scale as was sent from database, avoids the performance cost of rescaling.
Specified by:
getBigDecimal in interface ResultSet
See Also:
CallableStatement.getBigDecimal(int)

getBigDecimal

public BigDecimal getBigDecimal(String columnName)
                                   throws SQLException
JDBC 2.0 feature - Returns same scale as was sent from database, avoids the performance cost of rescaling.
Specified by:
getBigDecimal in interface ResultSet
See Also:
ResultSet.getBigDecimal(int)

updateBigDecimal

public void updateBigDecimal(int columnIndex,
                             BigDecimal x,
                             int precision,
                             int scale)
                      throws SQLException
JDBC 2.0 feature and Sybase extension to allow a jConnect JDBC application to explicitly set the precision and scale for the NUMERIC parameter value that will be sent to the Database as part of executing this update.
Parameters:
columnIndex - index of the parameter being set.
x - value being sent
precision - the maximum number of digits in the value of x
scale - the maximum number of digits to the right of the decimal in the value of x.
Throws:
SQLException - if precision > 38, precision < 1, or scale < 0, or precision < scale, or if the value x does not fit in the given precision/scale range specified, or if this ResultSet is not updatable.
See Also:
com.sybase.javax.SybPreparedStatement#setBigDecimal

updateBigDecimal

public void updateBigDecimal(String columnName,
                             BigDecimal x,
                             int precision,
                             int scale)
                      throws SQLException
JDBC 2.0 feature and Sybase extension to allow a jConnect JDBC application to explicitly set the precision and scale for the NUMERIC parameter value that will be sent to the Database as part of executing this update.
Parameters:
columnName - name of the column being updated.
x - value being sent
precision - the maximum number of digits in the value of x
scale - the maximum number of digits to the right of the decimal in the value of x.
Throws:
SQLException - if precision > 38, precision < 1, or scale < 0, or precision < scale, or if the value x does not fit in the given precision/scale range specified, or if this ResultSet is not updatable.
See Also:
com.sybase.javax.SybPreparedStatement#setBigDecimal

getSybTextPointer

public TextPointer getSybTextPointer(int columnIndex)
                              throws SQLException
Gets a text pointer which can be used to update the column, specifying the column by number.
Parameters:
columnIndex - column number to fetch (the index of the first column is 1)
Returns:
the text pointer

getSybTextPointer

public TextPointer getSybTextPointer(String columnName)
                              throws SQLException
Gets a text pointer which can be used to update the column, specifying the column by name.
Parameters:
columnName - name of the column to fetch
Returns:
the text pointer