com.jdbwc.core
Class WCResultSet

java.lang.Object
  extended by com.jdbwc.core.WCResultSetUpdates
      extended by com.jdbwc.core.WCResultSet
All Implemented Interfaces:
java.sql.ResultSet, java.sql.Wrapper

public class WCResultSet
extends WCResultSetUpdates
implements ResultSet

Extended JDBC-API implementation for java.sql.ResultSet.
See this packages ResultSet interface for extension method details.

Version:
2008-05-29
Author:
Tim Gall (Oz-DevWorX)

Field Summary
 
Fields inherited from class com.jdbwc.core.WCResultSetUpdates
myConnection, myDbType, myPointer, myRow, myRows, mySQL, myStatement
 
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
protected WCResultSet(WCConnection connection)
           
protected WCResultSet(WCConnection connection, WCStatement statement)
           
protected WCResultSet(WCConnection connection, WCStatement statement, java.lang.String sql)
           
protected WCResultSet(WCConnection connection, WCStatement statement, java.lang.String sql, com.ozdevworx.dtype.DataHandler results)
           
 
Method Summary
 boolean absolute(int row)
           
 void addRow(com.ozdevworx.dtype.DataHandler row)
          Adds a new data row to this ResultSet Object.
 void afterLast()
           
 void beforeFirst()
           
 void cancelRowUpdates()
           
 void clearWarnings()
           
 void close()
           
 void deleteRow()
           
 int findColumn(java.lang.String columnLabel)
           
 boolean first()
           
 java.sql.Array getArray(int columnIndex)
           
 java.sql.Array getArray(java.lang.String columnLabel)
           
 java.io.InputStream getAsciiStream(int columnIndex)
           
 java.io.InputStream getAsciiStream(java.lang.String columnLabel)
           
 java.math.BigDecimal getBigDecimal(int columnIndex)
           
 java.math.BigDecimal getBigDecimal(int columnIndex, int scale)
          Deprecated.  
 java.math.BigDecimal getBigDecimal(java.lang.String columnLabel)
           
 java.math.BigDecimal getBigDecimal(java.lang.String columnLabel, int scale)
          Deprecated.  
 java.io.InputStream getBinaryStream(int columnIndex)
           
 java.io.InputStream getBinaryStream(java.lang.String columnLabel)
           
 java.sql.Blob getBlob(int columnIndex)
           
 java.sql.Blob getBlob(java.lang.String columnLabel)
           
 boolean getBoolean(int columnIndex)
          Values that are considered booleans by this method (cAsE insensitive).
 boolean getBoolean(java.lang.String columnLabel)
          Values that are considered booleans by this method (cAsE insensitive).
 byte getByte(int columnIndex)
           
 byte getByte(java.lang.String columnLabel)
           
 byte[] getBytes(int columnIndex)
           
 byte[] getBytes(java.lang.String columnLabel)
           
 java.io.Reader getCharacterStream(int columnIndex)
           
 java.io.Reader getCharacterStream(java.lang.String columnLabel)
           
 java.sql.Clob getClob(int columnIndex)
           
 java.sql.Clob getClob(java.lang.String columnLabel)
           
 int getConcurrency()
           
 java.lang.String getCursorName()
           
 java.sql.Date getDate(int columnIndex)
          Dates are converted during transit from the server TimeZone to the Hosts TimeZone.

NOTE:
If this behavior is not desired use getDate(int columnIndex, Calendar cal) and specify the desired timezone in the Calendar Object.
 java.sql.Date getDate(int columnIndex, java.util.Calendar cal)
          Specify the desired TimeZone of the output java.sql.Date in the Calendar param.

NOTE:
If this behavior is not desired use getDate(int columnIndex) to have Dates automagically converted from the server TimeZone to the Hosts TimeZone.
 java.sql.Date getDate(java.lang.String columnLabel)
          Dates are converted during transit from the server TimeZone to the Hosts TimeZone.

NOTE:
If this behavior is not desired use getDate(String columnLabel, Calendar cal) and specify the desired timezone in the Calendar Object.
 java.sql.Date getDate(java.lang.String columnLabel, java.util.Calendar cal)
          Specify the desired TimeZone of the output java.sql.Date in the Calendar param.

NOTE:
If this behavior is not desired use getDate(String columnLabel) to have Dates automagically converted from the server TimeZone to the Hosts TimeZone.
protected  java.sql.Date getDateFromString(java.lang.String dateAsString, java.util.Calendar targetCal)
          A great deal of this method and any supporting methods it uses (including inline comments) were copied or derived from the My-Sql Connector-J Driver (By MySql/Sun/Oracle).
 double getDouble(int columnIndex)
           
 double getDouble(java.lang.String columnLabel)
           
 int getFetchDirection()
           
 int getFetchSize()
           
 float getFloat(int columnIndex)
           
 float getFloat(java.lang.String columnLabel)
           
 int getHoldability()
           
 int getInt(int columnIndex)
           
 int getInt(java.lang.String columnLabel)
           
 long getLong(int columnIndex)
           
 long getLong(java.lang.String columnLabel)
           
 java.sql.ResultSetMetaData getMetaData()
           
 java.io.Reader getNCharacterStream(int columnIndex)
           
 java.io.Reader getNCharacterStream(java.lang.String columnLabel)
           
 java.sql.NClob getNClob(int columnIndex)
           
 java.sql.NClob getNClob(java.lang.String columnLabel)
           
 java.lang.String getNString(int columnIndex)
           
 java.lang.String getNString(java.lang.String columnLabel)
           
 java.lang.Object getObject(int columnIndex)
           
 java.lang.Object getObject(int arg0, java.util.Map<java.lang.String,java.lang.Class<?>> arg1)
           
 java.lang.Object getObject(java.lang.String columnLabel)
           
 java.lang.Object getObject(java.lang.String arg0, java.util.Map<java.lang.String,java.lang.Class<?>> arg1)
           
 java.sql.Ref getRef(int columnIndex)
           
 java.sql.Ref getRef(java.lang.String columnLabel)
           
 int getRow()
           
 java.sql.RowId getRowId(int columnIndex)
           
 java.sql.RowId getRowId(java.lang.String columnLabel)
           
 short getShort(int columnIndex)
           
 short getShort(java.lang.String columnLabel)
           
 java.sql.SQLXML getSQLXML(int columnIndex)
           
 java.sql.SQLXML getSQLXML(java.lang.String columnLabel)
           
 WCStatement getStatement()
           
 java.lang.String getString(int columnIndex)
           
 java.lang.String getString(java.lang.String columnLabel)
           
 java.sql.Time getTime(int columnIndex)
          Times are converted during transit, from the server TimeZone to the Hosts TimeZone.

NOTE:
If this behavior is not desired use getTime(int columnIndex, Calendar cal) and specify the desired timezone in the Calendar Object.
 java.sql.Time getTime(int columnIndex, java.util.Calendar cal)
          Specify the desired TimeZone of the output java.sql.Time in the Calendar param.

NOTE:
If this behavior is not desired use getTime(int columnIndex) to have Times automagically converted from the server TimeZone to the Hosts TimeZone.
 java.sql.Time getTime(java.lang.String columnLabel)
          Times are converted during transit, from the server TimeZone to the Hosts TimeZone.

NOTE:
If this behavior is not desired use getTime(String columnLabel, Calendar cal) and specify the desired timezone in the Calendar Object.
 java.sql.Time getTime(java.lang.String columnLabel, java.util.Calendar cal)
          Specify the desired TimeZone of the output java.sql.Time in the Calendar param.

NOTE:
If this behavior is not desired use getTime(columnLabel) to have Times automagically converted from the server TimeZone to the Hosts TimeZone.
protected  java.sql.Time getTimeFromString(java.lang.String timeAsString, java.util.Calendar targetCal)
           
 java.sql.Timestamp getTimestamp(int columnIndex)
          Timestamps are converted during transit, from the server TimeZone to the Hosts TimeZone.

