ResultSet (Mimer JDBC Engine)

Overview

Package

Class

Index

Help

Mimer JDBC Engine 2.12

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

com.mimer.jdbc
Class ResultSet

java.lang.Object
  |
  +--com.mimer.jdbc.ResultSet

All Implemented Interfaces:: ResultSet

public class ResultSet
extends Object
implements ResultSet

Represents a result set, either forward only or scrollable.

The below table shows which Mimer SQL server data types are accessible from the specified JDBC getter methods. Those data types that may be retrieved using a specific getter method may also be set using the corresponding setter method with a PreparedStatement object.

	OT	SI	IN	N(n)	BI	RE	FL	FL(n)	DP	DC	NU	BI	CH	CV	BI	BV	NCH	NCV	DT	TI	TS	IV	IV2	BL	CL	NCL
getByte	X	x	x	x	x	x	x	x	x	x	x	x	x	x	-	-	x	x	-	-	-	-	-	-	-	-
getShort	x	X	x	x	x	x	x	x	x	x	x	x	x	x	-	-	x	x	-	-	-	-	-	-	-	-
getInt	x	x	X	x	x	x	x	x	x	x	x	x	x	x	-	-	x	x	-	-	-	-	-	-	-	-
getLong	x	x	x	x	X	x	x	x	x	x	x	x	x	x	-	-	x	x	-	-	-	-	-	-	-	-
getFloat	x	x	x	x	x	X	x	x	x	x	x	x	x	x	-	-	x	x	-	-	-	-	-	-	-	-
getDouble	x	x	x	x	x	x	X	X	X	x	x	x	x	x	-	-	x	x	-	-	-	-	-	-	-	-
getBigDecimal	x	x	x	x	x	x	x	x	x	X	X	x	x	x	-	-	x	x	-	-	-	-	-	-	-	-
getBoolean	x	x	x	x	x	x	x	x	x	x	x	X	x	x	-	-	x	x	-	-	-	-	-	-	-	-
getString	x	x	x	x	x	x	x	x	x	x	x	x	X	X	-	-	x	x	x	x	x	x	x	-	-	-
getBytes	-	-	-	-	-	-	-	-	-	-	-	-	-	-	X	X	-	-	-	-	-	-	-	-	-	-
getDate	-	-	-	-	-	-	-	-	-	-	-	-	x	x	-	-	x	x	X	x	x	-	-	-	-	-
getTime	-	-	-	-	-	-	-	-	-	-	-	-	x	x	-	-	x	x	x	X	x	-	-	-	-	-
getTimestamp	-	-	-	-	-	-	-	-	-	-	-	-	x	x	-	-	x	x	x	x	X	-	-	-	-	-
getAsciiStream	-	-	-	-	-	-	-	-	-	-	-	-	x	x	x	x	x	x	-	-	-	-	-	-	x	x
getBinaryStream	-	-	-	-	-	-	-	-	-	-	-	-	-	-	x	x	-	-	-	-	-	-	-	x	-	-
getCharacterStream	-	-	-	-	-	-	-	-	-	-	-	-	x	x	-	-	x	x	-	-	-	-	-	-	x	x
getClob	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	x	x
getBlob	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	x	-	-
getArray	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
getRef	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
getURL	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
getObject	x	x	x	x	x	x	x	x	x	x	x	x	x	x	x	x	x	x	x	x	x	x	x	x	x	x

Abbreviations in table above:

OT ODBC.TINYINT

SI SMALLINT

IN INTEGER

IN(n) INTEGER(n)

BI BIGINT

RE REAL

FL FLOAT

FL(n) FLOAT(n)

DP DOUBLE PRECISION

DC DECIMAL

NU NUMERIC

BI ODBC.BIT

CH CHARACTER

VC CHARACTER VARYING

BI BINARY

VB BINARY VARYING

NCH NATIONAL CHARACTER

NVC NATIONAL CHARACTER VARYING

DT DATE

TI TIME

TS TIMESTAMP

IV INTERVAL YEAR INTERVAL MONTH INTERVAL DAY INTERVAL HOUR INTERVAL MINUTE INTERVAL SECOND

IV2 INTERVAL YEAR TO MONTH INTERVAL DAY TO HOUR INTERVAL DAY TO MINUTE INTERVAL DAY TO SECOND INTERVAL HOUR TO MINUTE INTERVAL HOUR TO SECOND INTERVAL MINUTE TO SECOND

BL BINARY LARGE OBJECT

CL CHARACTER LARGE OBJECT

NCL NATIONAL CHARACTER LARGE OBJECT

Field Summary

Fields inherited from interface java.sql.ResultSet

CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE

Method Summary

boolean absolute(int row)
          Positions the cursor on a absolute position.

void afterLast()
          Positions the cursor after the end of the result set.

void beforeFirst()
          Positions the cursor before the beginning of the result set.

void cancelRowUpdates()
          Cancels the updates made to the current row in this ResultSet object.

void clearWarnings()
          Clears all warnings reported on the object.

void close()
          Closes the statement.

void deleteRow()
          Deletes the current row from this ResultSet object and from the underlying database.

int findColumn(String columnName)
          Finds a column index from a column name.

boolean first()
          Positions the cursor at the first row of the result set.

Array getArray(int columnIndex)
          Get an SQL array.

Array getArray(String columnName)
          Get an SQL array.

InputStream getAsciiStream(int columnIndex)
          Returns an ascii stream representing the result set column.

InputStream getAsciiStream(String columnName)
          Returns an ascii stream representing the result set column.

BigDecimal getBigDecimal(int columnIndex)
          Returns a java.math.BigDecimal object without scale.

BigDecimal getBigDecimal(int columnIndex, int scale)
          Returns a java.math.BigDecimal object.

BigDecimal getBigDecimal(String columnName)
          Returns a java.math.BigDecimal object.

BigDecimal getBigDecimal(String columnName, int scale)
          Returns a java.math.BigDecimal object.

InputStream getBinaryStream(int columnIndex)
          Returns an binary stream representing the result set column.

InputStream getBinaryStream(String columnName)
          Returns an binary stream representing the result set column.

Blob getBlob(int columnIndex)
          Get a BLOB LOCATOR object.

Blob getBlob(String columnName)
          Get a BLOB LOCATOR object.

boolean getBoolean(int columnIndex)
          Returns a boolean.

boolean getBoolean(String columnName)
          Returns a boolean.

byte getByte(int columnIndex)
          Returns a byte.

byte getByte(String columnName)
          Returns a byte.

byte[] getBytes(int columnIndex)
          Returns an array of bytes.

byte[] getBytes(String columnName)
          Returns an array of bytes.

Reader getCharacterStream(int columnIndex)
          Get a character stream.

Reader getCharacterStream(String columnName)
          Get a character stream.

Clob getClob(int columnIndex)
          Get a CLOB LOCATOR object.

Clob getClob(String columnName)
          Get a CLOB LOCATOR object.

int getConcurrency()
          Returns the concurrency mode for this result set.

String getCursorName()
          Returns the name of this cursor.

Date getDate(int columnIndex)
          Returns a Date.

Date getDate(int columnIndex, Calendar cal)
          Get a date with timezone compensation.

Date getDate(String columnName)
          Return a date.

Date getDate(String columnName, Calendar cal)
          Get a date with timezone compensation.

double getDouble(int columnIndex)
          Returns a double.

double getDouble(String columnName)
          Returns a double.

int getFetchDirection()
          Gets the current fetch direction hint.

int getFetchSize()
          Retrieves the current fetch size.

float getFloat(int columnIndex)
          Returns a float.

float getFloat(String columnName)
          Returns a float.

int getInt(int columnIndex)
          Returns an integer.

int getInt(String columnName)
          Returns an integer.

long getLong(int columnIndex)
          Returns an long.

long getLong(String columnName)
          Returns an long.

ResultSetMetaData getMetaData()
          Returns a ResultSetMetaData object describing the result set.

Object getObject(int columnIndex)
          Returns an object.

Object getObject(int columnIndex, Map map)
          Get object with type map.

Object getObject(String columnName)
          Returns an object.

Object getObject(String columnName, Map map)
          Get object with type map.

Ref getRef(int columnIndex)
          Get a reference type.

Ref getRef(String columnName)
          Get a reference type.

int getRow()
          Return the current row number.

short getShort(int columnIndex)
          Returns a short.

short getShort(String columnName)
          Returns a short.

Statement getStatement()
          Get the statement that belongs to this result set.

String getString(int columnIndex)
          Returns a string.

String getString(String columnName)
          Returns a string.

Time getTime(int columnIndex)
          Returns a time.

Time getTime(int columnIndex, Calendar cal)
          Get a time with timezone compensation.

Time getTime(String columnName)
          Returns a time.

Time getTime(String columnName, Calendar cal)
          Get a time with timezone compensation.

Timestamp getTimestamp(int columnIndex)
          Returns a timestamp.

