PreparedStatementResultSetImpl (sybaseadapter)

Overview

Package

Class

Tree

Deprecated

Index

Help

Sybase eWay API

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

com.stc.connector.sybaseadapter.base
Class PreparedStatementResultSetImpl

java.lang.Object
  com.stc.connector.sybaseadapter.base.PreparedStatementResultSetImpl

All Implemented Interfaces:: com.stc.connector.appconn.db.PreparedStatementResultSet

Direct Known Subclasses:: SybasePreparedStatementResultSet

public abstract class PreparedStatementResultSetImpl
extends java.lang.Object
implements com.stc.connector.appconn.db.PreparedStatementResultSet
extends java.lang.Object
implements com.stc.connector.appconn.db.PreparedStatementResultSet

Base class for Result Sets returned from a Prepared Statement execution.

Version:: $Revision: 1.5 $
Author:: $Author: pveerava $

Constructor Summary
`PreparedStatementResultSetImpl(int ord, com.stc.connector.appconn.db.PreparedStatementAgent parent)` Constructs a Prepared Statement Result Set object.
`PreparedStatementResultSetImpl(com.stc.connector.appconn.db.ResultSetAgent rsAgent)` Constructs a Prepared Statement Result Set object.

Method Summary
`boolean`	`absolute(int index)` Moves the cursor to the specified row of the result set.
`void`	`afterLast()` Moves the cursor after the last row of the result set.
`boolean`	`available()` Determines whether data for this particular Result Set is available after an execute.
`void`	`beforeFirst()` Moves the cursor before the first row of the result set.
`void`	`clearWarnings()` Clears any warnings reported on this object.
`void`	`close()` Immediately releases a ResultSet object's resources.
`void`	`closeResultSet()` Immediately releases a ResultSet object's resources.
`void`	`deleteRow()` Deletes the current row from the result set and the underlying database.
`int`	`findColumn(java.lang.String index)` Returns the column index for the named column in the result set.
`boolean`	`first()` Moves the cursor to the first row of the result set.
`java.sql.Array`	`getArray(int index)` Gets the Array value of the specified column.
`java.sql.Array`	`getArray(java.lang.String index)` Gets the Array value of the specified column.
`java.io.InputStream`	`getAsciiStream(int index)` Retrieves the value of the specified column vlaue as a stream of ASCII characters.
`java.io.InputStream`	`getAsciiStream(java.lang.String index)` Retrieves the value of the specified column as a stream of ASCII characters.
`java.math.BigDecimal`	`getBigDecimal(int index)` Gets the decimal value of the specified column.
`java.math.BigDecimal`	`getBigDecimal(java.lang.String index)` Gets the decimal value of the specified column.
`java.io.InputStream`	`getBinaryStream(int index)` Retrieves the value of the specified column as a stream of uninterpreted bytes.
`java.io.InputStream`	`getBinaryStream(java.lang.String index)` Retrieves the value of the specified column as a stream of uninterpreted bytes.
`java.sql.Blob`	`getBlob(int index)` Gets the Blob value of the specified column.
`java.sql.Blob`	`getBlob(java.lang.String index)` Gets the Blob value of the specified column.
`boolean`	`getBoolean(int index)` Gets the boolean value of the specified column.
`boolean`	`getBoolean(java.lang.String index)` Gets the boolean value of the specified column.
`byte`	`getByte(int index)` Gets the byte value of the specified column.
`byte`	`getByte(java.lang.String index)` Gets the byte value of the specified column.
`byte[]`	`getBytes(int index)` Gets the byte array value of the specified column.
`byte[]`	`getBytes(java.lang.String index)` Gets the byte array value of the specified column.
`java.io.Reader`	`getCharacterStream(int index)` Retrieves the value of the specified column as a Reader object.
`java.io.Reader`	`getCharacterStream(java.lang.String index)` Retrieves the value of the specified column as a Reader object.
`java.sql.Clob`	`getClob(int index)` Gets the Clob value of the specified column.
`java.sql.Clob`	`getClob(java.lang.String index)` Gets the Clob value of the specified column.
`int`	`getConcurrency()` Gets the concurrency mode for this ResultSet object.
`java.lang.String`	`getCursorName()` Retrieves the name for the cursor associated with this ResultSet object.
`java.sql.Date`	`getDate(int index)` Gets the date value of the specified column.
`java.sql.Date`	`getDate(int index, java.util.Calendar calendar)` Gets the date value of the specified column using the time zone from calendar.
`java.sql.Date`	`getDate(java.lang.String index)` Gets the date value of the specified column.
`java.sql.Date`	`getDate(java.lang.String index, java.util.Calendar calendar)` Gets the date value of the specified column using the time zone from calendar.
`double`	`getDouble(int index)` Gets the double value of the specified column.
`double`	`getDouble(java.lang.String index)` Gets the double value of the specified column.
`int`	`getFetchDirection()` Gets the direction suggested to the driver as the row fetch direction.
`int`	`getFetchSize()` Gets the number of rows to fetch suggested to the driver.
`float`	`getFloat(int index)` Gets the float value of the specified column.
`float`	`getFloat(java.lang.String index)` Gets the float value of the specified column.
`int`	`getInt(int index)` Gets the integer value of the specified column.
`int`	`getInt(java.lang.String index)` Gets the integer value of the specified column.
`long`	`getLong(int index)` Gets the long value of the specified column.
`long`	`getLong(java.lang.String index)` Gets the long value of the specified column.
`java.sql.ResultSetMetaData`	`getMetaData()` Retrieves a ResultSetMetaData object that contains ResultSet propreties.
`java.lang.Object`	`getObject(int index)` Gets the object value of the specified column.
`java.lang.Object`	`getObject(int index, java.util.Map map)` Gets the object value of the specified column using the given type map.
`java.lang.Object`	`getObject(java.lang.String index)` Gets the object value of the specified column.
`java.lang.Object`	`getObject(java.lang.String index, java.util.Map map)` Gets the object value of the specified column using the given type map.
`int`	`getOrdinalPosn()` Retrieves ordinal position of the resultset.
`com.stc.connector.appconn.db.PreparedStatementAgent`	`getParentPreparedStmtAgent()` Retrieves the parent PreparedStatmentAgent.
`java.sql.Ref`	`getRef(int index)` Gets the Ref value of the specified column.
`java.sql.Ref`	`getRef(java.lang.String index)` Gets the Ref value of the specified column.
`int`	`getRow()` Retrieves the current row number in the result set.
`com.stc.connector.appconn.db.ResultSetAgent`	`getRSAgent()` Retrieves the ResultSetAgent.
`short`	`getShort(int index)` Gets the short value of the specified column.
`short`	`getShort(java.lang.String index)` Gets the short value of the specified column.
`java.lang.String`	`getString(int index)` Gets the string value of the specified column.
`java.lang.String`	`getString(java.lang.String index)` Gets the string value of the specified column.
`java.sql.Time`	`getTime(int index)` Gets the time value of the specified column.
`java.sql.Time`	`getTime(int index, java.util.Calendar calendar)` Gets the time value of the specified column using the time zone from calendar.
`java.sql.Time`	`getTime(java.lang.String index)` Gets the time value of the specified column.
`java.sql.Time`	`getTime(java.lang.String index, java.util.Calendar calendar)` Gets the time value of the specified column using the time zone from calendar.
`java.sql.Timestamp`	`getTimestamp(int index)` Gets the timestamp value of the specified column.
`java.sql.Timestamp`	`getTimestamp(int index, java.util.Calendar calendar)` Gets the timestamp value of the specified column using the time zone from calendar.
`java.sql.Timestamp`	`getTimestamp(java.lang.String index)` Gets the timestamp value of the specified column.
`java.sql.Timestamp`	`getTimestamp(java.lang.String index, java.util.Calendar calendar)` Gets the timestamp value of the specified column using the time zone from calendar.
`int`	`getType()` Retrieves the scroll type of cursor associated with the result set.
`java.sql.SQLWarning`	`getWarnings()` Gets the first SQLWarning that has been reported for this object.
`void`	`insertRow()` Inserts the contents of the insert row into the result set and the database.
`boolean`	`isAfterLast()` Determines whether the cursor is after the last row of the result set.
`boolean`	`isBeforeFirst()` Determines whether the cursor is before the first row of the result set.
`boolean`	`isFirst()` Determines whether the cursor is on the first row of the result set.
`boolean`	`isLast()` Determines whether the cursor is on the last row of the result set.
`boolean`	`last()` Moves the cursor to the last row of the result set.
`void`	`moveToCurrentRow()` Moves the cursor to the current row that associated with an updatable result set.
`void`	`moveToInsertRow()` Moves the cursor to the insert row that associated with an updatable result set.
`boolean`	`next()` Moves the cursor to the next row of the result set.
`boolean`	`previous()` Moves the cursor to the previous row of the result set.
`void`	`refreshRow()` Replaces the values int the current row of the result set with their current values in the database.
`boolean`	`relative(int index)` Moves the cursor to the specified row relative to current row of the result set.
`void`	`setFetchDirection(int iDir)` Gives the driver a hint as to the row process direction.
`void`	`setFetchSize(int nSize)` Gives the drivers a hint as to the number of rows that should be fetched each time.
`void`	`setResultSetAgent(com.stc.connector.appconn.db.ResultSetAgent rsAgent)` Sets the underlying `ResultSetAgent` control for this Result Set.
`void`	`updateAsciiStream(int index, java.io.InputStream is, int length)` Updates the designated column with an InputStream object of specified length.
`void`	`updateAsciiStream(java.lang.String index, java.io.InputStream is, int length)` Updates the designated column with an InputStream object of specified length.
`void`	`updateBigDecimal(int index, java.math.BigDecimal dec)` Updates the designated column with a BigDecimal object.
`void`	`updateBigDecimal(java.lang.String index, java.math.BigDecimal dec)` Updates the designated column with a BigDecimal object.
`void`	`updateBinaryStream(int index, java.io.InputStream is, int length)` Updates the designated column with an InputStream object of specified length.
`void`	`updateBinaryStream(java.lang.String index, java.io.InputStream is, int length)` Updates the designated column with an InputStream object of specified length.
`void`	`updateBoolean(int index, boolean b)` Updates the designated column with a boolean value.
`void`	`updateBoolean(java.lang.String index, boolean b)` Updates the designated column with a boolean value.
`void`	`updateByte(int index, byte byt)` Updates the designated column with a byte value.
`void`	`updateByte(java.lang.String index, byte byt)` Updates the designated column with a byte value.
`void`	`updateBytes(int index, byte[] bytes)` Updates the designated column with a byte array value.
`void`	`updateBytes(java.lang.String index, byte[] bytes)` Updates the designated column with a byte array value.
`void`	`updateCharacterStream(int index, java.io.Reader rd, int length)` Updates the designated column with a Reader object of specified length.
`void`	`updateCharacterStream(java.lang.String index, java.io.Reader rd, int length)` Updates the designated column with a Reader object of specified length.
`void`	`updateDate(int index, java.sql.Date date)` Updates the designated column with a Date object.
`void`	`updateDate(java.lang.String index, java.sql.Date date)` Updates the designated column with a Date object.
`void`	`updateDouble(int index, double d)` Updates the designated column with a double value.
`void`	`updateDouble(java.lang.String index, double d)` Updates the designated column with a double value.
`void`	`updateFloat(int index, float f)` Updates the designated column with a float value.
`void`	`updateFloat(java.lang.String index, float f)` Updates the designated column with a float value.
`void`	`updateInt(int index, int i)` Updates the designated column with an integer value.
`void`	`updateInt(java.lang.String index, int i)` Updates the designated column with an integer value.
`void`	`updateLong(int index, long l)` Updates the designated column with a long value.
`void`	`updateLong(java.lang.String index, long l)` Updates the designated column with a long value.
`void`	`updateNull(int index)` Updates the designated nullable column with a null value.
`void`	`updateNull(java.lang.String index)` Updates the designated nullable column with a null value.
`void`	`updateObject(int index, java.lang.Object ob)` Updates the designated column with a Object value.
`void`	`updateObject(int index, java.lang.Object ob, int scale)` Updates the designated column with a Object value with the specified scale.
`void`	`updateObject(java.lang.String index, java.lang.Object ob)` Updates the designated column with a Object value.
`void`	`updateObject(java.lang.String index, java.lang.Object ob, int scale)` Updates the designated column with a Object value with the specified scale.
`void`	`updateRow()` Updates the underlying database with the new contents of the current row.
`void`	`updateShort(int index, short si)` Updates the designated column with a short value.
`void`	`updateShort(java.lang.String index, short si)` Updates the designated column with a short value.
`void`	`updateString(int index, java.lang.String s)` Updates the designated column with a String object.
`void`	`updateString(java.lang.String index, java.lang.String s)` Updates the designated column with a String object.
`void`	`updateTime(int index, java.sql.Time t)` Updates the designated column with a Time object.
`void`	`updateTime(java.lang.String index, java.sql.Time t)` Updates the designated column with a Time object.
`void`	`updateTimestamp(int index, java.sql.Timestamp ts)` Updates the designated column with a Timestamp object.
`void`	`updateTimestamp(java.lang.String index, java.sql.Timestamp ts)` Updates the designated column with a Timestamp object.
`boolean`	`wasNull()` Checks to see if the last value read was SQL NULL or not.

