com.mysql.jdbc

Class JDBC42CallableStatement

java.lang.Object

com.mysql.jdbc.StatementImpl

com.mysql.jdbc.PreparedStatement

com.mysql.jdbc.CallableStatement

com.mysql.jdbc.JDBC4CallableStatement

com.mysql.jdbc.JDBC42CallableStatement

All Implemented Interfaces:

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

public class JDBC42CallableStatement
extends JDBC4CallableStatement

Nested Class Summary

Nested classes/interfaces inherited from class com.mysql.jdbc.CallableStatement

CallableStatement.CallableStatementParam, CallableStatement.CallableStatementParamInfo

Nested classes/interfaces inherited from class com.mysql.jdbc.PreparedStatement

PreparedStatement.AppendingBatchVisitor, PreparedStatement.BatchParams, PreparedStatement.BatchVisitor, PreparedStatement.EmulatedPreparedStatementBindings, PreparedStatement.EndPoint, PreparedStatement.ParseInfo

Nested classes/interfaces inherited from class com.mysql.jdbc.StatementImpl

StatementImpl.CancelTask

Field Summary

Fields inherited from class com.mysql.jdbc.CallableStatement

JDBC_4_CSTMT_2_ARGS_CTOR, JDBC_4_CSTMT_4_ARGS_CTOR, outputParamWasNull, paramInfo

Fields inherited from class com.mysql.jdbc.PreparedStatement

batchCommandIndex, batchedValuesClause, batchHasPlainStatements, firstCharOfStmt, isLoadDataQuery, isNull, numberOfExecutions, originalSql, parameterCount, parameterMetaData, parameterTypes, parseInfo, rewrittenBatchSize, serverSupportsFracSecs, useTrueBoolean, usingAnsiMode

Fields inherited from class com.mysql.jdbc.StatementImpl

batchedArgs, batchedGeneratedKeys, cancelTimeoutMutex, charConverter, charEncoding, clearWarningsCalled, connection, connectionId, continueBatchOnError, currentCatalog, doEscapeProcessing, eventSink, generatedKeysResults, holdResultsOpenOverClose, isClosed, lastInsertId, lastQueryIsOnDupKeyUpdate, maxFieldSize, maxRows, ON_DUPLICATE_KEY_UPDATE_CLAUSE, openResults, pedantic, PING_MARKER, pingTarget, pointOfOrigin, profileSQL, results, resultSetConcurrency, resultSetType, retrieveGeneratedKeys, sendFractionalSeconds, statementCounter, statementExecuting, statementId, timeoutInMillis, updateCount, useLegacyDatetimeCode, USES_VARIABLES_FALSE, USES_VARIABLES_TRUE, USES_VARIABLES_UNKNOWN, useUsageAdvisor, version5013OrNewer, warningChain, wasCancelled, wasCancelledByTimeout

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
JDBC42CallableStatement(MySQLConnection conn, CallableStatement.CallableStatementParamInfo paramInfo)
JDBC42CallableStatement(MySQLConnection conn, java.lang.String sql, java.lang.String catalog, boolean isFunctionCall)

Method Summary

Methods