Timestamp getTimestamp(int columnIndex, Calendar cal)
          Get a timestamp with timezone compensation.

Timestamp getTimestamp(String columnName)
          Returns a time.

Timestamp getTimestamp(String columnName, Calendar cal)
          Get a timestamp with timezone compensation.

int getType()
          Return the type of the result set.

InputStream getUnicodeStream(int columnIndex)


InputStream getUnicodeStream(String columnName)


SQLWarning getWarnings()
          Returns the first warning posted to this object.

void insertRow()
          Inserts the contents of the insert row into this ResultSet object and into the database.

boolean isAfterLast()
          Returns true if the current row is after the last row of the result set.

boolean isBeforeFirst()
          Returns true if the current row is before the first row of the result set.

boolean isFirst()
          Returns true if the current row is at the first row of the result set.

boolean isLast()
          Returns true if the current row is at the last row of the result set.

boolean last()
          Positions the cursor on the last row of the result set.

void moveToCurrentRow()
          Moves the cursor to the remembered cursor position, usually the current row.

void moveToInsertRow()
          Moves the cursor to the insert row.

boolean next()
          Moves on to the next row in the result set.

boolean previous()
          Positions the cursor one row backwards in the result set.

void refreshRow()
          The refreshRow method provides a way for an application to explicitly tell the JDBC driver to refetch a row(s) from the database.

boolean relative(int rows)
          Positioning relative to the current cursor position.

boolean rowDeleted()
          Indicates whether a row has been deleted.

boolean rowInserted()
          Indicates whether the current row has had an insertion.

boolean rowUpdated()
          Indicates whether the current row has been updated.

void setFetchDirection(int direction)
          Sets the current fetch direction hint.

void setFetchSize(int rows)
          Sets the current fetch size.

void updateAsciiStream(int columnIndex, InputStream x, int length)
          Updates the designated column with an ascii stream value.

void updateAsciiStream(String columnName, InputStream x, int length)
          Updates the designated column with an ascii stream value.

void updateBigDecimal(int columnIndex, BigDecimal x)
          Updates the designated column with a java.math.BigDecimal value.

void updateBigDecimal(String columnName, BigDecimal x)
          Updates the designated column with a java.math.BigDecimal value.

void updateBinaryStream(int columnIndex, InputStream x, int length)
          Updates the designated column with a binary stream value.

void updateBinaryStream(String columnName, InputStream x, int length)
          Updates the designated column with a binary stream value.

void updateBoolean(int columnIndex, boolean x)
          Updates the designated column with a boolean value.

void updateBoolean(String columnName, boolean x)
          Updates the designated column with a boolean value.

void updateByte(int columnIndex, byte x)
          Updates the designated column with a byte value.

void updateByte(String columnName, byte x)
          Updates the designated column with a byte value.

void updateBytes(int columnIndex, byte[] x)
          Updates the designated column with a byte array value.

void updateBytes(String columnName, byte[] x)
          Updates the designated column with a byte array value.

void updateCharacterStream(int columnIndex, Reader x, int length)
          Updates the designated column with a character stream value.

void updateCharacterStream(String columnName, Reader x, int length)
          Updates the designated column with a character stream value.

void updateDate(int columnIndex, Date x)
          Updates the designated column with a java.sql.Date value.

void updateDate(String columnName, Date x)
          Updates the designated column with a java.sql.Date value.

void updateDouble(int columnIndex, double x)
          Updates the designated column with a double value.

void updateDouble(String columnName, double x)
          Updates the designated column with a double value.

void updateFloat(int columnIndex, float x)
          Updates the designated column with a float value.

void updateFloat(String columnName, float x)
          Updates the designated column with a float value.

void updateInt(int columnIndex, int x)
          Updates the designated column with an int value.

void updateInt(String columnName, int x)
          Updates the designated column with an int value.

void updateLong(int columnIndex, long x)
          Updates the designated column with a long value.

void updateLong(String columnName, long x)
          Updates the designated column with a long value.

void updateNull(int columnIndex)
          Gives a nullable column a null value.

void updateNull(String columnName)
          Gives a nullable column a null value.

void updateObject(int columnIndex, Object x)
          Updates the designated column with an Object value.

void updateObject(int columnIndex, Object x, int scale)
          Updates the designated column with an Object value.

void updateObject(String columnName, Object x)
          Updates the designated column with an Object value.

void updateObject(String columnName, Object x, int scale)
          Updates the designated column with an Object value.

void updateRow()
          Updates the underlying database with the new contents of the current row of this ResultSet object.

void updateShort(int columnIndex, short x)
          Updates the designated column with a short value.

void updateShort(String columnName, short x)
          Updates the designated column with a short value.

void updateString(int columnIndex, String x)
          Updates the designated column with a String value.

void updateString(String columnName, String x)
          Updates the designated column with a String value.

void updateTime(int columnIndex, Time x)
          Updates the designated column with a java.sql.Time value.

void updateTime(String columnName, Time x)
          Updates the designated column with a java.sql.Time value.

void updateTimestamp(int columnIndex, Timestamp x)
          Updates the designated column with a java.sql.Timestamp value.

void updateTimestamp(String columnName, Timestamp x)
          Updates the designated column with a java.sql.Timestamp value.

boolean wasNull()
          Returns true if the last column read was a NULL.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface java.sql.ResultSet

getURL, getURL, updateArray, updateArray, updateBlob, updateBlob, updateClob, updateClob, updateRef, updateRef

Method Detail

absolute

public boolean absolute(int row)
                 throws SQLException

Positions the cursor on a absolute position.

Performance consideration: If the application calls ResultSet.absolute to position itself to a particular row, the entire result set up to that point has to mbecome materialized on the server. This means that positioning far ahead in the result set might take some time, but returning to a position once visited is fast. For example:

ResultSet is created.
ResultSet is advanced one row at a time until the 10th row.
ResultSet.absolute(1000000) is called. At this time, only the beginning of the result set has been formed. To get to row 1000000 the server has to materialize all rows up to that point. This can take a while.
ResultSet.absolute(100) is called. This row has already been formed, so returning to it should be nearly instantaneous.
ResultSet.absolute(1000000) is called. This row has also already been formed, so returning to it is also nearly instantaneous.

In some situations, the entire result set is formed before the first row can be returned. An example of such a situation is when we have an ORDER BY clause on a non-indexed column. If this is so, we experience the penalty of forming the entire result set before the first row is returned, and then we don't see the effects outlined above.

Specified by:: absolute in interface ResultSet

Parameters:: row - If positive it is an absolute position from the start of the result set. If negative it is a absolute position coutned from the end of the result set.
Throws:: SQLException - if an error occurs. SQLSTATE HY109 is thrown if this is a forward-only result set. HY107 is thrown if the row parameter was 0.

afterLast

public void afterLast()
               throws SQLException

Positions the cursor after the end of the result set.

Performance consideration: If the end of result set hasn't been formed before, this operation may take some time since all rows up until the end of the result set has be formed on the server. The only workaround for this is to work with smaller result sets.

Specified by:: afterLast in interface ResultSet

Throws:: SQLException - if an error occurs. SQLSTATE HY109 is thrown if this is a forward-only result set.

beforeFirst

public void beforeFirst()
                 throws SQLException

Positions the cursor before the beginning of the result set.

Specified by:: beforeFirst in interface ResultSet

Throws:: SQLException - if an error occurs. SQLSTATE HY109 is thrown if this is a forward-only result set.

cancelRowUpdates

public void cancelRowUpdates()
                      throws SQLException

Cancels the updates made to the current row in this ResultSet object.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: cancelRowUpdates in interface ResultSet

Throws:: SQLException - if a database access error occurs or if this method is called when the cursor is on the insert row

clearWarnings

public void clearWarnings()
                   throws SQLException

Clears all warnings reported on the object.

Specified by:: clearWarnings in interface ResultSet

Throws:: SQLException - if an error occurs.

close

public void close()
           throws SQLException

Closes the statement.

Specified by:: close in interface ResultSet

Throws:: SQLException - if an error occurs.

deleteRow

public void deleteRow()
               throws SQLException

Deletes the current row from this ResultSet object and from the underlying database. This method cannot be called when the cursor is on the insert row.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: deleteRow in interface ResultSet

Throws:: SQLException - if a database access error occurs or if this method is called when the cursor is on the insert row

findColumn

public int findColumn(String columnName)
               throws SQLException

Finds a column index from a column name.

Specified by:: findColumn in interface ResultSet

Parameters:: columnName - The column name.
Returns:: The column index.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the result set is not open. 07009 is thrown if the column name doesn't exist.

first

public boolean first()
              throws SQLException

Positions the cursor at the first row of the result set.

Specified by:: first in interface ResultSet

Returns:: True if the cursor is on a valid row.
Throws:: SQLException - if an error occurs. SQLSTATE HY109 is thrown if this is a forward-only result set.

getArray

public Array getArray(int columnIndex)
               throws SQLException

Get an SQL array.

Mimer SQL (as of 9.2) does not support SQL arrays. This method will always throw an error.

Specified by:: getArray in interface ResultSet

Parameters:: columnIndex - The column index.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnIndex is not valid. 2200G is thrown if the column type wasn't castable to a string, see ResultSet for an overview of which column types are castable to which Java types.

getArray

public Array getArray(String columnName)
               throws SQLException

Get an SQL array.

Mimer SQL (as of 9.2) does not support SQL arrays. This method will always throw an error.

Specified by:: getArray in interface ResultSet

Parameters:: columnName - The column name.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnName is not valid. 2200G is thrown if the column type wasn't castable to a string, see ResultSet for an overview of which column types are castable to which Java types.

getAsciiStream

public InputStream getAsciiStream(int columnIndex)
                           throws SQLException

Returns an ascii stream representing the result set column.

Performance consideration: When calling this method on a CLOB or NCLOB server column, this call makes a separate server call to retrieve the object. This is different from all other data types, since they are fully transferred to the client no later when the cursor is moved to the current column. If you only wish to keep a reference to the CLOB or NCLOB for later use, please consider using the ResultSet.getClob since this only returns a LOCATOR reference to the object, and no server calls are being made.

Specified by:: getAsciiStream in interface ResultSet

Parameters:: columnIndex - The column number.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnIndex is invalid. 08S01 is thrown on a network receive error. 2200G is thrown if the column type wasn't castable to a string, see {link #ResultSetTypeCasting} for an overview of which column types are castable to which Java types.
See Also:: getClob(int)

getAsciiStream

public InputStream getAsciiStream(String columnName)
                           throws SQLException

Returns an ascii stream representing the result set column.

Specified by:: getAsciiStream in interface ResultSet

Parameters:: columnName - The column name.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnName does not exist. 08S01 is thrown on a network receive error. 2200G is thrown if the column type wasn't castable to a string, see ResultSet for an overview of which column types are castable to which Java types.

getBigDecimal

public BigDecimal getBigDecimal(int columnIndex)
                         throws SQLException

Returns a java.math.BigDecimal object without scale.

Specified by:: getBigDecimal in interface ResultSet

Parameters:: columnIndex - The column number.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnIndex is invalid. 22018 is thrown if a character value could not be casted to a numeric value. 2200G is thrown if the column type wasn't castable to a string, see ResultSet for an overview of which column types are castable to which Java types.

getBigDecimal

public BigDecimal getBigDecimal(int columnIndex,
                                int scale)
                         throws SQLException

Returns a java.math.BigDecimal object.

Specified by:: getBigDecimal in interface ResultSet

Parameters:: columnIndex - The column number.; scale - The scale.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnIndex is invalid. 22018 is thrown if a character value could not be casted to a numeric value. 2200G is thrown if the column type wasn't castable to a string, see ResultSet for an overview of which column types are castable to which Java types.

getBigDecimal

public BigDecimal getBigDecimal(String columnName)
                         throws SQLException

Returns a java.math.BigDecimal object.

Specified by:: getBigDecimal in interface ResultSet

Parameters:: columnName - The column name.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnName does not exist. 22018 is thrown if a character value could not be casted to a numeric value. 2200G is thrown if the column type wasn't castable to a string, see ResultSet for an overview of which column types are castable to which Java types.

getBigDecimal

public BigDecimal getBigDecimal(String columnName,
                                int scale)
                         throws SQLException

Returns a java.math.BigDecimal object.

Specified by:: getBigDecimal in interface ResultSet

Parameters:: columnName - The column name.; scale - The scale.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnName does not exist. 22018 is thrown if a character value could not be casted to a numeric value. 2200G is thrown if the column type wasn't castable to a string, see ResultSet for an overview of which column types are castable to which Java types.

getBinaryStream

public InputStream getBinaryStream(int columnIndex)
                            throws SQLException

Returns an binary stream representing the result set column.

Performance consideration: When calling this method on a BLOB server column, this call makes a separate server call to retrieve the BLOB. This is different from all other data types, since they are fully transferred to the client no later when the cursor is moved to the current column. If you only wish to keep a reference to the BLOB for later use, please consider using the ResultSet.getBlob since this only returns a LOCATOR reference to the object, and no server calls are being made.

Specified by:: getBinaryStream in interface ResultSet

Parameters:: columnIndex - The column number.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnIndex is invalid. 08S01 is thrown on a network receive error. 2200G is thrown if the column type wasn't castable to a string, see ResultSet for an overview of which column types are castable to which Java types.
See Also:: getBlob(int)

getBinaryStream

public InputStream getBinaryStream(String columnName)
                            throws SQLException

Returns an binary stream representing the result set column.

Specified by:: getBinaryStream in interface ResultSet

Parameters:: columnName - The column name.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnName does not exist. 08S01 is thrown on a network receive error. 2200G is thrown if the column type wasn't castable to a string, see ResultSet for an overview of which column types are castable to which Java types.

getBlob

public Blob getBlob(int columnIndex)
             throws SQLException

Get a BLOB LOCATOR object.

Specified by:: getBlob in interface ResultSet

Parameters:: columnIndex - The column number.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnIndex is invalid.

getBlob

public Blob getBlob(String columnName)
             throws SQLException

Get a BLOB LOCATOR object.

Specified by:: getBlob in interface ResultSet

Parameters:: columnName - The column name..
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnName does not exist.

getBoolean

public boolean getBoolean(int columnIndex)
                   throws SQLException

Returns a boolean.

If the column is a CHARACTER, CHARACTER VARYING, NATIONAL CHARACTER or NATIONAL CHARACTER VARYING, this returns true if the character has the values "true" or "1".

Specified by:: getBoolean in interface ResultSet

Parameters:: columnIndex - The column number.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnIndex is invalid. 2200G is thrown if the column type wasn't castable to a string, see ResultSet for an overview of which column types are castable to which Java types.

getBoolean

public boolean getBoolean(String columnName)
                   throws SQLException

Returns a boolean.

If the column is a CHARACTER, CHARACTER VARYING, NATIONAL CHARACTER or NATIONAL CHARACTER VARYING, this returns true if the character has the values "true" or "1".

Specified by:: getBoolean in interface ResultSet

Parameters:: columnName - The column name.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnName does not exist. 2200G is thrown if the column type wasn't castable to a string, see ResultSet for an overview of which column types are castable to which Java types.

getByte

public byte getByte(int columnIndex)
             throws SQLException

Returns a byte.

Specified by:: getByte in interface ResultSet

Parameters:: columnIndex - The column number.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnIndex is invalid. 22003 is thrown if the numeric value could not be fitted into a byte. 22018 is thrown if a character value could not be casted to a numeric value. 2200G is thrown if the column type wasn't castable to a string, see ResultSet for an overview of which column types are castable to which Java types.

getByte

public byte getByte(String columnName)
             throws SQLException

Returns a byte.

Specified by:: getByte in interface ResultSet

Parameters:: columnName - The column name.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnName does not exist. 22003 is thrown if the numeric value could not be fitted into a byte. 22018 is thrown if a character value could not be casted to a numeric value. 2200G is thrown if the column type wasn't castable to a string, see ResultSet for an overview of which column types are castable to which Java types.

getBytes

public byte[] getBytes(int columnIndex)
                throws SQLException

Returns an array of bytes.

Specified by:: getBytes in interface ResultSet

Parameters:: columnIndex - The column number.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnIndex is invalid. 08S01 is thrown on a network receive error. 2200G is thrown if the column type wasn't castable to a string, see ResultSet for an overview of which column types are castable to which Java types.

getBytes

public byte[] getBytes(String columnName)
                throws SQLException

Returns an array of bytes.

Specified by:: getBytes in interface ResultSet

Parameters:: columnName - The column name.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnName does not exist. 08S01 is thrown on a network receive error. 2200G is thrown if the column type wasn't castable to a string, see ResultSet for an overview of which column types are castable to which Java types.

getCharacterStream

public Reader getCharacterStream(int columnIndex)
                          throws SQLException

Get a character stream.

Specified by:: getCharacterStream in interface ResultSet

Parameters:: columnIndex - The column number.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnIndex is invalid. 08S01 is thrown on a network receive error.

getCharacterStream

public Reader getCharacterStream(String columnName)
                          throws SQLException

Get a character stream.

Specified by:: getCharacterStream in interface ResultSet

Parameters:: columnName - The column name..
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnName does not exist. 08S01 is thrown on a network receive error.

getClob

public Clob getClob(int columnIndex)
             throws SQLException

Get a CLOB LOCATOR object.

Specified by:: getClob in interface ResultSet

Parameters:: columnIndex - The column number.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnIndex is invalid.

getClob

public Clob getClob(String columnName)
             throws SQLException

Get a CLOB LOCATOR object.

Specified by:: getClob in interface ResultSet

Parameters:: columnName - The column name..
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnName does not exist.

