Class Statement
- java.lang.Object
-
- org.mariadb.jdbc.Statement
-
- All Implemented Interfaces:
AutoCloseable
,Statement
,Wrapper
- Direct Known Subclasses:
BasePreparedStatement
public class Statement extends Object implements Statement
Statement implementation
-
-
Field Summary
Fields Modifier and Type Field Description protected int
autoGeneratedKeys
automatic generated keys result requiredprotected boolean
canUseServerMaxRows
can use server row limitationprotected boolean
canUseServerTimeout
can use server query timeoutprotected boolean
closed
closed flagprotected boolean
closeOnCompletion
close statement on resultset completionprotected Connection
con
connectionprotected org.mariadb.jdbc.client.Completion
currResult
current resultsprotected boolean
escape
escape processingprotected int
fetchSize
fetch sizeprotected InputStream
localInfileInputStream
streaming load data infile dataprotected ReentrantLock
lock
thread safe lockerprotected long
maxRows
maximum row numberprotected int
queryTimeout
required query timeoutprotected List<org.mariadb.jdbc.client.Completion>
results
last execution resultsprotected int
resultSetConcurrency
concurrencyprotected int
resultSetType
result-set type-
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
Constructors Constructor Description Statement(Connection con, ReentrantLock lock, boolean canUseServerTimeout, boolean canUseServerMaxRows, int autoGeneratedKeys, int resultSetType, int resultSetConcurrency, int defaultFetchSize)
Constructor
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description void
abort()
Abort current command result if streaming.void
addBatch(String sql)
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
checkNotClosed()
Check if statement is closed, and throw exception if so.void
clearBatch()
Empties thisStatement
object's current list of SQL commands.void
clearWarnings()
Clears all the warnings reported on thisStatement
object.void
close()
Releases thisStatement
object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.void
closeOnCompletion()
Specifies that thisStatement
will be closed when all its dependent result sets are closed.String
enquoteIdentifier(String identifier, boolean alwaysQuote)
Escaped identifier according to MariaDB requirement.String
enquoteLiteral(String val)
Enquote String value.String
enquoteNCharLiteral(String val)
Enquote utf8 value.protected String
escapeTimeout(String sql)
Build sql command to execute : Execute escape substitution if needed add query timeout prefix if server permits it add max row limit prefix if server permits itboolean
execute(String sql)
Executes the given SQL statement, which may return multiple results.boolean
execute(String sql, int autoGeneratedKeys)
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(String sql, int[] columnIndexes)
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(String sql, String[] columnNames)
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()
Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.List<org.mariadb.jdbc.client.Completion>
executeInternalBatchPipeline()
Execute batch pipelining commands (sending all client message, then reading results) (batches cannot contain results-set, so cannot fill receiving socket buffer while sending buffer is full)List<org.mariadb.jdbc.client.Completion>
executeInternalBatchStandard()
basic implementation Send batch query per query.long[]
executeLargeBatch()
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.ResultSet
executeQuery(String sql)
Executes the given SQL statement, which returns a singleResultSet
object.int
executeUpdate(String sql)
Executes the given SQL statement, which may be anINSERT
,UPDATE
, orDELETE
statement or an SQL statement that returns nothing, such as an SQL DDL statement.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.void
fetchRemaining()
Permit to streaming result to fetch remaining results.Connection
getConnection()
Retrieves theConnection
object that produced thisStatement
object.int
getFetchDirection()
Retrieves the direction for fetching rows from database tables that is the default for result sets generated from thisStatement
object.int
getFetchSize()
Retrieves the number of result set rows that is the default fetch size forResultSet
objects generated from thisStatement
object.ResultSet
getGeneratedKeys()
Retrieves any auto-generated keys created as a result of executing thisStatement
object.long
getLargeMaxRows()
Retrieves the maximum number of rows that a ResultSet object produced by this Statement object can contain.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.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.int
getMaxRows()
Retrieves the maximum number of rows that aResultSet
object produced by thisStatement
object can contain.boolean
getMoreResults()
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
getQueryTimeout()
Retrieves the number of seconds the driver will wait for aStatement
object to execute.ResultSet
getResultSet()
Retrieves the current result as aResultSet
object.int
getResultSetConcurrency()
Retrieves the result set concurrency forResultSet
objects generated by thisStatement
object.int
getResultSetHoldability()
Retrieves the result set holdability forResultSet
objects generated by thisStatement
object.int
getResultSetType()
Retrieves the result set type forResultSet
objects generated by thisStatement
object.int
getUpdateCount()
Retrieves the current result as an update count; if the result is aResultSet
object or there are no more results, -1 is returned.SQLWarning
getWarnings()
Retrieves the first warning reported by calls on thisStatement
object.boolean
isClosed()
Retrieves whether thisStatement
object has been closed.boolean
isCloseOnCompletion()
Returns a value indicating whether thisStatement
will be closed when all its dependent result sets are closed.boolean
isPoolable()
Returns a value indicating whether theStatement
is poolable or not.boolean
isSimpleIdentifier(String identifier)
Retrieves whether identifier is a simple SQL identifier.boolean
isWrapperFor(Class<?> iface)
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)
Set current local infile streamvoid
setMaxFieldSize(int max)
NOT SUPPORTED.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.<T> T
unwrap(Class<T> iface)
Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.
-
-
-
Field Detail
-
resultSetType
protected final int resultSetType
result-set type
-
resultSetConcurrency
protected final int resultSetConcurrency
concurrency
-
lock
protected final ReentrantLock lock
thread safe locker
-
canUseServerTimeout
protected final boolean canUseServerTimeout
can use server query timeout
-
canUseServerMaxRows
protected final boolean canUseServerMaxRows
can use server row limitation
-
con
protected final Connection con
connection
-
queryTimeout
protected int queryTimeout
required query timeout
-
maxRows
protected long maxRows
maximum row number
-
fetchSize
protected int fetchSize
fetch size
-
autoGeneratedKeys
protected int autoGeneratedKeys
automatic generated keys result required
-
closeOnCompletion
protected boolean closeOnCompletion
close statement on resultset completion
-
closed
protected boolean closed
closed flag
-
escape
protected boolean escape
escape processing
-
results
protected List<org.mariadb.jdbc.client.Completion> results
last execution results
-
currResult
protected org.mariadb.jdbc.client.Completion currResult
current results
-
localInfileInputStream
protected InputStream localInfileInputStream
streaming load data infile data
-
-
Constructor Detail
-
Statement
public Statement(Connection con, ReentrantLock lock, boolean canUseServerTimeout, boolean canUseServerMaxRows, int autoGeneratedKeys, int resultSetType, int resultSetConcurrency, int defaultFetchSize)
Constructor- Parameters:
con
- connectionlock
- thread safe lockercanUseServerTimeout
- can use server timeoutcanUseServerMaxRows
- can use server row number limitationautoGeneratedKeys
- automatic generated keys result requiredresultSetType
- result-set typeresultSetConcurrency
- concurrencydefaultFetchSize
- fetch size
-
-
Method Detail
-
setLocalInfileInputStream
public void setLocalInfileInputStream(InputStream inputStream) throws SQLException
Set current local infile stream- Parameters:
inputStream
- stream- Throws:
SQLException
- if statement is already closed
-
executeQuery
public ResultSet executeQuery(String sql) throws SQLException
Executes the given SQL statement, which returns a singleResultSet
object.Note:This method cannot be called on a
PreparedStatement
orCallableStatement
.- Specified by:
executeQuery
in interfaceStatement
- Parameters:
sql
- an SQL statement to be sent to the database, typically a static SQLSELECT
statement- Returns:
- a
ResultSet
object that contains the data produced by the given query; nevernull
- Throws:
SQLException
- if a database access error occurs, this method is called on a closedStatement
, the given SQL statement produces anything other than a singleResultSet
object, the method is called on aPreparedStatement
orCallableStatement
SQLTimeoutException
- when the driver has determined that the timeout value that was specified by thesetQueryTimeout
method has been exceeded and has at least attempted to cancel the currently runningStatement
-
executeUpdate
public int executeUpdate(String sql) throws SQLException
Executes the given SQL statement, which may be anINSERT
,UPDATE
, orDELETE
statement or an SQL statement that returns nothing, such as an SQL DDL statement.Note:This method cannot be called on a
PreparedStatement
orCallableStatement
.- 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.- 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 produces aResultSet
object, the method is called on aPreparedStatement
orCallableStatement
SQLTimeoutException
- when the driver has determined that the timeout value that was specified by thesetQueryTimeout
method has been exceeded and has at least attempted to cancel the currently runningStatement
-
close
public void close() throws SQLException
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 method
close
on aStatement
object that is already closed has no effect.Note:When a
Statement
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
-
abort
public void abort()
Abort current command result if streaming. result-set will be incomplete and closed, but ensure connection state
-
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(int)
-
setMaxFieldSize
public void setMaxFieldSize(int max)
NOT SUPPORTED.- Specified by:
setMaxFieldSize
in interfaceStatement
- See Also:
getMaxFieldSize()
-
getMaxRows
public int getMaxRows() throws SQLException
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 - Throws:
SQLException
- if a database access error occurs or this method is called on a closedStatement
- See Also:
setMaxRows(int)
-
setMaxRows
public void setMaxRows(int max) throws SQLException
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 a database access error occurs, this method is called on a closedStatement
or the conditionmax >= 0
is not satisfied- See Also:
getMaxRows()
-
setEscapeProcessing
public void setEscapeProcessing(boolean enable) throws SQLException
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.The
Connection
andDataSource
propertyescapeProcessing
may be used to change the default escape processing behavior. A value of true (the default) enables escape Processing for allStatement
objects. A value of false disables escape processing for allStatement
objects. ThesetEscapeProcessing
method may be used to specify the escape processing behavior for an individualStatement
object.Note: Since prepared statements have usually been parsed prior to making this call, disabling escape processing for
PreparedStatements
objects will have no effect.- Specified by:
setEscapeProcessing
in interfaceStatement
- Parameters:
enable
-true
to enable escape processing;false
to disable it- Throws:
SQLException
- if a database access error occurs or this method is called on a closedStatement
-
getQueryTimeout
public int getQueryTimeout() throws SQLException
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
- Throws:
SQLException
- if a database access error occurs or this method is called on a closedStatement
- See Also:
setQueryTimeout(int)
-
setQueryTimeout
public void setQueryTimeout(int seconds) throws SQLException
Sets the number of seconds the driver will wait for aStatement
object to execute to the given number of seconds. By default, there is no limit on the amount of time allowed for a running statement to complete. If the limit is exceeded, anSQLTimeoutException
is thrown. A JDBC driver must apply this limit to theexecute
,executeQuery
andexecuteUpdate
methods.Note: JDBC driver implementations may also apply this limit to
ResultSet
methods (consult your driver vendor documentation for details).Note: In the case of
Statement
batching, it is implementation defined whether the time-out is applied to individual SQL commands added via theaddBatch
method or to the entire batch of SQL commands invoked by theexecuteBatch
method (consult your driver vendor documentation for details).- 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 conditionseconds >= 0
is not satisfied- See Also:
getQueryTimeout()
-
cancel
public void cancel() throws SQLException
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.- Specified by:
cancel
in interfaceStatement
- Throws:
SQLException
- if a database access error occurs or this method is called on a closedStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method
-
getWarnings
public SQLWarning getWarnings() throws SQLException
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
public void setCursorName(String name) throws SQLException
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 ensure 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
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method
-
execute
public boolean execute(String sql) throws SQLException
Executes the given SQL statement, which may return multiple results. 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, andgetMoreResults
to move to any subsequent result(s).Note:This method cannot be called on a
PreparedStatement
orCallableStatement
.- Specified by:
execute
in interfaceStatement
- Parameters:
sql
- any SQL statement- 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
, the method is called on aPreparedStatement
orCallableStatement
SQLTimeoutException
- when the driver has determined that the timeout value that was specified by thesetQueryTimeout
method has been exceeded and has at least attempted to cancel the currently runningStatement
- See Also:
getResultSet()
,getUpdateCount()
,getMoreResults()
-
getResultSet
public ResultSet getResultSet() throws SQLException
Retrieves the current result as aResultSet
object. This method should be called only once per result.- Specified by:
getResultSet
in interfaceStatement
- Returns:
- the current result as a
ResultSet
object ornull
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 closedStatement
- See Also:
execute(java.lang.String)
-
getUpdateCount
public int getUpdateCount() throws SQLException
Retrieves the current result as an update count; if the result is aResultSet
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 - Throws:
SQLException
- if a database access error occurs or this method is called on a closedStatement
- See Also:
execute(java.lang.String)
-
getMoreResults
public boolean getMoreResults() throws SQLException
Moves to thisStatement
object's next result, returnstrue
if it is aResultSet
object, and implicitly closes any currentResultSet
object(s) obtained with the methodgetResultSet
.There are no more results when the following is true:
// stmt is a Statement object ((stmt.getMoreResults() == 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:
execute(java.lang.String)
-
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(int)
-
setFetchDirection
public 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. 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
-
getFetchSize
public int getFetchSize() throws SQLException
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 - Throws:
SQLException
- if a database access error occurs or this method is called on a closedStatement
- See Also:
setFetchSize(int)
-
setFetchSize
public void setFetchSize(int rows) throws SQLException
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.- Since:
- 1.2
- See Also:
getFetchSize()
-
getResultSetConcurrency
public int getResultSetConcurrency() throws SQLException
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
- Throws:
SQLException
- if a database access error occurs or this method is called on a closedStatement
-
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
- Since:
- 1.2
-
addBatch
public void addBatch(String sql) throws SQLException
Adds the given SQL command to the current list of commands for thisStatement
object. The commands in this list can be executed as a batch by calling the methodexecuteBatch
.Note:This method cannot be called on a
PreparedStatement
orCallableStatement
.- Specified by:
addBatch
in interfaceStatement
- Parameters:
sql
- typically this is an SQLINSERT
orUPDATE
statement- Throws:
SQLException
- if a database access error occurs, this method is called on a closedStatement
, the driver does not support batch updates, the method is called on aPreparedStatement
orCallableStatement
- See Also:
executeBatch()
,DatabaseMetaData.supportsBatchUpdates()
-
clearBatch
public void clearBatch() throws SQLException
Empties thisStatement
object's current list of SQL commands.- Specified by:
clearBatch
in interfaceStatement
- Throws:
SQLException
- if a database access error occurs, this method is called on a closedStatement
or the driver does not support batch updates- Since:
- 1.2
- See Also:
addBatch(java.lang.String)
,DatabaseMetaData.supportsBatchUpdates()
-
executeBatch
public int[] executeBatch() throws SQLException
Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts. Theint
elements of the array that is returned are ordered to correspond to the commands in the batch, which are ordered according to the order in which they were added to the batch. The elements in the array returned by the methodexecuteBatch
may be one of the following:- A number greater than or equal to zero -- indicates that the command was processed successfully and is an update count giving the number of rows in the database that were affected by the command's execution
- A value of
SUCCESS_NO_INFO
-- indicates that the command was processed successfully but that the number of rows affected is unknownIf one of the commands in a batch update fails to execute properly, this method throws a
BatchUpdateException
, and a JDBC driver may or may not continue to process the remaining commands in the batch. However, the driver's behavior must be consistent with a particular DBMS, either always continuing to process commands or never continuing to process commands. If the driver continues processing after a failure, the array returned by the methodBatchUpdateException.getUpdateCounts
will contain as many elements as there are commands in the batch, and at least one of the elements will be the following: - A value of
EXECUTE_FAILED
-- indicates that the command failed to execute successfully and occurs only if a driver continues to process commands after a command fails
The possible implementations and return values have been modified in the Java 2 SDK, Standard Edition, version 1.3 to accommodate the option of continuing to process commands in a batch update after a
BatchUpdateException
object has been thrown.- 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 commands 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 commands sent to the database fails to execute properly or attempts to return a result set.SQLTimeoutException
- when the driver has determined that the timeout value that was specified by thesetQueryTimeout
method has been exceeded and has at least attempted to cancel the currently runningStatement
- Since:
- 1.2
- See Also:
addBatch(java.lang.String)
,DatabaseMetaData.supportsBatchUpdates()
-
getConnection
public Connection getConnection() throws SQLException
Retrieves theConnection
object that produced thisStatement
object.- Specified by:
getConnection
in interfaceStatement
- Returns:
- the connection that produced this statement
- Throws:
SQLException
- if a database access error occurs or this method is called on a closedStatement
- Since:
- 1.2
-
getMoreResults
public boolean getMoreResults(int current) throws SQLException
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.There are no more results when the following is true:
// stmt is a Statement object ((stmt.getMoreResults(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
SQLFeatureNotSupportedException
- ifDatabaseMetaData.supportsMultipleOpenResults
returnsfalse
and eitherStatement.KEEP_CURRENT_RESULT
orStatement.CLOSE_ALL_RESULTS
are supplied as the argument.- Since:
- 1.4
- See Also:
execute(java.lang.String)
-
fetchRemaining
public void fetchRemaining() throws SQLException
Permit to streaming result to fetch remaining results.- Throws:
SQLException
- if socket error occurs.
-
getGeneratedKeys
public ResultSet getGeneratedKeys() throws SQLException
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
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method- Since:
- 1.4
-
executeUpdate
public int executeUpdate(String sql, int autoGeneratedKeys) throws SQLException
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).Note:This method cannot be called on a
PreparedStatement
orCallableStatement
.- 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, the given constant is not one of those allowed, the method is called on aPreparedStatement
orCallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method with a constant of Statement.RETURN_GENERATED_KEYSSQLTimeoutException
- when the driver has determined that the timeout value that was specified by thesetQueryTimeout
method has been exceeded and has at least attempted to cancel the currently runningStatement
- Since:
- 1.4
-
executeUpdate
public int executeUpdate(String sql, int[] columnIndexes) throws SQLException
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).Note:This method cannot be called on a
PreparedStatement
orCallableStatement
.- 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,the second argument supplied to this method is not anint
array whose elements are valid column indexes, the method is called on aPreparedStatement
orCallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodSQLTimeoutException
- when the driver has determined that the timeout value that was specified by thesetQueryTimeout
method has been exceeded and has at least attempted to cancel the currently runningStatement
- Since:
- 1.4
-
executeUpdate
public int executeUpdate(String sql, String[] columnNames) throws SQLException
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).Note:This method cannot be called on a
PreparedStatement
orCallableStatement
.- 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, the second argument supplied to this method is not aString
array whose elements are valid column names, the method is called on aPreparedStatement
orCallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodSQLTimeoutException
- when the driver has determined that the timeout value that was specified by thesetQueryTimeout
method has been exceeded and has at least attempted to cancel the currently runningStatement
- Since:
- 1.4
-
execute
public boolean execute(String sql, int autoGeneratedKeys) throws SQLException
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 anINSERT
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, andgetMoreResults
to move to any subsequent result(s).Note:This method cannot be called on a
PreparedStatement
orCallableStatement
.- 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
, the second parameter supplied to this method is notStatement.RETURN_GENERATED_KEYS
orStatement.NO_GENERATED_KEYS
, the method is called on aPreparedStatement
orCallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this method with a constant of Statement.RETURN_GENERATED_KEYSSQLTimeoutException
- when the driver has determined that the timeout value that was specified by thesetQueryTimeout
method has been exceeded and has at least attempted to cancel the currently runningStatement
- Since:
- 1.4
- See Also:
getResultSet()
,getUpdateCount()
,getMoreResults()
,getGeneratedKeys()
-
escapeTimeout
protected String escapeTimeout(String sql) throws SQLException
Build sql command to execute :- Execute escape substitution if needed
- add query timeout prefix if server permits it
- add max row limit prefix if server permits it
- Parameters:
sql
- sql command- Returns:
- sql command to execute
- Throws:
SQLException
- if fails to escape sql
-
execute
public boolean execute(String sql, int[] columnIndexes) throws SQLException
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.
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, andgetMoreResults
to move to any subsequent result(s).Note:This method cannot be called on a
PreparedStatement
orCallableStatement
.- 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
, the elements in theint
array passed to this method are not valid column indexes, the method is called on aPreparedStatement
orCallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodSQLTimeoutException
- when the driver has determined that the timeout value that was specified by thesetQueryTimeout
method has been exceeded and has at least attempted to cancel the currently runningStatement
- Since:
- 1.4
- See Also:
getResultSet()
,getUpdateCount()
,getMoreResults()
-
execute
public boolean execute(String sql, String[] columnNames) throws SQLException
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 anINSERT
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, andgetMoreResults
to move to any subsequent result(s).Note:This method cannot be called on a
PreparedStatement
orCallableStatement
.- 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
,the elements of theString
array passed to this method are not valid column names, the method is called on aPreparedStatement
orCallableStatement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodSQLTimeoutException
- when the driver has determined that the timeout value that was specified by thesetQueryTimeout
method has been exceeded and has at least attempted to cancel the currently runningStatement
- Since:
- 1.4
- See Also:
getResultSet()
,getUpdateCount()
,getMoreResults()
,getGeneratedKeys()
-
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() throws SQLException
Returns a value indicating whether theStatement
is poolable or not.- Specified by:
isPoolable
in interfaceStatement
- Returns:
true
if theStatement
is poolable;false
otherwise- Throws:
SQLException
- if this method is called on a closedStatement
- See Also:
setPoolable(boolean)
-
setPoolable
public void setPoolable(boolean poolable) throws SQLException
Requests that aStatement
be pooled or not pooled. The value specified is a hint to the statement pool implementation indicating whether the application wants the statement to be pooled. It is up to the statement pool manager 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- Throws:
SQLException
- if this method is called on a closedStatement
-
closeOnCompletion
public void closeOnCompletion() throws SQLException
Specifies that thisStatement
will be closed when all its dependent result sets are closed. If execution of theStatement
does not produce any result sets, this method has no effect.Note: Multiple calls to
closeOnCompletion
do not toggle the effect on thisStatement
. However, a call tocloseOnCompletion
does affect both the subsequent execution of statements, and statements that currently have open, dependent, result sets.- Specified by:
closeOnCompletion
in interfaceStatement
- Throws:
SQLException
- if this method is called on a closedStatement
-
isCloseOnCompletion
public boolean isCloseOnCompletion() throws SQLException
Returns a value indicating whether thisStatement
will be closed when all its dependent result sets are closed.- Specified by:
isCloseOnCompletion
in interfaceStatement
- Returns:
true
if theStatement
will be closed when all of its dependent result sets are closed;false
otherwise- Throws:
SQLException
- if this method is called on a closedStatement
-
unwrap
public <T> T unwrap(Class<T> iface) throws SQLException
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 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. Maybe a proxy for the actual implementing object.
- Throws:
SQLException
- If no object found that implements the interface
-
isWrapperFor
public boolean isWrapperFor(Class<?> iface)
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:
iface
- a Class defining an interface.- Returns:
- true if this implements the interface or directly or indirectly wraps an object that does.
-
checkNotClosed
protected void checkNotClosed() throws SQLException
Check if statement is closed, and throw exception if so.- Throws:
SQLException
- if statement close
-
executeLargeUpdate
public long executeLargeUpdate(String sql) throws SQLException
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
public long executeLargeUpdate(String sql, int autoGeneratedKeys) throws SQLException
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
public long executeLargeUpdate(String sql, int[] columnIndexes) throws SQLException
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
public long executeLargeUpdate(String sql, String[] columnNames) throws SQLException
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
-
getLargeMaxRows
public long getLargeMaxRows() throws SQLException
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
- Throws:
SQLException
- if this method is called on a closed Statement
-
setLargeMaxRows
public void setLargeMaxRows(long max) throws SQLException
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
-
getLargeUpdateCount
public long getLargeUpdateCount() throws SQLException
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
- Throws:
SQLException
- if this method is called on a closed Statement
-
executeLargeBatch
public long[] executeLargeBatch() throws SQLException
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.
-
executeInternalBatchPipeline
public List<org.mariadb.jdbc.client.Completion> executeInternalBatchPipeline() throws SQLException
Execute batch pipelining commands (sending all client message, then reading results) (batches cannot contain results-set, so cannot fill receiving socket buffer while sending buffer is full)- Returns:
- results
- Throws:
SQLException
- if any error occurs
-
executeInternalBatchStandard
public List<org.mariadb.jdbc.client.Completion> executeInternalBatchStandard() throws SQLException
basic implementation Send batch query per query.- Returns:
- results
- Throws:
SQLException
- if any error occurs
-
enquoteLiteral
public String enquoteLiteral(String val)
Enquote String value.- Specified by:
enquoteLiteral
in interfaceStatement
- Parameters:
val
- string value to enquote- Returns:
- enquoted string value
-
enquoteIdentifier
public String enquoteIdentifier(String identifier, boolean alwaysQuote) throws SQLException
Escaped identifier according to MariaDB requirement.- Specified by:
enquoteIdentifier
in interfaceStatement
- Parameters:
identifier
- identifieralwaysQuote
- indicate if identifier must be enquoted even if not necessary.- Returns:
- return escaped identifier, quoted when necessary or indicated with alwaysQuote.
- Throws:
SQLException
- if containing u0000 character- See Also:
- mariadb identifier name
-
isSimpleIdentifier
public boolean isSimpleIdentifier(String identifier)
Retrieves whether identifier is a simple SQL identifier. The first character is an alphabetic character from a through z, or from A through Z The string only contains alphanumeric characters or the characters "_" and "$"- Specified by:
isSimpleIdentifier
in interfaceStatement
- Parameters:
identifier
- identifier- Returns:
- true if identifier doesn't have to be quoted
- See Also:
- mariadb identifier name
-
enquoteNCharLiteral
public String enquoteNCharLiteral(String val)
Enquote utf8 value.- Specified by:
enquoteNCharLiteral
in interfaceStatement
- Parameters:
val
- value to enquote- Returns:
- enquoted String value
-
-