NOTE:
If this behavior is not desired use getTimestamp(int columnIndex, Calendar cal) and specify the desired timezone in the Calendar Object.
 java.sql.Timestamp getTimestamp(int columnIndex, java.util.Calendar cal)
          Specify the desired TimeZone of the output java.sql.Timestamp in the Calendar param.

NOTE:
If this behavior is not desired use getTimestamp(int columnIndex) to have Timestamps automagically converted from the server TimeZone to the Hosts TimeZone.
 java.sql.Timestamp getTimestamp(java.lang.String columnLabel)
          Timestamps are converted during transit, from the server TimeZone to the Hosts TimeZone.

NOTE:
If this behavior is not desired use getTimestamp(String columnLabel, Calendar cal) and specify the desired timezone in the Calendar Object.
 java.sql.Timestamp getTimestamp(java.lang.String columnLabel, java.util.Calendar cal)
          Specify the desired TimeZone of the output java.sql.Timestamp in the Calendar param.

NOTE:
If this behavior is not desired use getTimestamp(String columnLabel) to have Timestamps automagically converted from the server TimeZone to the Hosts TimeZone.
protected  java.sql.Timestamp getTimestampFromString(java.lang.String timestampValue, java.util.Calendar targetCal)
           
 int getType()
           
 java.io.InputStream getUnicodeStream(int columnIndex)
          Deprecated.  
 java.io.InputStream getUnicodeStream(java.lang.String columnLabel)
          Deprecated.  
 java.net.URL getURL(int columnIndex)
           
 java.net.URL getURL(java.lang.String columnLabel)
           
 java.sql.SQLWarning getWarnings()
           
 void insertRow()
           
 boolean isAfterLast()
           
 boolean isBeforeFirst()
           
 boolean isClosed()
           
 boolean isFirst()
           
 boolean isLast()
           
 boolean isWrapperFor(java.lang.Class<?> iface)
           
 boolean last()
           
 void moveToCurrentRow()
           
 void moveToInsertRow()
           
 boolean next()
           
 boolean previous()
           
 void refreshRow()
           
 boolean relative(int rows)
           
 boolean rowDeleted()
           
 boolean rowInserted()
           
 boolean rowUpdated()
           
 void setFetchDirection(int direction)
           
 void setFetchSize(int rows)
           
<T> T
unwrap(java.lang.Class<T> iface)
           
 boolean wasNull()
           
 
Methods inherited from class com.jdbwc.core.WCResultSetUpdates
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, 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
 
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
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, 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
 

Constructor Detail

WCResultSet

protected WCResultSet(WCConnection connection)
               throws java.sql.SQLException
Throws:
java.sql.SQLException

WCResultSet

protected WCResultSet(WCConnection connection,
                      WCStatement statement)
               throws java.sql.SQLException
Throws:
java.sql.SQLException

WCResultSet

protected WCResultSet(WCConnection connection,
                      WCStatement statement,
                      java.lang.String sql)
               throws java.sql.SQLException
Throws:
java.sql.SQLException

WCResultSet

protected WCResultSet(WCConnection connection,
                      WCStatement statement,
                      java.lang.String sql,
                      com.ozdevworx.dtype.DataHandler results)
               throws java.sql.SQLException
Throws:
java.sql.SQLException
Method Detail

addRow

public void addRow(com.ozdevworx.dtype.DataHandler row)
Description copied from interface: ResultSet
Adds a new data row to this ResultSet Object.

Parameters:
row - The new row to add to this ResultSet.

next

public boolean next()
             throws java.sql.SQLException
Specified by:
next in interface java.sql.ResultSet
Throws:
java.sql.SQLException

previous

public boolean previous()
                 throws java.sql.SQLException
Specified by:
previous in interface java.sql.ResultSet
Throws:
java.sql.SQLException

first

public boolean first()
              throws java.sql.SQLException
Specified by:
first in interface java.sql.ResultSet
Throws:
java.sql.SQLException

last

public boolean last()
             throws java.sql.SQLException
Specified by:
last in interface java.sql.ResultSet
Throws:
java.sql.SQLException

isClosed

public boolean isClosed()
                 throws java.sql.SQLException
Specified by:
isClosed in interface java.sql.ResultSet
Throws:
java.sql.SQLException

isFirst

public boolean isFirst()
                throws java.sql.SQLException
Specified by:
isFirst in interface java.sql.ResultSet
Throws:
java.sql.SQLException

isLast

public boolean isLast()
               throws java.sql.SQLException
Specified by:
isLast in interface java.sql.ResultSet
Throws:
java.sql.SQLException

close

public void close()
           throws java.sql.SQLException
Specified by:
close in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getFetchDirection

public int getFetchDirection()
                      throws java.sql.SQLException
Specified by:
getFetchDirection in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getFetchSize

public int getFetchSize()
                 throws java.sql.SQLException
Specified by:
getFetchSize in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getFetchSize()

setFetchDirection

public void setFetchDirection(int direction)
                       throws java.sql.SQLException
Specified by:
setFetchDirection in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getRow

public int getRow()
           throws java.sql.SQLException
Specified by:
getRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getStatement

public WCStatement getStatement()
                         throws java.sql.SQLException
Specified by:
getStatement in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getInt

public int getInt(int columnIndex)
           throws java.sql.SQLException
Specified by:
getInt in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getInt

public int getInt(java.lang.String columnLabel)
           throws java.sql.SQLException
Specified by:
getInt in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getDouble

public double getDouble(int columnIndex)
                 throws java.sql.SQLException
Specified by:
getDouble in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getDouble

public double getDouble(java.lang.String columnLabel)
                 throws java.sql.SQLException
Specified by:
getDouble in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getFloat

public float getFloat(int columnIndex)
               throws java.sql.SQLException
Specified by:
getFloat in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getFloat

public float getFloat(java.lang.String columnLabel)
               throws java.sql.SQLException
Specified by:
getFloat in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getObject

public java.lang.Object getObject(int columnIndex)
                           throws java.sql.SQLException
Specified by:
getObject in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getObject

public java.lang.Object getObject(java.lang.String columnLabel)
                           throws java.sql.SQLException
Specified by:
getObject in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getString

public java.lang.String getString(int columnIndex)
                           throws java.sql.SQLException
Specified by:
getString in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getString

public java.lang.String getString(java.lang.String columnLabel)
                           throws java.sql.SQLException
Specified by:
getString in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getLong

public long getLong(int columnIndex)
             throws java.sql.SQLException
Specified by:
getLong in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getLong

public long getLong(java.lang.String columnLabel)
             throws java.sql.SQLException
Specified by:
getLong in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getShort

public short getShort(int columnIndex)
               throws java.sql.SQLException
Specified by:
getShort in interface java.sql.ResultSet
Throws:
java.sql.SQLException

getShort

public short getShort(java.lang.String columnLabel)
               throws java.sql.SQLException
Specified by:
getShort in interface java.sql.ResultSet
Throws:
java.sql.SQLException

absolute

public boolean absolute(int row)
                 throws java.sql.SQLException
Specified by:
absolute in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.absolute(int)

afterLast

public void afterLast()
               throws java.sql.SQLException
Specified by:
afterLast in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.afterLast()

beforeFirst

public void beforeFirst()
                 throws java.sql.SQLException
Specified by:
beforeFirst in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.beforeFirst()

cancelRowUpdates

public void cancelRowUpdates()
                      throws java.sql.SQLException
Specified by:
cancelRowUpdates in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.cancelRowUpdates()

clearWarnings

public void clearWarnings()
                   throws java.sql.SQLException
Specified by:
clearWarnings in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.clearWarnings()

deleteRow

public void deleteRow()
               throws java.sql.SQLException
Specified by:
deleteRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.deleteRow()

findColumn

public int findColumn(java.lang.String columnLabel)
               throws java.sql.SQLException
Specified by:
findColumn in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.findColumn(java.lang.String)

getArray

public java.sql.Array getArray(int columnIndex)
                        throws java.sql.SQLException
Specified by:
getArray in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getArray(int)

getArray

public java.sql.Array getArray(java.lang.String columnLabel)
                        throws java.sql.SQLException
Specified by:
getArray in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getArray(java.lang.String)

getAsciiStream

public java.io.InputStream getAsciiStream(int columnIndex)
                                   throws java.sql.SQLException
Specified by:
getAsciiStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getAsciiStream(int)

getAsciiStream

public java.io.InputStream getAsciiStream(java.lang.String columnLabel)
                                   throws java.sql.SQLException
Specified by:
getAsciiStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getAsciiStream(java.lang.String)

getBigDecimal

public java.math.BigDecimal getBigDecimal(int columnIndex)
                                   throws java.sql.SQLException
Specified by:
getBigDecimal in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getBigDecimal(int)

getBigDecimal

public java.math.BigDecimal getBigDecimal(java.lang.String columnLabel)
                                   throws java.sql.SQLException
Specified by:
getBigDecimal in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getBigDecimal(java.lang.String)

getBigDecimal

@Deprecated
public java.math.BigDecimal getBigDecimal(int columnIndex,
                                                     int scale)
                                   throws java.sql.SQLException
Deprecated. 

Specified by:
getBigDecimal in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getBigDecimal(int, int)

getBigDecimal

@Deprecated
public java.math.BigDecimal getBigDecimal(java.lang.String columnLabel,
                                                     int scale)
                                   throws java.sql.SQLException
Deprecated. 

Specified by:
getBigDecimal in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getBigDecimal(java.lang.String, int)

getBinaryStream

public java.io.InputStream getBinaryStream(int columnIndex)
                                    throws java.sql.SQLException
Specified by:
getBinaryStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getBinaryStream(int)

getBinaryStream

public java.io.InputStream getBinaryStream(java.lang.String columnLabel)
                                    throws java.sql.SQLException
Specified by:
getBinaryStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getBinaryStream(java.lang.String)

getBlob

public java.sql.Blob getBlob(int columnIndex)
                      throws java.sql.SQLException
Specified by:
getBlob in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getBlob(int)

getBlob

public java.sql.Blob getBlob(java.lang.String columnLabel)
                      throws java.sql.SQLException
Specified by:
getBlob in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getBlob(java.lang.String)

getBoolean

public boolean getBoolean(int columnIndex)
                   throws java.sql.SQLException
Values that are considered booleans by this method (cAsE insensitive).

Specified by:
getBoolean in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getBoolean(int)

getBoolean

public boolean getBoolean(java.lang.String columnLabel)
                   throws java.sql.SQLException
Values that are considered booleans by this method (cAsE insensitive).

Specified by:
getBoolean in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getBoolean(java.lang.String)

getByte

public byte getByte(int columnIndex)
             throws java.sql.SQLException
Specified by:
getByte in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getByte(int)

getByte

public byte getByte(java.lang.String columnLabel)
             throws java.sql.SQLException
Specified by:
getByte in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getByte(java.lang.String)

getBytes

public byte[] getBytes(int columnIndex)
                throws java.sql.SQLException
Specified by:
getBytes in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getBytes(int)

getBytes

public byte[] getBytes(java.lang.String columnLabel)
                throws java.sql.SQLException
Specified by:
getBytes in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getBytes(java.lang.String)

getCharacterStream

public java.io.Reader getCharacterStream(int columnIndex)
                                  throws java.sql.SQLException
Specified by:
getCharacterStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getCharacterStream(int)

getCharacterStream

public java.io.Reader getCharacterStream(java.lang.String columnLabel)
                                  throws java.sql.SQLException
Specified by:
getCharacterStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getCharacterStream(java.lang.String)

getClob

public java.sql.Clob getClob(int columnIndex)
                      throws java.sql.SQLException
Specified by:
getClob in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getClob(int)

getClob

public java.sql.Clob getClob(java.lang.String columnLabel)
                      throws java.sql.SQLException
Specified by:
getClob in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getClob(java.lang.String)

getConcurrency

public int getConcurrency()
                   throws java.sql.SQLException
Specified by:
getConcurrency in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getConcurrency()

getCursorName

public java.lang.String getCursorName()
                               throws java.sql.SQLException
Specified by:
getCursorName in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getCursorName()

getDate

public java.sql.Date getDate(int columnIndex)
                      throws java.sql.SQLException
Dates are converted during transit from the server TimeZone to the Hosts TimeZone.

NOTE:
If this behavior is not desired use getDate(int columnIndex, Calendar cal) and specify the desired timezone in the Calendar Object.

Specified by:
getDate in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getDate(int)

getDate

public java.sql.Date getDate(java.lang.String columnLabel)
                      throws java.sql.SQLException
Dates are converted during transit from the server TimeZone to the Hosts TimeZone.

NOTE:
If this behavior is not desired use getDate(String columnLabel, Calendar cal) and specify the desired timezone in the Calendar Object.

Specified by:
getDate in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getDate(java.lang.String)

getDate

public java.sql.Date getDate(int columnIndex,
                             java.util.Calendar cal)
                      throws java.sql.SQLException
Specify the desired TimeZone of the output java.sql.Date in the Calendar param.

NOTE:
If this behavior is not desired use getDate(int columnIndex) to have Dates automagically converted from the server TimeZone to the Hosts TimeZone.

Specified by:
getDate in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getDate(int, java.util.Calendar)

getDate

public java.sql.Date getDate(java.lang.String columnLabel,
                             java.util.Calendar cal)
                      throws java.sql.SQLException
Specify the desired TimeZone of the output java.sql.Date in the Calendar param.

NOTE:
If this behavior is not desired use getDate(String columnLabel) to have Dates automagically converted from the server TimeZone to the Hosts TimeZone.

Specified by:
getDate in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getDate(java.lang.String, java.util.Calendar)

getHoldability

public int getHoldability()
                   throws java.sql.SQLException
Specified by:
getHoldability in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getHoldability()

getMetaData

public java.sql.ResultSetMetaData getMetaData()
                                       throws java.sql.SQLException
Specified by:
getMetaData in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getMetaData()

getNCharacterStream

public java.io.Reader getNCharacterStream(int columnIndex)
                                   throws java.sql.SQLException
Specified by:
getNCharacterStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getNCharacterStream(int)

getNCharacterStream

public java.io.Reader getNCharacterStream(java.lang.String columnLabel)
                                   throws java.sql.SQLException
Specified by:
getNCharacterStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getNCharacterStream(java.lang.String)

getNClob

public java.sql.NClob getNClob(int columnIndex)
                        throws java.sql.SQLException
Specified by:
getNClob in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getNClob(int)

getNClob

public java.sql.NClob getNClob(java.lang.String columnLabel)
                        throws java.sql.SQLException
Specified by:
getNClob in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getNClob(java.lang.String)

getNString

public java.lang.String getNString(int columnIndex)
                            throws java.sql.SQLException
Specified by:
getNString in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getNString(int)

getNString

public java.lang.String getNString(java.lang.String columnLabel)
                            throws java.sql.SQLException
Specified by:
getNString in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getNString(java.lang.String)

getObject

public java.lang.Object getObject(int arg0,
                                  java.util.Map<java.lang.String,java.lang.Class<?>> arg1)
                           throws java.sql.SQLException
Specified by:
getObject in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getObject(int, java.util.Map)

getObject

public java.lang.Object getObject(java.lang.String arg0,
                                  java.util.Map<java.lang.String,java.lang.Class<?>> arg1)
                           throws java.sql.SQLException
Specified by:
getObject in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getObject(java.lang.String, java.util.Map)

getRef

public java.sql.Ref getRef(int columnIndex)
                    throws java.sql.SQLException
Specified by:
getRef in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getRef(int)

getRef

public java.sql.Ref getRef(java.lang.String columnLabel)
                    throws java.sql.SQLException
Specified by:
getRef in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getRef(java.lang.String)

getRowId

public java.sql.RowId getRowId(int columnIndex)
                        throws java.sql.SQLException
Specified by:
getRowId in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getRowId(int)

getRowId

public java.sql.RowId getRowId(java.lang.String columnLabel)
                        throws java.sql.SQLException
Specified by:
getRowId in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getRowId(java.lang.String)

getSQLXML

public java.sql.SQLXML getSQLXML(int columnIndex)
                          throws java.sql.SQLException
Specified by:
getSQLXML in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getSQLXML(int)

getSQLXML

public java.sql.SQLXML getSQLXML(java.lang.String columnLabel)
                          throws java.sql.SQLException
Specified by:
getSQLXML in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getSQLXML(java.lang.String)

getTime

public java.sql.Time getTime(int columnIndex)
                      throws java.sql.SQLException
Times are converted during transit, from the server TimeZone to the Hosts TimeZone.

NOTE:
If this behavior is not desired use getTime(int columnIndex, Calendar cal) and specify the desired timezone in the Calendar Object.

Specified by:
getTime in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getTime(int)

getTime

public java.sql.Time getTime(java.lang.String columnLabel)
                      throws java.sql.SQLException
Times are converted during transit, from the server TimeZone to the Hosts TimeZone.

NOTE:
If this behavior is not desired use getTime(String columnLabel, Calendar cal) and specify the desired timezone in the Calendar Object.

Specified by:
getTime in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getTime(java.lang.String)

getTime

public java.sql.Time getTime(int columnIndex,
                             java.util.Calendar cal)
                      throws java.sql.SQLException
Specify the desired TimeZone of the output java.sql.Time in the Calendar param.

NOTE:
If this behavior is not desired use getTime(int columnIndex) to have Times automagically converted from the server TimeZone to the Hosts TimeZone.

Specified by:
getTime in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getTime(int, java.util.Calendar)

getTime

public java.sql.Time getTime(java.lang.String columnLabel,
                             java.util.Calendar cal)
                      throws java.sql.SQLException
Specify the desired TimeZone of the output java.sql.Time in the Calendar param.

NOTE:
If this behavior is not desired use getTime(columnLabel) to have Times automagically converted from the server TimeZone to the Hosts TimeZone.

Specified by:
getTime in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getTime(java.lang.String, java.util.Calendar)

getTimestamp

public java.sql.Timestamp getTimestamp(int columnIndex)
                                throws java.sql.SQLException
Timestamps are converted during transit, from the server TimeZone to the Hosts TimeZone.

NOTE:
If this behavior is not desired use getTimestamp(int columnIndex, Calendar cal) and specify the desired timezone in the Calendar Object.

Specified by:
getTimestamp in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getTimestamp(int)

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String columnLabel)
                                throws java.sql.SQLException
Timestamps are converted during transit, from the server TimeZone to the Hosts TimeZone.

NOTE:
If this behavior is not desired use getTimestamp(String columnLabel, Calendar cal) and specify the desired timezone in the Calendar Object.

Specified by:
getTimestamp in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getTimestamp(java.lang.String)

getTimestamp

public java.sql.Timestamp getTimestamp(int columnIndex,
                                       java.util.Calendar cal)
                                throws java.sql.SQLException
Specify the desired TimeZone of the output java.sql.Timestamp in the Calendar param.

NOTE:
If this behavior is not desired use getTimestamp(int columnIndex) to have Timestamps automagically converted from the server TimeZone to the Hosts TimeZone.

Specified by:
getTimestamp in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getTimestamp(int, java.util.Calendar)

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String columnLabel,
                                       java.util.Calendar cal)
                                throws java.sql.SQLException
Specify the desired TimeZone of the output java.sql.Timestamp in the Calendar param.

NOTE:
If this behavior is not desired use getTimestamp(String columnLabel) to have Timestamps automagically converted from the server TimeZone to the Hosts TimeZone.

Specified by:
getTimestamp in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getTimestamp(java.lang.String, java.util.Calendar)

getType

public int getType()
            throws java.sql.SQLException
Specified by:
getType in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getType()

getURL

public java.net.URL getURL(int columnIndex)
                    throws java.sql.SQLException
