com.mysql.cj.jdbc

Class ClientPreparedStatement

java.lang.Object

com.mysql.cj.jdbc.StatementImpl

com.mysql.cj.jdbc.ClientPreparedStatement

All Implemented Interfaces:

JdbcPreparedStatement, JdbcStatement, Query, java.lang.AutoCloseable, java.sql.PreparedStatement, java.sql.Statement, java.sql.Wrapper

Direct Known Subclasses:

CallableStatement, ServerPreparedStatement

public class ClientPreparedStatement
extends StatementImpl
implements JdbcPreparedStatement

A SQL Statement is pre-compiled and stored in a PreparedStatement object. This object can then be used to efficiently execute this statement multiple times.

Note: The setXXX methods for setting IN parameter values must specify types that are compatible with the defined SQL type of the input parameter. For instance, if the IN parameter has SQL type Integer, then setInt should be used.

If arbitrary parameter type conversions are required, then the setObject method should be used with a target SQL type.

Nested Class Summary

Nested classes/interfaces inherited from interface com.mysql.cj.Query

Query.CancelStatus

Field Summary

Fields

Modifier and Type	Field and Description
protected java.lang.String	batchedValuesClause
protected boolean	batchHasPlainStatements Does the batch (if any) contain "plain" statements added by Statement.addBatch(String)? If so, we can't re-write it to use multi-value or multi-queries.
protected MysqlParameterMetadata	parameterMetaData
protected int	rewrittenBatchSize

Fields inherited from class com.mysql.cj.jdbc.StatementImpl

batchedGeneratedKeys, charEncoding, commandBuilder, connection, continueBatchOnError, doEscapeProcessing, dontCheckOnDuplicateKeyUpdateInSQL, dontTrackOpenResources, dumpQueriesOnException, exceptionInterceptor, generatedKeysResults, holdResultsOpenOverClose, isClosed, lastInsertId, lastQueryIsOnDupKeyUpdate, logSlowQueries, maxAllowedPacket, maxFieldSize, maxRows, openResults, pedantic, PING_MARKER, pingTarget, profileSQL, query, results, resultSetConcurrency, resultSetFactory, retrieveGeneratedKeys, rewriteBatchedStatements, sendFractionalSeconds, session, updateCount, USES_VARIABLES_FALSE, USES_VARIABLES_TRUE, USES_VARIABLES_UNKNOWN, useUsageAdvisor, warningChain

Fields inherited from interface com.mysql.cj.jdbc.JdbcStatement

MAX_ROWS

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

Modifier	Constructor and Description
protected	ClientPreparedStatement(JdbcConnection conn, java.lang.String db) Constructor used by server-side prepared statements
	ClientPreparedStatement(JdbcConnection conn, java.lang.String sql, java.lang.String db) Constructor for the PreparedStatement class.
	ClientPreparedStatement(JdbcConnection conn, java.lang.String sql, java.lang.String db, ParseInfo cachedParseInfo) Creates a new PreparedStatement object.

Method Summary

Modifier and Type	Method and Description
void	addBatch()
void	addBatch(java.lang.String sql)
java.lang.String	asSql()
java.lang.String	asSql(boolean quoteStreamsAndUnknowns)
protected void	checkBounds(int paramIndex, int parameterIndexOffset)
protected boolean	checkReadOnlySafeStatement() Check to see if the statement is safe for read-only slaves after failover.
void	clearBatch()
void	clearParameters()
protected boolean	containsOnDuplicateKeyUpdateInSQL()
boolean	execute()
protected long[]	executeBatchedInserts(int batchTimeout) Rewrites the already prepared statement into a multi-value insert statement of 'statementsPerBatch' values and executes the entire batch using this new statement.
protected long[]	executeBatchInternal()
protected long[]	executeBatchSerially(int batchTimeout) Executes the current batch of statements by executing them one-by-one.
protected <M extends Message> ResultSetInternalMethods	executeInternal(int maxRowsToRetrieve, M sendPacket, boolean createStreamingResultSet, boolean queryIsSelectOnly, ColumnDefinition metadata, boolean isBatch) Actually execute the prepared statement.
long	executeLargeUpdate()
protected long[]	executePreparedBatchAsMultiStatement(int batchTimeout) Rewrites the already prepared statement into a multi-statement query of 'statementsPerBatch' values and executes the entire batch using this new statement.
java.sql.ResultSet	executeQuery()
int	executeUpdate()
protected long	executeUpdateInternal(boolean clearBatchedGeneratedKeysAndWarnings, boolean isBatch)
protected long	executeUpdateInternal(QueryBindings<?> bindings, boolean isReallyBatch) Added to allow batch-updates
byte[]	getBytesRepresentation(int parameterIndex)
protected int	getCoreParameterIndex(int paramIndex)
protected static ClientPreparedStatement	getInstance(JdbcConnection conn, java.lang.String sql, java.lang.String db) Creates a prepared statement instance
protected static ClientPreparedStatement	getInstance(JdbcConnection conn, java.lang.String sql, java.lang.String db, ParseInfo cachedParseInfo) Creates a prepared statement instance
java.sql.ResultSetMetaData	getMetaData()
byte[]	getOrigBytes(int parameterIndex)
ParameterBindings	getParameterBindings()
protected int	getParameterIndexOffset() For calling stored functions, this will be -1 as Connector/J does not count the first '?' parameter marker, but JDBC counts it * as 1, otherwise it will return 0
java.sql.ParameterMetaData	getParameterMetaData()
ParseInfo	getParseInfo()
java.lang.String	getPreparedSql()
QueryBindings<?>	getQueryBindings()
int	getUpdateCount()
protected void	initQuery()
boolean	isNull(int paramIndex)
protected boolean	isSelectQuery()
protected ClientPreparedStatement	prepareBatchedInsertSQL(JdbcConnection localConn, int numBatches) Returns a prepared statement for the number of batched parameters, used when re-writing batch INSERTs.
void	realClose(boolean calledExplicitly, boolean closeOpenResults) Closes this statement, and frees resources.
void	setArray(int i, java.sql.Array x)
void	setAsciiStream(int parameterIndex, java.io.InputStream x)
void	setAsciiStream(int parameterIndex, java.io.InputStream x, int length)
void	setAsciiStream(int parameterIndex, java.io.InputStream x, long length)
void	setBigDecimal(int parameterIndex, java.math.BigDecimal x)
void	setBigInteger(int parameterIndex, java.math.BigInteger x)
void	setBinaryStream(int parameterIndex, java.io.InputStream x)
void	setBinaryStream(int parameterIndex, java.io.InputStream x, int length)
void	setBinaryStream(int parameterIndex, java.io.InputStream x, long length)
void	setBlob(int i, java.sql.Blob x)
void	setBlob(int parameterIndex, java.io.InputStream inputStream)
void	setBlob(int parameterIndex, java.io.InputStream inputStream, long length)
void	setBoolean(int parameterIndex, boolean x)
void	setByte(int parameterIndex, byte x)
void	setBytes(int parameterIndex, byte[] x)
void	setBytes(int parameterIndex, byte[] x, boolean checkForIntroducer, boolean escapeForMBChars)
void	setBytesNoEscape(int parameterIndex, byte[] parameterAsBytes) Used by updatable result sets for refreshRow() because the parameter has already been escaped for updater or inserter prepared statements.
void	setBytesNoEscapeNoQuotes(int parameterIndex, byte[] parameterAsBytes)
void	setCharacterStream(int parameterIndex, java.io.Reader reader)
void	setCharacterStream(int parameterIndex, java.io.Reader reader, int length)
void	setCharacterStream(int parameterIndex, java.io.Reader reader, long length)
void	setClob(int i, java.sql.Clob x)
void	setClob(int parameterIndex, java.io.Reader reader)
void	setClob(int parameterIndex, java.io.Reader reader, long length)
void	setDate(int parameterIndex, java.sql.Date x)
void	setDate(int parameterIndex, java.sql.Date x, java.util.Calendar cal)
void	setDouble(int parameterIndex, double x)
void	setFloat(int parameterIndex, float x)
void	setInt(int parameterIndex, int x)
void	setLong(int parameterIndex, long x)
void	setNCharacterStream(int parameterIndex, java.io.Reader value)
void	setNCharacterStream(int parameterIndex, java.io.Reader reader, long length)
void	setNClob(int parameterIndex, java.sql.NClob value)
void	setNClob(int parameterIndex, java.io.Reader reader)
void	setNClob(int parameterIndex, java.io.Reader reader, long length)
void	setNString(int parameterIndex, java.lang.String x) Set a parameter to a Java String value.
void	setNull(int parameterIndex, int sqlType)
void	setNull(int parameterIndex, int sqlType, java.lang.String typeName)
void	setNull(int parameterIndex, MysqlType mysqlType)
void	setObject(int parameterIndex, java.lang.Object parameterObj)
void	setObject(int parameterIndex, java.lang.Object parameterObj, int targetSqlType)
void	setObject(int parameterIndex, java.lang.Object parameterObj, int targetSqlType, int scale)
void	setObject(int parameterIndex, java.lang.Object parameterObj, java.sql.SQLType targetSqlType)
void	setObject(int parameterIndex, java.lang.Object x, java.sql.SQLType targetSqlType, int scaleOrLength)
protected int	setOneBatchedParameterSet(java.sql.PreparedStatement batchedStatement, int batchedParamIndex, java.lang.Object paramSet)
void	setRef(int i, java.sql.Ref x)
protected void	setRetrieveGeneratedKeys(boolean flag)
void	setRowId(int parameterIndex, java.sql.RowId x)
void	setShort(int parameterIndex, short x)
void	setSQLXML(int parameterIndex, java.sql.SQLXML xmlObject)
void	setString(int parameterIndex, java.lang.String x)
void	setTime(int parameterIndex, java.sql.Time x)
void	setTime(int parameterIndex, java.sql.Time x, java.util.Calendar cal)
void	setTimestamp(int parameterIndex, java.sql.Timestamp x)
void	setTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar cal)
void	setTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar targetCalendar, int fractionalLength)
void	setUnicodeStream(int parameterIndex, java.io.InputStream x, int length) Deprecated.
void	setURL(int parameterIndex, java.net.URL arg)
java.lang.String	toString() Returns this PreparedStatement represented as a string.