Modifier and Type	Method and Description
void	registerOutParameter(int parameterIndex, SQLType sqlType) Support for java.sql.JDBCType/java.sql.SQLType.
void	registerOutParameter(int parameterIndex, SQLType sqlType, int scale) Support for java.sql.JDBCType/java.sql.SQLType.
void	registerOutParameter(int parameterIndex, SQLType sqlType, java.lang.String typeName) Support for java.sql.JDBCType/java.sql.SQLType.
void	registerOutParameter(java.lang.String parameterName, SQLType sqlType) Support for java.sql.JDBCType/java.sql.SQLType.
void	registerOutParameter(java.lang.String parameterName, SQLType sqlType, int scale) Support for java.sql.JDBCType/java.sql.SQLType.
void	registerOutParameter(java.lang.String parameterName, SQLType sqlType, java.lang.String typeName) Support for java.sql.JDBCType/java.sql.SQLType.
void	setObject(int parameterIndex, java.lang.Object x) Support for java.time.LocalDate, java.time.LocalTime, java.time.LocalDateTime, java.time.OffsetTime and java.time.OffsetDateTime.
void	setObject(int parameterIndex, java.lang.Object x, int targetSqlType) Support for java.time.LocalDate, java.time.LocalTime, java.time.LocalDateTime, java.time.OffsetTime and java.time.OffsetDateTime.
void	setObject(int parameterIndex, java.lang.Object x, int targetSqlType, int scaleOrLength) Support for java.time.LocalDate, java.time.LocalTime, java.time.LocalDateTime, java.time.OffsetTime and java.time.OffsetDateTime.
void	setObject(int parameterIndex, java.lang.Object x, SQLType targetSqlType) Support for java.sql.JDBCType/java.sql.SQLType.
void	setObject(int parameterIndex, java.lang.Object x, SQLType targetSqlType, int scaleOrLength) Support for java.sql.JDBCType/java.sql.SQLType.
void	setObject(java.lang.String parameterName, java.lang.Object x, SQLType targetSqlType) Support for java.sql.JDBCType/java.sql.SQLType.
void	setObject(java.lang.String parameterName, java.lang.Object x, SQLType targetSqlType, int scaleOrLength) Support for java.sql.JDBCType/java.sql.SQLType.

Methods inherited from class com.mysql.jdbc.JDBC4CallableStatement

getCharacterStream, getCharacterStream, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getRowId, getRowId, getSQLXML, getSQLXML, setNClob, setNClob, setNClob, setNClob, setNString, setRowId, setRowId, setSQLXML, setSQLXML

Methods inherited from class com.mysql.jdbc.CallableStatement

addBatch, checkReadOnlySafeStatement, clearParameters, execute, executeBatch, executeLargeBatch, executeLargeUpdate, executeQuery, executeUpdate, fixParameterName, getArray, getArray, getBigDecimal, getBigDecimal, getBigDecimal, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getClob, getClob, getDate, getDate, getDate, getDate, getDouble, getDouble, getFloat, getFloat, getInstance, getInstance, getInt, getInt, getLong, getLong, getNamedParamIndex, getObject, getObject, getObject, getObject, getObject, getObject, getOutputParameters, getParameterIndexOffset, getParameterMetaData, getRef, getRef, getShort, getShort, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getURL, getURL, mapOutputParameterIndexToRsIndex, 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, setNull, setNull, setObject, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setURL, wasNull

Methods inherited from class com.mysql.jdbc.PreparedStatement

addBatch, asSql, asSql, canRewrite, canRewriteAsMultiValueInsertAtSqlLevel, checkBounds, clearBatch, computeBatchSize, computeMaxParameterSetSizeAndBatchSize, containsOnDuplicateKeyUpdateInSQL, detectFractionalSecondsSupport, executeBatchedInserts, executeBatchInternal, executeBatchSerially, executeInternal, executePreparedBatchAsMultiStatement, executeUpdateInternal, executeUpdateInternal, fillSendPacket, fillSendPacket, getBytesRepresentation, getBytesRepresentationForBatch, getDateTime, getInstance, getInstance, getInstance, getLocationOfOnDuplicateKeyUpdate, getMetaData, getNonRewrittenSql, getParameterBindings, getParseInfo, getPreparedSql, getRewrittenBatchSize, getUpdateCount, getValuesClause, isNull, isSelectQuery, prepareBatchedInsertSQL, readFully, realClose, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setBytes, setBytesNoEscape, setBytesNoEscapeNoQuotes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setInternal, setInternal, setLong, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNString, setNull, setNull, setOneBatchedParameterSet, setRef, setRetrieveGeneratedKeys, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL, toString

Methods inherited from class com.mysql.jdbc.StatementImpl