Methods inherited from class java.lang.Object
`clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait`

Constructor Detail

PreparedStatementResultSetImpl

public PreparedStatementResultSetImpl(com.stc.connector.appconn.db.ResultSetAgent rsAgent)

Constructs a Prepared Statement Result Set object.

Parameters:: rsAgent - the ResultSetAgent underlying control.

PreparedStatementResultSetImpl

public PreparedStatementResultSetImpl(int ord,
                                      com.stc.connector.appconn.db.PreparedStatementAgent parent)

Constructs a Prepared Statement Result Set object.

Parameters:: ord - the ordinal position of this Result Set (if there are multiple Result Sets).; parent - the parent PreparedStatementAgent container for this Result Set.

Method Detail

setResultSetAgent

public void setResultSetAgent(com.stc.connector.appconn.db.ResultSetAgent rsAgent)

Sets the underlying ResultSetAgent control for this Result Set.

Specified by:: setResultSetAgent in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: rsAgent - the ResultSetAgent underlying control.

available

public boolean available()
                  throws java.sql.SQLException

Determines whether data for this particular Result Set is available after an execute.

Specified by:: available in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Returns:: true if data is available.
Throws:: java.sql.SQLException - when SQL problems occur.

getMetaData

public java.sql.ResultSetMetaData getMetaData()
                                       throws java.sql.SQLException