Methods inherited from class com.mysql.cj.jdbc.StatementImpl

addBatch, cancel, checkCancelTimeout, checkClosed, checkForDml, checkNullOrEmptyQuery, clearBatchedArgs, clearWarnings, close, closeAllOpenResults, closeOnCompletion, closeQuery, containsOnDuplicateKeyInString, createStreamingResultSet, disableStreamingResults, doPingInstead, enableStreamingResults, execute, execute, execute, execute, executeBatch, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeQuery, executeSimpleNonQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, executeUpdateInternal, findStartOfStatement, generatePingResultSet, getBatchedArgs, getBatchedGeneratedKeys, getBatchedGeneratedKeys, getCancelTimeoutMutex, getConnection, getCurrentDatabase, getExceptionInterceptor, getExecuteTime, getFetchDirection, getFetchSize, getGeneratedKeys, getGeneratedKeysInternal, getGeneratedKeysInternal, getId, getLargeMaxRows, getLargeUpdateCount, getLastInsertID, getLocalInfileInputStream, getLongUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getOpenResultSetCount, getQuery, getQueryTimeout, getResultFetchSize, getResultSet, getResultSetConcurrency, getResultSetFactory, getResultSetHoldability, getResultSetInternal, getResultSetType, getResultType, getServerStatementId, getSession, getStatementExecuting, getTimeoutInMillis, getWarnings, handleExceptionForBatch, hasDeadlockOrTimeoutRolledBackTx, implicitlyCloseAllOpenResults, isClearWarningsCalled, isClosed, isCloseOnCompletion, isPoolable, isWrapperFor, processMultiCountsAndKeys, removeOpenResultSet, resetCancelledState, setCancelStatus, setClearWarningsCalled, setCurrentDatabase, setCursorName, setEscapeProcessing, setExecuteTime, setFetchDirection, setFetchSize, setHoldResultsOpenOverClose, setLargeMaxRows, setLocalInfileInputStream, setMaxFieldSize, setMaxRows, setPingTarget, setPoolable, setQueryTimeout, setResultFetchSize, setResultType, setTimeoutInMillis, setupStreamingTimeout, startQueryTimer, statementBegins, stopQueryTimer, unwrap

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.mysql.cj.jdbc.JdbcStatement