cancel, checkClosed, checkForDml, checkNullOrEmptyQuery, clearWarnings, close, closeAllOpenResults, closeOnCompletion, containsOnDuplicateKeyInString, createStreamingResultSet, disableStreamingResults, doPingInstead, enableStreamingResults, execute, execute, execute, execute, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeQuery, executeSimpleNonQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, executeUpdateInternal, findStartOfStatement, generatePingResultSet, getBatchedArgs, getBatchedGeneratedKeys, getBatchedGeneratedKeys, getCalendarInstanceForSessionOrNew, getConnection, getExceptionInterceptor, getFetchDirection, getFetchSize, getGeneratedKeys, getGeneratedKeysInternal, getGeneratedKeysInternal, getId, getLargeMaxRows, getLargeUpdateCount, getLastInsertID, getLocalInfileInputStream, getLongUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getOnDuplicateKeyLocation, getOpenResultSetCount, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetInternal, getResultSetType, getWarnings, handleExceptionForBatch, hasDeadlockOrTimeoutRolledBackTx, implicitlyCloseAllOpenResults, isClosed, isCloseOnCompletion, isPoolable, isWrapperFor, processMultiCountsAndKeys, removeOpenResultSet, resetCancelledState, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setHoldResultsOpenOverClose, setLargeMaxRows, setLocalInfileInputStream, setMaxFieldSize, setMaxRows, setPingTarget, setPoolable, setQueryTimeout, setResultSetConcurrency, setResultSetType, setupStreamingTimeout, statementBegins, unwrap

Methods inherited from class java.lang.Object

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

Methods inherited from interface java.sql.PreparedStatement

getMetaData, 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, setNString, setNull, setNull, setRef, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL

Methods inherited from interface java.sql.Statement

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

Methods inherited from interface java.sql.Wrapper

isWrapperFor, unwrap

Constructor Detail

JDBC42CallableStatement

public JDBC42CallableStatement(MySQLConnection conn,
                       CallableStatement.CallableStatementParamInfo paramInfo)
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

JDBC42CallableStatement

public JDBC42CallableStatement(MySQLConnection conn,
                       java.lang.String sql,
                       java.lang.String catalog,
                       boolean isFunctionCall)
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

Method Detail

registerOutParameter

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

Support for java.sql.JDBCType/java.sql.SQLType.

Specified by:

registerOutParameter in interface java.sql.CallableStatement

Overrides:

registerOutParameter in class CallableStatement

Parameters:

parameterIndex -

sqlType -

Throws:

java.sql.SQLException

See Also:

CallableStatement.registerOutParameter(int, int)

registerOutParameter

public void registerOutParameter(int parameterIndex,
                        SQLType sqlType,
                        int scale)
                          throws java.sql.SQLException

Support for java.sql.JDBCType/java.sql.SQLType.

Specified by:

registerOutParameter in interface java.sql.CallableStatement

Overrides:

registerOutParameter in class CallableStatement

Parameters:

parameterIndex -

sqlType -

scale -

Throws:

java.sql.SQLException

See Also:

CallableStatement.registerOutParameter(int, int, int)

registerOutParameter

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

Support for java.sql.JDBCType/java.sql.SQLType.

Specified by:

registerOutParameter in interface java.sql.CallableStatement

Overrides:

registerOutParameter in class CallableStatement

Parameters:

parameterIndex -

sqlType -

typeName -

Throws:

java.sql.SQLException

See Also:

CallableStatement.registerOutParameter(int, int, java.lang.String)

registerOutParameter

public void registerOutParameter(java.lang.String parameterName,
                        SQLType sqlType)
                          throws java.sql.SQLException

Support for java.sql.JDBCType/java.sql.SQLType.

Specified by:

registerOutParameter in interface java.sql.CallableStatement

Overrides:

registerOutParameter in class CallableStatement

Parameters:

parameterName -

sqlType -

Throws:

java.sql.SQLException

See Also:

CallableStatement.registerOutParameter(java.lang.String, int)

registerOutParameter

public void registerOutParameter(java.lang.String parameterName,
                        SQLType sqlType,
                        int scale)
                          throws java.sql.SQLException

Support for java.sql.JDBCType/java.sql.SQLType.

Specified by:

registerOutParameter in interface java.sql.CallableStatement