Specified by:
getURL in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getURL(int)

getURL

public java.net.URL getURL(java.lang.String columnLabel)
                    throws java.sql.SQLException
Specified by:
getURL in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getURL(java.lang.String)

getUnicodeStream

@Deprecated
public java.io.InputStream getUnicodeStream(int columnIndex)
                                     throws java.sql.SQLException
Deprecated. 

Specified by:
getUnicodeStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getUnicodeStream(int)

getUnicodeStream

@Deprecated
public java.io.InputStream getUnicodeStream(java.lang.String columnLabel)
                                     throws java.sql.SQLException
Deprecated. 

Specified by:
getUnicodeStream in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getUnicodeStream(java.lang.String)

getWarnings

public java.sql.SQLWarning getWarnings()
                                throws java.sql.SQLException
Specified by:
getWarnings in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.getWarnings()

insertRow

public void insertRow()
               throws java.sql.SQLException
Specified by:
insertRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.insertRow()

isAfterLast

public boolean isAfterLast()
                    throws java.sql.SQLException
Specified by:
isAfterLast in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.isAfterLast()

isBeforeFirst

public boolean isBeforeFirst()
                      throws java.sql.SQLException
Specified by:
isBeforeFirst in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.isBeforeFirst()

moveToCurrentRow

public void moveToCurrentRow()
                      throws java.sql.SQLException
Specified by:
moveToCurrentRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.moveToCurrentRow()

moveToInsertRow

public void moveToInsertRow()
                     throws java.sql.SQLException
Specified by:
moveToInsertRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.moveToInsertRow()

refreshRow

public void refreshRow()
                throws java.sql.SQLException
Specified by:
refreshRow in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.refreshRow()

relative

public boolean relative(int rows)
                 throws java.sql.SQLException
Specified by:
relative in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.relative(int)

rowDeleted

public boolean rowDeleted()
                   throws java.sql.SQLException
Specified by:
rowDeleted in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.rowDeleted()

rowInserted

public boolean rowInserted()
                    throws java.sql.SQLException
Specified by:
rowInserted in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.rowInserted()

rowUpdated

public boolean rowUpdated()
                   throws java.sql.SQLException
Specified by:
rowUpdated in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.rowUpdated()

setFetchSize

public void setFetchSize(int rows)
                  throws java.sql.SQLException
Specified by:
setFetchSize in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.setFetchSize(int)

wasNull

public boolean wasNull()
                throws java.sql.SQLException
Specified by:
wasNull in interface java.sql.ResultSet
Throws:
java.sql.SQLException
See Also:
ResultSet.wasNull()

isWrapperFor

public boolean isWrapperFor(java.lang.Class<?> iface)
                     throws java.sql.SQLException
Specified by:
isWrapperFor in interface java.sql.Wrapper
Throws:
java.sql.SQLException
See Also:
Wrapper.isWrapperFor(java.lang.Class)

unwrap

public <T> T unwrap(java.lang.Class<T> iface)
         throws java.sql.SQLException
Specified by:
unwrap in interface java.sql.Wrapper
Throws:
java.sql.SQLException
See Also:
Wrapper.unwrap(java.lang.Class)

getDateFromString

protected java.sql.Date getDateFromString(java.lang.String dateAsString,
                                          java.util.Calendar targetCal)
                                   throws java.sql.SQLException
A great deal of this method and any supporting methods it uses (including inline comments) were copied or derived from the My-Sql Connector-J Driver (By MySql/Sun/Oracle).

Parameters:
dateAsString -
targetCal -
Returns:
java.sql.Date
Throws:
java.sql.SQLException

getTimeFromString

protected java.sql.Time getTimeFromString(java.lang.String timeAsString,
                                          java.util.Calendar targetCal)
                                   throws java.sql.SQLException
Throws:
java.sql.SQLException

getTimestampFromString

protected java.sql.Timestamp getTimestampFromString(java.lang.String timestampValue,
                                                    java.util.Calendar targetCal)
                                             throws java.sql.SQLException
Throws:
java.sql.SQLException