disableStreamingResults, enableStreamingResults, getExceptionInterceptor, getLocalInfileInputStream, getOpenResultSetCount, getQuery, removeOpenResultSet, setHoldResultsOpenOverClose, setLocalInfileInputStream, setPingTarget

Methods inherited from interface java.sql.Statement

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

Methods inherited from interface java.sql.Wrapper

isWrapperFor, unwrap

Methods inherited from interface com.mysql.cj.Query

addBatch, checkCancelTimeout, clearBatchedArgs, closeQuery, getBatchedArgs, getCancelTimeoutMutex, getCurrentDatabase, getExecuteTime, getId, getResultFetchSize, getResultSetFactory, getResultType, getSession, getStatementExecuting, getTimeoutInMillis, isClearWarningsCalled, resetCancelledState, setCancelStatus, setClearWarningsCalled, setCurrentDatabase, setExecuteTime, setResultFetchSize, setResultType, setTimeoutInMillis, startQueryTimer, statementBegins, stopQueryTimer

Field Detail

batchHasPlainStatements

protected boolean batchHasPlainStatements

Does the batch (if any) contain "plain" statements added by Statement.addBatch(String)? If so, we can't re-write it to use multi-value or multi-queries.

parameterMetaData

protected MysqlParameterMetadata parameterMetaData

batchedValuesClause

protected java.lang.String batchedValuesClause

rewrittenBatchSize

protected int rewrittenBatchSize

Constructor Detail

ClientPreparedStatement

protected ClientPreparedStatement(JdbcConnection conn,
                                  java.lang.String db)
                           throws java.sql.SQLException

Constructor used by server-side prepared statements

Parameters:

conn - the connection that created us

db - the database in use when we were created

Throws:

java.sql.SQLException - if an error occurs

ClientPreparedStatement

public ClientPreparedStatement(JdbcConnection conn,
                               java.lang.String sql,
                               java.lang.String db)
                        throws java.sql.SQLException

Constructor for the PreparedStatement class.

Parameters:

conn - the connection creating this statement

sql - the SQL for this statement

db - the database this statement should be issued against

Throws:

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

ClientPreparedStatement

public ClientPreparedStatement(JdbcConnection conn,
                               java.lang.String sql,
                               java.lang.String db,
                               ParseInfo cachedParseInfo)
                        throws java.sql.SQLException

Creates a new PreparedStatement object.

Parameters:

conn - the connection creating this statement

sql - the SQL for this statement

db - the database this statement should be issued against

cachedParseInfo - already created parseInfo or null.

Throws:

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

Method Detail

getInstance

protected static ClientPreparedStatement getInstance(JdbcConnection conn,
                                                     java.lang.String sql,
                                                     java.lang.String db)
                                              throws java.sql.SQLException

Creates a prepared statement instance

Parameters:

conn - the connection creating this statement

sql - the SQL for this statement

db - the database this statement should be issued against

Returns:

ClientPreparedStatement

Throws:

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

getInstance

protected static ClientPreparedStatement getInstance(JdbcConnection conn,
                                                     java.lang.String sql,
                                                     java.lang.String db,
                                                     ParseInfo cachedParseInfo)
                                              throws java.sql.SQLException

Creates a prepared statement instance

Parameters:

conn - the connection creating this statement

sql - the SQL for this statement

db - the database this statement should be issued against

cachedParseInfo - already created parseInfo or null.

Returns:

ClientPreparedStatement instance

Throws:

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

initQuery

protected void initQuery()

Overrides:

initQuery in class StatementImpl

getQueryBindings

public QueryBindings<?> getQueryBindings()

Specified by:

getQueryBindings in interface JdbcPreparedStatement

toString

public java.lang.String toString()

Returns this PreparedStatement represented as a string.

Overrides:

toString in class java.lang.Object

Returns:

this PreparedStatement represented as a string.

addBatch

public void addBatch()
              throws java.sql.SQLException

Specified by:

addBatch in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

addBatch

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

Specified by:

addBatch in interface java.sql.Statement

Overrides:

addBatch in class StatementImpl

Throws:

java.sql.SQLException

asSql

public java.lang.String asSql()
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

asSql

public java.lang.String asSql(boolean quoteStreamsAndUnknowns)
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

clearBatch

public void clearBatch()
                throws java.sql.SQLException

Specified by:

clearBatch in interface java.sql.Statement

Overrides:

clearBatch in class StatementImpl

Throws:

java.sql.SQLException

clearParameters

public void clearParameters()
                     throws java.sql.SQLException

Specified by:

clearParameters in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

checkReadOnlySafeStatement

protected boolean checkReadOnlySafeStatement()
                                      throws java.sql.SQLException

Check to see if the statement is safe for read-only slaves after failover.

Returns:

true if safe for read-only.

Throws:

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

execute

public boolean execute()
                throws java.sql.SQLException

Specified by:

execute in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

executeBatchInternal

protected long[] executeBatchInternal()
                               throws java.sql.SQLException

Overrides:

executeBatchInternal in class StatementImpl

Throws:

java.sql.SQLException

executePreparedBatchAsMultiStatement

protected long[] executePreparedBatchAsMultiStatement(int batchTimeout)
                                               throws java.sql.SQLException

Rewrites the already prepared statement into a multi-statement query of 'statementsPerBatch' values and executes the entire batch using this new statement.

Parameters:

batchTimeout - timeout for the batch execution

Returns:

update counts in the same fashion as executeBatch()

Throws:

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

setOneBatchedParameterSet

protected int setOneBatchedParameterSet(java.sql.PreparedStatement batchedStatement,
                                        int batchedParamIndex,
                                        java.lang.Object paramSet)
                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

executeBatchedInserts

protected long[] executeBatchedInserts(int batchTimeout)
                                throws java.sql.SQLException

Rewrites the already prepared statement into a multi-value insert statement of 'statementsPerBatch' values and executes the entire batch using this new statement.

Parameters:

batchTimeout - timeout for the batch execution

Returns:

update counts in the same fashion as executeBatch()

Throws:

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

executeBatchSerially

protected long[] executeBatchSerially(int batchTimeout)
                               throws java.sql.SQLException

Executes the current batch of statements by executing them one-by-one.

Parameters:

batchTimeout - timeout for the batch execution

Returns:

a list of update counts

Throws:

java.sql.SQLException - if an error occurs

executeInternal

protected <M extends Message> ResultSetInternalMethods executeInternal(int maxRowsToRetrieve,
                                                                       M sendPacket,
                                                                       boolean createStreamingResultSet,
                                                                       boolean queryIsSelectOnly,
                                                                       ColumnDefinition metadata,
                                                                       boolean isBatch)
                                                                throws java.sql.SQLException

Actually execute the prepared statement. This is here so server-side PreparedStatements can re-use most of the code from this class.

Type Parameters:

M - extends Message

Parameters:

maxRowsToRetrieve - the max number of rows to return

sendPacket - the packet to send

createStreamingResultSet - should a 'streaming' result set be created?

queryIsSelectOnly - is this query doing a SELECT?

metadata - use this metadata instead of the one provided on wire

isBatch - is this a batch query?

Returns:

the results as a ResultSet

Throws:

java.sql.SQLException - if an error occurs.

executeQuery

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

Specified by:

executeQuery in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

executeUpdate

public int executeUpdate()
                  throws java.sql.SQLException

Specified by:

executeUpdate in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

executeUpdateInternal

protected long executeUpdateInternal(boolean clearBatchedGeneratedKeysAndWarnings,
                                     boolean isBatch)
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

executeUpdateInternal

protected long executeUpdateInternal(QueryBindings<?> bindings,
                                     boolean isReallyBatch)
                              throws java.sql.SQLException

Added to allow batch-updates

Parameters:

bindings - bindings object

isReallyBatch - is it a batched statement?

Returns:

the update count

Throws:

java.sql.SQLException - if a database error occurs

containsOnDuplicateKeyUpdateInSQL

protected boolean containsOnDuplicateKeyUpdateInSQL()

prepareBatchedInsertSQL

protected ClientPreparedStatement prepareBatchedInsertSQL(JdbcConnection localConn,
                                                          int numBatches)
                                                   throws java.sql.SQLException

Returns a prepared statement for the number of batched parameters, used when re-writing batch INSERTs.

Parameters:

localConn - the connection creating this statement

numBatches - number of entries in a batch

Returns:

new ClientPreparedStatement

Throws:

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

setRetrieveGeneratedKeys

protected void setRetrieveGeneratedKeys(boolean flag)
                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

getBytesRepresentation

