Java Doc for JdbcResultSet.java in  » Database-DBMS » h2database » org » h2 » jdbc » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Java Source Code / Java Documentation 1.  6.0 JDK Core 2.  6.0 JDK Modules 3.  6.0 JDK Modules com.sun 4.  6.0 JDK Modules com.sun.java 5.  6.0 JDK Modules sun 6.  6.0 JDK Platform 7.  Ajax 8.  Apache Harmony Java SE 9.  Aspect oriented 10.  Authentication Authorization 11.  Blogger System 12.  Build 13.  Byte Code 14.  Cache 15.  Chart 16.  Chat 17.  Code Analyzer 18.  Collaboration 19.  Content Management System 20.  Database Client 21.  Database DBMS 22.  Database JDBC Connection Pool 23.  Database ORM 24.  Development 25.  EJB Server geronimo 26.  EJB Server GlassFish 27.  EJB Server JBoss 4.2.1 28.  EJB Server resin 3.1.5 29.  ERP CRM Financial 30.  ESB 31.  Forum 32.  GIS 33.  Graphic Library 34.  Groupware 35.  HTML Parser 36.  IDE 37.  IDE Eclipse 38.  IDE Netbeans 39.  Installer 40.  Internationalization Localization 41.  Inversion of Control 42.  Issue Tracking 43.  J2EE 44.  JBoss 45.  JMS 46.  JMX 47.  Library 48.  Mail Clients 49.  Net 50.  Parser 51.  PDF 52.  Portal 53.  Profiler 54.  Project Management 55.  Report 56.  RSS RDF 57.  Rule Engine 58.  Science 59.  Scripting 60.  Search Engine 61.  Security 62.  Sevlet Container 63.  Source Control 64.  Swing Library 65.  Template Engine 66.  Test Coverage 67.  Testing 68.  UML 69.  Web Crawler 70.  Web Framework 71.  Web Mail 72.  Web Server 73.  Web Services 74.  Web Services apache cxf 2.0.1 75.  Web Services AXIS2 76.  Wiki Engine 77.  Workflow Engines 78.  XML 79.  XML UI Java Java Tutorial Java Open Source Jar File Download Java Articles Java Products Java by API Photoshop Tutorials Maya Tutorials Flash Tutorials 3ds-Max Tutorials Illustrator Tutorials GIMP Tutorials C# / C Sharp C# / CSharp Tutorial C# / CSharp Open Source ASP.Net ASP.NET Tutorial JavaScript DHTML JavaScript Tutorial JavaScript Reference HTML / CSS HTML CSS Reference C / ANSI-C C Tutorial C++ C++ Tutorial Ruby PHP Python Python Tutorial Python Open Source SQL Server / T-SQL SQL Server / T-SQL Tutorial Oracle PL / SQL Oracle PL/SQL Tutorial PostgreSQL SQL / MySQL MySQL Tutorial VB.Net VB.Net Tutorial Flash / Flex / ActionScript VBA / Excel / Access / Word XML XML Tutorial Microsoft Office PowerPoint 2007 Tutorial Microsoft Office Excel 2007 Tutorial Microsoft Office Word 2007 Tutorial

Java Source Code / Java Documentation » Database DBMS » h2database » org.h2.jdbc   Source Cross Reference   Class Diagram   Java Document (Java Doc)   java.lang.Object    org.h2.message.TraceObject       org.h2.jdbc.JdbcResultSet JdbcResultSet public class JdbcResultSet extends TraceObject implements ResultSet(Code) Represents a result set. Column names are case-insensitive, quotes are not supported. The first column has the column index 1. Result sets are updatable when the result only contains columns from one table, and if it contains all columns of a unique index (primary key or other) of this table. Constructor Summary   JdbcResultSet(SessionInterface session, JdbcConnection conn, JdbcStatement stat, ResultInterface result, int id, boolean closeStatement, boolean scrollable)      Method Summary public  boolean absolute(int rowNumber)      Moves the current position to a specific row. Parameters:   rowNumber - the row number. public  void afterLast()      Moves the current position to after the last row, that means after the end. public  void beforeFirst()      Moves the current position to before the first row, that means resets the result set. public  void cancelRowUpdates()      Cancels updating a row.  void checkClosed()      public  void clearWarnings()      Clears all warnings. public  void close()      Closes the result set.  void closeInternal()      public  void deleteRow()      Deletes the current row. public  int findColumn(String columnName)      Searches for a specific column in the result set. public  boolean first()      Moves the current position to the first row. public  Array getArray(int columnIndex)      Returns the value of the specified column as an Array. public  Array getArray(String columnName)      Returns the value of the specified column as an Array. public  InputStream getAsciiStream(int columnIndex)      Returns the value of the specified column as input stream. public  InputStream getAsciiStream(String columnName)      Returns the value of the specified column as input stream. public  BigDecimal getBigDecimal(int columnIndex)      Returns the value of the specified column as a String. public  BigDecimal getBigDecimal(String columnName)      Returns the value of the specified column as a String. public  BigDecimal getBigDecimal(String columnName, int scale)      Returns the value of the specified column as a String. public  BigDecimal getBigDecimal(int columnIndex, int scale)      Returns the value of the specified column as a String. public  InputStream getBinaryStream(int columnIndex)      Returns the value of the specified column as input stream. public  InputStream getBinaryStream(String columnName)      Returns the value of the specified column as input stream. public  Blob getBlob(int columnIndex)      Returns the value of the specified column as a Blob. public  Blob getBlob(String columnName)      Returns the value of the specified column as a Blob. public  boolean getBoolean(int columnIndex)      Returns the value of the specified column as a boolean. public  boolean getBoolean(String columnName)      Returns the value of the specified column as a boolean. public  byte getByte(int columnIndex)      Returns the value of the specified column as a byte. public  byte getByte(String columnName)      Returns the value of the specified column as a byte. public  byte[] getBytes(int columnIndex)      Returns the value of the specified column as a byte array. public  byte[] getBytes(String columnName)      Returns the value of the specified column as a byte array. public  Reader getCharacterStream(int columnIndex)      Returns the value of the specified column as input stream. public  Reader getCharacterStream(String columnName)      Returns the value of the specified column as input stream. public  Clob getClob(int columnIndex)      Returns the value of the specified column as a Clob. public  Clob getClob(String columnName)      Returns the value of the specified column as a Clob.  int getColumnIndex(String columnName)      public  int getConcurrency()      Gets the result set concurrency. public  String getCursorName()      [Not supported] Gets the cursor name if it was defined. public  Date getDate(int columnIndex)      Returns the value of the specified column as a java.sql.Date. public  Date getDate(String columnName)      Returns the value of the specified column as a java.sql.Date. public  Date getDate(int columnIndex, Calendar calendar)      Returns the value of the specified column as a java.sql.Date using a specified timezone. public  Date getDate(String columnName, Calendar calendar)      Returns the value of the specified column as a java.sql.Date using a specified timezone. public  double getDouble(int columnIndex)      Returns the value of the specified column as a double. public  double getDouble(String columnName)      Returns the value of the specified column as a double. public  int getFetchDirection()      Gets the fetch direction. public  int getFetchSize()      Gets the number of rows suggested to read in one step. public  float getFloat(int columnIndex)      Returns the value of the specified column as a float. public  float getFloat(String columnName)      Returns the value of the specified column as a float. public  int getHoldability()      Returns the current result set holdability. public  int getInt(int columnIndex)      Returns the value of the specified column as an int. public  int getInt(String columnName)      Returns the value of the specified column as an int. public  long getLong(int columnIndex)      Returns the value of the specified column as a long. public  long getLong(String columnName)      Returns the value of the specified column as a long. public  ResultSetMetaData getMetaData()      Gets the meta data of this result set. public  Reader getNCharacterStream(int columnIndex)      Returns the value of the specified column as input stream. public  Reader getNCharacterStream(String columnName)      Returns the value of the specified column as input stream. public  String getNString(int columnIndex)      Returns the value of the specified column as a String. public  String getNString(String columnName)      Returns the value of the specified column as a String. public  Object getObject(int columnIndex)      Returns a column value as a Java object. public  Object getObject(String columnName)      Returns a column value as a Java object. public  Object getObject(int columnIndex, Map map)      [Not supported] Gets a column as a object using the specified type mapping. public  Object getObject(String columnName, Map map)      [Not supported] Gets a column as a object using the specified type mapping. public  Ref getRef(int columnIndex)      [Not supported] Gets a column as a reference. public  Ref getRef(String columnName)      [Not supported] Gets a column as a reference. public  int getRow()      Gets the current row number. public  short getShort(int columnIndex)      Returns the value of the specified column as a short. public  short getShort(String columnName)      Returns the value of the specified column as a short. public  Statement getStatement()      Returns the statement that created this object. public  String getString(int columnIndex)      Returns the value of the specified column as a String. public  String getString(String columnName)      Returns the value of the specified column as a String. public  Time getTime(int columnIndex)      Returns the value of the specified column as a java.sql.Time. public  Time getTime(String columnName)      Returns the value of the specified column as a java.sql.Time. public  Time getTime(int columnIndex, Calendar calendar)      Returns the value of the specified column as a java.sql.Time using a specified timezone. public  Time getTime(String columnName, Calendar calendar)      Returns the value of the specified column as a java.sql.Time using a specified timezone. public  Timestamp getTimestamp(int columnIndex)      Returns the value of the specified column as a java.sql.Timestamp. public  Timestamp getTimestamp(String columnName)      Returns the value of the specified column as a java.sql.Timestamp. public  Timestamp getTimestamp(int columnIndex, Calendar calendar)      Returns the value of the specified column as a java.sql.Timestamp using a specified timezone. public  Timestamp getTimestamp(String columnName, Calendar calendar)      Returns the value of the specified column as a java.sql.Timestamp. public  int getTraceId()      public  int getType()      Get the result set type. public  URL getURL(int columnIndex)      public  URL getURL(String columnName)      public  InputStream getUnicodeStream(int columnIndex)      public  InputStream getUnicodeStream(String columnName)      public  SQLWarning getWarnings()      Gets the first warning reported by calls on this object. public  void insertRow()      Inserts the current row. public  boolean isAfterLast()      Checks if the current position is after the last row, that means next() was called and returned false. public  boolean isBeforeFirst()      Checks if the current position is before the first row, that means next() was not called yet. public  boolean isClosed()      Returns whether this result set is closed. public  boolean isFirst()      Checks if the current position is row 1, that means next() was called once and returned true. public  boolean isLast()      Checks if the current position is the last row, that means next() was called and did not yet returned false, but will in the next call. public  boolean last()      Moves the current position to the last row. public  void moveToCurrentRow()      Moves the current position to the current row. public  void moveToInsertRow()      Moves the current position to the insert row. public  boolean next()      Moves the cursor to the next row of the result set. public  boolean previous()      Moves the cursor to the last row, or row before first row if the current position is the first row. public  void refreshRow()      Re-reads the current row from the database. public  boolean relative(int rowCount)      Moves the current position to a specific row relative to the current row. Parameters:   rowCount - 0 means don't do anything, 1 is the next row, -1 theprevious. public  boolean rowDeleted()      Detects if the row was deleted (by somebody else or the caller). public  boolean rowInserted()      Detects if the row was inserted. public  boolean rowUpdated()      Detects if the row was updated (by somebody else or the caller). public  void setFetchDirection(int direction)      Sets (changes) the fetch direction for this result set. public  void setFetchSize(int rowCount)      Sets the number of rows suggested to read in one step. public  String toString()      public  void updateArray(int columnIndex, Array x)      public  void updateArray(String columnName, Array x)      public  void updateAsciiStream(int columnIndex, InputStream x, int length)      Updates a column in the current or insert row. public  void updateAsciiStream(int columnIndex, InputStream x)      Updates a column in the current or insert row. public  void updateAsciiStream(int columnIndex, InputStream x, long length)      Updates a column in the current or insert row. public  void updateAsciiStream(String columnName, InputStream x, int length)      Updates a column in the current or insert row. public  void updateAsciiStream(String columnName, InputStream x)      Updates a column in the current or insert row. public  void updateAsciiStream(String columnName, InputStream x, long length)      Updates a column in the current or insert row. public  void updateBigDecimal(int columnIndex, BigDecimal x)      Updates a column in the current or insert row. public  void updateBigDecimal(String columnName, BigDecimal x)      Updates a column in the current or insert row. public  void updateBinaryStream(int columnIndex, InputStream x, int length)      Updates a column in the current or insert row. public  void updateBinaryStream(int columnIndex, InputStream x)      Updates a column in the current or insert row. public  void updateBinaryStream(int columnIndex, InputStream x, long length)      Updates a column in the current or insert row. public  void updateBinaryStream(String columnName, InputStream x)      Updates a column in the current or insert row. public  void updateBinaryStream(String columnName, InputStream x, int length)      Updates a column in the current or insert row. public  void updateBinaryStream(String columnName, InputStream x, long length)      Updates a column in the current or insert row. public  void updateBlob(int columnIndex, InputStream x)      Updates a column in the current or insert row. public  void updateBlob(int columnIndex, InputStream x, long length)      Updates a column in the current or insert row. public  void updateBlob(int columnIndex, Blob x)      Updates a column in the current or insert row. public  void updateBlob(String columnName, Blob x)      Updates a column in the current or insert row. public  void updateBlob(String columnName, InputStream x)      Updates a column in the current or insert row. public  void updateBlob(String columnName, InputStream x, long length)      Updates a column in the current or insert row. public  void updateBoolean(int columnIndex, boolean x)      Updates a column in the current or insert row. public  void updateBoolean(String columnName, boolean x)      Updates a column in the current or insert row. public  void updateByte(int columnIndex, byte x)      Updates a column in the current or insert row. public  void updateByte(String columnName, byte x)      Updates a column in the current or insert row. public  void updateBytes(int columnIndex, byte[] x)      Updates a column in the current or insert row. public  void updateBytes(String columnName, byte[] x)      Updates a column in the current or insert row. public  void updateCharacterStream(int columnIndex, Reader x, long length)      Updates a column in the current or insert row. public  void updateCharacterStream(int columnIndex, Reader x, int length)      Updates a column in the current or insert row. public  void updateCharacterStream(int columnIndex, Reader x)      Updates a column in the current or insert row. public  void updateCharacterStream(String columnName, Reader x, int length)      Updates a column in the current or insert row. public  void updateCharacterStream(String columnName, Reader x)      Updates a column in the current or insert row. public  void updateCharacterStream(String columnName, Reader x, long length)      Updates a column in the current or insert row. public  void updateClob(int columnIndex, Clob x)      Updates a column in the current or insert row. public  void updateClob(int columnIndex, Reader x)      Updates a column in the current or insert row. public  void updateClob(int columnIndex, Reader x, long length)      Updates a column in the current or insert row. public  void updateClob(String columnName, Clob x)      Updates a column in the current or insert row. public  void updateClob(String columnName, Reader x)      Updates a column in the current or insert row. public  void updateClob(String columnName, Reader x, long length)      Updates a column in the current or insert row. public  void updateDate(int columnIndex, Date x)      Updates a column in the current or insert row. public  void updateDate(String columnName, Date x)      Updates a column in the current or insert row. public  void updateDouble(int columnIndex, double x)      Updates a column in the current or insert row. public  void updateDouble(String columnName, double x)      Updates a column in the current or insert row. public  void updateFloat(int columnIndex, float x)      Updates a column in the current or insert row. public  void updateFloat(String columnName, float x)      Updates a column in the current or insert row. public  void updateInt(int columnIndex, int x)      Updates a column in the current or insert row. public  void updateInt(String columnName, int x)      Updates a column in the current or insert row. public  void updateLong(int columnIndex, long x)      Updates a column in the current or insert row. public  void updateLong(String columnName, long x)      Updates a column in the current or insert row. public  void updateNCharacterStream(int columnIndex, Reader x, int length)      Updates a column in the current or insert row. public  void updateNCharacterStream(int columnIndex, Reader x)      Updates a column in the current or insert row. public  void updateNCharacterStream(int columnIndex, Reader x, long length)      Updates a column in the current or insert row. public  void updateNCharacterStream(String columnName, Reader x, int length)      Updates a column in the current or insert row. public  void updateNCharacterStream(String columnName, Reader x)      Updates a column in the current or insert row. public  void updateNCharacterStream(String columnName, Reader x, long length)      Updates a column in the current or insert row. public  void updateNString(int columnIndex, String x)      Updates a column in the current or insert row. public  void updateNString(String columnName, String x)      Updates a column in the current or insert row. public  void updateNull(int columnIndex)      Updates a column in the current or insert row. public  void updateNull(String columnName)      Updates a column in the current or insert row. public  void updateObject(int columnIndex, Object x, int scale)      Updates a column in the current or insert row. public  void updateObject(String columnName, Object x, int scale)      Updates a column in the current or insert row. public  void updateObject(int columnIndex, Object x)      Updates a column in the current or insert row. public  void updateObject(String columnName, Object x)      Updates a column in the current or insert row. public  void updateRef(int columnIndex, Ref x)      public  void updateRef(String columnName, Ref x)      public  void updateRow()      Updates the current row. public  void updateShort(int columnIndex, short x)      Updates a column in the current or insert row. public  void updateShort(String columnName, short x)      Updates a column in the current or insert row. public  void updateString(int columnIndex, String x)      Updates a column in the current or insert row. public  void updateString(String columnName, String x)      Updates a column in the current or insert row. public  void updateTime(int columnIndex, Time x)      Updates a column in the current or insert row. public  void updateTime(String columnName, Time x)      Updates a column in the current or insert row. public  void updateTimestamp(int columnIndex, Timestamp x)      Updates a column in the current or insert row. public  void updateTimestamp(String columnName, Timestamp x)      Updates a column in the current or insert row. public  boolean wasNull()      Returns whether the last column accessed was a null value. Constructor Detail JdbcResultSet JdbcResultSet(SessionInterface session, JdbcConnection conn, JdbcStatement stat, ResultInterface result, int id, boolean closeStatement, boolean scrollable)(Code) Method Detail absolute public boolean absolute(int rowNumber) throws SQLException(Code) Moves the current position to a specific row. Parameters:   rowNumber - the row number. 0 is not allowed, 1 means the first row,2 the second. -1 means the last row, -2 the row before thelast row. If the value is too large, the position is movedafter the last row, if if the value is too small it is movedbefore the first row. true if there is a row available, false if not throws:   SQLException - if the result set is closed afterLast public void afterLast() throws SQLException(Code) Moves the current position to after the last row, that means after the end. throws:   SQLException - if the result set is closed beforeFirst public void beforeFirst() throws SQLException(Code) Moves the current position to before the first row, that means resets the result set. throws:   SQLException - if the result set is closed cancelRowUpdates public void cancelRowUpdates() throws SQLException(Code) Cancels updating a row. throws:   SQLException - if the result set is closed or if the current row isthe insert row checkClosed void checkClosed() throws SQLException(Code) clearWarnings public void clearWarnings() throws SQLException(Code) Clears all warnings. close public void close() throws SQLException(Code) Closes the result set. closeInternal void closeInternal() throws SQLException(Code) deleteRow public void deleteRow() throws SQLException(Code) Deletes the current row. throws:   SQLException - if the result set is closed or if the current row isthe insert row or if not on a valid row findColumn public int findColumn(String columnName) throws SQLException(Code) Searches for a specific column in the result set. A case-insensitive search is made. Parameters:   columnName - the name of the column label the column index (1,2,...) throws:   SQLException - if the column is not found or if the result set isclosed first public boolean first() throws SQLException(Code) Moves the current position to the first row. This is the same as calling beforeFirst() followed by next(). true if there is a row available, false if not throws:   SQLException - if the result set is closed getArray public Array getArray(int columnIndex) throws SQLException(Code) Returns the value of the specified column as an Array. Parameters:   columnIndex - (1,2,...) the value throws:   SQLException - if the column is not found or if the result set isclosed getArray public Array getArray(String columnName) throws SQLException(Code) Returns the value of the specified column as an Array. Parameters:   columnName - the name of the column label the value throws:   SQLException - if the column is not found or if the result set isclosed getAsciiStream public InputStream getAsciiStream(int columnIndex) throws SQLException(Code) Returns the value of the specified column as input stream. Parameters:   columnIndex - (1,2,...) the value throws:   SQLException - if the column is not found or if the result set isclosed getAsciiStream public InputStream getAsciiStream(String columnName) throws SQLException(Code) Returns the value of the specified column as input stream. Parameters:   columnName - the name of the column label the value throws:   SQLException - if the column is not found or if the result set isclosed getBigDecimal public BigDecimal getBigDecimal(int columnIndex) throws SQLException(Code) Returns the value of the specified column as a String. Parameters:   columnIndex - (1,2,...) the value throws:   SQLException - if the column is not found or if the result set is closed getBigDecimal public BigDecimal getBigDecimal(String columnName) throws SQLException(Code) Returns the value of the specified column as a String. Parameters:   columnName - the name of the column label the value throws:   SQLException - if the column is not found or if the result set is closed getBigDecimal public BigDecimal getBigDecimal(String columnName, int scale) throws SQLException(Code) Returns the value of the specified column as a String. Parameters:   columnName - the value throws:   SQLException - if the column is not found or if the result set isclosed getBigDecimal public BigDecimal getBigDecimal(int columnIndex, int scale) throws SQLException(Code) Returns the value of the specified column as a String. Parameters:   columnIndex - (1,2,...) the value throws:   SQLException - if the column is not found or if the result set isclosed getBinaryStream public InputStream getBinaryStream(int columnIndex) throws SQLException(Code) Returns the value of the specified column as input stream. Parameters:   columnIndex - (1,2,...) the value throws:   SQLException - if the column is not found or if the result set isclosed getBinaryStream public InputStream getBinaryStream(String columnName) throws SQLException(Code) Returns the value of the specified column as input stream. Parameters:   columnName - the name of the column label the value throws:   SQLException - if the column is not found or if the result set isclosed getBlob public Blob getBlob(int columnIndex) throws SQLException(Code) Returns the value of the specified column as a Blob. Parameters:   columnIndex - (1,2,...) the value throws:   SQLException - if the column is not found or if the result set isclosed getBlob public Blob getBlob(String columnName) throws SQLException(Code) Returns the value of the specified column as a Blob. Parameters:   columnName - the name of the column label the value throws:   SQLException - if the column is not found or if the result set isclosed getBoolean public boolean getBoolean(int columnIndex) throws SQLException(Code) Returns the value of the specified column as a boolean. Parameters:   columnIndex - (1,2,...) the value throws:   SQLException - if the column is not found or if the result set isclosed getBoolean public boolean getBoolean(String columnName) throws SQLException(Code) Returns the value of the specified column as a boolean. Parameters:   columnName - the name of the column label the value throws:   SQLException - if the column is not found or if the result set isclosed getByte public byte getByte(int columnIndex) throws SQLException(Code) Returns the value of the specified column as a byte. Parameters:   columnIndex - (1,2,...) the value throws:   SQLException - if the column is not found or if the result set isclosed getByte public byte getByte(String columnName) throws SQLException(Code) Returns the value of the specified column as a byte. Parameters:   columnName - the name of the column label the value throws:   SQLException - if the column is not found or if the result set isclosed getBytes public byte[] getBytes(int columnIndex) throws SQLException(Code) Returns the value of the specified column as a byte array. Parameters:   columnIndex - (1,2,...) the value throws:   SQLException - if the column is not found or if the result set isclosed getBytes public byte[] getBytes(String columnName) throws SQLException(Code) Returns the value of the specified column as a byte array. Parameters:   columnName - the name of the column label the value throws:   SQLException - if the column is not found or if the result set isclosed getCharacterStream public Reader getCharacterStream(int columnIndex) throws SQLException(Code) Returns the value of the specified column as input stream. Parameters:   columnIndex - (1,2,...) the value throws:   SQLException - if the column is not found or if the result set isclosed getCharacterStream public Reader getCharacterStream(String columnName) throws SQLException(Code) Returns the value of the specified column as input stream. Parameters:   columnName - the name of the column label the value throws:   SQLException - if the column is not found or if the result set isclosed getClob public Clob getClob(int columnIndex) throws SQLException(Code) Returns the value of the specified column as a Clob. Parameters:   columnIndex - (1,2,...) the value throws:   SQLException - if the column is not found or if the result set isclosed getClob public Clob getClob(String columnName) throws SQLException(Code) Returns the value of the specified column as a Clob. Parameters:   columnName - the name of the column label the value throws:   SQLException - if the column is not found or if the result set isclosed getColumnIndex int getColumnIndex(String columnName) throws SQLException(Code) getConcurrency public int getConcurrency() throws SQLException(Code) Gets the result set concurrency. ResultSet.CONCUR_UPDATABLE getCursorName public String getCursorName() throws SQLException(Code) [Not supported] Gets the cursor name if it was defined. This feature is superseded by updateX methods. This method throws a SQLException because cursor names are not supported. getDate public Date getDate(int columnIndex) throws SQLException(Code) Returns the value of the specified column as a java.sql.Date. Parameters:   columnIndex - (1,2,...) the value throws:   SQLException - if the column is not found or if the result set is closed getDate public Date getDate(String columnName) throws SQLException(Code) Returns the value of the specified column as a java.sql.Date. Parameters:   columnName - the name of the column label the value throws:   SQLException - if the column is not found or if the result set is closed getDate public Date getDate(int columnIndex, Calendar calendar) throws SQLException(Code) Returns the value of the specified column as a java.sql.Date using a specified timezone. Parameters:   columnIndex - (1,2,...) Parameters:   calendar - the calendar the value throws:   SQLException - if the column is not found or if the result set isclosed getDate public Date getDate(String columnName, Calendar calendar) throws SQLException(Code) Returns the value of the specified column as a java.sql.Date using a specified timezone. Parameters:   columnName - the name of the column label Parameters:   calendar - the calendar the value throws:   SQLException - if the column is not found or if the result set isclosed getDouble public double getDouble(int columnIndex) throws SQLException(Code) Returns the value of the specified column as a double. Parameters:   columnIndex - (1,2,...) the value throws:   SQLException - if the column is not found or if the result set isclosed getDouble public double getDouble(String columnName) throws SQLException(Code) Returns the value of the specified column as a double. Parameters:   columnName - the name of the column label the value throws:   SQLException - if the column is not found or if the result set isclosed getFetchDirection public int getFetchDirection() throws SQLException(Code) Gets the fetch direction. the direction: FETCH_FORWARD getFetchSize public int getFetchSize() throws SQLException(Code) Gets the number of rows suggested to read in one step. the current fetch size getFloat public float getFloat(int columnIndex) throws SQLException(Code) Returns the value of the specified column as a float. Parameters:   columnIndex - (1,2,...) the value throws:   SQLException - if the column is not found or if the result set isclosed getFloat public float getFloat(String columnName) throws SQLException(Code) Returns the value of the specified column as a float. Parameters:   columnName - the name of the column label the value throws:   SQLException - if the column is not found or if the result set isclosed getHoldability public int getHoldability() throws SQLException(Code) Returns the current result set holdability. the holdability throws:   SQLException - if the connection is closed getInt public int getInt(int columnIndex) throws SQLException(Code) Returns the value of the specified column as an int. Parameters:   columnIndex - (1,2,...) the value throws:   SQLException - if the column is not found or if the result set is closed getInt public int getInt(String columnName) throws SQLException(Code) Returns the value of the specified column as an int. Parameters:   columnName - the name of the column label the value throws:   SQLException - if the column is not found or if the result set is closed getLong public long getLong(int columnIndex) throws SQLException(Code) Returns the value of the specified column as a long. Parameters:   columnIndex - (1,2,...) the value throws:   SQLException - if the column is not found or if the result set isclosed getLong public long getLong(String columnName) throws SQLException(Code) Returns the value of the specified column as a long. Parameters:   columnName - the name of the column label the value throws:   SQLException - if the column is not found or if the result set isclosed getMetaData public ResultSetMetaData getMetaData() throws SQLException(Code) Gets the meta data of this result set. the meta data getNCharacterStream public Reader getNCharacterStream(int columnIndex) throws SQLException(Code) Returns the value of the specified column as input stream. Parameters:   columnIndex - (1,2,...) the value throws:   SQLException - if the column is not found or if the result set isclosed getNCharacterStream public Reader getNCharacterStream(String columnName) throws SQLException(Code) Returns the value of the specified column as input stream. Parameters:   columnName - the name of the column label the value throws:   SQLException - if the column is not found or if the result set isclosed getNString public String getNString(int columnIndex) throws SQLException(Code) Returns the value of the specified column as a String. Parameters:   columnIndex - (1,2,...) the value throws:   SQLException - if the column is not found or if the result set isclosed getNString public String getNString(String columnName) throws SQLException(Code) Returns the value of the specified column as a String. Parameters:   columnName - the value throws:   SQLException - if the column is not found or if the result set isclosed getObject public Object getObject(int columnIndex) throws SQLException(Code) Returns a column value as a Java object. For BINARY data, the data is de-serialized into a Java Object. Parameters:   columnIndex - (1,2,...) the value or null throws:   SQLException - if the column is not found or if the result set isclosed getObject public Object getObject(String columnName) throws SQLException(Code) Returns a column value as a Java object. For BINARY data, the data is de-serialized into a Java Object. Parameters:   columnName - the name of the column label the value or null throws:   SQLException - if the column is not found or if the result set isclosed getObject public Object getObject(int columnIndex, Map map) throws SQLException(Code) [Not supported] Gets a column as a object using the specified type mapping. getObject public Object getObject(String columnName, Map map) throws SQLException(Code) [Not supported] Gets a column as a object using the specified type mapping. getRef public Ref getRef(int columnIndex) throws SQLException(Code) [Not supported] Gets a column as a reference. getRef public Ref getRef(String columnName) throws SQLException(Code) [Not supported] Gets a column as a reference. getRow public int getRow() throws SQLException(Code) Gets the current row number. The first row is row 1, the second 2 and so on. This method returns 0 before the first and after the last row. the row number getShort public short getShort(int columnIndex) throws SQLException(Code) Returns the value of the specified column as a short. Parameters:   columnIndex - (1,2,...) the value throws:   SQLException - if the column is not found or if the result set isclosed getShort public short getShort(String columnName) throws SQLException(Code) Returns the value of the specified column as a short. Parameters:   columnName - the name of the column label the value throws:   SQLException - if the column is not found or if the result set isclosed getStatement public Statement getStatement() throws SQLException(Code) Returns the statement that created this object. the statement or prepared statement, or null if created by aDatabaseMetaData call. getString public String getString(int columnIndex) throws SQLException(Code) Returns the value of the specified column as a String. Parameters:   columnIndex - (1,2,...) the value throws:   SQLException - if the column is not found or if the result set is closed getString public String getString(String columnName) throws SQLException(Code) Returns the value of the specified column as a String. Parameters:   columnName - the name of the column label the value throws:   SQLException - if the column is not found or if the result set is closed getTime public Time getTime(int columnIndex) throws SQLException(Code) Returns the value of the specified column as a java.sql.Time. Parameters:   columnIndex - (1,2,...) the value throws:   SQLException - if the column is not found or if the result set is closed getTime public Time getTime(String columnName) throws SQLException(Code) Returns the value of the specified column as a java.sql.Time. Parameters:   columnName - the name of the column label the value throws:   SQLException - if the column is not found or if the result set is closed getTime public Time getTime(int columnIndex, Calendar calendar) throws SQLException(Code) Returns the value of the specified column as a java.sql.Time using a specified timezone. Parameters:   columnIndex - (1,2,...) Parameters:   calendar - the calendar the value throws:   SQLException - if the column is not found or if the result set isclosed getTime public Time getTime(String columnName, Calendar calendar) throws SQLException(Code) Returns the value of the specified column as a java.sql.Time using a specified timezone. Parameters:   columnName - the name of the column label Parameters:   calendar - the calendar the value throws:   SQLException - if the column is not found or if the result set isclosed getTimestamp public Timestamp getTimestamp(int columnIndex) throws SQLException(Code) Returns the value of the specified column as a java.sql.Timestamp. Parameters:   columnIndex - (1,2,...) the value throws:   SQLException - if the column is not found or if the result set is closed getTimestamp public Timestamp getTimestamp(String columnName) throws SQLException(Code) Returns the value of the specified column as a java.sql.Timestamp. Parameters:   columnName - the name of the column label the value throws:   SQLException - if the column is not found or if the result set is closed getTimestamp public Timestamp getTimestamp(int columnIndex, Calendar calendar) throws SQLException(Code) Returns the value of the specified column as a java.sql.Timestamp using a specified timezone. Parameters:   columnIndex - (1,2,...) Parameters:   calendar - the calendar the value throws:   SQLException - if the column is not found or if the result set isclosed getTimestamp public Timestamp getTimestamp(String columnName, Calendar calendar) throws SQLException(Code) Returns the value of the specified column as a java.sql.Timestamp. Parameters:   columnName - the name of the column label Parameters:   calendar - the calendar the value throws:   SQLException - if the column is not found or if the result set isclosed getTraceId public int getTraceId()(Code) INTERNAL getType public int getType() throws SQLException(Code) Get the result set type. the result set type (TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVEor TYPE_SCROLL_SENSITIVE) throws:   SQLException - if the column is not found or if the result set isclosed getURL public URL getURL(int columnIndex) throws SQLException(Code) [Not supported] getURL public URL getURL(String columnName) throws SQLException(Code) [Not supported] getUnicodeStream public InputStream getUnicodeStream(int columnIndex) throws SQLException(Code) [Not supported] getUnicodeStream public InputStream getUnicodeStream(String columnName) throws SQLException(Code) [Not supported] getWarnings public SQLWarning getWarnings() throws SQLException(Code) Gets the first warning reported by calls on this object. null insertRow public void insertRow() throws SQLException(Code) Inserts the current row. The current position must be the insert row. throws:   SQLException - if the result set is closed or if not on the insert row isAfterLast public boolean isAfterLast() throws SQLException(Code) Checks if the current position is after the last row, that means next() was called and returned false. if the current position is after the last row throws:   SQLException - if the result set is closed isBeforeFirst public boolean isBeforeFirst() throws SQLException(Code) Checks if the current position is before the first row, that means next() was not called yet. if the current position is before the first row throws:   SQLException - if the result set is closed isClosed public boolean isClosed() throws SQLException(Code) Returns whether this result set is closed. true if the result set is closed isFirst public boolean isFirst() throws SQLException(Code) Checks if the current position is row 1, that means next() was called once and returned true. if the current position is the first row throws:   SQLException - if the result set is closed isLast public boolean isLast() throws SQLException(Code) Checks if the current position is the last row, that means next() was called and did not yet returned false, but will in the next call. if the current position is the last row throws:   SQLException - if the result set is closed last public boolean last() throws SQLException(Code) Moves the current position to the last row. true if there is a row available, false if not throws:   SQLException - if the result set is closed moveToCurrentRow public void moveToCurrentRow() throws SQLException(Code) Moves the current position to the current row. throws:   SQLException - if the result set is closed moveToInsertRow public void moveToInsertRow() throws SQLException(Code) Moves the current position to the insert row. The current row is remembered. throws:   SQLException - if the result set is closed next public boolean next() throws SQLException(Code) Moves the cursor to the next row of the result set. true if successful, false if there are no more rows previous public boolean previous() throws SQLException(Code) Moves the cursor to the last row, or row before first row if the current position is the first row. true if there is a row available, false if not throws:   SQLException - if the result set is closed refreshRow public void refreshRow() throws SQLException(Code) Re-reads the current row from the database. throws:   SQLException - if the result set is closed or if the current row isthe insert row or if the row has been deleted or if not on avalid row relative public boolean relative(int rowCount) throws SQLException(Code) Moves the current position to a specific row relative to the current row. Parameters:   rowCount - 0 means don't do anything, 1 is the next row, -1 theprevious. If the value is too large, the position is movedafter the last row, if if the value is too small it is movedbefore the first row. true if there is a row available, false if not throws:   SQLException - if the result set is closed rowDeleted public boolean rowDeleted() throws SQLException(Code) Detects if the row was deleted (by somebody else or the caller). false because this driver does not detect this rowInserted public boolean rowInserted() throws SQLException(Code) Detects if the row was inserted. false because this driver does not detect this rowUpdated public boolean rowUpdated() throws SQLException(Code) Detects if the row was updated (by somebody else or the caller). false because this driver does not detect this setFetchDirection public void setFetchDirection(int direction) throws SQLException(Code) Sets (changes) the fetch direction for this result set. This method should only be called for scrollable result sets, otherwise it will throw an exception (no matter what direction is used). Parameters:   direction - the new fetch direction throws:   SQLException - Unsupported Feature if the method is called for aforward-only result set setFetchSize public void setFetchSize(int rowCount) throws SQLException(Code) Sets the number of rows suggested to read in one step. This value cannot be higher than the maximum rows (setMaxRows) set by the statement or prepared statement, otherwise an exception is throws. Parameters:   rowCount - the number of rows toString public String toString()(Code) INTERNAL updateArray public void updateArray(int columnIndex, Array x) throws SQLException(Code) [Not supported] updateArray public void updateArray(String columnName, Array x) throws SQLException(Code) [Not supported] updateAsciiStream public void updateAsciiStream(int columnIndex, InputStream x, int length) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value Parameters:   length - the number of characters throws:   SQLException - if the result set is closed updateAsciiStream public void updateAsciiStream(int columnIndex, InputStream x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value throws:   SQLException - if the result set is closed updateAsciiStream public void updateAsciiStream(int columnIndex, InputStream x, long length) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value Parameters:   length - the number of characters throws:   SQLException - if the result set is closed updateAsciiStream public void updateAsciiStream(String columnName, InputStream x, int length) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value Parameters:   length - the number of characters throws:   SQLException - if the result set is closed updateAsciiStream public void updateAsciiStream(String columnName, InputStream x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value throws:   SQLException - if the result set is closed updateAsciiStream public void updateAsciiStream(String columnName, InputStream x, long length) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value Parameters:   length - the number of characters throws:   SQLException - if the result set is closed updateBigDecimal public void updateBigDecimal(int columnIndex, BigDecimal x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value throws:   SQLException - if the result set is closed updateBigDecimal public void updateBigDecimal(String columnName, BigDecimal x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value throws:   SQLException - if the result set is closed updateBinaryStream public void updateBinaryStream(int columnIndex, InputStream x, int length) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value Parameters:   length - the number of characters throws:   SQLException - if the result set is closed updateBinaryStream public void updateBinaryStream(int columnIndex, InputStream x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value throws:   SQLException - if the result set is closed updateBinaryStream public void updateBinaryStream(int columnIndex, InputStream x, long length) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value Parameters:   length - the number of characters throws:   SQLException - if the result set is closed updateBinaryStream public void updateBinaryStream(String columnName, InputStream x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value throws:   SQLException - if the result set is closed updateBinaryStream public void updateBinaryStream(String columnName, InputStream x, int length) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value Parameters:   length - the number of characters throws:   SQLException - if the result set is closed updateBinaryStream public void updateBinaryStream(String columnName, InputStream x, long length) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value Parameters:   length - the number of characters throws:   SQLException - if the result set is closed updateBlob public void updateBlob(int columnIndex, InputStream x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value throws:   SQLException - if the result set is closed updateBlob public void updateBlob(int columnIndex, InputStream x, long length) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value Parameters:   length - the length throws:   SQLException - if the result set is closed updateBlob public void updateBlob(int columnIndex, Blob x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value throws:   SQLException - if the result set is closed updateBlob public void updateBlob(String columnName, Blob x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value throws:   SQLException - if the result set is closed updateBlob public void updateBlob(String columnName, InputStream x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value throws:   SQLException - if the result set is closed updateBlob public void updateBlob(String columnName, InputStream x, long length) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value Parameters:   length - the length throws:   SQLException - if the result set is closed updateBoolean public void updateBoolean(int columnIndex, boolean x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value throws:   SQLException - if the result set is closed updateBoolean public void updateBoolean(String columnName, boolean x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value throws:   SQLException - if result set is closed updateByte public void updateByte(int columnIndex, byte x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value throws:   SQLException - if the result set is closed updateByte public void updateByte(String columnName, byte x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value throws:   SQLException - if the result set is closed updateBytes public void updateBytes(int columnIndex, byte[] x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value throws:   SQLException - if the result set is closed updateBytes public void updateBytes(String columnName, byte[] x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value throws:   SQLException - if the result set is closed updateCharacterStream public void updateCharacterStream(int columnIndex, Reader x, long length) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value Parameters:   length - the number of characters throws:   SQLException - if the result set is closed updateCharacterStream public void updateCharacterStream(int columnIndex, Reader x, int length) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value Parameters:   length - the number of characters throws:   SQLException - if the result set is closed updateCharacterStream public void updateCharacterStream(int columnIndex, Reader x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value throws:   SQLException - if the result set is closed updateCharacterStream public void updateCharacterStream(String columnName, Reader x, int length) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value Parameters:   length - the number of characters throws:   SQLException - if the result set is closed updateCharacterStream public void updateCharacterStream(String columnName, Reader x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value throws:   SQLException - if the result set is closed updateCharacterStream public void updateCharacterStream(String columnName, Reader x, long length) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value Parameters:   length - the number of characters throws:   SQLException - if the result set is closed updateClob public void updateClob(int columnIndex, Clob x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value throws:   SQLException - if the result set is closed updateClob public void updateClob(int columnIndex, Reader x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value throws:   SQLException - if the result set is closed updateClob public void updateClob(int columnIndex, Reader x, long length) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value Parameters:   length - the length throws:   SQLException - if the result set is closed updateClob public void updateClob(String columnName, Clob x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value throws:   SQLException - if the result set is closed updateClob public void updateClob(String columnName, Reader x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value throws:   SQLException - if the result set is closed updateClob public void updateClob(String columnName, Reader x, long length) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value Parameters:   length - the length throws:   SQLException - if the result set is closed updateDate public void updateDate(int columnIndex, Date x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value throws:   SQLException - if the result set is closed updateDate public void updateDate(String columnName, Date x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value throws:   SQLException - if the result set is closed updateDouble public void updateDouble(int columnIndex, double x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value throws:   SQLException - if the result set is closed updateDouble public void updateDouble(String columnName, double x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value throws:   SQLException - if the result set is closed updateFloat public void updateFloat(int columnIndex, float x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value throws:   SQLException - if the result set is closed updateFloat public void updateFloat(String columnName, float x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value throws:   SQLException - if the result set is closed updateInt public void updateInt(int columnIndex, int x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value throws:   SQLException - if the result set is closed updateInt public void updateInt(String columnName, int x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value throws:   SQLException - if the result set is closed updateLong public void updateLong(int columnIndex, long x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value throws:   SQLException - if the result set is closed updateLong public void updateLong(String columnName, long x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value throws:   SQLException - if the result set is closed updateNCharacterStream public void updateNCharacterStream(int columnIndex, Reader x, int length) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value Parameters:   length - the number of characters throws:   SQLException - if the result set is closed updateNCharacterStream public void updateNCharacterStream(int columnIndex, Reader x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value throws:   SQLException - if the result set is closed updateNCharacterStream public void updateNCharacterStream(int columnIndex, Reader x, long length) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value Parameters:   length - the number of characters throws:   SQLException - if the result set is closed updateNCharacterStream public void updateNCharacterStream(String columnName, Reader x, int length) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value Parameters:   length - the number of characters throws:   SQLException - if the result set is closed updateNCharacterStream public void updateNCharacterStream(String columnName, Reader x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value throws:   SQLException - if the result set is closed updateNCharacterStream public void updateNCharacterStream(String columnName, Reader x, long length) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value Parameters:   length - the number of characters throws:   SQLException - if the result set is closed updateNString public void updateNString(int columnIndex, String x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value throws:   SQLException - if the result set is closed updateNString public void updateNString(String columnName, String x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value throws:   SQLException - if the result set is closed updateNull public void updateNull(int columnIndex) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) throws:   SQLException - if the result set is closed updateNull public void updateNull(String columnName) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label throws:   SQLException - if the result set is closed updateObject public void updateObject(int columnIndex, Object x, int scale) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value Parameters:   scale - is ignored throws:   SQLException - if the result set is closed updateObject public void updateObject(String columnName, Object x, int scale) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value Parameters:   scale - is ignored throws:   SQLException - if the result set is closed updateObject public void updateObject(int columnIndex, Object x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value throws:   SQLException - if the result set is closed updateObject public void updateObject(String columnName, Object x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value throws:   SQLException - if the result set is closed updateRef public void updateRef(int columnIndex, Ref x) throws SQLException(Code) [Not supported] updateRef public void updateRef(String columnName, Ref x) throws SQLException(Code) [Not supported] updateRow public void updateRow() throws SQLException(Code) Updates the current row. throws:   SQLException - if the result set is closed or if the current row isthe insert row or if not on a valid row updateShort public void updateShort(int columnIndex, short x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value throws:   SQLException - if the result set is closed updateShort public void updateShort(String columnName, short x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value throws:   SQLException - if the result set is closed updateString public void updateString(int columnIndex, String x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value throws:   SQLException - if the result set is closed updateString public void updateString(String columnName, String x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value throws:   SQLException - if the result set is closed updateTime public void updateTime(int columnIndex, Time x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value throws:   SQLException - if the result set is closed updateTime public void updateTime(String columnName, Time x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value throws:   SQLException - if the result set is closed updateTimestamp public void updateTimestamp(int columnIndex, Timestamp x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnIndex - (1,2,...) Parameters:   x - the value throws:   SQLException - if the result set is closed updateTimestamp public void updateTimestamp(String columnName, Timestamp x) throws SQLException(Code) Updates a column in the current or insert row. Parameters:   columnName - the name of the column label Parameters:   x - the value throws:   SQLException - if the result set is closed wasNull public boolean wasNull() throws SQLException(Code) Returns whether the last column accessed was a null value. true if the last column accessed was a null value Fields inherited from org.h2.message.TraceObject final public static int CALLABLE_STATEMENTCONNECTIONDATABASE_META_DATAPREPARED_STATEMENTRESULT_SETRESULT_SET_META_DATASAVEPOINTSQL_EXCEPTIONSTATEMENTBLOBCLOBPARAMETER_META_DATA(Code)(Java Doc) final public static int DATA_SOURCEXA_DATA_SOURCEXIDARRAY(Code)(Java Doc) Methods inherited from org.h2.message.TraceObject protected boolean debug()(Code)(Java Doc) protected void debugCode(String text)(Code)(Java Doc) protected void debugCodeAssign(String className, int type, int id, String value)(Code)(Java Doc) protected void debugCodeCall(String text)(Code)(Java Doc) protected void debugCodeCall(String text, long param)(Code)(Java Doc) protected void debugCodeCall(String text, String param)(Code)(Java Doc) protected int getNextId(int type)(Code)(Java Doc) protected Trace getTrace()(Code)(Java Doc) protected int getTraceId()(Code)(Java Doc) public String getTraceObjectName()(Code)(Java Doc) protected boolean info()(Code)(Java Doc) protected SQLException logAndConvert(Throwable e)(Code)(Java Doc) protected String quote(String s)(Code)(Java Doc) protected String quoteArray(String[] s)(Code)(Java Doc) protected String quoteBigDecimal(BigDecimal x)(Code)(Java Doc) protected String quoteBytes(byte[] x)(Code)(Java Doc) protected String quoteDate(java.sql.Date x)(Code)(Java Doc) protected String quoteIntArray(int[] s)(Code)(Java Doc) protected String quoteMap(Map map)(Code)(Java Doc) protected String quoteTime(java.sql.Time x)(Code)(Java Doc) protected String quoteTimestamp(java.sql.Timestamp x)(Code)(Java Doc) protected void setTrace(Trace trace, int type, int id)(Code)(Java Doc) public static String toString(String sql, ObjectArray params)(Code)(Java Doc) Methods inherited from java.lang.Object native protected Object clone() throws CloneNotSupportedException(Code)(Java Doc) public boolean equals(Object obj)(Code)(Java Doc) protected void finalize() throws Throwable(Code)(Java Doc) final native public Class getClass()(Code)(Java Doc) native public int hashCode()(Code)(Java Doc) final native public void notify()(Code)(Java Doc) final native public void notifyAll()(Code)(Java Doc) public String toString()(Code)(Java Doc) final native public void wait(long timeout) throws InterruptedException(Code)(Java Doc) final public void wait(long timeout, int nanos) throws InterruptedException(Code)(Java Doc) final public void wait() throws InterruptedException(Code)(Java Doc)