getConcurrency

public int getConcurrency()
                   throws SQLException

Returns the concurrency mode for this result set.

Specified by:: getConcurrency in interface ResultSet

Returns:: The concurrency mode.
Throws:: SQLException - if an error occurs.

getCursorName

public String getCursorName()
                     throws SQLException

Returns the name of this cursor.

The name of the cursor can be used in conjunction with the UPDATE WHERE CURRENT OF or DELETE WHERE CURRENT OF SQL statements. See Statement.setCursorName for more information on this feature.

Specified by:: getCursorName in interface ResultSet

Returns:: The cursor name.
Throws:: SQLException - if an error occurs.
See Also:: Statement.setCursorName(java.lang.String)

getDate

public Date getDate(int columnIndex)
             throws SQLException

Returns a Date.

When the column is a CHARACTER, CHARACTER VARYING, NATIONAL CHARACTER or NATIONAL CHARACTER VARYING only the column values of the following grammar are castable to the result object.

<time castable literal> ::= <unquoted timestamp string> | <unquoted date string> <unquoted timestamp string> ::= <unquoted date string> <space>unquoted time string> <unquoted date string> ::= <date value> <unquoted time string> ::= <t�me value> <date value> ::= <years value> <minus sign> <months value> <minus sign> <days value> <time value> ::= <hours value> <colon> <minutes value> <colon> <seconds value> <years value> ::= <digit> <digit> <digit> <digit> <months value> ::= <digit> <digit> <days value> ::= <digit> <digit> <hours value> ::= <digit> <digit> <minutes value> ::= <digit> <digit> <seconds value> ::= <digit> <digit> [ <period> [ <second fraction> ]] <second fraction> ::= <digit> [ <digit> [ <digit> [ <digit> [ <digit> [ <digit> [ <digit> [ <digit> [ <digit> ]]]]]]]]

When the string represents an <unquoted timestamp string> the time part is simply dropped, and only the date part is returned. Examples of strings castable to a date.

1914-06-28 2003-12-31 14:49:23.234

Note that Mimer SQL servers up until 9.2 does not support time zones. If time zone handling is required, please consider using the ResultSet.getDate(int,Calendar) method instead.

Specified by:: getDate in interface ResultSet

Parameters:: columnIndex - The column number.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnIndex is invalid. 22018 if the column type was a character which could not be casted to a date. 2200G is thrown if the column type wasn't castable to a date, see ResultSet for an overview of which column types are castable to which Java types.
See Also:: getDate(int,Calendar)

getDate

public Date getDate(int columnIndex,
                    Calendar cal)
             throws SQLException

Get a date with timezone compensation.

Specified by:: getDate in interface ResultSet

Parameters:: columnIndex - The column number.; cal - Calendar object defining time zone.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnIndex is invalid. 22018 if the column type was a character which could not be casted to a date. 2200G is thrown if the column type wasn't castable to a date, see ResultSet for an overview of which column types are castable to which Java types.
See Also:: getDate(int)

getDate

public Date getDate(String columnName)
             throws SQLException

Return a date.

Specified by:: getDate in interface ResultSet

Parameters:: columnName - The column name.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnName does not exist. 22018 if the column type was a character which could not be casted to a date. 2200G is thrown if the column type wasn't castable to a string, see ResultSet for an overview of which column types are castable to which Java types.
See Also:: getDate(int)

getDate

public Date getDate(String columnName,
                    Calendar cal)
             throws SQLException

Get a date with timezone compensation.

Specified by:: getDate in interface ResultSet

Parameters:: columnName - The column name.; cal - Calendar object defining time zone.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnName does not exist. 22018 if the column type was a character which could not be casted to a date. 2200G is thrown if the column type wasn't castable to a string, see ResultSet for an overview of which column types are castable to which Java types.
See Also:: getDate(int)

getDouble

public double getDouble(int columnIndex)
                 throws SQLException

Returns a double.

Specified by:: getDouble in interface ResultSet

Parameters:: columnIndex - The column number.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnIndex is invalid. 22003 is thrown if the numeric value could not be fitted into a double. 22018 is thrown if a character value could not be casted to a numeric value. 2200G is thrown if the column type wasn't castable to a string, see ResultSet for an overview of which column types are castable to which Java types.

getDouble

public double getDouble(String columnName)
                 throws SQLException

Returns a double.

Specified by:: getDouble in interface ResultSet

Parameters:: columnName - The column name.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnIndex is invalid. 22003 is thrown if the numeric value could not be fitted into a double. 22018 is thrown if a character value could not be casted to a numeric value. 2200G is thrown if the column type wasn't castable to a string, see ResultSet for an overview of which column types are castable to which Java types.

getFetchDirection

public int getFetchDirection()
                      throws SQLException

Gets the current fetch direction hint.

Specified by:: getFetchDirection in interface ResultSet

Returns:: The fetch direction hint.
Throws:: SQLException - if an error occurs.
See Also:: setFetchDirection(int)

getFetchSize

public int getFetchSize()
                 throws SQLException

Retrieves the current fetch size. A value of 0 implies that the driver uses an appropriate fetch size of its on choice.

Specified by:: getFetchSize in interface ResultSet

Returns:: The fetch size.
Throws:: SQLException - if an error occurs.
See Also:: setFetchSize(int)

getFloat

public float getFloat(int columnIndex)
               throws SQLException

Returns a float.

Specified by:: getFloat in interface ResultSet

Parameters:: columnIndex - The column number.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnIndex is invalid. 22003 is thrown if the numeric value could not be fitted into a float. 22018 is thrown if a character value could not be casted to a numeric value. 2200G is thrown if the column type wasn't castable to a string, see ResultSet for an overview of which column types are castable to which Java types.

getFloat

public float getFloat(String columnName)
               throws SQLException

Returns a float.

Specified by:: getFloat in interface ResultSet

Parameters:: columnName - The column name.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnIndex is invalid. 22003 is thrown if the numeric value could not be fitted into a float. 22018 is thrown if a character value could not be casted to a numeric value. 2200G is thrown if the column type wasn't castable to a string, see ResultSet for an overview of which column types are castable to which Java types.

getInt

public int getInt(int columnIndex)
           throws SQLException

Returns an integer.

Specified by:: getInt in interface ResultSet

Parameters:: columnIndex - The column number.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnIndex is invalid. 22003 is thrown if the numeric value could not be fitted into an int. 22018 is thrown if a character value could not be casted to a numeric value. 2200G is thrown if the column type wasn't castable to a string, see ResultSet for an overview of which column types are castable to which Java types.

getInt

public int getInt(String columnName)
           throws SQLException

Returns an integer.

Specified by:: getInt in interface ResultSet

Parameters:: columnName - The column name.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnIndex is invalid. 22003 is thrown if the numeric value could not be fitted into an int. 22018 is thrown if a character value could not be casted to a numeric value. 2200G is thrown if the column type wasn't castable to a string, see ResultSet for an overview of which column types are castable to which Java types.

getLong

public long getLong(int columnIndex)
             throws SQLException

Returns an long.

Specified by:: getLong in interface ResultSet

Parameters:: columnIndex - The column number.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnIndex is invalid. 22003 is thrown if the numeric value could not be fitted into an long. 22018 is thrown if a character value could not be casted to a numeric value. 2200G is thrown if the column type wasn't castable to a string, see ResultSet for an overview of which column types are castable to which Java types.

getLong

public long getLong(String columnName)
             throws SQLException

Returns an long.

Specified by:: getLong in interface ResultSet

Parameters:: columnName - The column name.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnIndex is invalid. 22003 is thrown if the numeric value could not be fitted into an long. 22018 is thrown if a character value could not be casted to a numeric value. 2200G is thrown if the column type wasn't castable to a string, see ResultSet for an overview of which column types are castable to which Java types.

getMetaData

public ResultSetMetaData getMetaData()
                              throws SQLException

Returns a ResultSetMetaData object describing the result set.

A ResultSetMetaData object is always internally created at the same time the ResultSet object is created. The driver must have this information somewhere to return data from the result set. This method simply returns this object.

Specified by:: getMetaData in interface ResultSet

Returns:: The ResultSetMetaData object.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open.

getObject

public Object getObject(int columnIndex)
                 throws SQLException

Returns an object.

Specified by:: getObject in interface ResultSet

Parameters:: columnIndex - The column number.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnIndex is not valid.

getObject

public Object getObject(int columnIndex,
                        Map map)
                 throws SQLException

Get object with type map.

Mimer SQL (as of 9.2) does not support either User Defined Data types, structured data types or distinct data types so Mimer JDBC currently only accepts and uses the default type mapping. The map argument is ignored.

Specified by:: getObject in interface ResultSet

Parameters:: columnIndex - The column number.; map - The type map.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnIndex is invalid.

getObject

public Object getObject(String columnName)
                 throws SQLException

Returns an object.

Specified by:: getObject in interface ResultSet

