org.mariadb.jdbc

Class ClientSidePreparedStatement

java.lang.Object

org.mariadb.jdbc.MariaDbStatement

org.mariadb.jdbc.BasePrepareStatement

org.mariadb.jdbc.ClientSidePreparedStatement

All Implemented Interfaces:

java.lang.AutoCloseable, java.lang.Cloneable, java.sql.PreparedStatement, java.sql.Statement, java.sql.Wrapper

Direct Known Subclasses:

CallableFunctionStatement

public class ClientSidePreparedStatement
extends BasePrepareStatement

Field Summary

Fields

Modifier and Type	Field and Description
private static Logger	logger
private java.util.List<ParameterHolder[]>	parameterList
private java.sql.ParameterMetaData	parameterMetaData
private ParameterHolder[]	parameters
private ClientPrepareResult	prepareResult
private java.sql.ResultSetMetaData	resultSetMetaData
private java.lang.String	sqlQuery

Fields inherited from class org.mariadb.jdbc.BasePrepareStatement

autoGeneratedKeys, SPEC_ISO_ZONED_DATE_TIME

Fields inherited from class org.mariadb.jdbc.MariaDbStatement

canUseServerTimeout, closed, connection, exceptionFactory, executing, fetchSize, lock, maxRows, options, protocol, queryTimeout, results, resultSetConcurrency, resultSetScrollType

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 and Description
ClientSidePreparedStatement(MariaDbConnection connection, java.lang.String sql, int resultSetScrollType, int resultSetConcurrency, int autoGeneratedKeys, ExceptionFactory exceptionFactory) Constructor.

Method Summary

Modifier and Type	Method and Description
void	addBatch() Adds a set of parameters to this PreparedStatement object's batch of send.
void	addBatch(java.lang.String sql) Add batch.
void	clearBatch() Clear batch.
void	clearParameters() Clears the current parameter values immediately.
ClientSidePreparedStatement	clone(MariaDbConnection connection) Clone statement.
void	close() Releases this Statement object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
boolean	execute() Executes the SQL statement in this PreparedStatement object, which may be any kind of SQL statement.
int[]	executeBatch() {inheritdoc}.
protected boolean	executeInternal(int fetchSize)
private void	executeInternalBatch(int size) Choose better way to execute queries according to query and options.
long[]	executeLargeBatch() Execute batch, like executeBatch(), with returning results with long[].
java.sql.ResultSet	executeQuery() Executes the SQL query in this PreparedStatement object and returns the ResultSet object generated by the query.
int	executeUpdate() Executes the SQL statement in this PreparedStatement object, which must be an SQL Data Manipulation Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL statement that returns nothing, such as a DDL statement.
java.sql.ResultSetMetaData	getMetaData() Retrieves a ResultSetMetaData object that contains information about the columns of the ResultSet object that will be returned when this PreparedStatement object is executed.
protected int	getParameterCount()
java.sql.ParameterMetaData	getParameterMetaData() Retrieves the number, types and properties of this PreparedStatement object's parameters.
protected ClientPrepareResult	getPrepareResult()
int[]	getServerUpdateCounts() Non JDBC : Permit to retrieve server update counts when using option rewriteBatchedStatements.
private void	loadParametersData()
void	setParameter(int parameterIndex, ParameterHolder holder) Set parameter.
java.lang.String	toString() {inherit}.

Methods inherited from class org.mariadb.jdbc.BasePrepareStatement

executeLargeUpdate, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNull, setNull, setNull, setObject, setObject, setObject, setObject, setObject, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL

Methods inherited from class org.mariadb.jdbc.MariaDbStatement

cancel, checkClose, checkCloseOnCompletion, clearWarnings, closeOnCompletion, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, execute, execute, execute, execute, executeBatchEpilogue, executeBatchExceptionEpilogue, executeEpilogue, executeExceptionEpilogue, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeQuery, executeQueryPrologue, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isSimpleIdentifier, isWrapperFor, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setLocalInfileInputStream, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, setTimerTask, skipMoreResults, testExecute, unwrap

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface java.sql.Statement

cancel, clearWarnings, closeOnCompletion, execute, execute, execute, execute, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout

Methods inherited from interface java.sql.Wrapper

isWrapperFor, unwrap

Field Detail

logger

private static final Logger logger

parameterList