public byte[] getBytesRepresentation(int parameterIndex)
                              throws java.sql.SQLException

Specified by:

getBytesRepresentation in interface JdbcPreparedStatement

Throws:

java.sql.SQLException

getOrigBytes

public byte[] getOrigBytes(int parameterIndex)
                    throws java.sql.SQLException

Specified by:

getOrigBytes in interface JdbcPreparedStatement

Throws:

java.sql.SQLException

getMetaData

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

Specified by:

getMetaData in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

isSelectQuery

protected boolean isSelectQuery()
                         throws java.sql.SQLException

Throws:

java.sql.SQLException

getParameterMetaData

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

Specified by:

getParameterMetaData in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

getParseInfo

public ParseInfo getParseInfo()

Specified by:

getParseInfo in interface JdbcPreparedStatement

isNull

public boolean isNull(int paramIndex)
               throws java.sql.SQLException

Specified by:

isNull in interface JdbcPreparedStatement

Throws:

java.sql.SQLException

realClose

public void realClose(boolean calledExplicitly,
                      boolean closeOpenResults)
               throws java.sql.SQLException

Description copied from class: StatementImpl

Closes this statement, and frees resources.

Specified by:

realClose in interface JdbcPreparedStatement

Overrides:

realClose in class StatementImpl

Parameters:

calledExplicitly - was this called from close()?

closeOpenResults - should open result sets be closed?

Throws:

java.sql.SQLException - if an error occurs

getPreparedSql

public java.lang.String getPreparedSql()

Specified by:

getPreparedSql in interface JdbcPreparedStatement

getUpdateCount

public int getUpdateCount()
                   throws java.sql.SQLException

Specified by:

getUpdateCount in interface java.sql.Statement

Overrides:

getUpdateCount in class StatementImpl

Throws:

java.sql.SQLException

executeLargeUpdate

public long executeLargeUpdate()
                        throws java.sql.SQLException

Specified by:

executeLargeUpdate in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

getParameterBindings

public ParameterBindings getParameterBindings()
                                       throws java.sql.SQLException

Specified by:

getParameterBindings in interface JdbcPreparedStatement

Throws:

java.sql.SQLException

getParameterIndexOffset

protected int getParameterIndexOffset()

For calling stored functions, this will be -1 as Connector/J does not count the first '?' parameter marker, but JDBC counts it * as 1, otherwise it will return 0

Returns:

offset

checkBounds

protected void checkBounds(int paramIndex,
                           int parameterIndexOffset)
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

getCoreParameterIndex

protected final int getCoreParameterIndex(int paramIndex)
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

setArray

public void setArray(int i,
                     java.sql.Array x)
              throws java.sql.SQLException

Specified by:

setArray in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setAsciiStream

public void setAsciiStream(int parameterIndex,
                           java.io.InputStream x)
                    throws java.sql.SQLException

Specified by:

setAsciiStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setAsciiStream

public void setAsciiStream(int parameterIndex,
                           java.io.InputStream x,
                           int length)
                    throws java.sql.SQLException

Specified by:

setAsciiStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setAsciiStream

public void setAsciiStream(int parameterIndex,
                           java.io.InputStream x,
                           long length)
                    throws java.sql.SQLException

Specified by:

setAsciiStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBigDecimal

public void setBigDecimal(int parameterIndex,
                          java.math.BigDecimal x)
                   throws java.sql.SQLException

Specified by:

setBigDecimal in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBinaryStream

public void setBinaryStream(int parameterIndex,
                            java.io.InputStream x)
                     throws java.sql.SQLException

Specified by:

setBinaryStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBinaryStream

public void setBinaryStream(int parameterIndex,
                            java.io.InputStream x,
                            int length)
                     throws java.sql.SQLException

Specified by:

setBinaryStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBinaryStream

public void setBinaryStream(int parameterIndex,
                            java.io.InputStream x,
                            long length)
                     throws java.sql.SQLException

Specified by:

setBinaryStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBlob

public void setBlob(int i,
                    java.sql.Blob x)
             throws java.sql.SQLException

Specified by:

setBlob in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBlob

public void setBlob(int parameterIndex,
                    java.io.InputStream inputStream)
             throws java.sql.SQLException

Specified by:

setBlob in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBlob

public void setBlob(int parameterIndex,
                    java.io.InputStream inputStream,
                    long length)
             throws java.sql.SQLException

Specified by:

setBlob in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBoolean

public void setBoolean(int parameterIndex,
                       boolean x)
                throws java.sql.SQLException

Specified by:

setBoolean in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setByte

public void setByte(int parameterIndex,
                    byte x)
             throws java.sql.SQLException

Specified by:

setByte in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBytes

public void setBytes(int parameterIndex,
                     byte[] x)
              throws java.sql.SQLException

Specified by:

setBytes in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBytes

public void setBytes(int parameterIndex,
                     byte[] x,
                     boolean checkForIntroducer,
                     boolean escapeForMBChars)
              throws java.sql.SQLException

Specified by:

setBytes in interface JdbcPreparedStatement

Throws:

java.sql.SQLException

setBytesNoEscape

public void setBytesNoEscape(int parameterIndex,
                             byte[] parameterAsBytes)
                      throws java.sql.SQLException

Description copied from interface: JdbcPreparedStatement

Used by updatable result sets for refreshRow() because the parameter has already been escaped for updater or inserter prepared statements.

Specified by:

setBytesNoEscape in interface JdbcPreparedStatement

Parameters:

parameterIndex - the parameter to set.

parameterAsBytes - the parameter as a string.

Throws:

java.sql.SQLException - if an error occurs

setBytesNoEscapeNoQuotes

public void setBytesNoEscapeNoQuotes(int parameterIndex,
                                     byte[] parameterAsBytes)
                              throws java.sql.SQLException

Specified by:

setBytesNoEscapeNoQuotes in interface JdbcPreparedStatement

Throws:

java.sql.SQLException

setCharacterStream

public void setCharacterStream(int parameterIndex,
                               java.io.Reader reader)
                        throws java.sql.SQLException

Specified by:

setCharacterStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setCharacterStream

public void setCharacterStream(int parameterIndex,
                               java.io.Reader reader,
                               int length)
                        throws java.sql.SQLException

Specified by:

setCharacterStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setCharacterStream

public void setCharacterStream(int parameterIndex,
                               java.io.Reader reader,
                               long length)
                        throws java.sql.SQLException

Specified by:

setCharacterStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setClob

public void setClob(int parameterIndex,
                    java.io.Reader reader)
             throws java.sql.SQLException

Specified by:

setClob in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setClob

public void setClob(int parameterIndex,
                    java.io.Reader reader,
                    long length)
             throws java.sql.SQLException

Specified by:

setClob in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setClob

public void setClob(int i,
                    java.sql.Clob x)
             throws java.sql.SQLException

Specified by:

setClob in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setDate

public void setDate(int parameterIndex,
                    java.sql.Date x)
             throws java.sql.SQLException

Specified by:

setDate in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setDate

public void setDate(int parameterIndex,
                    java.sql.Date x,
                    java.util.Calendar cal)
             throws java.sql.SQLException

Specified by:

setDate in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setDouble

public void setDouble(int parameterIndex,
                      double x)
               throws java.sql.SQLException

Specified by:

setDouble in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setFloat

public void setFloat(int parameterIndex,
                     float x)
              throws java.sql.SQLException

Specified by:

setFloat in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setInt

public void setInt(int parameterIndex,
                   int x)
            throws java.sql.SQLException

Specified by:

setInt in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setLong

public void setLong(int parameterIndex,
                    long x)
             throws java.sql.SQLException

Specified by:

setLong in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBigInteger

public void setBigInteger(int parameterIndex,
                          java.math.BigInteger x)
                   throws java.sql.SQLException

Specified by:

setBigInteger in interface JdbcPreparedStatement

Throws:

java.sql.SQLException

setNCharacterStream

public void setNCharacterStream(int parameterIndex,
                                java.io.Reader value)
                         throws java.sql.SQLException

Specified by:

setNCharacterStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setNCharacterStream

public void setNCharacterStream(int parameterIndex,
                                java.io.Reader reader,
                                long length)
                         throws java.sql.SQLException

Specified by:

setNCharacterStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setNClob

public void setNClob(int parameterIndex,
                     java.io.Reader reader)
              throws java.sql.SQLException

Specified by:

setNClob in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setNClob

public void setNClob(int parameterIndex,
                     java.io.Reader reader,
                     long length)
              throws java.sql.SQLException

Specified by:

setNClob in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setNClob

public void setNClob(int parameterIndex,
                     java.sql.NClob value)
              throws java.sql.SQLException

Specified by:

setNClob in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setNString

public void setNString(int parameterIndex,
                       java.lang.String x)
                throws java.sql.SQLException

Set a parameter to a Java String value. The driver converts this to a SQL VARCHAR or LONGVARCHAR value with introducer _utf8 (depending on the arguments size relative to the driver's limits on VARCHARs) when it sends it to the database. If charset is set as utf8, this method just call setString.

Specified by:

setNString in interface java.sql.PreparedStatement

Parameters:

parameterIndex - the first parameter is 1...

x - the parameter value

Throws:

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

setNull

public void setNull(int parameterIndex,
                    int sqlType)
             throws java.sql.SQLException

Specified by:

setNull in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setNull

public void setNull(int parameterIndex,
                    int sqlType,
                    java.lang.String typeName)
             throws java.sql.SQLException

Specified by:

setNull in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setNull

public void setNull(int parameterIndex,
                    MysqlType mysqlType)
             throws java.sql.SQLException

Specified by:

setNull in interface JdbcPreparedStatement

Throws:

java.sql.SQLException

setObject

public void setObject(int parameterIndex,
                      java.lang.Object parameterObj)
               throws java.sql.SQLException

Specified by:

setObject in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setObject

public void setObject(int parameterIndex,
                      java.lang.Object parameterObj,
                      int targetSqlType)
               throws java.sql.SQLException

Specified by:

setObject in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setObject

public void setObject(int parameterIndex,
                      java.lang.Object parameterObj,
                      java.sql.SQLType targetSqlType)
               throws java.sql.SQLException

Specified by:

setObject in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setObject

public void setObject(int parameterIndex,
                      java.lang.Object parameterObj,
                      int targetSqlType,
                      int scale)
               throws java.sql.SQLException

Specified by:

setObject in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setObject

public void setObject(int parameterIndex,
                      java.lang.Object x,
                      java.sql.SQLType targetSqlType,
                      int scaleOrLength)
               throws java.sql.SQLException

Specified by:

setObject in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setRef

public void setRef(int i,
                   java.sql.Ref x)
            throws java.sql.SQLException

Specified by:

setRef in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setRowId

public void setRowId(int parameterIndex,
                     java.sql.RowId x)
              throws java.sql.SQLException

Specified by:

setRowId in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setShort

public void setShort(int parameterIndex,
                     short x)
              throws java.sql.SQLException

Specified by:

setShort in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setSQLXML

public void setSQLXML(int parameterIndex,
                      java.sql.SQLXML xmlObject)
               throws java.sql.SQLException

Specified by:

setSQLXML in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setString

public void setString(int parameterIndex,
                      java.lang.String x)
               throws java.sql.SQLException

Specified by:

setString in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setTime

public void setTime(int parameterIndex,
                    java.sql.Time x)
             throws java.sql.SQLException

Specified by:

setTime in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setTime

public void setTime(int parameterIndex,
                    java.sql.Time x,
                    java.util.Calendar cal)
             throws java.sql.SQLException

Specified by:

setTime in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setTimestamp

public void setTimestamp(int parameterIndex,
                         java.sql.Timestamp x)
                  throws java.sql.SQLException

Specified by:

setTimestamp in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setTimestamp

public void setTimestamp(int parameterIndex,
                         java.sql.Timestamp x,
                         java.util.Calendar cal)
                  throws java.sql.SQLException

Specified by:

setTimestamp in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setTimestamp

public void setTimestamp(int parameterIndex,
                         java.sql.Timestamp x,
                         java.util.Calendar targetCalendar,
                         int fractionalLength)
                  throws java.sql.SQLException

Throws:

java.sql.SQLException

setUnicodeStream

@Deprecated
public void setUnicodeStream(int parameterIndex,
                                         java.io.InputStream x,
                                         int length)
                                  throws java.sql.SQLException

Deprecated.

Specified by:

setUnicodeStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setURL

public void setURL(int parameterIndex,
                   java.net.URL arg)
            throws java.sql.SQLException

Specified by:

setURL in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException