Class MariaDbStatement
- All Implemented Interfaces:
AutoCloseable
,Cloneable
,Statement
,Wrapper
- Direct Known Subclasses:
BasePrepareStatement
-
Field Summary
FieldsModifier and TypeFieldDescriptionprotected final boolean
protected boolean
protected MariaDbConnection
the Connection object.protected boolean
protected int
private boolean
protected final ReentrantLock
private static final Logger
private int
protected long
private boolean
protected final Options
protected Protocol
the protocol used to talk to the server.protected int
protected Results
protected final int
protected final int
private static final ScheduledExecutorService
private Future<?>
private boolean
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
ConstructorsConstructorDescriptionMariaDbStatement
(MariaDbConnection connection, int resultSetScrollType, int resultSetConcurrency) Creates a new Statement. -
Method Summary
Modifier and TypeMethodDescriptionvoid
Adds the given SQL command to the current list of commands for thisStatement
object.void
cancel()
Cancels thisStatement
object if both the DBMS and driver support aborting an SQL statement.protected void
Check if statement is closed, and throw exception if so.void
checkCloseOnCompletion
(ResultSet resultSet) Check that close on completion is asked, and close if so.void
Empties thisStatement
object's current list of SQL send.void
Clears all the warnings reported on thisStatement
object.clone
(MariaDbConnection connection) Clone statement.void
close()
Releases thisStatement
object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.void
boolean
executes a query.boolean
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
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
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[]
Execute statements.protected void
protected BatchUpdateException
executeBatchExceptionEpilogue
(SQLException initialSqle, int size) protected void
protected SQLException
Reset timeout after query, re-throw SQL exception.private boolean
executeInternal
(String sql, int fetchSize, int autoGeneratedKeys) Executes a query.long[]
Execute batch, like executeBatch(), with returning results with long[].long
executeLargeUpdate
(String sql) Executes the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement or an SQL statement that returns nothing, such as an SQL DDL statement.long
executeLargeUpdate
(String sql, int autoGeneratedKeys) Identical to executeLargeUpdate(String sql), with a flag that indicate that autoGeneratedKeys (primary key fields with "auto_increment") generated id's must be retrieved.long
executeLargeUpdate
(String sql, int[] columnIndexes) Identical to executeLargeUpdate(String sql, int autoGeneratedKeys) with autoGeneratedKeys = Statement.RETURN_GENERATED_KEYS set.long
executeLargeUpdate
(String sql, String[] columnNames) Identical to executeLargeUpdate(String sql, int autoGeneratedKeys) with autoGeneratedKeys = Statement.RETURN_GENERATED_KEYS set.executeQuery
(String sql) executes a select query.protected void
executeQueryPrologue
(boolean isBatch) Command prolog.int
executeUpdate
(String sql) Executes an update.int
executeUpdate
(String sql, int autoGeneratedKeys) Executes the given SQL statement and signals the driver with the given flag about whether the auto-generated keys produced by thisStatement
object should be made available for retrieval.int
executeUpdate
(String sql, int[] columnIndexes) 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
(String sql, String[] columnNames) 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.Gets the connection that created this statement.int
Retrieves the direction for fetching rows from database tables that is the default for result sets generated from thisStatement
object.int
Retrieves the number of result set rows that is the default fetch size forResultSet
objects generated from thisStatement
object.Retrieves any auto-generated keys created as a result of executing thisStatement
object.long
Retrieves the maximum number of rows that a ResultSet object produced by this Statement object can contain.long
Retrieves the current result as an update count; if the result is a ResultSet object or there are no more results, -1 is returned.int
Retrieves the maximum number of bytes that can be returned for character and binary column values in aResultSet
object produced by thisStatement
object.int
Retrieves the maximum number of rows that aResultSet
object produced by thisStatement
object can contain.boolean
Moves to thisStatement
object's next result, returnstrue
if it is aResultSet
object, and implicitly closes any currentResultSet
object(s) obtained with the methodgetResultSet
.boolean
getMoreResults
(int current) Moves to thisStatement
object's next result, deals with any currentResultSet
object(s) according to the instructions specified by the given flag, and returnstrue
if the next result is aResultSet
object.int
Retrieves the number of seconds the driver will wait for aStatement
object to execute.Retrieves the current result as a ResultSet object.int
Retrieves the result set concurrency forResultSet
objects generated by thisStatement
object.int
Retrieves the result set holdability forResultSet
objects generated by thisStatement
object.int
Retrieves the result set type forResultSet
objects generated by thisStatement
object.long
Permit to retrieve current connection thread id, or -1 if unknown.private String
getTimeoutSql
(String sql) int
Retrieves the current result as an update count; if the result is a ResultSet object or there are no more results, -1 is returned.Retrieves the first warning reported by calls on thisStatement
object.private SQLException
private void
internalBatchExecution
(int size) Internal batch execution.boolean
isClosed()
Retrieves whether thisStatement
object has been closed.boolean
boolean
Returns a value indicating whether theStatement
is poolable or not.boolean
isWrapperFor
(Class<?> interfaceOrWrapper) Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.void
setCursorName
(String name) Sets the SQL cursor name to the givenString
, which will be used by subsequentStatement
objectexecute
methods.void
setEscapeProcessing
(boolean enable) Sets escape processing on or off.void
setFetchDirection
(int direction) Gives the driver a hint as to the direction in which rows will be processed inResultSet
objects created using thisStatement
object.void
setFetchSize
(int rows) Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed forResultSet
objects generated by thisStatement
.void
setLargeMaxRows
(long max) Sets the limit for the maximum number of rows that any ResultSet object generated by this Statement object can contain to the given number.void
setLocalInfileInputStream
(InputStream inputStream) Sets the inputStream that will be used for the next execute that uses "LOAD DATA LOCAL INFILE".void
setMaxFieldSize
(int max) Sets the limit for the maximum number of bytes that can be returned for character and binary column values in aResultSet
object produced by thisStatement
object.void
setMaxRows
(int max) Sets the limit for the maximum number of rows that anyResultSet
object generated by thisStatement
object can contain to the given number.void
setPoolable
(boolean poolable) Requests that aStatement
be pooled or not pooled.void
setQueryTimeout
(int seconds) Sets the number of seconds the driver will wait for aStatement
object to execute to the given number of seconds.protected void
setTimerTask
(boolean isBatch) protected void
private void
boolean
testExecute
(String sql, Charset charset) ! This method is for test only ! This permit sending query using specific charset.<T> T
Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
Methods inherited from interface java.sql.Statement
enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, isSimpleIdentifier
-
Field Details
-
timeoutScheduler
-
logger
-
lock
-
resultSetScrollType
protected final int resultSetScrollType -
resultSetConcurrency
protected final int resultSetConcurrency -
options
-
canUseServerTimeout
protected final boolean canUseServerTimeout -
protocol
the protocol used to talk to the server. -
connection
the Connection object. -
closed
protected volatile boolean closed -
queryTimeout
protected int queryTimeout -
maxRows
protected long maxRows -
results
-
fetchSize
protected int fetchSize -
executing
protected volatile boolean executing -
warningsCleared
private boolean warningsCleared -
mustCloseOnCompletion
private boolean mustCloseOnCompletion -
batchQueries
-
timerTaskFuture
-
isTimedout
private boolean isTimedout -
maxFieldSize
private int maxFieldSize
-
-
Constructor Details
-
MariaDbStatement
public MariaDbStatement(MariaDbConnection connection, int resultSetScrollType, int resultSetConcurrency) Creates a new Statement.- Parameters:
connection
- the connection to return in getConnection.resultSetScrollType
- one of the followingResultSet
constants:ResultSet.TYPE_FORWARD_ONLY
,ResultSet.TYPE_SCROLL_INSENSITIVE
, orResultSet.TYPE_SCROLL_SENSITIVE
resultSetConcurrency
- a concurrency type; one ofResultSet.CONCUR_READ_ONLY
orResultSet.CONCUR_UPDATABLE
-
-
Method Details
-
clone
Clone statement.- Parameters:
connection
- connection- Returns:
- Clone statement.
- Throws:
CloneNotSupportedException
- if any error occur.
-
setTimerTask
protected void setTimerTask(boolean isBatch) -
executeQueryPrologue
Command prolog.- clear previous query state
- launch timeout timer if needed
- Parameters:
isBatch
- is batch- Throws:
SQLException
- if statement is closed
-
stopTimeoutTask
private void stopTimeoutTask() -
executeExceptionEpilogue
Reset timeout after query, re-throw SQL exception.- Parameters:
sqle
- current exception- Returns:
- SQLException exception with new message in case of timer timeout.
-
executeEpilogue
protected void executeEpilogue() -
executeBatchEpilogue
protected void executeBatchEpilogue() -
handleFailoverAndTimeout
-
executeBatchExceptionEpilogue
-
executeInternal
private boolean executeInternal(String sql, int fetchSize, int autoGeneratedKeys) throws SQLException Executes a query.- Parameters:
sql
- the queryfetchSize
- fetch sizeautoGeneratedKeys
- a flag indicating whether auto-generated keys should be returned; one ofStatement.RETURN_GENERATED_KEYS
orStatement.NO_GENERATED_KEYS
- Returns:
- true if there was a result set, false otherwise.
- Throws:
SQLException
- the error description
-
getTimeoutSql
-
testExecute
! This method is for test only ! This permit sending query using specific charset.- Parameters:
sql
- sqlcharset
- charset- Returns:
- boolean if execution went well
- Throws:
SQLException
- if any exception occur
-
execute
executes a query.- Specified by:
execute
in interfaceStatement
- Parameters:
sql
- the query- Returns:
- true if there was a result set, false otherwise.
- Throws:
SQLException
- if the query could not be sent to server
-
execute
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. The driver will ignore this signal if the SQL statement is not an
INSERT
statement, or an SQL statement able to return auto-generated keys (the list of such statements is vendor-specific).In some (uncommon) situations, a single SQL statement may return multiple result sets and/or update counts. Normally you can ignore this unless you are (1) executing a stored procedure that you know may return multiple results or (2) you are dynamically executing an unknown SQL string.
Theexecute
method executes an SQL statement and indicates the form of the first result. You must then use the methodsgetResultSet
orgetUpdateCount
to retrieve the result, andgetInternalMoreResults
to move to any subsequent result(s).- Specified by:
execute
in interfaceStatement
- Parameters:
sql
- any SQL statementautoGeneratedKeys
- a constant indicating whether auto-generated keys should be made available for retrieval using the methodgetGeneratedKeys
; one of the following constants:Statement.RETURN_GENERATED_KEYS
orStatement.NO_GENERATED_KEYS
- Returns:
true
if the first result is aResultSet
object;false
if it is an update count or there are no results- Throws:
SQLException
- if a database access error occurs, this method is called on a closedStatement
or the second parameter supplied to this method is notStatement.RETURN_GENERATED_KEYS
orStatement.NO_GENERATED_KEYS
.- See Also:
-
execute
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. This array contains the indexes of the columns in the target table that contain the auto-generated keys that should be made available. The driver will ignore the array if the SQL statement is not anINSERT
statement, or an SQL statement able to return auto-generated keys (the list of such statements is vendor-specific).Under some (uncommon) situations, a single SQL statement may return multiple result sets and/or update counts. Normally you can ignore this unless you are (1) executing a stored procedure that you know may return multiple results or (2) you are dynamically executing an unknown SQL string.
Theexecute
method executes an SQL statement and indicates the form of the first result. You must then use the methodsgetResultSet
orgetUpdateCount
to retrieve the result, andgetInternalMoreResults
to move to any subsequent result(s).- Specified by:
execute
in interfaceStatement
- Parameters:
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 methodgetGeneratedKeys
- Returns:
true
if the first result is aResultSet
object;false
if it is an update count or there are no results- Throws:
SQLException
- if a database access error occurs, this method is called on a closedStatement
or the elements in theint
array passed to this method are not valid column indexes- See Also:
-
execute
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. This array contains the names of the columns in the target table that contain the auto-generated keys that should be made available. The driver will ignore the array if the SQL statement is not an
INSERT
statement, or an SQL statement able to return auto-generated keys (the list of such statements is vendor-specific).In some (uncommon) situations, a single SQL statement may return multiple result sets and/or update counts. Normally you can ignore this unless you are (1) executing a stored procedure that you know may return multiple results or (2) you are dynamically executing an unknown SQL string.
The
execute
method executes an SQL statement and indicates the form of the first result. You must then use the methodsgetResultSet
orgetUpdateCount
to retrieve the result, andgetInternalMoreResults
to move to any subsequent result(s).- Specified by:
execute
in interfaceStatement
- Parameters:
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 methodgetGeneratedKeys
- Returns:
true
if the next result is aResultSet
object;false
if it is an update count or there are no more results- Throws:
SQLException
- if a database access error occurs, this method is called on a closedStatement
or the elements of theString
array passed to this method are not valid column names- See Also:
-
executeQuery
executes a select query.- Specified by:
executeQuery
in interfaceStatement
- Parameters:
sql
- the query to send to the server- Returns:
- a result set
- Throws:
SQLException
- if something went wrong
-
executeUpdate
Executes an update.- Specified by:
executeUpdate
in interfaceStatement
- Parameters:
sql
- the update query.- Returns:
- update count
- Throws:
SQLException
- if the query could not be sent to server.
-
executeUpdate
Executes the given SQL statement and signals the driver with the given flag about whether the auto-generated keys produced by thisStatement
object should be made available for retrieval. The driver will ignore the flag if the SQL statement is not anINSERT
statement, or an SQL statement able to return auto-generated keys (the list of such statements is vendor-specific).- Specified by:
executeUpdate
in interfaceStatement
- Parameters:
sql
- an SQL Data Manipulation Language (DML) statement, such asINSERT
,UPDATE
orDELETE
; or an SQL statement that returns nothing, such as a DDL statement.autoGeneratedKeys
- 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
- Returns:
- either (1) the row count for SQL Data Manipulation Language (DML) statements or (2) 0 for SQL statements that return nothing
- Throws:
SQLException
- if a database access error occurs, this method is called on a closedStatement
, the given SQL statement returns aResultSet
object, or the given constant is not one of those allowed
-
executeUpdate
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. This array contains the indexes of the columns in the target table that contain the auto-generated keys that should be made available. The driver will ignore the array if the SQL statement is not anINSERT
statement, or an SQL statement able to return auto-generated keys (the list of such statements is vendor-specific).- Specified by:
executeUpdate
in interfaceStatement
- Parameters:
sql
- an SQL Data Manipulation Language (DML) statement, such asINSERT
,UPDATE
orDELETE
; or an SQL statement that returns nothing, such as a DDL statement.columnIndexes
- an array of column indexes indicating the columns that should be returned from the inserted row- Returns:
- either (1) the row count for SQL Data Manipulation Language (DML) statements or (2) 0 for SQL statements that return nothing
- Throws:
SQLException
- if a database access error occurs, this method is called on a closedStatement
, the SQL statement returns aResultSet
object, or the second argument supplied to this method is not anint
array whose elements are valid column indexes
-
executeUpdate
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. This array contains the names of the columns in the target table that contain the auto-generated keys that should be made available. The driver will ignore the array if the SQL statement is not anINSERT
statement, or an SQL statement able to return auto-generated keys (the list of such statements is vendor-specific).- Specified by:
executeUpdate
in interfaceStatement
- Parameters:
sql
- an SQL Data Manipulation Language (DML) statement, such asINSERT
,UPDATE
orDELETE
; or an SQL statement that returns nothing, such as a DDL statement.columnNames
- an array of the names of the columns that should be returned from the inserted row- Returns:
- either the row count for
INSERT
,UPDATE
, orDELETE
statements, or 0 for SQL statements that return nothing - Throws:
SQLException
- if a database access error occurs, this method is called on a closedStatement
, the SQL statement returns aResultSet
object, or the second argument supplied to this method is not aString
array whose elements are valid column names
-
executeLargeUpdate
Executes the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement or an SQL statement that returns nothing, such as an SQL DDL statement. This method should be used when the returned row count may exceed Integer.MAX_VALUE.- Specified by:
executeLargeUpdate
in interfaceStatement
- Parameters:
sql
- sql command- Returns:
- update counts
- Throws:
SQLException
- if any error occur during execution
-
executeLargeUpdate
Identical to executeLargeUpdate(String sql), with a flag that indicate that autoGeneratedKeys (primary key fields with "auto_increment") generated id's must be retrieved.Those id's will be available using getGeneratedKeys() method.
- Specified by:
executeLargeUpdate
in interfaceStatement
- Parameters:
sql
- sql commandautoGeneratedKeys
- 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- Returns:
- update counts
- Throws:
SQLException
- if any error occur during execution
-
executeLargeUpdate
Identical to executeLargeUpdate(String sql, int autoGeneratedKeys) with autoGeneratedKeys = Statement.RETURN_GENERATED_KEYS set.- Specified by:
executeLargeUpdate
in interfaceStatement
- Parameters:
sql
- sql commandcolumnIndexes
- column Indexes- Returns:
- update counts
- Throws:
SQLException
- if any error occur during execution
-
executeLargeUpdate
Identical to executeLargeUpdate(String sql, int autoGeneratedKeys) with autoGeneratedKeys = Statement.RETURN_GENERATED_KEYS set.- Specified by:
executeLargeUpdate
in interfaceStatement
- Parameters:
sql
- sql commandcolumnNames
- columns names- Returns:
- update counts
- Throws:
SQLException
- if any error occur during execution
-
close
Releases thisStatement
object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed. It is generally good practice to release resources as soon as you are finished with them to avoid tying up database resources. Calling the methodclose
on aStatement
object that is already closed has no effect. Note:When aStatement
object is closed, its currentResultSet
object, if one exists, is also closed.- Specified by:
close
in interfaceAutoCloseable
- Specified by:
close
in interfaceStatement
- Throws:
SQLException
- if a database access error occurs
-
getMaxFieldSize
public int getMaxFieldSize()Retrieves the maximum number of bytes that can be returned for character and binary column values in aResultSet
object produced by thisStatement
object. This limit applies only toBINARY
,VARBINARY
,LONGVARBINARY
,CHAR
,VARCHAR
,NCHAR
,NVARCHAR
,LONGNVARCHAR
andLONGVARCHAR
columns. If the limit is exceeded, the excess data is silently discarded.- Specified by:
getMaxFieldSize
in interfaceStatement
- Returns:
- the current column size limit for columns storing character and binary values; zero means there is no limit
- See Also:
-
setMaxFieldSize
public void setMaxFieldSize(int max) Sets the limit for the maximum number of bytes that can be returned for character and binary column values in aResultSet
object produced by thisStatement
object. This limit applies only toBINARY
,VARBINARY
,LONGVARBINARY
,CHAR
,VARCHAR
,NCHAR
,NVARCHAR
,LONGNVARCHAR
andLONGVARCHAR
fields. If the limit is exceeded, the excess data is silently discarded. For maximum portability, use values greater than 256.- Specified by:
setMaxFieldSize
in interfaceStatement
- Parameters:
max
- the new column size limit in bytes; zero means there is no limit- See Also:
-
getMaxRows
public int getMaxRows()Retrieves the maximum number of rows that aResultSet
object produced by thisStatement
object can contain. If this limit is exceeded, the excess rows are silently dropped.- Specified by:
getMaxRows
in interfaceStatement
- Returns:
- the current maximum number of rows for a
ResultSet
object produced by thisStatement
object; zero means there is no limit - See Also:
-
setMaxRows
Sets the limit for the maximum number of rows that anyResultSet
object generated by thisStatement
object can contain to the given number. If the limit is exceeded, the excess rows are silently dropped.- Specified by:
setMaxRows
in interfaceStatement
- Parameters:
max
- the new max rows limit; zero means there is no limit- Throws:
SQLException
- if the condition max >= 0 is not satisfied- See Also:
-
getLargeMaxRows
public long getLargeMaxRows()Retrieves the maximum number of rows that a ResultSet object produced by this Statement object can contain. If this limit is exceeded, the excess rows are silently dropped.- Specified by:
getLargeMaxRows
in interfaceStatement
- Returns:
- the current maximum number of rows for a ResultSet object produced by this Statement object; zero means there is no limit
-
setLargeMaxRows
Sets the limit for the maximum number of rows that any ResultSet object generated by this Statement object can contain to the given number. If the limit is exceeded, the excess rows are silently dropped.- Specified by:
setLargeMaxRows
in interfaceStatement
- Parameters:
max
- the new max rows limit; zero means there is no limit- Throws:
SQLException
- if the condition max >= 0 is not satisfied
-
setEscapeProcessing
public void setEscapeProcessing(boolean enable) Sets escape processing on or off. If escape scanning is on (the default), the driver will do escape substitution before sending the SQL statement to the database. Note: Since prepared statements have usually been parsed prior to making this call, disabling escape processing forPreparedStatements
objects will have no effect.- Specified by:
setEscapeProcessing
in interfaceStatement
- Parameters:
enable
-true
to enable escape processing;false
to disable it
-
getQueryTimeout
public int getQueryTimeout()Retrieves the number of seconds the driver will wait for aStatement
object to execute. If the limit is exceeded, aSQLException
is thrown.- Specified by:
getQueryTimeout
in interfaceStatement
- Returns:
- the current query timeout limit in seconds; zero means there is no limit
- See Also:
-
setQueryTimeout
Sets the number of seconds the driver will wait for aStatement
object to execute to the given number of seconds. If the limit is exceeded, anSQLException
is thrown. A JDBC driver must apply this limit to theexecute
,executeQuery
andexecuteUpdate
methods.- Specified by:
setQueryTimeout
in interfaceStatement
- Parameters:
seconds
- the new query timeout limit in seconds; zero means there is no limit- Throws:
SQLException
- if a database access error occurs, this method is called on a closedStatement
or the condition seconds >= 0 is not satisfied- See Also:
-
setLocalInfileInputStream
Sets the inputStream that will be used for the next execute that uses "LOAD DATA LOCAL INFILE". The name specified as local file/URL will be ignored.- Parameters:
inputStream
- inputStream instance, that will be used to send data to server- Throws:
SQLException
- if statement is closed
-
cancel
Cancels thisStatement
object if both the DBMS and driver support aborting an SQL statement. This method can be used by one thread to cancel a statement that is being executed by another thread.In case there is result-set from this Statement that are still streaming data from server, will cancel streaming.
- Specified by:
cancel
in interfaceStatement
- Throws:
SQLException
- if a database access error occurs or this method is called on a closedStatement
-
getWarnings
Retrieves the first warning reported by calls on thisStatement
object. SubsequentStatement
object warnings will be chained to thisSQLWarning
object.The warning chain is automatically cleared each time a statement is (re)executed. This method may not be called on a closed
Statement
object; doing so will cause anSQLException
to be thrown.Note: If you are processing a
ResultSet
object, any warnings associated with reads on thatResultSet
object will be chained on it rather than on theStatement
object that produced it.- Specified by:
getWarnings
in interfaceStatement
- Returns:
- the first
SQLWarning
object ornull
if there are no warnings - Throws:
SQLException
- if a database access error occurs or this method is called on a closedStatement
-
clearWarnings
public void clearWarnings()Clears all the warnings reported on thisStatement
object. After a call to this method, the methodgetWarnings
will returnnull
until a new warning is reported for thisStatement
object.- Specified by:
clearWarnings
in interfaceStatement
-
setCursorName
Sets the SQL cursor name to the givenString
, which will be used by subsequentStatement
objectexecute
methods. This name can then be used in SQL positioned update or delete statements to identify the current row in theResultSet
object generated by this statement. If the database does not support positioned update/delete, this method is a noop. To insure that a cursor has the proper isolation level to support updates, the cursor'sSELECT
statement should have the formSELECT FOR UPDATE
. IfFOR UPDATE
is not present, positioned updates may fail.Note: By definition, the execution of positioned updates and deletes must be done by a different
Statement
object than the one that generated theResultSet
object being used for positioning. Also, cursor names must be unique within a connection.- Specified by:
setCursorName
in interfaceStatement
- Parameters:
name
- the new cursor name, which must be unique within a connection- Throws:
SQLException
- if a database access error occurs or this method is called on a closedStatement
-
getConnection
Gets the connection that created this statement.- Specified by:
getConnection
in interfaceStatement
- Returns:
- the connection
-
getGeneratedKeys
Retrieves any auto-generated keys created as a result of executing thisStatement
object. If thisStatement
object did not generate any keys, an emptyResultSet
object is returned.Note:If the columns which represent the auto-generated keys were not specified, the JDBC driver implementation will determine the columns which best represent the auto-generated keys.
- Specified by:
getGeneratedKeys
in interfaceStatement
- Returns:
- a
ResultSet
object containing the auto-generated key(s) generated by the execution of thisStatement
object - Throws:
SQLException
- if a database access error occurs or this method is called on a closedStatement
-
getResultSetHoldability
public int getResultSetHoldability()Retrieves the result set holdability forResultSet
objects generated by thisStatement
object.- Specified by:
getResultSetHoldability
in interfaceStatement
- Returns:
- either
ResultSet.HOLD_CURSORS_OVER_COMMIT
orResultSet.CLOSE_CURSORS_AT_COMMIT
- Since:
- 1.4
-
isClosed
public boolean isClosed()Retrieves whether thisStatement
object has been closed. AStatement
is closed if the method close has been called on it, or if it is automatically closed. -
isPoolable
public boolean isPoolable()Returns a value indicating whether theStatement
is poolable or not.- Specified by:
isPoolable
in interfaceStatement
- Returns:
true
if theStatement
is poolable;false
otherwise- Since:
- 1.6
- See Also:
-
setPoolable
public void setPoolable(boolean poolable) Requests that a
Statement
be pooled or not pooled. The value specified is a hint to the statement pool implementation indicating whether the applicaiton wants the statement to be pooled. It is up to the statement pool manager as to whether the hint is used.The poolable value of a statement is applicable to both internal statement caches implemented by the driver and external statement caches implemented by application servers and other applications.
By default, a
Statement
is not poolable when created, and aPreparedStatement
andCallableStatement
are poolable when created.- Specified by:
setPoolable
in interfaceStatement
- Parameters:
poolable
- requests that the statement be pooled if true and that the statement not be pooled if false- Since:
- 1.6
-
getResultSet
Retrieves the current result as a ResultSet object. This method should be called only once per result.- Specified by:
getResultSet
in interfaceStatement
- Returns:
- the current result as a ResultSet object or null if the result is an update count or there are no more results
- Throws:
SQLException
- if a database access error occurs or this method is called on a closed Statement
-
getUpdateCount
public int getUpdateCount()Retrieves the current result as an update count; if the result is a ResultSet object or there are no more results, -1 is returned. This method should be called only once per result.- Specified by:
getUpdateCount
in interfaceStatement
- Returns:
- the current result as an update count; -1 if the current result is a ResultSet object or there are no more results
-
getLargeUpdateCount
public long getLargeUpdateCount()Retrieves the current result as an update count; if the result is a ResultSet object or there are no more results, -1 is returned.- Specified by:
getLargeUpdateCount
in interfaceStatement
- Returns:
- last update count
-
skipMoreResults
- Throws:
SQLException
-
getMoreResults
Moves to this
There are no more results when the following is true:Statement
object's next result, returnstrue
if it is aResultSet
object, and implicitly closes any currentResultSet
object(s) obtained with the methodgetResultSet
.// stmt is a Statement object ((stmt.getInternalMoreResults() == false) && (stmt.getUpdateCount() == -1))
- Specified by:
getMoreResults
in interfaceStatement
- Returns:
true
if the next result is aResultSet
object;false
if it is an update count or there are no more results- Throws:
SQLException
- if a database access error occurs or this method is called on a closedStatement
- See Also:
-
getMoreResults
Moves to this
There are no more results when the following is true:Statement
object's next result, deals with any currentResultSet
object(s) according to the instructions specified by the given flag, and returnstrue
if the next result is aResultSet
object.// stmt is a Statement object ((stmt.getInternalMoreResults(current) == false) && (stmt.getUpdateCount() == -1))
- Specified by:
getMoreResults
in interfaceStatement
- Parameters:
current
- one of the followingStatement
constants indicating what should happen to currentResultSet
objects obtained using the methodgetResultSet
:Statement.CLOSE_CURRENT_RESULT
,Statement.KEEP_CURRENT_RESULT
, orStatement.CLOSE_ALL_RESULTS
- Returns:
true
if the next result is aResultSet
object;false
if it is an update count or there are no more results- Throws:
SQLException
- if a database access error occurs, this method is called on a closedStatement
or the argument supplied is not one of the following:Statement.CLOSE_CURRENT_RESULT
,Statement.KEEP_CURRENT_RESULT
orStatement.CLOSE_ALL_RESULTS
- See Also:
-
getFetchDirection
public int getFetchDirection()Retrieves the direction for fetching rows from database tables that is the default for result sets generated from thisStatement
object. If thisStatement
object has not set a fetch direction by calling the methodsetFetchDirection
, the return value is implementation-specific.- Specified by:
getFetchDirection
in interfaceStatement
- Returns:
- the default fetch direction for result sets generated from this
Statement
object - Since:
- 1.2
- See Also:
-
setFetchDirection
public void setFetchDirection(int direction) Gives the driver a hint as to the direction in which rows will be processed in
ResultSet
objects created using thisStatement
object. The default value isResultSet.FETCH_FORWARD
.Note that this method sets the default fetch direction for result sets generated by this
Statement
object. Each result set has its own methods for getting and setting its own fetch direction.- Specified by:
setFetchDirection
in interfaceStatement
- Parameters:
direction
- the initial direction for processing rows- Since:
- 1.2
- See Also:
-
getFetchSize
public int getFetchSize()Retrieves the number of result set rows that is the default fetch size forResultSet
objects generated from thisStatement
object. If thisStatement
object has not set a fetch size by calling the methodsetFetchSize
, the return value is implementation-specific.- Specified by:
getFetchSize
in interfaceStatement
- Returns:
- the default fetch size for result sets generated from this
Statement
object - See Also:
-
setFetchSize
Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed forResultSet
objects generated by thisStatement
. If the value specified is zero, then the hint is ignored. The default value is zero.- Specified by:
setFetchSize
in interfaceStatement
- Parameters:
rows
- the number of rows to fetch- Throws:
SQLException
- if a database access error occurs, this method is called on a closedStatement
or the conditionrows >= 0
is not satisfied.- See Also:
-
getResultSetConcurrency
public int getResultSetConcurrency()Retrieves the result set concurrency forResultSet
objects generated by thisStatement
object.- Specified by:
getResultSetConcurrency
in interfaceStatement
- Returns:
- either
ResultSet.CONCUR_READ_ONLY
orResultSet.CONCUR_UPDATABLE
- Since:
- 1.2
-
getResultSetType
public int getResultSetType()Retrieves the result set type forResultSet
objects generated by thisStatement
object.- Specified by:
getResultSetType
in interfaceStatement
- Returns:
- one of
ResultSet.TYPE_FORWARD_ONLY
,ResultSet.TYPE_SCROLL_INSENSITIVE
, orResultSet.TYPE_SCROLL_SENSITIVE
-
addBatch
Adds the given SQL command to the current list of commands for thisStatement
object. The send in this list can be executed as a batch by calling the methodexecuteBatch
.- Specified by:
addBatch
in interfaceStatement
- Parameters:
sql
- typically this is a SQLINSERT
orUPDATE
statement- Throws:
SQLException
- if a database access error occurs, this method is called on a closedStatement
or the driver does not support batch updates- See Also:
-
clearBatch
public void clearBatch()Empties thisStatement
object's current list of SQL send.- Specified by:
clearBatch
in interfaceStatement
- Since:
- 1.2
- See Also:
-
executeBatch
Execute statements. depending on option, queries mays be rewritten :those queries will be rewritten if possible to INSERT INTO ... VALUES (...) ; INSERT INTO ... VALUES (...);
if option rewriteBatchedStatements is set to true, rewritten to INSERT INTO ... VALUES (...), (...);
- Specified by:
executeBatch
in interfaceStatement
- Returns:
- an array of update counts containing one element for each command in the batch. The elements of the array are ordered according to the order in which send were added to the batch.
- Throws:
SQLException
- if a database access error occurs, this method is called on a closedStatement
or the driver does not support batch statements. ThrowsBatchUpdateException
(a subclass ofSQLException
) if one of the send sent to the database fails to execute properly or attempts to return a result set.- Since:
- 1.3
- See Also:
-
executeLargeBatch
Execute batch, like executeBatch(), with returning results with long[]. For when row count may exceed Integer.MAX_VALUE.- Specified by:
executeLargeBatch
in interfaceStatement
- Returns:
- an array of update counts (one element for each command in the batch)
- Throws:
SQLException
- if a database error occur.
-
internalBatchExecution
Internal batch execution.- Parameters:
size
- expected result-set size- Throws:
SQLException
- throw exception if batch error occur
-
unwrap
Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.
If the receiver implements the interface then the result is the receiver or a proxy for the receiver. If the receiver is a wrapper and the wrapped object implements the interface then the result is the wrapped object or a proxy for the wrapped object. Otherwise return the the result of calling
unwrap
recursively on the wrapped object or a proxy for that result. If the receiver is not a wrapper and does not implement the interface, then anSQLException
is thrown.- Specified by:
unwrap
in interfaceWrapper
- Parameters:
iface
- A Class defining an interface that the result must implement.- Returns:
- an object that implements the interface. May be a proxy for the actual implementing object.
- Throws:
SQLException
- If no object found that implements the interface- Since:
- 1.6
-
isWrapperFor
Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does. Returns false otherwise. If this implements the interface then return true, else if this is a wrapper then return the result of recursively callingisWrapperFor
on the wrapped object. If this does not implement the interface and is not a wrapper, return false. This method should be implemented as a low-cost operation compared tounwrap
so that callers can use this method to avoid expensiveunwrap
calls that may fail. If this method returns true then callingunwrap
with the same argument should succeed.- Specified by:
isWrapperFor
in interfaceWrapper
- Parameters:
interfaceOrWrapper
- a Class defining an interface.- Returns:
- true if this implements the interface or directly or indirectly wraps an object that does.
- Throws:
SQLException
- if an error occurs while determining whether this is a wrapper for an object with the given interface.- Since:
- 1.6
-
closeOnCompletion
public void closeOnCompletion()- Specified by:
closeOnCompletion
in interfaceStatement
-
isCloseOnCompletion
public boolean isCloseOnCompletion()- Specified by:
isCloseOnCompletion
in interfaceStatement
-
checkCloseOnCompletion
Check that close on completion is asked, and close if so.- Parameters:
resultSet
- resultSet- Throws:
SQLException
- if close has error
-
checkClose
Check if statement is closed, and throw exception if so.- Throws:
SQLException
- if statement close
-
getServerThreadId
public long getServerThreadId()Permit to retrieve current connection thread id, or -1 if unknown.- Returns:
- current connection thread id.
-