|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.apache.derby.impl.jdbc.ConnectionChild
org.apache.derby.impl.jdbc.EmbedStatement
EmbedStatement is a local JDBC statement.
Supports
Field Summary | |
protected boolean |
active
|
private java.sql.Connection |
applicationConnection
|
private java.sql.ResultSet |
autoGeneratedKeysResultSet
|
protected java.util.Vector |
batchStatements
|
protected static boolean |
CLOSE
|
private int |
currentDynamicResultSet
|
protected java.lang.String |
cursorName
|
private EmbedResultSet[] |
dynamicResults
|
protected InternalDriver |
factory
Factory for JDBC objects to be created. |
private int |
fetchDirection
|
private int |
fetchSize
|
protected boolean |
forMetaData
|
protected LanguageConnectionContext |
lcc
|
protected EmbedConnection |
localConn
|
(package private) int |
MaxFieldSize
|
(package private) int |
maxRows
|
protected static boolean |
NOCLOSE
|
private ParameterValueSet |
pvs
|
protected java.sql.ResultSet |
results
|
protected int |
resultSetConcurrency
|
protected int |
resultSetHoldability
|
int |
resultSetType
|
protected java.lang.String |
SQLText
|
protected int |
updateCount
|
private java.sql.SQLWarning |
warnings
|
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 |
Constructor Summary | |
EmbedStatement(EmbedConnection connection,
boolean forMetaData,
int resultSetType,
int resultSetConcurrency,
int resultSetHoldability)
|
Method Summary | |
void |
addBatch(java.lang.String sql)
JDBC 2.0 Adds a SQL command to the current batch of commmands for the statement. |
void |
cancel()
Cancel can be used by one thread to cancel a statement that is being executed by another thread. |
protected void |
checkExecStatus()
A heavier weight version of checkStatus() that ensures the application's Connection object is still open. |
protected void |
checkIfInMiddleOfBatch()
|
protected void |
checkRequiresCallableStatement(Activation activation)
Check to see if a statement requires to be executed via a callable statement. |
protected void |
checkStatus()
|
void |
clearBatch()
JDBC 2.0 Make the set of commands in the current batch empty. |
protected void |
clearResultSets()
Close and clear all result sets associated with this statement from the last execution. |
void |
clearWarnings()
After this call getWarnings returns null until a new warning is reported for this Statement. |
void |
close()
In many cases, it is desirable to immediately release a Statements's database and JDBC resources instead of waiting for this to happen when it is automatically closed; the close method provides this immediate release. |
protected void |
closeActions()
|
protected void |
commitIfAutoCommit()
Perform a commit if autocommit is enabled. |
protected void |
commitIfNeeded()
Perform a commit if one is needed. |
boolean |
execute(java.lang.String sql)
Execute a SQL statement that may return multiple results. |
protected boolean |
execute(java.lang.String sql,
boolean executeQuery,
boolean executeUpdate,
int autoGeneratedKeys,
int[] columnIndexes,
java.lang.String[] columnNames)
|
boolean |
execute(java.lang.String sql,
int autoGeneratedKeys)
JDBC 3.0 Executes the given SQL statement, which may return multiple results, and signals the driver that any auto-generated keys should be made available for retrieval. |
boolean |
execute(java.lang.String sql,
int[] columnIndexes)
JDBC 3.0 Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. |
boolean |
execute(java.lang.String sql,
java.lang.String[] columnNames)
JDBC 3.0 Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. |
int[] |
executeBatch()
JDBC 2.0 Submit a batch of commands to the database for execution. |
protected boolean |
executeBatchElement(java.lang.Object batchElement)
Execute a single element of the batch. |
java.sql.ResultSet |
executeQuery(java.lang.String sql)
Execute a SQL statement that returns a single ResultSet. |
protected boolean |
executeStatement(Activation a,
boolean executeQuery,
boolean executeUpdate)
Execute the current statement. |
int |
executeUpdate(java.lang.String sql)
Execute a SQL INSERT, UPDATE or DELETE statement. |
int |
executeUpdate(java.lang.String sql,
int autoGeneratedKeys)
JDBC 3.0 Execute the given SQL statement and signals the driver with the given flag about whether the auto-generated keys produced by this Statement object should be made available for retrieval. |
int |
executeUpdate(java.lang.String sql,
int[] columnIndexes)
JDBC 3.0 Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. |
int |
executeUpdate(java.lang.String sql,
java.lang.String[] columnNames)
JDBC 3.0 Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. |
protected java.util.Calendar |
getCal()
Get and save a unique calendar object for this JDBC object. |
java.sql.Connection |
getConnection()
JDBC 2.0 Return the Connection that produced the Statement. |
protected java.lang.Object |
getConnectionSynchronization()
Return an object to be used for connection synchronization. |
ContextManager |
getContextManager()
|
Database |
getDatabase()
|
protected EmbedConnection |
getEmbedConnection()
Return a reference to the EmbedConnection |
int |
getFetchDirection()
JDBC 2.0 Determine the fetch direction. |
int |
getFetchSize()
JDBC 2.0 Determine the default fetch size. |
java.sql.ResultSet |
getGeneratedKeys()
JDBC 3.0 Retrieves any auto-generated keys created as a result of executing this Statement object. |
int |
getMaxFieldSize()
The maxFieldSize limit (in bytes) is the maximum amount of data returned for any column value; it only applies to BINARY, VARBINARY, LONGVARBINARY, CHAR, VARCHAR, and LONGVARCHAR columns. |
int |
getMaxRows()
The maxRows limit is the maximum number of rows that a ResultSet can contain. |
boolean |
getMoreResults()
getMoreResults moves to a Statement's next result. |
boolean |
getMoreResults(int current)
JDBC 3.0 Moves to this Statement obect's next result, deals with any current ResultSet object(s) according to the instructions specified by the given flag, and returns true if the next result is a ResultSet object |
ParameterValueSet |
getParameterValueSet()
|
int |
getQueryTimeout()
The queryTimeout limit is the number of seconds the driver will wait for a Statement to execute. |
java.sql.ResultSet |
getResultSet()
getResultSet returns the current result as a ResultSet. |
int |
getResultSetConcurrency()
JDBC 2.0 Determine the result set concurrency. |
int |
getResultSetHoldability()
JDBC 3.0 Retrieves the result set holdability for ResultSet objects generated by this Statement object. |
int |
getResultSetType()
JDBC 2.0 Determine the result set type. |
java.lang.String |
getSQLText()
|
int |
getUpdateCount()
getUpdateCount returns the current result as an update count; if the result is a ResultSet or there are no more results -1 is returned. |
java.sql.SQLWarning |
getWarnings()
The first warning reported by calls on this Statement is returned. |
protected void |
getWarnings(java.sql.SQLWarning sw)
|
protected java.sql.SQLException |
handleException(java.lang.Throwable t)
Handle any exception. |
protected java.sql.SQLException |
handleException(java.lang.Throwable t,
boolean close)
Handle any exception. |
protected void |
needCommit()
If Autocommit is on, note that a commit is needed. |
protected java.sql.SQLException |
newSQLException(java.lang.String messageId)
|
protected java.sql.SQLException |
newSQLException(java.lang.String messageId,
java.lang.Object arg1)
|
protected java.sql.SQLException |
newSQLException(java.lang.String messageId,
java.lang.Object arg1,
java.lang.Object arg2)
|
private boolean |
processDynamicResults(java.sql.ResultSet[][] holder,
int maxDynamicResultSets)
|
protected void |
restoreContextStack()
Setup the context stack (a.k.a. context manager) for this connection. |
(package private) void |
resultSetClosing(EmbedResultSet closingLRS)
Callback on the statement when one of its result sets is closed. |
void |
setCursorName(java.lang.String name)
setCursorName defines the SQL cursor name that will be used by subsequent Statement execute methods. |
void |
setEscapeProcessing(boolean enable)
If escape scanning is on (the default) the driver will do escape substitution before sending the SQL to the database. |
void |
setFetchDirection(int direction)
JDBC 2.0 Give a hint as to the direction in which the rows in a result set will be processed. |
void |
setFetchSize(int rows)
JDBC 2.0 Give the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed. |
void |
setMaxFieldSize(int max)
The maxFieldSize limit (in bytes) is set to limit the size of data that can be returned for any column value; it only applies to BINARY, VARBINARY, LONGVARBINARY, CHAR, VARCHAR, and LONGVARCHAR fields. |
void |
setMaxRows(int max)
The maxRows limit is set to limit the number of rows that any ResultSet can contain. |
void |
setQueryTimeout(int seconds)
The queryTimeout limit is the number of seconds the driver will wait for a Statement to execute. |
protected void |
setupContextStack()
Setup the context stack (a.k.a. context manager) for this connection. |
void |
transferBatch(EmbedStatement other)
Transfer my batch of Statements to a newly created Statement. |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
private final java.sql.Connection applicationConnection
protected int updateCount
protected java.sql.ResultSet results
private java.sql.ResultSet autoGeneratedKeysResultSet
protected java.lang.String cursorName
protected final boolean forMetaData
public final int resultSetType
protected final int resultSetConcurrency
protected final int resultSetHoldability
protected final LanguageConnectionContext lcc
private java.sql.SQLWarning warnings
protected java.lang.String SQLText
private int fetchSize
private int fetchDirection
int MaxFieldSize
protected boolean active
protected java.util.Vector batchStatements
int maxRows
private ParameterValueSet pvs
private EmbedResultSet[] dynamicResults
private int currentDynamicResultSet
protected static final boolean CLOSE
protected static final boolean NOCLOSE
protected EmbedConnection localConn
protected final InternalDriver factory
Constructor Detail |
public EmbedStatement(EmbedConnection connection, boolean forMetaData, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
Method Detail |
public java.sql.ResultSet executeQuery(java.lang.String sql) throws java.sql.SQLException
executeQuery
in interface java.sql.Statement
sql
- typically this is a static SQL SELECT statement
java.sql.SQLException
- thrown on failure.public int executeUpdate(java.lang.String sql) throws java.sql.SQLException
executeUpdate
in interface java.sql.Statement
sql
- a SQL INSERT, UPDATE or DELETE statement or a SQL
statement that returns nothing
java.sql.SQLException
- thrown on failure.public int executeUpdate(java.lang.String sql, int autoGeneratedKeys) throws java.sql.SQLException
executeUpdate
in interface java.sql.Statement
sql
- a SQL INSERT, UPDATE or DELETE statement or a SQL
statement that returns nothingautoGeneratedKeys
- - a flag indicating whether auto-generated keys
should be made available for retrieval; one of the following constants:
Statement.RETURN_GENERATED_KEYS Statement.NO_GENERATED_KEYS
java.sql.SQLException
- if a database access error occurspublic int executeUpdate(java.lang.String sql, int[] columnIndexes) throws java.sql.SQLException
executeUpdate
in interface java.sql.Statement
sql
- a SQL INSERT, UPDATE or DELETE statement or a SQL
statement that returns nothingcolumnIndexes
- - an array of column indexes indicating the
columns that should be returned from the inserted row
java.sql.SQLException
- if a database access error occurspublic int executeUpdate(java.lang.String sql, java.lang.String[] columnNames) throws java.sql.SQLException
executeUpdate
in interface java.sql.Statement
sql
- a SQL INSERT, UPDATE or DELETE statement or a SQL
statement that returns nothingcolumnNames
- - an array of the names of the columns
that should be returned from the inserted row
java.sql.SQLException
- if a database access error occursprotected final void checkIfInMiddleOfBatch() throws java.sql.SQLException
java.sql.SQLException
public final void close() throws java.sql.SQLException
Note: A Statement is automatically closed when it is garbage collected. When a Statement is closed its current ResultSet, if one exists, is also closed.
close
in interface java.sql.Statement
java.sql.SQLException
- thrown on failure.protected void closeActions() throws java.sql.SQLException
java.sql.SQLException
public int getMaxFieldSize() throws java.sql.SQLException
getMaxFieldSize
in interface java.sql.Statement
java.sql.SQLException
- thrown on failure.public void setMaxFieldSize(int max) throws java.sql.SQLException
setMaxFieldSize
in interface java.sql.Statement
max
- the new max column size limit; zero means unlimited
java.sql.SQLException
- thrown on failure.public int getMaxRows() throws java.sql.SQLException
getMaxRows
in interface java.sql.Statement
java.sql.SQLException
- thrown on failure.public void setMaxRows(int max) throws java.sql.SQLException
setMaxRows
in interface java.sql.Statement
max
- the new max rows limit; zero means unlimited
java.sql.SQLException
- thrown on failure.public void setEscapeProcessing(boolean enable) throws java.sql.SQLException
setEscapeProcessing
in interface java.sql.Statement
enable
- true to enable; false to disable
java.sql.SQLException
- thrown on failure.public int getQueryTimeout() throws java.sql.SQLException
getQueryTimeout
in interface java.sql.Statement
java.sql.SQLException
- thrown on failure.public void setQueryTimeout(int seconds) throws java.sql.SQLException
setQueryTimeout
in interface java.sql.Statement
seconds
- the new query timeout limit in seconds; zero means unlimited
java.sql.SQLException
- thrown on failure.public void cancel() throws java.sql.SQLException
cancel
in interface java.sql.Statement
java.sql.SQLException
- thrown on failure.public java.sql.SQLWarning getWarnings() throws java.sql.SQLException
The warning chain is automatically cleared each time a statement is (re)executed.
Note: If you are processing a ResultSet then any warnings associated with ResultSet reads will be chained on the ResultSet object.
getWarnings
in interface java.sql.Statement
java.sql.SQLException
- thrown on failure.public void clearWarnings() throws java.sql.SQLException
clearWarnings
in interface java.sql.Statement
java.sql.SQLException
- thrown on failure.public void setCursorName(java.lang.String name) throws java.sql.SQLException
Note: By definition, positioned update/delete execution must be done by a different Statement than the one which generated the ResultSet being used for positioning. Also, cursor names must be unique within a Connection.
setCursorName
in interface java.sql.Statement
name
- the new cursor name.
java.sql.SQLException
public boolean execute(java.lang.String sql) throws java.sql.SQLException
execute
in interface java.sql.Statement
sql
- any SQL statement
java.sql.SQLException
- thrown on failuregetResultSet()
,
getUpdateCount()
,
getMoreResults()
protected boolean execute(java.lang.String sql, boolean executeQuery, boolean executeUpdate, int autoGeneratedKeys, int[] columnIndexes, java.lang.String[] columnNames) throws java.sql.SQLException
java.sql.SQLException
public boolean execute(java.lang.String sql, int autoGeneratedKeys) throws java.sql.SQLException
execute
in interface java.sql.Statement
sql
- any SQL statementautoGeneratedKeys
- - a constant indicating whether
auto-generated keys should be made available for retrieval using
the method getGeneratedKeys; one of the following constants:
Statement.RETURN_GENERATED_KEYS or Statement.NO_GENERATED_KEYS
java.sql.SQLException
- if a database access error occurspublic boolean execute(java.lang.String sql, int[] columnIndexes) throws java.sql.SQLException
execute
in interface java.sql.Statement
sql
- any SQL statementcolumnIndexes
- - an array of the indexes of the columns in the
inserted row that should be made available for retrieval by a call to
the method getGeneratedKeys
java.sql.SQLException
- if a database access error occurspublic boolean execute(java.lang.String sql, java.lang.String[] columnNames) throws java.sql.SQLException
execute
in interface java.sql.Statement
sql
- any SQL statementcolumnNames
- - an array of the names of the columns in the
inserted row that should be made available for retrieval by a call to
the method getGeneratedKeys
java.sql.SQLException
- if a database access error occurspublic final java.sql.ResultSet getResultSet() throws java.sql.SQLException
getResultSet
in interface java.sql.Statement
java.sql.SQLException
execute(java.lang.String)
public final int getUpdateCount() throws java.sql.SQLException
The only way to tell for sure that the result is an update count is to first test to see if it is a ResultSet. If it is not a ResultSet it is either an update count or there are no more results.
getUpdateCount
in interface java.sql.Statement
java.sql.SQLException
execute(java.lang.String)
public final boolean getMoreResults() throws java.sql.SQLException
getMoreResults
in interface java.sql.Statement
java.sql.SQLException
- thrown on failure.execute(java.lang.String)
public final int getResultSetType() throws java.sql.SQLException
getResultSetType
in interface java.sql.Statement
java.sql.SQLException
- Feature not implemented for now.public void setFetchDirection(int direction) throws java.sql.SQLException
setFetchDirection
in interface java.sql.Statement
direction
- the initial direction for processing rows
java.sql.SQLException
- if a database-access error occurs or direction
is not one of ResultSet.FETCH_FORWARD, ResultSet.FETCH_REVERSE, or
ResultSet.FETCH_UNKNOWNpublic int getFetchDirection() throws java.sql.SQLException
getFetchDirection
in interface java.sql.Statement
java.sql.SQLException
- if a database-access error occurspublic void setFetchSize(int rows) throws java.sql.SQLException
setFetchSize
in interface java.sql.Statement
rows
- the number of rows to fetch
java.sql.SQLException
- if a database-access error occurs, or the
condition 0 <= rows <= this.getMaxRows() is not satisfied.public int getFetchSize() throws java.sql.SQLException
getFetchSize
in interface java.sql.Statement
java.sql.SQLException
- if a database-access error occurspublic int getResultSetConcurrency() throws java.sql.SQLException
getResultSetConcurrency
in interface java.sql.Statement
java.sql.SQLException
- Feature not implemented for now.public int getResultSetHoldability() throws java.sql.SQLException
getResultSetHoldability
in interface java.sql.Statement
java.sql.SQLException
- Feature not implemented for now.public void addBatch(java.lang.String sql) throws java.sql.SQLException
addBatch
in interface java.sql.Statement
sql
- typically this is a static SQL INSERT or UPDATE statement
java.sql.SQLException
- if a database-access error occurs, or the
driver does not support batch statementspublic final void clearBatch() throws java.sql.SQLException
clearBatch
in interface java.sql.Statement
java.sql.SQLException
- if a database-access error occurs, or the
driver does not support batch statementspublic int[] executeBatch() throws java.sql.SQLException
executeBatch
in interface java.sql.Statement
java.sql.SQLException
- if a database-access error occurs, or the
driver does not support batch statementsprotected boolean executeBatchElement(java.lang.Object batchElement) throws java.sql.SQLException, StandardException
java.sql.SQLException
StandardException
public final java.sql.Connection getConnection() throws java.sql.SQLException
getConnection
in interface java.sql.Statement
java.sql.SQLException
- Exception if it cannot find the connection
associated to this statement.public final boolean getMoreResults(int current) throws java.sql.SQLException
getMoreResults
in interface java.sql.Statement
current
- - one of the following Statement constants indicating what
should happen to current ResultSet objects obtained using the method
getResultSetCLOSE_CURRENT_RESULT, KEEP_CURRENT_RESULT, or CLOSE_ALL_RESULTS
java.sql.SQLException
- thrown on failure.execute(java.lang.String)
public final java.sql.ResultSet getGeneratedKeys() throws java.sql.SQLException
getGeneratedKeys
in interface java.sql.Statement
java.sql.SQLException
- if a database access error occursprotected boolean executeStatement(Activation a, boolean executeQuery, boolean executeUpdate) throws java.sql.SQLException
java.sql.SQLException
- thrown on failure.protected void getWarnings(java.sql.SQLWarning sw)
public java.lang.String getSQLText()
public ParameterValueSet getParameterValueSet()
protected final void checkStatus() throws java.sql.SQLException
java.sql.SQLException
protected final void checkExecStatus() throws java.sql.SQLException
java.sql.SQLException
protected void clearResultSets() throws java.sql.SQLException
java.sql.SQLException
protected void checkRequiresCallableStatement(Activation activation) throws java.sql.SQLException
java.sql.SQLException
public void transferBatch(EmbedStatement other) throws java.sql.SQLException
java.sql.SQLException
private boolean processDynamicResults(java.sql.ResultSet[][] holder, int maxDynamicResultSets) throws java.sql.SQLException
java.sql.SQLException
void resultSetClosing(EmbedResultSet closingLRS) throws java.sql.SQLException
java.sql.SQLException
protected final EmbedConnection getEmbedConnection()
protected final java.lang.Object getConnectionSynchronization()
protected final java.sql.SQLException handleException(java.lang.Throwable t) throws java.sql.SQLException
java.sql.SQLException
- thrown if can't handleEmbedConnection.handleException(java.lang.Throwable)
protected final java.sql.SQLException handleException(java.lang.Throwable t, boolean close) throws java.sql.SQLException
java.sql.SQLException
- thrown if can't handleEmbedConnection.handleException(java.lang.Throwable)
protected final void needCommit()
EmbedConnection.needCommit
protected final void commitIfNeeded() throws java.sql.SQLException
java.sql.SQLException
- thrown on failureEmbedConnection.commitIfNeeded()
protected final void commitIfAutoCommit() throws java.sql.SQLException
java.sql.SQLException
- thrown on failureEmbedConnection.commitIfNeeded()
protected final void setupContextStack() throws java.sql.SQLException
java.sql.SQLException
- thrown on failureEmbedConnection.setupContextStack()
protected final void restoreContextStack() throws java.sql.SQLException
java.sql.SQLException
- thrown on failureEmbedConnection.restoreContextStack()
public ContextManager getContextManager()
public Database getDatabase()
protected java.util.Calendar getCal()
protected java.sql.SQLException newSQLException(java.lang.String messageId)
protected java.sql.SQLException newSQLException(java.lang.String messageId, java.lang.Object arg1)
protected java.sql.SQLException newSQLException(java.lang.String messageId, java.lang.Object arg1, java.lang.Object arg2)
|
Built on Tue 2006-10-10 19:23:47+0200, from revision exported | |||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |