JdbcStatement (JBoss Application Server: Build 7.1.2.Final API)

java.lang.Object
- org.h2.message.TraceObject
- - org.h2.jdbc.JdbcStatement

All Implemented Interfaces:

AutoCloseable, Statement, Wrapper

Direct Known Subclasses:

JdbcPreparedStatement
```
public class JdbcStatement
extends TraceObject
implements Statement
```
Represents a statement.

Field Summary

Fields
Modifier and Type	Field and Description
`protected boolean`	`closedByResultSet`
`protected JdbcConnection`	`conn`
`protected int`	`fetchSize`
`protected int`	`maxRows`
`protected JdbcResultSet`	`resultSet`
`protected int`	`resultSetConcurrency`
`protected int`	`resultSetType`
`protected SessionInterface`	`session`
`protected int`	`updateCount`

Fields inherited from class org.h2.message.TraceObject
ARRAY, BLOB, CALLABLE_STATEMENT, CLOB, CONNECTION, DATA_SOURCE, DATABASE_META_DATA, PARAMETER_META_DATA, PREPARED_STATEMENT, RESULT_SET, RESULT_SET_META_DATA, SAVEPOINT, SQL_EXCEPTION, STATEMENT, trace, XA_DATA_SOURCE, XA_RESOURCE, XID

Fields inherited from interface java.sql.Statement
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO

Method Summary

Methods
Modifier and Type	Method and Description
`void`	`addBatch(String sql)` Adds a statement to the batch.
`void`	`cancel()` Cancels a currently running statement.
`protected boolean`	`checkClosed(boolean write)` INTERNAL.
`void`	`clearBatch()` Clears the batch.
`void`	`clearWarnings()` Clears all warnings.
`void`	`close()` Closes this statement.
`protected void`	`closeOldResultSet()` INTERNAL.
`boolean`	`execute(String sql)` Executes an arbitrary statement.
`boolean`	`execute(String sql, int autoGeneratedKeys)` Executes a statement and returns the update count.
`boolean`	`execute(String sql, int[] columnIndexes)` Executes a statement and returns the update count.
`boolean`	`execute(String sql, String[] columnNames)` Executes a statement and returns the update count.
`int[]`	`executeBatch()` Executes the batch.
`ResultSet`	`executeQuery(String sql)` Executes a query (select statement) and returns the result set.
`int`	`executeUpdate(String sql)` Executes a statement (insert, update, delete, create, drop) and returns the update count.
`int`	`executeUpdate(String sql, int autoGeneratedKeys)` Executes a statement and returns the update count.
`int`	`executeUpdate(String sql, int[] columnIndexes)` Executes a statement and returns the update count.
`int`	`executeUpdate(String sql, String[] columnNames)` Executes a statement and returns the update count.
`Connection`	`getConnection()` Returns the connection that created this object.
`int`	`getFetchDirection()` Gets the fetch direction.
`int`	`getFetchSize()` Gets the number of rows suggested to read in one step.
`ResultSet`	`getGeneratedKeys()` Return a result set that contains the last generated auto-increment key for this connection, if there was one.
`int`	`getLastExecutedCommandType()` INTERNAL.
`int`	`getMaxFieldSize()` Gets the maximum number of bytes for a result set column.
`int`	`getMaxRows()` Gets the maximum number of rows for a ResultSet.
`boolean`	`getMoreResults()` Moves to the next result set - however there is always only one result set.
`boolean`	`getMoreResults(int current)` Move to the next result set.
`int`	`getQueryTimeout()` Gets the current query timeout in seconds.
`ResultSet`	`getResultSet()` Returns the last result set produces by this statement.
`int`	`getResultSetConcurrency()` Gets the result set concurrency created by this object.
`int`	`getResultSetHoldability()` Gets the result set holdability.
`int`	`getResultSetType()` Gets the result set type.
`int`	`getUpdateCount()` Returns the last update count of this statement.
`SQLWarning`	`getWarnings()` Gets the first warning reported by calls on this object.
`boolean`	`isClosed()` Returns whether this statement is closed.
`boolean`	`isPoolable()` Returns whether this object is poolable.
`void`	`setCursorName(String name)` Sets the name of the cursor.
`void`	`setEscapeProcessing(boolean enable)` Enables or disables processing or JDBC escape syntax.
`protected void`	`setExecutingStatement(CommandInterface c)` INTERNAL.
`void`	`setFetchDirection(int direction)` Sets the fetch direction.
`void`	`setFetchSize(int rows)` Sets the number of rows suggested to read in one step.
`void`	`setMaxFieldSize(int max)` Sets the maximum number of bytes for a result set column.
`void`	`setMaxRows(int maxRows)` Gets the maximum number of rows for a ResultSet.
`void`	`setPoolable(boolean poolable)` Requests that this object should be pooled or not.
`void`	`setQueryTimeout(int seconds)` Sets the current query timeout in seconds.
`String`	`toString()` INTERNAL

Methods inherited from class org.h2.message.TraceObject
debugCode, debugCodeAssign, debugCodeCall, debugCodeCall, debugCodeCall, getNextId, getTrace, getTraceId, getTraceObjectName, isDebugEnabled, isInfoEnabled, logAndConvert, quote, quoteArray, quoteBigDecimal, quoteBytes, quoteDate, quoteIntArray, quoteMap, quoteTime, quoteTimestamp, setTrace, unsupported

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

Methods inherited from interface java.sql.Statement
closeOnCompletion, isCloseOnCompletion

Methods inherited from interface java.sql.Wrapper
isWrapperFor, unwrap

- Field Detail
  - conn
```
protected JdbcConnection conn
```
  - session
```
protected SessionInterface session
```
  - resultSet
```
protected JdbcResultSet resultSet
```
  - maxRows
```
protected int maxRows
```
  - fetchSize
```
protected int fetchSize
```
  - updateCount
```
protected int updateCount
```
  - resultSetType
```
protected final int resultSetType
```
  - resultSetConcurrency
```
protected final int resultSetConcurrency
```
  - closedByResultSet
```
protected boolean closedByResultSet
```
- Method Detail
  - executeQuery
```
public ResultSet executeQuery(String sql)
                       throws SQLException
```
    Executes a query (select statement) and returns the result set. If another result set exists for this statement, this will be closed (even if this statement fails).
    
    Specified by:
    
    executeQuery in interface Statement
    
    Parameters:
    sql - the SQL statement to execute
    
    Returns:
    the result set
    
    Throws:
    
    SQLException
  - executeUpdate
```
public int executeUpdate(String sql)
                  throws SQLException
```
    Executes a statement (insert, update, delete, create, drop) and returns the update count. If another result set exists for this statement, this will be closed (even if this statement fails). If auto commit is on, this statement will be committed. If the statement is a DDL statement (create, drop, alter) and does not throw an exception, the current transaction (if any) is committed after executing the statement.
    
    Specified by:
    
    executeUpdate in interface Statement
    
    Parameters:
    sql - the SQL statement
    
    Returns:
    the update count (number of row affected by an insert, update or delete, or 0 if no rows or the statement was a create, drop, commit or rollback)
    
    Throws:
    
    SQLException - if a database error occurred or a select statement was executed
  - execute
```
public boolean execute(String sql)
                throws SQLException
```
    Executes an arbitrary statement. If another result set exists for this statement, this will be closed (even if this statement fails). If the statement is a create or drop and does not throw an exception, the current transaction (if any) is committed after executing the statement. If auto commit is on, and the statement is not a select, this statement will be committed.
    
    Specified by:
    
    execute in interface Statement
    
    Parameters:
    sql - the SQL statement to execute
    
    Returns:
    true if a result set is available, false if not
    
    Throws:
    
    SQLException
  - getResultSet
```
public ResultSet getResultSet()
                       throws SQLException
```
    Returns the last result set produces by this statement.
    
    Specified by:
    
    getResultSet in interface Statement
    
    Returns:
    the result set
    
    Throws:
    
    SQLException
  - getUpdateCount
```
public int getUpdateCount()
                   throws SQLException
```
    Returns the last update count of this statement.
    
    Specified by:
    
    getUpdateCount in interface Statement
    
    Returns:
    the update count (number of row affected by an insert, update or delete, or 0 if no rows or the statement was a create, drop, commit or rollback; -1 if the statement was a select).
    
    Throws:
    
    SQLException - if this object is closed or invalid
  - close
```
public void close()
           throws SQLException
```
    Closes this statement. All result sets that where created by this statement become invalid after calling this method.
    
    Specified by:
    
    close in interface AutoCloseable
    
    Specified by:
    
    close in interface Statement
    
    Throws:
    
    SQLException
  - getConnection
```
public Connection getConnection()
```
    Returns the connection that created this object.
    
    Specified by:
    
    getConnection in interface Statement
    
    Returns:
    the connection
  - getWarnings
```
public SQLWarning getWarnings()
                       throws SQLException
```
    Gets the first warning reported by calls on this object. This driver does not support warnings, and will always return null.
    
    Specified by:
    
    getWarnings in interface Statement
    
    Returns:
    null
    
    Throws:
    
    SQLException
  - clearWarnings
```
public void clearWarnings()
                   throws SQLException
```
    Clears all warnings. As this driver does not support warnings, this call is ignored.
    
    Specified by:
    
    clearWarnings in interface Statement
    
    Throws:
    
    SQLException
  - getMoreResults
```
public boolean getMoreResults()
                       throws SQLException
```
    Moves to the next result set - however there is always only one result set. This call also closes the current result set (if there is one). Returns true if there is a next result set (that means - it always returns false).
    
    Specified by:
    
    getMoreResults in interface Statement
    
    Returns:
    false
    
    Throws:
    
    SQLException - if this object is closed.
  - setCursorName
```
public void setCursorName(String name)
                   throws SQLException
```
    Sets the name of the cursor. This call is ignored.
    
    Specified by:
    
    setCursorName in interface Statement
    
    Parameters:
    name - ignored
    
    Throws:
    
    SQLException - if this object is closed
  - setFetchDirection
```
public void setFetchDirection(int direction)
                       throws SQLException
```
    Sets the fetch direction. This call is ignored by this driver.
    
    Specified by:
    
    setFetchDirection in interface Statement
    
    Parameters:
    direction - ignored
    
    Throws:
    
    SQLException - if this object is closed
  - getFetchDirection
```
public int getFetchDirection()
                      throws SQLException
```
    Gets the fetch direction.
    
    Specified by:
    
    getFetchDirection in interface Statement
    
    Returns:
    FETCH_FORWARD
    
    Throws:
    
    SQLException - if this object is closed
  - getMaxRows
```
public int getMaxRows()
               throws SQLException
```
    Gets the maximum number of rows for a ResultSet.
    
    Specified by:
    
    getMaxRows in interface Statement
    
    Returns:
    the number of rows where 0 means no limit
    
    Throws:
    
    SQLException - if this object is closed
  - setMaxRows
```
public void setMaxRows(int maxRows)
                throws SQLException
```
    Gets the maximum number of rows for a ResultSet.
    
    Specified by:
    
    setMaxRows in interface Statement
    
    Parameters:
    maxRows - the number of rows where 0 means no limit
    
    Throws:
    
    SQLException - if this object is closed
  - setFetchSize
```
public void setFetchSize(int rows)
                  throws SQLException
```
    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. Setting the value to 0 will set the default value. The default value can be changed using the system property h2.serverResultSetFetchSize.
    
    Specified by:
    
    setFetchSize in interface Statement
    
    Parameters:
    rows - the number of rows
    
    Throws:
    
    SQLException - if this object is closed
  - getFetchSize
```
public int getFetchSize()
                 throws SQLException
```
    Gets the number of rows suggested to read in one step.
    
    Specified by:
    
    getFetchSize in interface Statement
    
    Returns:
    the current fetch size
    
    Throws:
    
    SQLException - if this object is closed
  - getResultSetConcurrency
```
public int getResultSetConcurrency()
                            throws SQLException
```
    Gets the result set concurrency created by this object.
    
    Specified by:
    
    getResultSetConcurrency in interface Statement
    
    Returns:
    the concurrency
    
    Throws:
    
    SQLException
  - getResultSetType
```
public int getResultSetType()
                     throws SQLException
```
    Gets the result set type.
    
    Specified by:
    
    getResultSetType in interface Statement
    
    Returns:
    the type
    
    Throws:
    
    SQLException - if this object is closed
  - getMaxFieldSize
```
public int getMaxFieldSize()
                    throws SQLException
```
    Gets the maximum number of bytes for a result set column.
    
    Specified by:
    
    getMaxFieldSize in interface Statement
    
    Returns:
    always 0 for no limit
    
    Throws:
    
    SQLException - if this object is closed
  - setMaxFieldSize
```
public void setMaxFieldSize(int max)
                     throws SQLException
```
    Sets the maximum number of bytes for a result set column. This method does currently do nothing for this driver.
    
    Specified by:
    
    setMaxFieldSize in interface Statement
    
    Parameters:
    max - the maximum size - ignored
    
    Throws:
    
    SQLException - if this object is closed
  - setEscapeProcessing
```
public void setEscapeProcessing(boolean enable)
                         throws SQLException
```
    Enables or disables processing or JDBC escape syntax. See also Connection.nativeSQL.
    
    Specified by:
    
    setEscapeProcessing in interface Statement
    
    Parameters:
    enable - - true (default) or false (no conversion is attempted)
    
    Throws:
    
    SQLException - if this object is closed
  - cancel
```
public void cancel()
            throws SQLException
```
    Cancels a currently running statement. This method must be called from within another thread than the execute method.
    
    Specified by:
    
    cancel in interface Statement
    
    Throws:
    
    SQLException - if this object is closed
  - getQueryTimeout
```
public int getQueryTimeout()
                    throws SQLException
```
    Gets the current query timeout in seconds. This method will return 0 if no query timeout is set. The result is rounded to the next second.
    
    Specified by:
    
    getQueryTimeout in interface Statement
    
    Returns:
    the timeout in seconds
    
    Throws:
    
    SQLException - if this object is closed
  - setQueryTimeout
```
public void setQueryTimeout(int seconds)
                     throws SQLException
```
    Sets the current query timeout in seconds. Calling this method will commit an open transaction, even if the value is the same as before. Changing the value will affect all statements of this connection. This method does not commit a transaction, and rolling back a transaction does not affect this setting.
    
    Specified by:
    
    setQueryTimeout in interface Statement
    
    Parameters:
    seconds - the timeout in seconds - 0 means no timeout, values smaller 0 will throw an exception
    
    Throws:
    
    SQLException - if this object is closed
  - addBatch
```
public void addBatch(String sql)
              throws SQLException
```
    Adds a statement to the batch.
    
    Specified by:
    
    addBatch in interface Statement
    
    Parameters:
    sql - the SQL statement
    
    Throws:
    
    SQLException
  - clearBatch
```
public void clearBatch()
                throws SQLException
```
    Clears the batch.
    
    Specified by:
    
    clearBatch in interface Statement
    
    Throws:
    
    SQLException
  - executeBatch
```
public int[] executeBatch()
                   throws SQLException
```
    Executes the batch.
    
    Specified by:
    
    executeBatch in interface Statement
    
    Returns:
    the array of update counts
    
    Throws:
    
    SQLException
  - getGeneratedKeys
```
public ResultSet getGeneratedKeys()
                           throws SQLException
```
    Return a result set that contains the last generated auto-increment key for this connection, if there was one. If no key was generated by the last modification statement, then an empty result set is returned. The returned result set only contains the data for the very last row.
    
    Specified by:
    
    getGeneratedKeys in interface Statement
    
    Returns:
    the result set with one row and one column containing the key
    
    Throws:
    
    SQLException - if this object is closed
  - getMoreResults
```
public boolean getMoreResults(int current)
                       throws SQLException
```
    Move to the next result set. This method always returns false.
    
    Specified by:
    
    getMoreResults in interface Statement
    
    Parameters:
    current - Statement.CLOSE_CURRENT_RESULT, Statement.KEEP_CURRENT_RESULT, or Statement.CLOSE_ALL_RESULTS
    
    Returns:
    false
    
    Throws:
    
    SQLException
  - executeUpdate
```
public int executeUpdate(String sql,
                int autoGeneratedKeys)
                  throws SQLException
```
    Executes a statement and returns the update count. This method just calls executeUpdate(String sql) internally. The method getGeneratedKeys supports at most one columns and row.
    
    Specified by:
    
    executeUpdate in interface Statement
    
    Parameters:
    sql - the SQL statement
    autoGeneratedKeys - ignored
    
    Returns:
    the update count (number of row affected by an insert, update or delete, or 0 if no rows or the statement was a create, drop, commit or rollback)
    
    Throws:
    
    SQLException - if a database error occurred or a select statement was executed
  - executeUpdate
```
public int executeUpdate(String sql,
                int[] columnIndexes)
                  throws SQLException
```
    Executes a statement and returns the update count. This method just calls executeUpdate(String sql) internally. The method getGeneratedKeys supports at most one columns and row.
    
    Specified by:
    
    executeUpdate in interface Statement
    
    Parameters:
    sql - the SQL statement
    columnIndexes - ignored
    
    Returns:
    the update count (number of row affected by an insert, update or delete, or 0 if no rows or the statement was a create, drop, commit or rollback)
    
    Throws:
    
    SQLException - if a database error occurred or a select statement was executed
  - executeUpdate
```
public int executeUpdate(String sql,
                String[] columnNames)
                  throws SQLException
```
    Executes a statement and returns the update count. This method just calls executeUpdate(String sql) internally. The method getGeneratedKeys supports at most one columns and row.
    
    Specified by:
    
    executeUpdate in interface Statement
    
    Parameters:
    sql - the SQL statement
    columnNames - ignored
    
    Returns:
    the update count (number of row affected by an insert, update or delete, or 0 if no rows or the statement was a create, drop, commit or rollback)
    
    Throws:
    
    SQLException - if a database error occurred or a select statement was executed
  - execute
```
public boolean execute(String sql,
              int autoGeneratedKeys)
                throws SQLException
```
    Executes a statement and returns the update count. This method just calls execute(String sql) internally. The method getGeneratedKeys supports at most one columns and row.
    
    Specified by:
    
    execute in interface Statement
    
    Parameters:
    sql - the SQL statement
    autoGeneratedKeys - ignored
    
    Returns:
    the update count (number of row affected by an insert, update or delete, or 0 if no rows or the statement was a create, drop, commit or rollback)
    
    Throws:
    
    SQLException - if a database error occurred or a select statement was executed
  - execute
```
public boolean execute(String sql,
              int[] columnIndexes)
                throws SQLException
```
    Executes a statement and returns the update count. This method just calls execute(String sql) internally. The method getGeneratedKeys supports at most one columns and row.
    
    Specified by:
    
    execute in interface Statement
    
    Parameters:
    sql - the SQL statement
    columnIndexes - ignored
    
    Returns:
    the update count (number of row affected by an insert, update or delete, or 0 if no rows or the statement was a create, drop, commit or rollback)
    
    Throws:
    
    SQLException - if a database error occurred or a select statement was executed
  - execute
```
public boolean execute(String sql,
              String[] columnNames)
                throws SQLException
```
    Executes a statement and returns the update count. This method just calls execute(String sql) internally. The method getGeneratedKeys supports at most one columns and row.
    
    Specified by:
    
    execute in interface Statement
    
    Parameters:
    sql - the SQL statement
    columnNames - ignored
    
    Returns:
    the update count (number of row affected by an insert, update or delete, or 0 if no rows or the statement was a create, drop, commit or rollback)
    
    Throws:
    
    SQLException - if a database error occurred or a select statement was executed
  - getResultSetHoldability
```
public int getResultSetHoldability()
                            throws SQLException
```
    Gets the result set holdability.
    
    Specified by:
    
    getResultSetHoldability in interface Statement
    
    Returns:
    the holdability
    
    Throws:
    
    SQLException
  - checkClosed
```
protected boolean checkClosed(boolean write)
```
    INTERNAL. Check if the statement is closed.
    
    Parameters:
    write - if the next operation is possibly writing
    
    Returns:
    true if a reconnect was required
    
    Throws:
    
    DbException - if it is closed
  - closeOldResultSet
```
protected void closeOldResultSet()
                          throws SQLException
```
    INTERNAL. Close and old result set if there is still one open.
    
    Throws:
    
    SQLException
  - setExecutingStatement
```
protected void setExecutingStatement(CommandInterface c)
```
    INTERNAL. Set the statement that is currently running.
    
    Parameters:
    c - the command
  - getLastExecutedCommandType
```
public int getLastExecutedCommandType()
```
    INTERNAL. Get the command type of the last executed command.
  - isClosed
```
public boolean isClosed()
                 throws SQLException
```
    Returns whether this statement is closed.
    
    Specified by:
    
    isClosed in interface Statement
    
    Returns:
    true if the statement is closed
    
    Throws:
    
    SQLException
  - isPoolable
```
public boolean isPoolable()
```
    Returns whether this object is poolable.
    
    Specified by:
    
    isPoolable in interface Statement
    
    Returns:
    false
  - setPoolable
```
public void setPoolable(boolean poolable)
```
    Requests that this object should be pooled or not. This call is ignored.
    
    Specified by:
    
    setPoolable in interface Statement
    
    Parameters:
    poolable - the requested value
  - toString
```
public String toString()
```
    INTERNAL
    
    Overrides:
    
    toString in class Object

Class JdbcStatement

Field Summary

Fields inherited from class org.h2.message.TraceObject

Fields inherited from interface java.sql.Statement

Method Summary

Methods inherited from class org.h2.message.TraceObject

Methods inherited from class java.lang.Object

Methods inherited from interface java.sql.Statement

Methods inherited from interface java.sql.Wrapper

Field Detail

conn

session

resultSet

maxRows

fetchSize

updateCount

resultSetType

resultSetConcurrency

closedByResultSet

Method Detail

executeQuery

executeUpdate

execute

getResultSet

getUpdateCount

close

getConnection

getWarnings

clearWarnings

getMoreResults

setCursorName

setFetchDirection

getFetchDirection

getMaxRows

setMaxRows

setFetchSize

getFetchSize

getResultSetConcurrency

getResultSetType

getMaxFieldSize

setMaxFieldSize

setEscapeProcessing

cancel

getQueryTimeout

setQueryTimeout

addBatch

clearBatch

executeBatch

getGeneratedKeys

getMoreResults

executeUpdate

executeUpdate

executeUpdate

execute

execute

execute

getResultSetHoldability

checkClosed

closeOldResultSet

setExecutingStatement

getLastExecutedCommandType

isClosed

isPoolable

setPoolable

toString