Overrides:

registerOutParameter in class CallableStatement

Parameters:

parameterName -

sqlType -

scale -

Throws:

java.sql.SQLException

See Also:

CallableStatement.registerOutParameter(java.lang.String, int, int)

registerOutParameter

public void registerOutParameter(java.lang.String parameterName,
                        SQLType sqlType,
                        java.lang.String typeName)
                          throws java.sql.SQLException

Support for java.sql.JDBCType/java.sql.SQLType.

Specified by:

registerOutParameter in interface java.sql.CallableStatement

Overrides:

registerOutParameter in class CallableStatement

Parameters:

parameterName -

sqlType -

typeName -

Throws:

java.sql.SQLException

See Also:

CallableStatement.registerOutParameter(java.lang.String, int, java.lang.String)

setObject

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

Support for java.time.LocalDate, java.time.LocalTime, java.time.LocalDateTime, java.time.OffsetTime and java.time.OffsetDateTime.

Specified by:

setObject in interface java.sql.PreparedStatement

Overrides:

setObject in class PreparedStatement

Parameters:

parameterIndex -

x -

Throws:

java.sql.SQLException

setObject

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

Support for java.time.LocalDate, java.time.LocalTime, java.time.LocalDateTime, java.time.OffsetTime and java.time.OffsetDateTime.

Specified by:

setObject in interface java.sql.PreparedStatement

Overrides:

setObject in class PreparedStatement

Parameters:

parameterIndex -

x -

targetSqlType -

Throws:

java.sql.SQLException

setObject

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

Support for java.time.LocalDate, java.time.LocalTime, java.time.LocalDateTime, java.time.OffsetTime and java.time.OffsetDateTime.

Specified by:

setObject in interface java.sql.PreparedStatement

Overrides:

setObject in class PreparedStatement

Parameters:

parameterIndex -

x -

targetSqlType -

scaleOrLength -

Throws:

java.sql.SQLException

setObject

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

Support for java.sql.JDBCType/java.sql.SQLType. Support for java.time.LocalDate, java.time.LocalTime, java.time.LocalDateTime, java.time.OffsetTime and java.time.OffsetDateTime.

Specified by:

setObject in interface java.sql.PreparedStatement

Overrides:

setObject in class PreparedStatement

Parameters:

parameterIndex -

x -

targetSqlType -

Throws:

java.sql.SQLException

setObject

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

Support for java.sql.JDBCType/java.sql.SQLType. Support for java.time.LocalDate, java.time.LocalTime, java.time.LocalDateTime, java.time.OffsetTime and java.time.OffsetDateTime.

Specified by:

setObject in interface java.sql.PreparedStatement

Overrides:

setObject in class PreparedStatement

Parameters:

parameterIndex -

x -

targetSqlType -

scaleOrLength -

Throws:

java.sql.SQLException

setObject

public void setObject(java.lang.String parameterName,
             java.lang.Object x,
             SQLType targetSqlType)
               throws java.sql.SQLException

Support for java.sql.JDBCType/java.sql.SQLType. Support for java.time.LocalDate, java.time.LocalTime, java.time.LocalDateTime, java.time.OffsetTime and java.time.OffsetDateTime.

Specified by:

setObject in interface java.sql.CallableStatement

Overrides:

setObject in class CallableStatement

Parameters:

parameterName -

x -

targetSqlType -

Throws:

java.sql.SQLException

See Also:

CallableStatement.setObject(java.lang.String, java.lang.Object, int)

setObject

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

Support for java.sql.JDBCType/java.sql.SQLType. Support for java.time.LocalDate, java.time.LocalTime, java.time.LocalDateTime, java.time.OffsetTime and java.time.OffsetDateTime.

Specified by:

setObject in interface java.sql.CallableStatement

Overrides:

setObject in class CallableStatement

Parameters:

parameterName -

x -

targetSqlType -

scaleOrLength -

Throws:

java.sql.SQLException

See Also:

CallableStatement.setObject(java.lang.String, java.lang.Object, int, int)