Parameters:: columnName - The column name.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnName does not exist.

getObject

public Object getObject(String columnName,
                        Map map)
                 throws SQLException

Get object with type map.

Specified by:: getObject in interface ResultSet

Parameters:: columnName - The column name.; map - The type map.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnName does not exist.

getRef

public Ref getRef(int columnIndex)
           throws SQLException

Get a reference type.

Mimer SQL (as of 9.2) does not support references. This method will always throw an error.

Specified by:: getRef in interface ResultSet

Parameters:: columnIndex - The column index.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnIndex is not valid. 2200G is thrown if the column type wasn't castable to a string, see ResultSet for an overview of which column types are castable to which Java types.

getRef

public Ref getRef(String columnName)
           throws SQLException

Get a reference type.

Mimer SQL (as of 9.2) does not support references. This method will always throw an error.

Specified by:: getRef in interface ResultSet

Parameters:: columnName - The column name.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnName is not valid. 2200G is thrown if the column type wasn't castable to a string, see ResultSet for an overview of which column types are castable to which Java types.

getRow

public int getRow()
           throws SQLException

Return the current row number.

Specified by:: getRow in interface ResultSet

Returns:: The row number.
Throws:: SQLException - if an error occurs.

getShort

public short getShort(int columnIndex)
               throws SQLException

Returns a short.

Specified by:: getShort in interface ResultSet

Parameters:: columnIndex - The column number.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnIndex is invalid. 22003 is thrown if the numeric value could not be fitted into an short. 22018 is thrown if a character value could not be casted to a numeric value. 2200G is thrown if the column type wasn't castable to a short, see ResultSet for an overview of which column types are castable to which Java types.

getShort

public short getShort(String columnName)
               throws SQLException

Returns a short.

Specified by:: getShort in interface ResultSet

Parameters:: columnName - The column name.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnName is invalid. 22003 is thrown if the numeric value could not be fitted into an short. 22018 is thrown if a character value could not be casted to a numeric value. 2200G is thrown if the column type wasn't castable to a short, see ResultSet for an overview of which column types are castable to which Java types.

getStatement

public Statement getStatement()
                       throws SQLException

Get the statement that belongs to this result set.

Specified by:: getStatement in interface ResultSet

Returns:: The statement.
Throws:: SQLException - if an error occurs.

getString

public String getString(int columnIndex)
                 throws SQLException

Returns a string.

Specified by:: getString in interface ResultSet

Parameters:: columnIndex - The column number.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnIndex is invalid.

getString

public String getString(String columnName)
                 throws SQLException

Returns a string.

Specified by:: getString in interface ResultSet

Parameters:: columnName - The column name..
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnName does not exist.

getTime

public Time getTime(int columnIndex)
             throws SQLException

Returns a time.

When the column is a CHARACTER, CHARACTER VARYING, NATIONAL CHARACTER or NATIONAL CHARACTER VARYING only the column values of the following grammar are castable to the result object.

<time castable literal> ::= <unquoted timestamp string> | <unquoted time string> <unquoted timestamp string> ::= <unquoted date string> <space>unquoted time string> <unquoted date string> ::= <date value> <unquoted time string> ::= <t�me value> <date value> ::= <years value> <minus sign> <months value> <minus sign> <days value> <time value> ::= <hours value> <colon> <minutes value> <colon> <seconds value> <years value> ::= <digit> <digit> <digit> <digit> <months value> ::= <digit> <digit> <days value> ::= <digit> <digit> <hours value> ::= <digit> <digit> <minutes value> ::= <digit> <digit> <seconds value> ::= <digit> <digit> [ <period> [ <second fraction> ]] <second fraction> ::= <digit> [ <digit> [ <digit> [ <digit> [ <digit> [ <digit> [ <digit> [ <digit> [ <digit> ]]]]]]]]

When the string represents an <unquoted timestamp string> the date part is simply dropped, and only the time part is returned. Examples of strings castable to a time.

23:59:59 2003-12-31 14:49:23.234 18:00:00.0012

A warning (SQLWarning SQLSTATE 01S07) is registered if the time or timestamp contains a fraction that was truncated because the java time object doesn't hold second fractions.

Specified by:: getTime in interface ResultSet

Parameters:: columnIndex - The column number.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnIndex is invalid. 22018 is thrown if a character value could not be casted to a time value. 2200G is thrown if the column type wasn't castable to a time, see ResultSet for an overview of which column types are castable to which Java types.

getTime

public Time getTime(int columnIndex,
                    Calendar cal)
             throws SQLException

Get a time with timezone compensation.

Specified by:: getTime in interface ResultSet

Parameters:: columnIndex - The column number.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnIndex is invalid. 22018 if the column type was a character which could not be casted to a time. 2200G is thrown if the column type wasn't castable to a time, see ResultSet for an overview of which column types are castable to which Java types.
See Also:: getTime(int)

getTime

public Time getTime(String columnName)
             throws SQLException

Returns a time.

Specified by:: getTime in interface ResultSet

Parameters:: columnName - The column name..
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnName is invalid. 22018 is thrown if a character value could not be casted to a time value. 2200G is thrown if the column type wasn't castable to a time, see ResultSet for an overview of which column types are castable to which Java types.
See Also:: getTime(int)

getTime

public Time getTime(String columnName,
                    Calendar cal)
             throws SQLException

Get a time with timezone compensation.

Specified by:: getTime in interface ResultSet

Parameters:: columnName - The column name.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnName does not exist. 22018 if the column type was a character which could not be casted to a time. 2200G is thrown if the column type wasn't castable to a string, see ResultSet for an overview of which column types are castable to which Java types.
See Also:: getTime(int)

getTimestamp

public Timestamp getTimestamp(int columnIndex)
                       throws SQLException

Returns a timestamp.

When the column is a CHARACTER, CHARACTER VARYING, NATIONAL CHARACTER or NATIONAL CHARACTER VARYING only the column values of the following grammar are castable to the result object.

<time castable literal> ::= <unquoted timestamp string> | <unquoted date string> | <unquoted time string> <unquoted timestamp string> ::= <unquoted date string> <space>unquoted time string> <unquoted date string> ::= <date value> <unquoted time string> ::= <t�me value> <date value> ::= <years value> <minus sign> <months value> <minus sign> <days value> <time value> ::= <hours value> <colon> <minutes value> <colon> <seconds value> <years value> ::= <digit> <digit> <digit> <digit> <months value> ::= <digit> <digit> <days value> ::= <digit> <digit> <hours value> ::= <digit> <digit> <minutes value> ::= <digit> <digit> <seconds value> ::= <digit> <digit> [ <period> [ <second fraction> ]] <second fraction> ::= <digit> [ <digit> [ <digit> [ <digit> [ <digit> [ <digit> [ <digit> [ <digit> [ <digit> ]]]]]]]]

When the string represents an <unquoted timestamp string> the date part is simply dropped, and only the time part is returned. If the string represents a time value, the returned timestamp will contain that time at the current date. Examples of strings castable to a time.

1914-06-28 23:59:59 2003-12-31 14:49:23.234 18:00:00.0012

Specified by:: getTimestamp in interface ResultSet

Parameters:: columnIndex - The column number.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnIndex is invalid. 22018 is thrown if a character value could not be casted to a timestamp value. 2200G is thrown if the column type wasn't castable to a timestamp, see ResultSet for an overview of which column types are castable to which Java types.

getTimestamp

public Timestamp getTimestamp(int columnIndex,
                              Calendar cal)
                       throws SQLException

Get a timestamp with timezone compensation.

Specified by:: getTimestamp in interface ResultSet

Parameters:: columnIndex - The column number.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnIndex is invalid. 22018 if the column type was a character which could not be casted to a timestamp. 2200G is thrown if the column type wasn't castable to a timestamp, see ResultSet for an overview of which column types are castable to which Java types.
See Also:: getTimestamp(int)

getTimestamp

public Timestamp getTimestamp(String columnName)
                       throws SQLException

Returns a time.

Specified by:: getTimestamp in interface ResultSet

Parameters:: columnName - The column name..
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnName does not exist.
See Also:: getTimestamp(int)

getTimestamp

public Timestamp getTimestamp(String columnName,
                              Calendar cal)
                       throws SQLException

Get a timestamp with timezone compensation.

Specified by:: getTimestamp in interface ResultSet

Parameters:: columnName - The column name.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnName does not exist. 22018 if the column type was a character which could not be casted to a timestamp. 2200G is thrown if the column type wasn't castable to a string, see ResultSet for an overview of which column types are castable to which Java types.
See Also:: getTimestamp(int)

getType

public int getType()
            throws SQLException

Return the type of the result set.

Specified by:: getType in interface ResultSet

Returns:: The result set type.
Throws:: SQLException - if an error occurs.

getUnicodeStream

public InputStream getUnicodeStream(int columnIndex)
                             throws SQLException

Specified by:: getUnicodeStream in interface ResultSet

Parameters:: columnIndex - The column number.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnIndex is invalid. 08S01 is thrown on a network receive error.

getUnicodeStream

public InputStream getUnicodeStream(String columnName)
                             throws SQLException

Specified by:: getUnicodeStream in interface ResultSet

Parameters:: columnName - The column name..
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 24000 is thrown if the cursor is not located on a valid row. 07009 is thrown if the columnName does not exist. 08S01 is thrown on a network receive error.

getWarnings

public SQLWarning getWarnings()
                       throws SQLException

Returns the first warning posted to this object.

Specified by:: getWarnings in interface ResultSet

Returns:: The first warning object or null if no warnings available.
Throws:: SQLException - if an error occurred.
See Also:: clearWarnings()

insertRow

public void insertRow()
               throws SQLException

Inserts the contents of the insert row into this ResultSet object and into the database.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: insertRow in interface ResultSet

Throws:: SQLException - if a database access error occurs

isAfterLast

public boolean isAfterLast()
                    throws SQLException

Returns true if the current row is after the last row of the result set.

Specified by:: isAfterLast in interface ResultSet

Returns:: True if current is after last.
Throws:: SQLException - if an error occurs.

isBeforeFirst

public boolean isBeforeFirst()
                      throws SQLException

Returns true if the current row is before the first row of the result set.

Specified by:: isBeforeFirst in interface ResultSet

Returns:: True if current is before first.
Throws:: SQLException - if an error occurs.

isFirst

public boolean isFirst()
                throws SQLException

Returns true if the current row is at the first row of the result set.

Specified by:: isFirst in interface ResultSet

Returns:: True if current is at first.
Throws:: SQLException - if an error occurs.

isLast

public boolean isLast()
               throws SQLException

Returns true if the current row is at the last row of the result set.

Specified by:: isLast in interface ResultSet

Returns:: True if current is at last.
Throws:: SQLException - if an error occurs.

last

public boolean last()
             throws SQLException

Positions the cursor on the last row of the result set.

Specified by:: last in interface ResultSet

Returns:: True if the cursor is on a valid row.
Throws:: SQLException - if an error occurs. SQLSTATE HY109 is thrown if this is a forward-only result set.

moveToCurrentRow

public void moveToCurrentRow()
                      throws SQLException

Moves the cursor to the remembered cursor position, usually the current row. This method has no effect if the cursor is not on the insert row.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: moveToCurrentRow in interface ResultSet

Throws:: SQLException - if a database access error occurs or the result set is not updatable

moveToInsertRow

public void moveToInsertRow()
                     throws SQLException

Moves the cursor to the insert row. The current cursor position is remembered while the cursor is positioned on the insert row.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: moveToInsertRow in interface ResultSet

Throws:: SQLException - if a database access error occurs or the result set is not updatable

public boolean next()
             throws SQLException

Moves on to the next row in the result set.

Specified by:: next in interface ResultSet

Returns:: true if the cursor is located on a valid row after the operation.
Throws:: SQLException - if an error occurs. SQLSTATE HY010 is thrown if the cursor is not open. 08S01 is thrown on a network receive error.
See Also:: previous(), absolute(int), first(), last()

public boolean previous()
                 throws SQLException

Positions the cursor one row backwards in the result set.

Specified by:: previous in interface ResultSet

Returns:: True if the cursor is on a valid row.
Throws:: SQLException - if an error occurs. SQLSTATE HY109 is thrown if this is a forward-only result set.

refreshRow

public void refreshRow()
                throws SQLException

The refreshRow method provides a way for an application to explicitly tell the JDBC driver to refetch a row(s) from the database.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: refreshRow in interface ResultSet

Throws:: SQLException - if a database access error occurs or if this method is called when the cursor is on the insert row

relative

public boolean relative(int rows)
                 throws SQLException

Positioning relative to the current cursor position.

Specified by:: relative in interface ResultSet

Parameters:: rows - If positive the cursor is repositioned forward in the result set. If negative it is repositioned backwards.
Throws:: SQLException - if an error occurs. SQLSTATE HY109 is thrown if this is a forward-only result set.

rowDeleted

public boolean rowDeleted()
                   throws SQLException

Indicates whether a row has been deleted.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: rowDeleted in interface ResultSet

Returns:: true if a row was deleted and deletions are detected; false otherwise
Throws:: SQLException - if a database access error occurs

rowInserted

public boolean rowInserted()
                    throws SQLException

Indicates whether the current row has had an insertion.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: rowInserted in interface ResultSet

Returns:: true if a row has had an insertion and insertions are detected; false otherwise
Throws:: SQLException - if a database access error occurs

rowUpdated

public boolean rowUpdated()
                   throws SQLException

Indicates whether the current row has been updated.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: rowUpdated in interface ResultSet

Returns:: true if the row has been visibly updated by the owner or another, and updates are detected
Throws:: SQLException - if a database access error occurs

setFetchDirection

public void setFetchDirection(int direction)
                       throws SQLException

Sets the current fetch direction hint.

See Statement.setFetchDirection for a deeper descissuion on fetch direction and Mimer SQL.

Specified by:: setFetchDirection in interface ResultSet

Parameters:: direction - The fetch direction hint.
Throws:: SQLException - if an error occurs. If the Statement object is closed, SQLSTATE HY010 is thrown. If the fetch direction is illegal HY024 is thrown.
See Also:: Statement.setFetchDirection(int), getFetchDirection()

setFetchSize

public void setFetchSize(int rows)
                  throws SQLException

Sets the current fetch size.

See Statement.setFetchSize for a deeper descissuion on fetch size and Mimer SQL.

Specified by:: setFetchSize in interface ResultSet

Parameters:: rows - The fetch size.
Throws:: SQLException - if an error occurs. If the Statement object is closed, SQLSTATE HY010 is thrown. HY024 is thrown if the fetch size is negative.
See Also:: Statement.setMaxRows(int), Statement.setFetchSize(int), getFetchSize()

updateAsciiStream

public void updateAsciiStream(int columnIndex,
                              InputStream x,
                              int length)
                       throws SQLException

Updates the designated column with an ascii stream value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateAsciiStream in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value; length - the length of the stream
Throws:: SQLException - if a database access error occurs

updateAsciiStream

public void updateAsciiStream(String columnName,
                              InputStream x,
                              int length)
                       throws SQLException

Updates the designated column with an ascii stream value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateAsciiStream in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value; length - the length of the stream
Throws:: SQLException - if a database access error occurs

updateBigDecimal

public void updateBigDecimal(int columnIndex,
                             BigDecimal x)
                      throws SQLException

Updates the designated column with a java.math.BigDecimal value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateBigDecimal in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value
Throws:: SQLException - if a database access error occurs

updateBigDecimal

public void updateBigDecimal(String columnName,
                             BigDecimal x)
                      throws SQLException

Updates the designated column with a java.math.BigDecimal value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateBigDecimal in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value
Throws:: SQLException - if a database access error occurs

updateBinaryStream

public void updateBinaryStream(int columnIndex,
                               InputStream x,
                               int length)
                        throws SQLException

Updates the designated column with a binary stream value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateBinaryStream in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value; length - the length of the stream
Throws:: SQLException - if a database access error occurs

updateBinaryStream

public void updateBinaryStream(String columnName,
                               InputStream x,
                               int length)
                        throws SQLException

Updates the designated column with a binary stream value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateBinaryStream in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value; length - the length of the stream
Throws:: SQLException - if a database access error occurs

updateBoolean

public void updateBoolean(int columnIndex,
                          boolean x)
                   throws SQLException

Updates the designated column with a boolean value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateBoolean in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value
Throws:: SQLException - if a database access error occurs

updateBoolean

public void updateBoolean(String columnName,
                          boolean x)
                   throws SQLException

Updates the designated column with a boolean value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateBoolean in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value
Throws:: SQLException - if a database access error occurs

updateByte

public void updateByte(int columnIndex,
                       byte x)
                throws SQLException

Updates the designated column with a byte value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateByte in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value
Throws:: SQLException - if a database access error occurs

updateByte

public void updateByte(String columnName,
                       byte x)
                throws SQLException

Updates the designated column with a byte value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateByte in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value
Throws:: SQLException - if a database access error occurs

updateBytes

public void updateBytes(int columnIndex,
                        byte[] x)
                 throws SQLException

Updates the designated column with a byte array value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateBytes in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value
Throws:: SQLException - if a database access error occurs

updateBytes

public void updateBytes(String columnName,
                        byte[] x)
                 throws SQLException

Updates the designated column with a byte array value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateBytes in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value
Throws:: SQLException - if a database access error occurs

updateCharacterStream

public void updateCharacterStream(int columnIndex,
                                  Reader x,
                                  int length)
                           throws SQLException

Updates the designated column with a character stream value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateCharacterStream in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value; length - the length of the stream
Throws:: SQLException - if a database access error occurs

updateCharacterStream

public void updateCharacterStream(String columnName,
                                  Reader x,
                                  int length)
                           throws SQLException

Updates the designated column with a character stream value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateCharacterStream in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value; length - the length of the stream
Throws:: SQLException - if a database access error occurs

updateDate

public void updateDate(int columnIndex,
                       Date x)
                throws SQLException

Updates the designated column with a java.sql.Date value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateDate in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value
Throws:: SQLException - if a database access error occurs

updateDate

public void updateDate(String columnName,
                       Date x)
                throws SQLException

Updates the designated column with a java.sql.Date value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateDate in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value
Throws:: SQLException - if a database access error occurs

updateDouble

public void updateDouble(int columnIndex,
                         double x)
                  throws SQLException

Updates the designated column with a double value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateDouble in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value
Throws:: SQLException - if a database access error occurs

updateDouble

public void updateDouble(String columnName,
                         double x)
                  throws SQLException

Updates the designated column with a double value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateDouble in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value
Throws:: SQLException - if a database access error occurs

updateFloat

public void updateFloat(int columnIndex,
                        float x)
                 throws SQLException

Updates the designated column with a float value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateFloat in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value
Throws:: SQLException - if a database access error occurs

updateFloat

public void updateFloat(String columnName,
                        float x)
                 throws SQLException

Updates the designated column with a float value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateFloat in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value
Throws:: SQLException - if a database access error occurs

updateInt

public void updateInt(int columnIndex,
                      int x)
               throws SQLException

Updates the designated column with an int value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateInt in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value
Throws:: SQLException - if a database access error occurs

updateInt

public void updateInt(String columnName,
                      int x)
               throws SQLException

Updates the designated column with an int value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateInt in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value
Throws:: SQLException - if a database access error occurs

updateLong

public void updateLong(int columnIndex,
                       long x)
                throws SQLException

Updates the designated column with a long value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateLong in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value
Throws:: SQLException - if a database access error occurs

updateLong

public void updateLong(String columnName,
                       long x)
                throws SQLException

Updates the designated column with a long value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateLong in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value
Throws:: SQLException - if a database access error occurs

updateNull

public void updateNull(int columnIndex)
                throws SQLException

Gives a nullable column a null value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateNull in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Throws:: SQLException - if a database access error occurs

updateNull

public void updateNull(String columnName)
                throws SQLException

Gives a nullable column a null value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateNull in interface ResultSet

Parameters:: columnName - the name of the column
Throws:: SQLException - if a database access error occurs

updateObject

public void updateObject(int columnIndex,
                         Object x)
                  throws SQLException

Updates the designated column with an Object value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateObject in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value
Throws:: SQLException - if a database access error occurs

updateObject

public void updateObject(int columnIndex,
                         Object x,
                         int scale)
                  throws SQLException

Updates the designated column with an Object value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateObject in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value; scale - for java.sql.Types.DECIMA or java.sql.Types.NUMERIC types, this is the number of digits after the decimal point. For all other types this value will be ignored.
Throws:: SQLException - if a database access error occurs

updateObject

public void updateObject(String columnName,
                         Object x)
                  throws SQLException

Updates the designated column with an Object value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateObject in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value
Throws:: SQLException - if a database access error occurs

updateObject

public void updateObject(String columnName,
                         Object x,
                         int scale)
                  throws SQLException

Updates the designated column with an Object value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateObject in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value; scale - for java.sql.Types.DECIMA or java.sql.Types.NUMERIC types, this is the number of digits after the decimal point. For all other types this value will be ignored.
Throws:: SQLException - if a database access error occurs

updateRow

public void updateRow()
               throws SQLException

Updates the underlying database with the new contents of the current row of this ResultSet object.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateRow in interface ResultSet

Throws:: SQLException - if a database access error occurs or if this method is called when the cursor is on the insert row

updateShort

public void updateShort(int columnIndex,
                        short x)
                 throws SQLException

Updates the designated column with a short value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateShort in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value
Throws:: SQLException - if a database access error occurs

updateShort

public void updateShort(String columnName,
                        short x)
                 throws SQLException

Updates the designated column with a short value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateShort in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value
Throws:: SQLException - if a database access error occurs

updateString

public void updateString(int columnIndex,
                         String x)
                  throws SQLException

Updates the designated column with a String value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateString in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value
Throws:: SQLException - if a database access error occurs

updateString

public void updateString(String columnName,
                         String x)
                  throws SQLException

Updates the designated column with a String value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateString in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value
Throws:: SQLException - if a database access error occurs

updateTime

public void updateTime(int columnIndex,
                       Time x)
                throws SQLException

Updates the designated column with a java.sql.Time value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateTime in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value
Throws:: SQLException - if a database access error occurs

updateTime

public void updateTime(String columnName,
                       Time x)
                throws SQLException

Updates the designated column with a java.sql.Time value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateTime in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value
Throws:: SQLException - if a database access error occurs

updateTimestamp

public void updateTimestamp(int columnIndex,
                            Timestamp x)
                     throws SQLException

Updates the designated column with a java.sql.Timestamp value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateTimestamp in interface ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; x - the new column value
Throws:: SQLException - if a database access error occurs

updateTimestamp

public void updateTimestamp(String columnName,
                            Timestamp x)
                     throws SQLException

Updates the designated column with a java.sql.Timestamp value.

Mimer SQL currently don't support updatable cursors. Use positioned UPDATE/DELETE:s instead.

Specified by:: updateTimestamp in interface ResultSet

Parameters:: columnName - the name of the column; x - the new column value
Throws:: SQLException - if a database access error occurs

wasNull

public boolean wasNull()
                throws SQLException

Returns true if the last column read was a NULL.

Specified by:: wasNull in interface ResultSet

Returns:: true if SQL NULL.
Throws:: SQLException - if an error occurs.

Overview

Package

Class

Index

Help

Mimer JDBC Engine 2.12

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

Method Summary
`boolean`	`absolute(int row)` Positions the cursor on a absolute position.
`void`	`afterLast()` Positions the cursor after the end of the result set.
`void`	`beforeFirst()` Positions the cursor before the beginning of the result set.
`void`	`cancelRowUpdates()` Cancels the updates made to the current row in this `ResultSet` object.
`void`	`clearWarnings()` Clears all warnings reported on the object.
`void`	`close()` Closes the statement.
`void`	`deleteRow()` Deletes the current row from this `ResultSet` object and from the underlying database.
`int`	`findColumn(String columnName)` Finds a column index from a column name.
`boolean`	`first()` Positions the cursor at the first row of the result set.
`Array`	`getArray(int columnIndex)` Get an SQL array.
`Array`	`getArray(String columnName)` Get an SQL array.
`InputStream`	`getAsciiStream(int columnIndex)` Returns an ascii stream representing the result set column.
`InputStream`	`getAsciiStream(String columnName)` Returns an ascii stream representing the result set column.
`BigDecimal`	`getBigDecimal(int columnIndex)` Returns a java.math.BigDecimal object without scale.
`BigDecimal`	`getBigDecimal(int columnIndex, int scale)` Returns a java.math.BigDecimal object.
`BigDecimal`	`getBigDecimal(String columnName)` Returns a java.math.BigDecimal object.
`BigDecimal`	`getBigDecimal(String columnName, int scale)` Returns a java.math.BigDecimal object.
`InputStream`	`getBinaryStream(int columnIndex)` Returns an binary stream representing the result set column.
`InputStream`	`getBinaryStream(String columnName)` Returns an binary stream representing the result set column.
`Blob`	`getBlob(int columnIndex)` Get a BLOB LOCATOR object.
`Blob`	`getBlob(String columnName)` Get a BLOB LOCATOR object.
`boolean`	`getBoolean(int columnIndex)` Returns a boolean.
`boolean`	`getBoolean(String columnName)` Returns a boolean.
`byte`	`getByte(int columnIndex)` Returns a byte.
`byte`	`getByte(String columnName)` Returns a byte.
`byte[]`	`getBytes(int columnIndex)` Returns an array of bytes.
`byte[]`	`getBytes(String columnName)` Returns an array of bytes.
`Reader`	`getCharacterStream(int columnIndex)` Get a character stream.
`Reader`	`getCharacterStream(String columnName)` Get a character stream.
`Clob`	`getClob(int columnIndex)` Get a CLOB LOCATOR object.
`Clob`	`getClob(String columnName)` Get a CLOB LOCATOR object.
`int`	`getConcurrency()` Returns the concurrency mode for this result set.
`String`	`getCursorName()` Returns the name of this cursor.
`Date`	`getDate(int columnIndex)` Returns a Date.
`Date`	`getDate(int columnIndex, Calendar cal)` Get a date with timezone compensation.
`Date`	`getDate(String columnName)` Return a date.
`Date`	`getDate(String columnName, Calendar cal)` Get a date with timezone compensation.
`double`	`getDouble(int columnIndex)` Returns a double.
`double`	`getDouble(String columnName)` Returns a double.
`int`	`getFetchDirection()` Gets the current fetch direction hint.
`int`	`getFetchSize()` Retrieves the current fetch size.
`float`	`getFloat(int columnIndex)` Returns a float.
`float`	`getFloat(String columnName)` Returns a float.
`int`	`getInt(int columnIndex)` Returns an integer.
`int`	`getInt(String columnName)` Returns an integer.
`long`	`getLong(int columnIndex)` Returns an long.
`long`	`getLong(String columnName)` Returns an long.
`ResultSetMetaData`	`getMetaData()` Returns a ResultSetMetaData object describing the result set.
`Object`	`getObject(int columnIndex)` Returns an object.
`Object`	`getObject(int columnIndex, Map map)` Get object with type map.
`Object`	`getObject(String columnName)` Returns an object.
`Object`	`getObject(String columnName, Map map)` Get object with type map.
`Ref`	`getRef(int columnIndex)` Get a reference type.
`Ref`	`getRef(String columnName)` Get a reference type.
`int`	`getRow()` Return the current row number.
`short`	`getShort(int columnIndex)` Returns a short.
`short`	`getShort(String columnName)` Returns a short.
`Statement`	`getStatement()` Get the statement that belongs to this result set.
`String`	`getString(int columnIndex)` Returns a string.
`String`	`getString(String columnName)` Returns a string.
`Time`	`getTime(int columnIndex)` Returns a time.
`Time`	`getTime(int columnIndex, Calendar cal)` Get a time with timezone compensation.
`Time`	`getTime(String columnName)` Returns a time.
`Time`	`getTime(String columnName, Calendar cal)` Get a time with timezone compensation.
`Timestamp`	`getTimestamp(int columnIndex)` Returns a timestamp.
`Timestamp`	`getTimestamp(int columnIndex, Calendar cal)` Get a timestamp with timezone compensation.
`Timestamp`	`getTimestamp(String columnName)` Returns a time.
`Timestamp`	`getTimestamp(String columnName, Calendar cal)` Get a timestamp with timezone compensation.
`int`	`getType()` Return the type of the result set.
`InputStream`	`getUnicodeStream(int columnIndex)`
`InputStream`	`getUnicodeStream(String columnName)`
`SQLWarning`	`getWarnings()` Returns the first warning posted to this object.
`void`	`insertRow()` Inserts the contents of the insert row into this `ResultSet` object and into the database.
`boolean`	`isAfterLast()` Returns true if the current row is after the last row of the result set.
`boolean`	`isBeforeFirst()` Returns true if the current row is before the first row of the result set.
`boolean`	`isFirst()` Returns true if the current row is at the first row of the result set.
`boolean`	`isLast()` Returns true if the current row is at the last row of the result set.
`boolean`	`last()` Positions the cursor on the last row of the result set.
`void`	`moveToCurrentRow()` Moves the cursor to the remembered cursor position, usually the current row.
`void`	`moveToInsertRow()` Moves the cursor to the insert row.
`boolean`	`next()` Moves on to the next row in the result set.
`boolean`	`previous()` Positions the cursor one row backwards in the result set.
`void`	`refreshRow()` The `refreshRow` method provides a way for an application to explicitly tell the JDBC driver to refetch a row(s) from the database.
`boolean`	`relative(int rows)` Positioning relative to the current cursor position.
`boolean`	`rowDeleted()` Indicates whether a row has been deleted.
`boolean`	`rowInserted()` Indicates whether the current row has had an insertion.
`boolean`	`rowUpdated()` Indicates whether the current row has been updated.
`void`	`setFetchDirection(int direction)` Sets the current fetch direction hint.
`void`	`setFetchSize(int rows)` Sets the current fetch size.
`void`	`updateAsciiStream(int columnIndex, InputStream x, int length)` Updates the designated column with an ascii stream value.
`void`	`updateAsciiStream(String columnName, InputStream x, int length)` Updates the designated column with an ascii stream value.
`void`	`updateBigDecimal(int columnIndex, BigDecimal x)` Updates the designated column with a `java.math.BigDecimal` value.
`void`	`updateBigDecimal(String columnName, BigDecimal x)` Updates the designated column with a `java.math.BigDecimal` value.
`void`	`updateBinaryStream(int columnIndex, InputStream x, int length)` Updates the designated column with a binary stream value.
`void`	`updateBinaryStream(String columnName, InputStream x, int length)` Updates the designated column with a binary stream value.
`void`	`updateBoolean(int columnIndex, boolean x)` Updates the designated column with a `boolean` value.
`void`	`updateBoolean(String columnName, boolean x)` Updates the designated column with a `boolean` value.
`void`	`updateByte(int columnIndex, byte x)` Updates the designated column with a `byte` value.
`void`	`updateByte(String columnName, byte x)` Updates the designated column with a `byte` value.
`void`	`updateBytes(int columnIndex, byte[] x)` Updates the designated column with a `byte` array value.
`void`	`updateBytes(String columnName, byte[] x)` Updates the designated column with a `byte` array value.
`void`	`updateCharacterStream(int columnIndex, Reader x, int length)` Updates the designated column with a character stream value.
`void`	`updateCharacterStream(String columnName, Reader x, int length)` Updates the designated column with a character stream value.
`void`	`updateDate(int columnIndex, Date x)` Updates the designated column with a `java.sql.Date` value.
`void`	`updateDate(String columnName, Date x)` Updates the designated column with a `java.sql.Date` value.
`void`	`updateDouble(int columnIndex, double x)` Updates the designated column with a `double` value.
`void`	`updateDouble(String columnName, double x)` Updates the designated column with a `double` value.
`void`	`updateFloat(int columnIndex, float x)` Updates the designated column with a `float` value.
`void`	`updateFloat(String columnName, float x)` Updates the designated column with a `float` value.
`void`	`updateInt(int columnIndex, int x)` Updates the designated column with an `int` value.
`void`	`updateInt(String columnName, int x)` Updates the designated column with an `int` value.
`void`	`updateLong(int columnIndex, long x)` Updates the designated column with a `long` value.
`void`	`updateLong(String columnName, long x)` Updates the designated column with a `long` value.
`void`	`updateNull(int columnIndex)` Gives a nullable column a null value.
`void`	`updateNull(String columnName)` Gives a nullable column a null value.
`void`	`updateObject(int columnIndex, Object x)` Updates the designated column with an `Object` value.
`void`	`updateObject(int columnIndex, Object x, int scale)` Updates the designated column with an `Object` value.
`void`	`updateObject(String columnName, Object x)` Updates the designated column with an `Object` value.
`void`	`updateObject(String columnName, Object x, int scale)` Updates the designated column with an `Object` value.
`void`	`updateRow()` Updates the underlying database with the new contents of the current row of this `ResultSet` object.
`void`	`updateShort(int columnIndex, short x)` Updates the designated column with a `short` value.
`void`	`updateShort(String columnName, short x)` Updates the designated column with a `short` value.
`void`	`updateString(int columnIndex, String x)` Updates the designated column with a `String` value.
`void`	`updateString(String columnName, String x)` Updates the designated column with a `String` value.
`void`	`updateTime(int columnIndex, Time x)` Updates the designated column with a `java.sql.Time` value.
`void`	`updateTime(String columnName, Time x)` Updates the designated column with a `java.sql.Time` value.
`void`	`updateTimestamp(int columnIndex, Timestamp x)` Updates the designated column with a `java.sql.Timestamp` value.
`void`	`updateTimestamp(String columnName, Timestamp x)` Updates the designated column with a `java.sql.Timestamp` value.
`boolean`	`wasNull()` Returns true if the last column read was a NULL.

com.mimer.jdbc Class ResultSet

absolute

afterLast

beforeFirst

cancelRowUpdates

clearWarnings

close

deleteRow

findColumn

first

getArray

getArray

getAsciiStream

getAsciiStream

getBigDecimal

getBigDecimal

getBigDecimal

getBigDecimal

getBinaryStream

getBinaryStream

getBlob

getBlob

getBoolean

getBoolean

getByte

getByte

getBytes

getBytes

getCharacterStream

getCharacterStream

getClob

getClob

getConcurrency

getCursorName

getDate

getDate

getDate

getDate

getDouble

getDouble

getFetchDirection

getFetchSize

getFloat

getFloat

getInt

getInt

getLong

getLong

getMetaData

getObject

getObject

getObject

getObject

getRef

getRef

getRow

getShort

getShort

getStatement

getString

getString

getTime

getTime

getTime

getTime

getTimestamp

getTimestamp

getTimestamp

getTimestamp

getType

getUnicodeStream

getUnicodeStream

getWarnings

insertRow

isAfterLast

isBeforeFirst

isFirst

isLast

last

moveToCurrentRow

com.mimer.jdbc
Class ResultSet