private final java.util.List<ParameterHolder[]> parameterList

prepareResult

private ClientPrepareResult prepareResult

sqlQuery

private java.lang.String sqlQuery

parameters

private ParameterHolder[] parameters

resultSetMetaData

private java.sql.ResultSetMetaData resultSetMetaData

parameterMetaData

private java.sql.ParameterMetaData parameterMetaData

Constructor Detail

ClientSidePreparedStatement

public ClientSidePreparedStatement(MariaDbConnection connection,
                                   java.lang.String sql,
                                   int resultSetScrollType,
                                   int resultSetConcurrency,
                                   int autoGeneratedKeys,
                                   ExceptionFactory exceptionFactory)
                            throws java.sql.SQLException

Constructor.

Parameters:

connection - connection

sql - sql query

resultSetScrollType - one of the following ResultSet constants: ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE

resultSetConcurrency - a concurrency type; one of ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE

autoGeneratedKeys - a flag indicating whether auto-generated keys should be returned; one of Statement.RETURN_GENERATED_KEYS or Statement.NO_GENERATED_KEYS

exceptionFactory - exception factory

Throws:

java.sql.SQLException - exception

Method Detail

clone

public ClientSidePreparedStatement clone(MariaDbConnection connection)
                                  throws java.lang.CloneNotSupportedException

Clone statement.

Overrides:

clone in class BasePrepareStatement

Parameters:

connection - connection

Returns:

Clone statement.

Throws:

java.lang.CloneNotSupportedException - if any error occur.

execute

public boolean execute()
                throws java.sql.SQLException

Executes the SQL statement in this PreparedStatement object, which may be any kind of SQL statement. Some prepared statements return multiple results; the execute method handles these complex statements as well as the simpler form of statements handled by the methods executeQuery and executeUpdate.
The execute method returns a boolean to indicate the form of the first result. You must call either the method getResultSet or getUpdateCount to retrieve the result; you must call getInternalMoreResults to move to any subsequent result(s).

Returns:

true if the first result is a ResultSet object; false if the first result is an update count or there is no result

Throws:

java.sql.SQLException - if a database access error occurs; this method is called on a closed PreparedStatement or an argument is supplied to this method

See Also:

Statement.execute(java.lang.String), Statement.getResultSet(), Statement.getUpdateCount(), Statement.getMoreResults()

executeQuery

public java.sql.ResultSet executeQuery()
                                throws java.sql.SQLException

Executes the SQL query in this PreparedStatement object and returns the ResultSet object generated by the query.

Returns:

a ResultSet object that contains the data produced by the query; never null

Throws:

java.sql.SQLException - if a database access error occurs; this method is called on a closed PreparedStatement or the SQL statement does not return a ResultSet object

executeUpdate

public int executeUpdate()
                  throws java.sql.SQLException

Executes the SQL statement in this PreparedStatement object, which must be an SQL Data Manipulation Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL statement that returns nothing, such as a DDL statement. Result-set are permitted for historical reason, even if spec indicate to throw exception.

Returns:

either (1) the row count for SQL Data Manipulation Language (DML) statements or (2) 0 for SQL statements that return nothing

Throws:

java.sql.SQLException - if a database access error occurs; this method is called on a closed PreparedStatement

executeInternal

protected boolean executeInternal(int fetchSize)
                           throws java.sql.SQLException

Specified by:

executeInternal in class BasePrepareStatement

Throws:

java.sql.SQLException

addBatch

public void addBatch()
              throws java.sql.SQLException

Adds a set of parameters to this PreparedStatement object's batch of send.

Throws:

java.sql.SQLException - if a database access error occurs or this method is called on a closed PreparedStatement

Since:

1.2

See Also:

Statement.addBatch(java.lang.String)

addBatch

public void addBatch(java.lang.String sql)
              throws java.sql.SQLException

Add batch.

Specified by:

addBatch in interface java.sql.Statement

Overrides:

addBatch in class MariaDbStatement

Parameters:

sql - typically this is a SQL INSERT or UPDATE statement

Throws:

java.sql.SQLException - every time since that method is forbidden on prepareStatement

See Also:

MariaDbStatement.executeBatch(), DatabaseMetaData.supportsBatchUpdates()

clearBatch

public void clearBatch()

Clear batch.

Specified by:

clearBatch in interface java.sql.Statement

Overrides:

