Class JDBC4CallableStatement

java.lang.Object

com.mysql.jdbc.StatementImpl

com.mysql.jdbc.PreparedStatement

com.mysql.jdbc.CallableStatement

com.mysql.jdbc.JDBC4CallableStatement

All Implemented Interfaces:

Statement, Wrapper, AutoCloseable, CallableStatement, PreparedStatement, Statement, Wrapper

Direct Known Subclasses:

JDBC42CallableStatement

public class JDBC4CallableStatement
extends CallableStatement

Nested Class Summary

Nested classes/interfaces inherited from class CallableStatement

CallableStatement.CallableStatementParam, CallableStatement.CallableStatementParamInfo

Nested classes/interfaces inherited from class PreparedStatement

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

Nested classes/interfaces inherited from class StatementImpl

StatementImpl.CancelTask

Field Summary

Fields inherited from class CallableStatement

callingStoredFunction, JDBC_4_CSTMT_2_ARGS_CTOR, JDBC_4_CSTMT_4_ARGS_CTOR, outputParamWasNull, paramInfo

Fields inherited from class PreparedStatement

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

Fields inherited from class StatementImpl

batchedArgs, batchedGeneratedKeys, cancelTimeoutMutex, charConverter, charEncoding, clearWarningsCalled, connection, continueBatchOnError, currentCatalog, doEscapeProcessing, generatedKeysResults, holdResultsOpenOverClose, isClosed, lastInsertId, lastQueryIsOnDupKeyUpdate, maxFieldSize, maxRows, ON_DUPLICATE_KEY_UPDATE_CLAUSE, openResults, pedantic, physicalConnection, PING_MARKER, pingTarget, 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 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
JDBC4CallableStatement(MySQLConnection conn, CallableStatement.CallableStatementParamInfo paramInfo)
JDBC4CallableStatement(MySQLConnection conn, String sql, String catalog, boolean isFunctionCall)

Method Summary

Modifier and Type	Method	Description
Reader	getCharacterStream(int parameterIndex)
Reader	getCharacterStream(String parameterName)
Reader	getNCharacterStream(int parameterIndex)
Reader	getNCharacterStream(String parameterName)
NClob	getNClob(int parameterIndex)
NClob	getNClob(String parameterName)
String	getNString(int parameterIndex)
String	getNString(String parameterName)
protected ResultSet	getParamTypes(String catalog, String routineName)
RowId	getRowId(int parameterIndex)
RowId	getRowId(String parameterName)
SQLXML	getSQLXML(int parameterIndex)
SQLXML	getSQLXML(String parameterName)
void	setNClob(int parameterIndex, NClob value)	JDBC 4.0 Set a NCLOB parameter.
void	setNClob(String parameterName, Reader reader)
void	setNClob(String parameterName, Reader reader, long length)
void	setNClob(String parameterName, NClob value)
void	setNString(String parameterName, String value)
void	setRowId(int parameterIndex, RowId x)
void	setRowId(String parameterName, RowId x)
void	setSQLXML(int parameterIndex, SQLXML xmlObject)
void	setSQLXML(String parameterName, SQLXML xmlObject)

Methods inherited from class 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, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, 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, setObject, setObject, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setURL, wasNull

Methods inherited from class 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, setObject, setObject, setObject, setOneBatchedParameterSet, setRef, setRetrieveGeneratedKeys, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setTimestampInternal, setUnicodeStream, setURL, toString

Methods inherited from class 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, isCursorRequired, 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 Object

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

Methods inherited from interface CallableStatement

registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, setObject, setObject

Methods inherited from interface 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, setObject, setObject, setObject, setObject, setObject, setRef, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL

Methods inherited from interface Statement

addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, 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, isSimpleIdentifier, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout

Methods inherited from interface Wrapper

isWrapperFor, unwrap

Constructor Details

JDBC4CallableStatement

public JDBC4CallableStatement(MySQLConnection conn,
 CallableStatement.CallableStatementParamInfo paramInfo)
                       throws SQLException

Throws:

SQLException

JDBC4CallableStatement

public JDBC4CallableStatement(MySQLConnection conn,
 String sql,
 String catalog,
 boolean isFunctionCall)
                       throws SQLException

Throws:

SQLException

Method Details

getParamTypes

protected ResultSet getParamTypes(String catalog,
 String routineName)
                           throws SQLException

Overrides:

getParamTypes in class CallableStatement

Throws:

SQLException

setRowId

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

Throws:

SQLException

setRowId

public void setRowId(String parameterName,
 RowId x)
              throws SQLException

Throws:

SQLException

setSQLXML

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

Throws:

SQLException

setSQLXML

public void setSQLXML(String parameterName,
 SQLXML xmlObject)
               throws SQLException

Throws:

SQLException

getSQLXML

public SQLXML getSQLXML(int parameterIndex)
                 throws SQLException

Throws:

SQLException

getSQLXML

public SQLXML getSQLXML(String parameterName)
                 throws SQLException

Throws:

SQLException

getRowId

public RowId getRowId(int parameterIndex)
               throws SQLException

Throws:

SQLException

getRowId

public RowId getRowId(String parameterName)
               throws SQLException

Throws:

SQLException

setNClob

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

JDBC 4.0 Set a NCLOB parameter.

Parameters:

i - the first parameter is 1, the second is 2, ...

x - an object representing a NCLOB

Throws:

SQLException - if a database error occurs

setNClob

public void setNClob(String parameterName,
 NClob value)
              throws SQLException

Throws:

SQLException

setNClob

public void setNClob(String parameterName,
 Reader reader)
              throws SQLException

Throws:

SQLException

setNClob

public void setNClob(String parameterName,
 Reader reader,
 long length)
              throws SQLException

Throws:

SQLException

setNString

public void setNString(String parameterName,
 String value)
                throws SQLException

Throws:

SQLException

getCharacterStream

public Reader getCharacterStream(int parameterIndex)
                          throws SQLException

Throws:

SQLException

See Also:

• CallableStatement.getCharacterStream(int)

getCharacterStream

public Reader getCharacterStream(String parameterName)
                          throws SQLException

Throws:

SQLException

See Also:

• CallableStatement.getCharacterStream(java.lang.String)

getNCharacterStream

public Reader getNCharacterStream(int parameterIndex)
                           throws SQLException

Throws:

SQLException

See Also:

• CallableStatement.getNCharacterStream(int)

getNCharacterStream

public Reader getNCharacterStream(String parameterName)
                           throws SQLException

Throws:

SQLException

See Also:

• CallableStatement.getNCharacterStream(java.lang.String)

getNClob

public NClob getNClob(int parameterIndex)
               throws SQLException

Throws:

SQLException

See Also:

• CallableStatement.getNClob(int)

getNClob

public NClob getNClob(String parameterName)
               throws SQLException

Throws:

SQLException

See Also:

• CallableStatement.getNClob(java.lang.String)

getNString

public String getNString(int parameterIndex)
                  throws SQLException

Throws:

SQLException

See Also:

• CallableStatement.getNString(int)

getNString

public String getNString(String parameterName)
                  throws SQLException

Throws:

SQLException

See Also:

• CallableStatement.getNString(java.lang.String)