Retrieves a ResultSetMetaData object that contains ResultSet propreties.

Specified by:: getMetaData in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Returns:: ResultSetMetaData object
Throws:: java.sql.SQLException - when SQL problems occur.

getConcurrency

public int getConcurrency()
                   throws java.sql.SQLException

Gets the concurrency mode for this ResultSet object.

Specified by:: getConcurrency in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Returns:: concurrency mode
Throws:: java.sql.SQLException - when SQL problems occur.

getFetchDirection

public int getFetchDirection()
                      throws java.sql.SQLException

Gets the direction suggested to the driver as the row fetch direction.

Specified by:: getFetchDirection in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Returns:: Row fetch direction
Throws:: java.sql.SQLException - when SQL problems occur.

setFetchDirection

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

Gives the driver a hint as to the row process direction.

Specified by:: setFetchDirection in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: iDir - fetch direction to use
Throws:: java.sql.SQLException - when SQL problems occur.

getFetchSize

public int getFetchSize()
                 throws java.sql.SQLException

Gets the number of rows to fetch suggested to the driver.

Specified by:: getFetchSize in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Returns:: number of rows to fetch at a time
Throws:: java.sql.SQLException - when SQL problems occur.

setFetchSize

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

Gives the drivers a hint as to the number of rows that should be fetched each time.

Specified by:: setFetchSize in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: nSize - number of rows to fetch at a time
Throws:: java.sql.SQLException - when SQL problems occur.

getCursorName

public java.lang.String getCursorName()
                               throws java.sql.SQLException

Retrieves the name for the cursor associated with this ResultSet object.

Specified by:: getCursorName in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Returns:: name of cursor
Throws:: java.sql.SQLException - when SQL problems occur.

close

public void close()
           throws java.sql.SQLException

Immediately releases a ResultSet object's resources.

Specified by:: close in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Throws:: java.sql.SQLException - when SQL problems occur.

closeResultSet

public void closeResultSet()
                    throws java.sql.SQLException

Immediately releases a ResultSet object's resources.

Throws:: java.sql.SQLException - SQLException when SQL problems occur.

public boolean next()
             throws java.sql.SQLException

Moves the cursor to the next row of the result set.

Specified by:: next in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Returns:: true if successful
Throws:: java.sql.SQLException - when SQL problems occur.

public boolean previous()
                 throws java.sql.SQLException

Moves the cursor to the previous row of the result set.

Specified by:: previous in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Returns:: true if successful
Throws:: java.sql.SQLException - when SQL problems occur.

absolute

public boolean absolute(int index)
                 throws java.sql.SQLException

Moves the cursor to the specified row of the result set.

Specified by:: absolute in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index.
Returns:: true if successful
Throws:: java.sql.SQLException - when SQL problems occur.

relative

public boolean relative(int index)
                 throws java.sql.SQLException

Moves the cursor to the specified row relative to current row of the result set.

Specified by:: relative in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index.
Returns:: true if successful
Throws:: java.sql.SQLException - when SQL problems occur.

first

public boolean first()
              throws java.sql.SQLException

Moves the cursor to the first row of the result set.

Specified by:: first in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Returns:: true if successful
Throws:: java.sql.SQLException - when SQL problems occur.

isFirst

public boolean isFirst()
                throws java.sql.SQLException

Determines whether the cursor is on the first row of the result set.

Specified by:: isFirst in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Returns:: true if on first row
Throws:: java.sql.SQLException - when SQL problems occur.

last

public boolean last()
             throws java.sql.SQLException

Moves the cursor to the last row of the result set.

Specified by:: last in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Returns:: true if successful
Throws:: java.sql.SQLException - when SQL problems occur.

isLast

public boolean isLast()
               throws java.sql.SQLException

Determines whether the cursor is on the last row of the result set.

Specified by:: isLast in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Returns:: true if on last row
Throws:: java.sql.SQLException - when SQL problems occur.

beforeFirst

public void beforeFirst()
                 throws java.sql.SQLException

Moves the cursor before the first row of the result set.

Specified by:: beforeFirst in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Throws:: java.sql.SQLException - when SQL problems occur.

isBeforeFirst

public boolean isBeforeFirst()
                      throws java.sql.SQLException

Determines whether the cursor is before the first row of the result set.

Specified by:: isBeforeFirst in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Returns:: true if before first row
Throws:: java.sql.SQLException - when SQL problems occur.

afterLast

public void afterLast()
               throws java.sql.SQLException

Moves the cursor after the last row of the result set.

Specified by:: afterLast in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Throws:: java.sql.SQLException - when SQL problems occur.

isAfterLast

public boolean isAfterLast()
                    throws java.sql.SQLException

Determines whether the cursor is after the last row of the result set.

Specified by:: isAfterLast in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Returns:: true if afater last row
Throws:: java.sql.SQLException - when SQL problems occur.

getType

public int getType()
            throws java.sql.SQLException

Retrieves the scroll type of cursor associated with the result set.

Specified by:: getType in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Returns:: scroll type of cursor
Throws:: java.sql.SQLException - when SQL problems occur.

findColumn

public int findColumn(java.lang.String index)
               throws java.sql.SQLException

Returns the column index for the named column in the result set.

Specified by:: findColumn in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name
Returns:: corresponding column index
Throws:: java.sql.SQLException - when SQL problems occur.

getObject

public java.lang.Object getObject(int index)
                           throws java.sql.SQLException

Gets the object value of the specified column.

Specified by:: getObject in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index
Returns:: object form of column value
Throws:: java.sql.SQLException - when SQL problems occur.

getObject

public java.lang.Object getObject(java.lang.String index)
                           throws java.sql.SQLException

Gets the object value of the specified column.

Specified by:: getObject in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name
Returns:: object form of column value
Throws:: java.sql.SQLException - when SQL problems occur.

getObject

public java.lang.Object getObject(int index,
                                  java.util.Map map)
                           throws java.sql.SQLException

Gets the object value of the specified column using the given type map.

Specified by:: getObject in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index; map - type map
Returns:: object form of column value
Throws:: java.sql.SQLException - when SQL problems occur.

getObject

public java.lang.Object getObject(java.lang.String index,
                                  java.util.Map map)
                           throws java.sql.SQLException

Gets the object value of the specified column using the given type map.

Specified by:: getObject in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name; map - type map
Returns:: object form of column value
Throws:: java.sql.SQLException - when SQL problems occur.

getBoolean

public boolean getBoolean(int index)
                   throws java.sql.SQLException

Gets the boolean value of the specified column.

Specified by:: getBoolean in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index
Returns:: boolean value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getBoolean

public boolean getBoolean(java.lang.String index)
                   throws java.sql.SQLException

Gets the boolean value of the specified column.

Specified by:: getBoolean in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name
Returns:: boolean value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getByte

public byte getByte(int index)
             throws java.sql.SQLException

Gets the byte value of the specified column.

Specified by:: getByte in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index
Returns:: byte value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getByte

public byte getByte(java.lang.String index)
             throws java.sql.SQLException

Gets the byte value of the specified column.

Specified by:: getByte in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name
Returns:: byte value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getShort

public short getShort(int index)
               throws java.sql.SQLException

Gets the short value of the specified column.

Specified by:: getShort in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index
Returns:: short value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getShort

public short getShort(java.lang.String index)
               throws java.sql.SQLException

Gets the short value of the specified column.

Specified by:: getShort in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name
Returns:: short value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getInt

public int getInt(int index)
           throws java.sql.SQLException

Gets the integer value of the specified column.

Specified by:: getInt in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index
Returns:: int value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getInt

public int getInt(java.lang.String index)
           throws java.sql.SQLException

Gets the integer value of the specified column.

Specified by:: getInt in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name
Returns:: int value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getLong

public long getLong(int index)
             throws java.sql.SQLException

Gets the long value of the specified column.

Specified by:: getLong in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index
Returns:: long value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getLong

public long getLong(java.lang.String index)
             throws java.sql.SQLException

Gets the long value of the specified column.

Specified by:: getLong in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name
Returns:: long value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getFloat

public float getFloat(int index)
               throws java.sql.SQLException

Gets the float value of the specified column.