clearBatch in class MariaDbStatement

See Also:

MariaDbStatement.addBatch(java.lang.String), DatabaseMetaData.supportsBatchUpdates()

executeBatch

public int[] executeBatch()
                   throws java.sql.SQLException

{inheritdoc}.

Specified by:

executeBatch in interface java.sql.Statement

Overrides:

executeBatch in class MariaDbStatement

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:

java.sql.SQLException - if a database access error occurs, this method is called on a closed Statement or the driver does not support batch statements. Throws BatchUpdateException (a subclass of SQLException) if one of the send sent to the database fails to execute properly or attempts to return a result set.

See Also:

MariaDbStatement.addBatch(java.lang.String), DatabaseMetaData.supportsBatchUpdates()

getServerUpdateCounts

public int[] getServerUpdateCounts()

Non JDBC : Permit to retrieve server update counts when using option rewriteBatchedStatements.

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.

executeLargeBatch

public long[] executeLargeBatch()
                         throws java.sql.SQLException

Execute batch, like executeBatch(), with returning results with long[]. For when row count may exceed Integer.MAX_VALUE.

Specified by:

executeLargeBatch in interface java.sql.Statement

Overrides:

executeLargeBatch in class MariaDbStatement

Returns:

an array of update counts (one element for each command in the batch)

Throws:

java.sql.SQLException - if a database error occur.

executeInternalBatch

private void executeInternalBatch(int size)
                           throws java.sql.SQLException

Choose better way to execute queries according to query and options.

Parameters:

size - parameters number

Throws:

java.sql.SQLException - if any error occur

getMetaData

public java.sql.ResultSetMetaData getMetaData()
                                       throws java.sql.SQLException

Retrieves a ResultSetMetaData object that contains information about the columns of the ResultSet object that will be returned when this PreparedStatement object is executed.
Because a PreparedStatement object is precompiled, it is possible to know about the ResultSet object that it will return without having to execute it. Consequently, it is possible to invoke the method getMetaData on a PreparedStatement object rather than waiting to execute it and then invoking the ResultSet.getMetaData method on the ResultSet object that is returned.

Returns:

the description of a ResultSet object's columns or null if the driver cannot return a ResultSetMetaData object

Throws:

java.sql.SQLException - if a database access error occurs or this method is called on a closed PreparedStatement

setParameter

public void setParameter(int parameterIndex,
                         ParameterHolder holder)
                  throws java.sql.SQLException

Set parameter.

Specified by:

setParameter in class BasePrepareStatement

Parameters:

parameterIndex - index

holder - parameter holder

Throws:

java.sql.SQLException - if index position doesn't correspond to query parameters

getParameterMetaData

public java.sql.ParameterMetaData getParameterMetaData()
                                                throws java.sql.SQLException

Retrieves the number, types and properties of this PreparedStatement object's parameters.

Specified by:

getParameterMetaData in interface java.sql.PreparedStatement

Specified by:

getParameterMetaData in class BasePrepareStatement

Returns:

a ParameterMetaData object that contains information about the number, types and properties for each parameter marker of this PreparedStatement object

Throws:

java.sql.SQLException - if a database access error occurs or this method is called on a closed PreparedStatement

Since:

1.4

See Also:

ParameterMetaData

loadParametersData

private void loadParametersData()
                         throws java.sql.SQLSyntaxErrorException

Throws:

java.sql.SQLSyntaxErrorException

clearParameters

public void clearParameters()

Clears the current parameter values immediately.

In general, parameter values remain in force for repeated use of a statement. Setting a parameter value automatically clears its previous value. However, in some cases it is useful to immediately release the resources used by the current parameter values; this can be done by calling the method clearParameters.

close

public void close()
           throws java.sql.SQLException

Description copied from class: MariaDbStatement

Releases this Statement 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 a Statement object that is already closed has no effect. Note:When a Statement object is closed, its current ResultSet object, if one exists, is also closed.

Specified by:

close in interface java.lang.AutoCloseable

Specified by:

close in interface java.sql.Statement

Overrides:

close in class MariaDbStatement

Throws:

java.sql.SQLException - if a database access error occurs

getParameterCount

protected int getParameterCount()

toString

public java.lang.String toString()

{inherit}.

Overrides:

toString in class java.lang.Object

getPrepareResult

protected ClientPrepareResult getPrepareResult()