Mimer JDBC Engine 2.12

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:

OTODBC.TINYINT
SISMALLINT
ININTEGER
IN(n)INTEGER(n)
BIBIGINT
REREAL
FLFLOAT
FL(n)FLOAT(n)
DPDOUBLE PRECISION
DCDECIMAL
NUNUMERIC
BIODBC.BIT
CHCHARACTER
VCCHARACTER VARYING
BIBINARY
VBBINARY VARYING
NCHNATIONAL CHARACTER
NVCNATIONAL CHARACTER VARYING
DTDATE
TITIME
TSTIMESTAMP
IVINTERVAL YEAR
INTERVAL MONTH
INTERVAL DAY
INTERVAL HOUR
INTERVAL MINUTE
INTERVAL SECOND
IV2INTERVAL 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
BLBINARY LARGE OBJECT
CLCHARACTER LARGE OBJECT
NCLNATIONAL 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:

  1. ResultSet is created.
  2. ResultSet is advanced one row at a time until the 10th row.
  3. 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.
  4. ResultSet.absolute(100) is called. This row has already been formed, so returning to it should be nearly instantaneous.
  5. 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.

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:
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.

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:
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

next

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()

previous

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.

Mimer JDBC Engine 2.12

Submit a comment or suggestion Version 2.12 of Mimer JDBC Engine
Copyright Upright Database Technology AB, Box 1713, SE-751 47 UPPSALA, Sweden. All Rights Reserved.