Specified by:: getFloat in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index
Returns:: float value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getFloat

public float getFloat(java.lang.String index)
               throws java.sql.SQLException

Gets the float value of the specified column.

Specified by:: getFloat in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name
Returns:: float value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getDouble

public double getDouble(int index)
                 throws java.sql.SQLException

Gets the double value of the specified column.

Specified by:: getDouble in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index
Returns:: double value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getDouble

public double getDouble(java.lang.String index)
                 throws java.sql.SQLException

Gets the double value of the specified column.

Specified by:: getDouble in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name
Returns:: double value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getBigDecimal

public java.math.BigDecimal getBigDecimal(int index)
                                   throws java.sql.SQLException

Gets the decimal value of the specified column.

Specified by:: getBigDecimal in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index
Returns:: big decimal value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getBigDecimal

public java.math.BigDecimal getBigDecimal(java.lang.String index)
                                   throws java.sql.SQLException

Gets the decimal value of the specified column.

Specified by:: getBigDecimal in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name
Returns:: big decimal value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getDate

public java.sql.Date getDate(int index)
                      throws java.sql.SQLException

Gets the date value of the specified column.

Specified by:: getDate in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index
Returns:: date value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getDate

public java.sql.Date getDate(java.lang.String index)
                      throws java.sql.SQLException

Gets the date value of the specified column.

Specified by:: getDate in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name
Returns:: date value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getDate

public java.sql.Date getDate(int index,
                             java.util.Calendar calendar)
                      throws java.sql.SQLException

Gets the date value of the specified column using the time zone from calendar.

Specified by:: getDate in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index; calendar - calandar to use
Returns:: date value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getDate

public java.sql.Date getDate(java.lang.String index,
                             java.util.Calendar calendar)
                      throws java.sql.SQLException

Gets the date value of the specified column using the time zone from calendar.

Specified by:: getDate in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name; calendar - calendar to use
Returns:: date value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getTime

public java.sql.Time getTime(int index)
                      throws java.sql.SQLException

Gets the time value of the specified column.

Specified by:: getTime in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index
Returns:: time value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getTime

public java.sql.Time getTime(java.lang.String index)
                      throws java.sql.SQLException

Gets the time value of the specified column.

Specified by:: getTime in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name
Returns:: time value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getTime

public java.sql.Time getTime(int index,
                             java.util.Calendar calendar)
                      throws java.sql.SQLException

Gets the time value of the specified column using the time zone from calendar.

Specified by:: getTime in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index; calendar - calendar to use
Returns:: time value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getTime

public java.sql.Time getTime(java.lang.String index,
                             java.util.Calendar calendar)
                      throws java.sql.SQLException

Gets the time value of the specified column using the time zone from calendar.

Specified by:: getTime in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name; calendar - calendar to use
Returns:: time value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getTimestamp

public java.sql.Timestamp getTimestamp(int index)
                                throws java.sql.SQLException

Gets the timestamp value of the specified column.

Specified by:: getTimestamp in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index
Returns:: timestamp value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String index)
                                throws java.sql.SQLException

Gets the timestamp value of the specified column.

Specified by:: getTimestamp in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name
Returns:: timestamp value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getTimestamp

public java.sql.Timestamp getTimestamp(int index,
                                       java.util.Calendar calendar)
                                throws java.sql.SQLException

Gets the timestamp value of the specified column using the time zone from calendar.

Specified by:: getTimestamp in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index; calendar - calendar to use
Returns:: timestamp value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String index,
                                       java.util.Calendar calendar)
                                throws java.sql.SQLException

Gets the timestamp value of the specified column using the time zone from calendar.

Specified by:: getTimestamp in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name; calendar - calendar to use
Returns:: timestamp value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getString

public java.lang.String getString(int index)
                           throws java.sql.SQLException

Gets the string value of the specified column.

Specified by:: getString in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index
Returns:: string value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getString

public java.lang.String getString(java.lang.String index)
                           throws java.sql.SQLException

Gets the string value of the specified column.

Specified by:: getString in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name
Returns:: string value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getBytes

public byte[] getBytes(int index)
                throws java.sql.SQLException

Gets the byte array value of the specified column.

Specified by:: getBytes in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index
Returns:: byte array value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getBytes

public byte[] getBytes(java.lang.String index)
                throws java.sql.SQLException

Gets the byte array value of the specified column.

Specified by:: getBytes in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name
Returns:: byte array value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getAsciiStream

public java.io.InputStream getAsciiStream(int index)
                                   throws java.sql.SQLException

Retrieves the value of the specified column vlaue as a stream of ASCII characters.

Specified by:: getAsciiStream in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index
Returns:: ASCII output stream value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getAsciiStream

public java.io.InputStream getAsciiStream(java.lang.String index)
                                   throws java.sql.SQLException

Retrieves the value of the specified column as a stream of ASCII characters.

Specified by:: getAsciiStream in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name
Returns:: ASCII output stream value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getBinaryStream

public java.io.InputStream getBinaryStream(int index)
                                    throws java.sql.SQLException

Retrieves the value of the specified column as a stream of uninterpreted bytes.

Specified by:: getBinaryStream in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index
Returns:: Binary out stream value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getBinaryStream

public java.io.InputStream getBinaryStream(java.lang.String index)
                                    throws java.sql.SQLException

Retrieves the value of the specified column as a stream of uninterpreted bytes.

Specified by:: getBinaryStream in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name
Returns:: Binary out stream value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getCharacterStream

public java.io.Reader getCharacterStream(int index)
                                  throws java.sql.SQLException

Retrieves the value of the specified column as a Reader object.

Specified by:: getCharacterStream in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index
Returns:: Reader for value in column
Throws:: java.sql.SQLException - when SQL problems occur.

getCharacterStream

public java.io.Reader getCharacterStream(java.lang.String index)
                                  throws java.sql.SQLException

Retrieves the value of the specified column as a Reader object.

Specified by:: getCharacterStream in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name
Returns:: Reader for value in column
Throws:: java.sql.SQLException - when SQL problems occur.

getArray

public java.sql.Array getArray(int index)
                        throws java.sql.SQLException

Gets the Array value of the specified column.

Specified by:: getArray in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index
Returns:: Array value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getArray

public java.sql.Array getArray(java.lang.String index)
                        throws java.sql.SQLException

Gets the Array value of the specified column.

Specified by:: getArray in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name
Returns:: Array value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getBlob

public java.sql.Blob getBlob(int index)
                      throws java.sql.SQLException

Gets the Blob value of the specified column.

Specified by:: getBlob in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index
Returns:: Blob value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getBlob

public java.sql.Blob getBlob(java.lang.String index)
                      throws java.sql.SQLException

Gets the Blob value of the specified column.

Specified by:: getBlob in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name
Returns:: Blob value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getClob

public java.sql.Clob getClob(int index)
                      throws java.sql.SQLException

Gets the Clob value of the specified column.

Specified by:: getClob in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index
Returns:: Clob value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getClob

public java.sql.Clob getClob(java.lang.String index)
                      throws java.sql.SQLException

Gets the Clob value of the specified column.

Specified by:: getClob in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name
Returns:: Clob value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getRef

public java.sql.Ref getRef(int index)
                    throws java.sql.SQLException

Gets the Ref value of the specified column.

Specified by:: getRef in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index
Returns:: Ref value of column
Throws:: java.sql.SQLException - when SQL problems occur.

getRef

public java.sql.Ref getRef(java.lang.String index)
                    throws java.sql.SQLException

Gets the Ref value of the specified column.

Specified by:: getRef in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name
Returns:: Ref value of column
Throws:: java.sql.SQLException - when SQL problems occur.

wasNull

public boolean wasNull()
                throws java.sql.SQLException

Checks to see if the last value read was SQL NULL or not.

Specified by:: wasNull in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Returns:: true if SQL NULL
Throws:: java.sql.SQLException - when SQL problems occur.

getWarnings

public java.sql.SQLWarning getWarnings()
                                throws java.sql.SQLException

Gets the first SQLWarning that has been reported for this object.

Specified by:: getWarnings in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Returns:: SQL Warning
Throws:: java.sql.SQLException - when SQL problems occur.

updateNull

public void updateNull(int index)
                throws java.sql.SQLException

Updates the designated nullable column with a null value.

Specified by:: updateNull in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index.
Throws:: java.sql.SQLException - when SQL problems occur.

updateNull

public void updateNull(java.lang.String index)
                throws java.sql.SQLException

Updates the designated nullable column with a null value.

Specified by:: updateNull in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name.
Throws:: java.sql.SQLException - when SQL problems occur.

updateObject

public void updateObject(int index,
                         java.lang.Object ob)
                  throws java.sql.SQLException

Updates the designated column with a Object value.

Specified by:: updateObject in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index.; ob - an Object parameter value.
Throws:: java.sql.SQLException - when SQL problems occur.

updateObject

public void updateObject(java.lang.String index,
                         java.lang.Object ob)
                  throws java.sql.SQLException

Updates the designated column with a Object value.

Specified by:: updateObject in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name.; ob - an Object parameter value.
Throws:: java.sql.SQLException - when SQL problems occur.

updateObject

public void updateObject(int index,
                         java.lang.Object ob,
                         int scale)
                  throws java.sql.SQLException

Updates the designated column with a Object value with the specified scale.

Specified by:: updateObject in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index.; ob - an Object parameter value.; scale - the desired number of digits to the right of the decimal point.
Throws:: java.sql.SQLException - when SQL problems occur.

updateObject

public void updateObject(java.lang.String index,
                         java.lang.Object ob,
                         int scale)
                  throws java.sql.SQLException

Updates the designated column with a Object value with the specified scale.

Specified by:: updateObject in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name.; ob - an Object parameter value.; scale - the desired number of digits to the right of the decimal point.
Throws:: java.sql.SQLException - when SQL problems occur.

updateBoolean

public void updateBoolean(int index,
                          boolean b)
                   throws java.sql.SQLException

Updates the designated column with a boolean value.

Specified by:: updateBoolean in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index.; b - a boolean parameter value.
Throws:: java.sql.SQLException - when SQL problems occur.

updateBoolean

public void updateBoolean(java.lang.String index,
                          boolean b)
                   throws java.sql.SQLException

Updates the designated column with a boolean value.

Specified by:: updateBoolean in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name.; b - a boolean parameter value.
Throws:: java.sql.SQLException - when SQL problems occur.

updateByte

public void updateByte(int index,
                       byte byt)
                throws java.sql.SQLException

Updates the designated column with a byte value.

Specified by:: updateByte in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index.; byt - a byte parameter value
Throws:: java.sql.SQLException - when SQL problems occur.

updateByte

public void updateByte(java.lang.String index,
                       byte byt)
                throws java.sql.SQLException

Updates the designated column with a byte value.

Specified by:: updateByte in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name.; byt - a byte parameter value
Throws:: java.sql.SQLException - when SQL problems occur.

updateShort

public void updateShort(int index,
                        short si)
                 throws java.sql.SQLException

Updates the designated column with a short value.

Specified by:: updateShort in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index.; si - a short parameter value.
Throws:: java.sql.SQLException - when SQL problems occur.

updateShort

public void updateShort(java.lang.String index,
                        short si)
                 throws java.sql.SQLException

Updates the designated column with a short value.

Specified by:: updateShort in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name.; si - a short parameter value.
Throws:: java.sql.SQLException - when SQL problems occur.

updateInt

public void updateInt(int index,
                      int i)
               throws java.sql.SQLException

Updates the designated column with an integer value.

Specified by:: updateInt in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index.; i - an integer parameter value.
Throws:: java.sql.SQLException - when SQL problems occur.

updateInt

public void updateInt(java.lang.String index,
                      int i)
               throws java.sql.SQLException

Updates the designated column with an integer value.

Specified by:: updateInt in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index.; i - an integer parameter value.
Throws:: java.sql.SQLException - when SQL problems occur.

updateLong

public void updateLong(int index,
                       long l)
                throws java.sql.SQLException

Updates the designated column with a long value.

Specified by:: updateLong in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index.; l - a long parameter value.
Throws:: java.sql.SQLException - when SQL problems occur.

updateLong

public void updateLong(java.lang.String index,
                       long l)
                throws java.sql.SQLException

Updates the designated column with a long value.

Specified by:: updateLong in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name.; l - a long parameter value.
Throws:: java.sql.SQLException - when SQL problems occur.

updateFloat

public void updateFloat(int index,
                        float f)
                 throws java.sql.SQLException

Updates the designated column with a float value.

Specified by:: updateFloat in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index.; f - a float parameter value.
Throws:: java.sql.SQLException - when SQL problems occur.

updateFloat

public void updateFloat(java.lang.String index,
                        float f)
                 throws java.sql.SQLException

Updates the designated column with a float value.

Specified by:: updateFloat in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name.; f - a float parameter value.
Throws:: java.sql.SQLException - when SQL problems occur.

updateDouble

public void updateDouble(int index,
                         double d)
                  throws java.sql.SQLException

Updates the designated column with a double value.

Specified by:: updateDouble in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index.; d - a double parameter value.
Throws:: java.sql.SQLException - when SQL problems occur.

updateDouble

public void updateDouble(java.lang.String index,
                         double d)
                  throws java.sql.SQLException

Updates the designated column with a double value.

Specified by:: updateDouble in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name.; d - a double parameter value.
Throws:: java.sql.SQLException - when SQL problems occur.

updateBigDecimal

public void updateBigDecimal(int index,
                             java.math.BigDecimal dec)
                      throws java.sql.SQLException

Updates the designated column with a BigDecimal object.

Specified by:: updateBigDecimal in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index.; dec - a BigDecimal parameter value.
Throws:: java.sql.SQLException - when SQL problems occur.

updateBigDecimal

public void updateBigDecimal(java.lang.String index,
                             java.math.BigDecimal dec)
                      throws java.sql.SQLException

Updates the designated column with a BigDecimal object.

Specified by:: updateBigDecimal in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name.; dec - a BigDecimal parameter value.
Throws:: java.sql.SQLException - when SQL problems occur.

updateDate

public void updateDate(int index,
                       java.sql.Date date)
                throws java.sql.SQLException

Updates the designated column with a Date object.

Specified by:: updateDate in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index.; date - a Date parameter value.
Throws:: java.sql.SQLException - when SQL problems occur.

updateDate

public void updateDate(java.lang.String index,
                       java.sql.Date date)
                throws java.sql.SQLException

Updates the designated column with a Date object.

Specified by:: updateDate in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name.; date - a Date parameter value.
Throws:: java.sql.SQLException - when SQL problems occur.

updateTime

public void updateTime(int index,
                       java.sql.Time t)
                throws java.sql.SQLException

Updates the designated column with a Time object.

Specified by:: updateTime in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index.; t - a Time parameter value.
Throws:: java.sql.SQLException - when SQL problems occur.

updateTime

public void updateTime(java.lang.String index,
                       java.sql.Time t)
                throws java.sql.SQLException

Updates the designated column with a Time object.

Specified by:: updateTime in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name.; t - a Time parameter value.
Throws:: java.sql.SQLException - when SQL problems occur.

updateTimestamp

public void updateTimestamp(int index,
                            java.sql.Timestamp ts)
                     throws java.sql.SQLException

Updates the designated column with a Timestamp object.

Specified by:: updateTimestamp in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index.; ts - a Timestamp parameter value.
Throws:: java.sql.SQLException - when SQL problems occur.

updateTimestamp

public void updateTimestamp(java.lang.String index,
                            java.sql.Timestamp ts)
                     throws java.sql.SQLException

Updates the designated column with a Timestamp object.

Specified by:: updateTimestamp in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name.; ts - a Timestamp parameter value.
Throws:: java.sql.SQLException - when SQL problems occur.

updateString

public void updateString(int index,
                         java.lang.String s)
                  throws java.sql.SQLException

Updates the designated column with a String object.

Specified by:: updateString in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index.; s - a String parameter value.
Throws:: java.sql.SQLException - when SQL problems occur.

updateString

public void updateString(java.lang.String index,
                         java.lang.String s)
                  throws java.sql.SQLException

Updates the designated column with a String object.

Specified by:: updateString in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name.; s - a String parameter value.
Throws:: java.sql.SQLException - when SQL problems occur.

updateBytes

public void updateBytes(int index,
                        byte[] bytes)
                 throws java.sql.SQLException

Updates the designated column with a byte array value.

Specified by:: updateBytes in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index.; bytes - a byte arrary parameter value.
Throws:: java.sql.SQLException - when SQL problems occur.

updateBytes

public void updateBytes(java.lang.String index,
                        byte[] bytes)
                 throws java.sql.SQLException

Updates the designated column with a byte array value.

Specified by:: updateBytes in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name.; bytes - a byte arrary parameter value.
Throws:: java.sql.SQLException - when SQL problems occur.

updateAsciiStream

public void updateAsciiStream(int index,
                              java.io.InputStream is,
                              int length)
                       throws java.sql.SQLException

Updates the designated column with an InputStream object of specified length.

Specified by:: updateAsciiStream in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index.; is - an Ascii stream parameter value.; length - the number of bytes to be read from the stream.
Throws:: java.sql.SQLException - when SQL problems occur.

updateAsciiStream

public void updateAsciiStream(java.lang.String index,
                              java.io.InputStream is,
                              int length)
                       throws java.sql.SQLException

Updates the designated column with an InputStream object of specified length.

Specified by:: updateAsciiStream in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name.; is - an Ascii stream parameter value.; length - the number of bytes to be read from the stream.
Throws:: java.sql.SQLException - when SQL problems occur.

updateBinaryStream

public void updateBinaryStream(int index,
                               java.io.InputStream is,
                               int length)
                        throws java.sql.SQLException

Updates the designated column with an InputStream object of specified length.

Specified by:: updateBinaryStream in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index.; is - a Binary stream parameter value.; length - the number of bytes to be read from the stream.
Throws:: java.sql.SQLException - when SQL problems occur.

updateBinaryStream

public void updateBinaryStream(java.lang.String index,
                               java.io.InputStream is,
                               int length)
                        throws java.sql.SQLException

Updates the designated column with an InputStream object of specified length.

Specified by:: updateBinaryStream in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column name.; is - a Binary stream parameter value.; length - the number of bytes to be read from the stream.
Throws:: java.sql.SQLException - when SQL problems occur.

updateCharacterStream

public void updateCharacterStream(java.lang.String index,
                                  java.io.Reader rd,
                                  int length)
                           throws java.sql.SQLException

Updates the designated column with a Reader object of specified length.

Specified by:: updateCharacterStream in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index.; rd - a Reader parameter value.; length - the number of characters to be read from the stream.
Throws:: java.sql.SQLException - when SQL problems occur.

updateCharacterStream

public void updateCharacterStream(int index,
                                  java.io.Reader rd,
                                  int length)
                           throws java.sql.SQLException

Updates the designated column with a Reader object of specified length.

Specified by:: updateCharacterStream in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Parameters:: index - column index.; rd - a Reader parameter value.; length - the number of characters to be read from the stream.
Throws:: java.sql.SQLException - when SQL problems occur.

clearWarnings

public void clearWarnings()
                   throws java.sql.SQLException

Clears any warnings reported on this object.

Specified by:: clearWarnings in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Throws:: java.sql.SQLException - when SQL problems occur.

getRow

public int getRow()
           throws java.sql.SQLException

Retrieves the current row number in the result set.

Specified by:: getRow in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Returns:: current row number
Throws:: java.sql.SQLException - when SQL problems occur.

refreshRow

public void refreshRow()
                throws java.sql.SQLException

Replaces the values int the current row of the result set with their current values in the database.

Specified by:: refreshRow in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Throws:: java.sql.SQLException - when SQL problems occur.

insertRow

public void insertRow()
               throws java.sql.SQLException

Inserts the contents of the insert row into the result set and the database.

Specified by:: insertRow in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Throws:: java.sql.SQLException - when SQL problems occur.

updateRow

public void updateRow()
               throws java.sql.SQLException

Updates the underlying database with the new contents of the current row.

Specified by:: updateRow in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Throws:: java.sql.SQLException - when SQL problems occur.

deleteRow

public void deleteRow()
               throws java.sql.SQLException

Deletes the current row from the result set and the underlying database.

Specified by:: deleteRow in interface com.stc.connector.appconn.db.PreparedStatementResultSet

Throws:: java.sql.SQLException - when SQL problems occur.

moveToInsertRow

public void moveToInsertRow()
                     throws java.sql.SQLException

Moves the cursor to the insert row that associated with an updatable result set.

Throws:: java.sql.SQLException - when SQL problems occur.

moveToCurrentRow

public void moveToCurrentRow()
                      throws java.sql.SQLException

Moves the cursor to the current row that associated with an updatable result set.

Throws:: java.sql.SQLException - when SQL problems occur.

getRSAgent

public com.stc.connector.appconn.db.ResultSetAgent getRSAgent()

Retrieves the ResultSetAgent.

Returns:: the ResultSetAgent instance.

getOrdinalPosn

public int getOrdinalPosn()

Retrieves ordinal position of the resultset.

Returns:: the ordinal position.

getParentPreparedStmtAgent

public com.stc.connector.appconn.db.PreparedStatementAgent getParentPreparedStmtAgent()

Retrieves the parent PreparedStatmentAgent.

Returns:: a PreparedStatementAgent instance.

Overview

Package

Class

Tree

Deprecated

Index

Help

Sybase eWay API

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

com.stc.connector.sybaseadapter.base Class PreparedStatementResultSetImpl

PreparedStatementResultSetImpl

PreparedStatementResultSetImpl

setResultSetAgent

available

getMetaData

getConcurrency

getFetchDirection

setFetchDirection

getFetchSize

setFetchSize

getCursorName

close

closeResultSet

next

previous

absolute

relative

first

isFirst

last

isLast

beforeFirst

isBeforeFirst

afterLast

isAfterLast

getType

findColumn

getObject

getObject

getObject

getObject

getBoolean

getBoolean

getByte

getByte

getShort

getShort

getInt

getInt

getLong

getLong

getFloat

getFloat

getDouble

getDouble

getBigDecimal

getBigDecimal

getDate

getDate

getDate

getDate

getTime

getTime

getTime

getTime

getTimestamp

getTimestamp

getTimestamp

getTimestamp

getString

getString

getBytes

getBytes

getAsciiStream

getAsciiStream

getBinaryStream

getBinaryStream

getCharacterStream

getCharacterStream

getArray

getArray

getBlob

getBlob

getClob

getClob

getRef

getRef

wasNull

getWarnings

com.stc.connector.sybaseadapter.base
Class PreparedStatementResultSetImpl