MySQL Connector/J 9.2.0 · com.mysql.cj.jdbc.CallableStatement

Modifier and Type	Class and Description
protected static class	CallableStatement.CallableStatementParam
public class	CallableStatement.CallableStatementParamInfo

Modifier and Type	Field and Description
private boolean	callingStoredFunction
private ResultSetInternalMethods	functionReturnValueResults
private boolean	hasOutputParams
private boolean	noAccessToProcedureBodies
private static final int	NOT_OUTPUT_PARAMETER_INDICATOR
private ResultSetInternalMethods	outputParameterResults
protected boolean	outputParamWasNull
private static final String	PARAMETER_NAMESPACE_PREFIX
private int[]	parameterIndexToRsIndex
protected CallableStatement.CallableStatementParamInfo	paramInfo
private CallableStatement.CallableStatementParam	returnValueParam

Access	Constructor and Description
public	CallableStatement(JdbcConnection the connection creating this statement conn, CallableStatement.CallableStatementParamInfo the SQL to prepare paramInfo) Creates a new CallableStatement
public	CallableStatement(JdbcConnection the connection creating this statement conn, String the SQL to prepare sql, String the current database db, boolean is it a function call or a procedure call? isFunctionCall) Creates a new CallableStatement

Method Summary

Modifier and Type	Method and Description
public void	addBatch() Overrides com.mysql.cj.jdbc.ClientPreparedStatement.addBatch. Implements java.sql.PreparedStatement.addBatch. Adds a set of parameters to this `PreparedStatement` object's batch of commands.
private CallableStatement.CallableStatementParam	checkIsOutputParam(int paramIndex)
private void	checkParameterIndexBounds(int parameter index paramIndex)
private boolean	Returns: true if procedure does not alter data checkReadOnlyProcedure() Check whether the stored procedure alters any data or is safe for read-only usage.
protected boolean	checkReadOnlySafeStatement() Overrides com.mysql.cj.jdbc.ClientPreparedStatement.checkReadOnlySafeStatement. Check to see if the statement is safe for read-only replicas after failover.
private void	checkStreamability() Checks whether or not this statement is supposed to be providing streamable result sets...If output parameters are registered, the driver can not stream the results.
public void	clearParameters() Overrides com.mysql.cj.jdbc.ClientPreparedStatement.clearParameters. Implements java.sql.PreparedStatement.clearParameters. Clears the current parameter values immediately.
private void	convertGetProcedureColumnsToInternalDescriptors(ResultSet paramTypesRs)
private void	determineParameterTypes()
public boolean	execute() Overrides com.mysql.cj.jdbc.ClientPreparedStatement.execute. Implements java.sql.PreparedStatement.execute. Executes the SQL statement in this `PreparedStatement` object, which may be any kind of SQL statement.
public int[]	executeBatch() Overrides com.mysql.cj.jdbc.StatementImpl.executeBatch. Implements java.sql.Statement.executeBatch. Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.
public long[]	executeLargeBatch() Overrides com.mysql.cj.jdbc.StatementImpl.executeLargeBatch. Overrides default java.sql.Statement.executeLargeBatch. Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.
public long	executeLargeUpdate() Overrides com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate. Overrides default java.sql.PreparedStatement.executeLargeUpdate. 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.
public ResultSet	executeQuery() Overrides com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery. Implements java.sql.PreparedStatement.executeQuery. Executes the SQL query in this `PreparedStatement` object and returns the `ResultSet` object generated by the query.
public int	executeUpdate() Overrides com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate. Implements java.sql.PreparedStatement.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.
private String	extractProcedureName()
private void	fakeParameterTypes(boolean is it a procedure or function isReallyProcedure) Used to fake up some metadata when we don't have access to SHOW CREATE PROCEDURE or mysql.proc.
protected String	Returns: the parameter name with an '(at)' prepended, if needed fixParameterName(String the parameter name to 'fix' paramNameIn) Adds '(at)' symbol to beginning of parameter names if needed.
private void	generateParameterMap()
public Array	getArray(int the first parameter is 1, the second is 2, and so on i) Implements java.sql.CallableStatement.getArray. Retrieves the value of the designated JDBC `ARRAY` parameter as an `java.sql.Array` object in the Java programming language.
public Array	getArray(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getArray. Retrieves the value of a JDBC `ARRAY` parameter as an `java.sql.Array` object in the Java programming language.
public BigDecimal	getBigDecimal(int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getBigDecimal. Retrieves the value of the designated JDBC `NUMERIC` parameter as a `java.math.BigDecimal` object with as many digits to the right of the decimal point as the value contains.
public BigDecimal	getBigDecimal(int the first parameter is 1, the second is 2, and so on parameterIndex, int the number of digits to the right of the decimal point scale) Implements java.sql.CallableStatement.getBigDecimal. Deprecated Retrieves the value of the designated JDBC `NUMERIC` parameter as a `java.math.BigDecimal` object with scale digits to the right of the decimal point.
public BigDecimal	getBigDecimal(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getBigDecimal. Retrieves the value of a JDBC `NUMERIC` parameter as a `java.math.BigDecimal` object with as many digits to the right of the decimal point as the value contains.
public Blob	getBlob(int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getBlob. Retrieves the value of the designated JDBC `BLOB` parameter as a `java.sql.Blob` object in the Java programming language.
public Blob	getBlob(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getBlob. Retrieves the value of a JDBC `BLOB` parameter as a `java.sql.Blob` object in the Java programming language.
public boolean	getBoolean(int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getBoolean. Retrieves the value of the designated JDBC `BIT` or `BOOLEAN` parameter as a `boolean` in the Java programming language.
public boolean	getBoolean(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getBoolean. Retrieves the value of a JDBC `BIT` or `BOOLEAN` parameter as a `boolean` in the Java programming language.
public byte	getByte(int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getByte. Retrieves the value of the designated JDBC `TINYINT` parameter as a `byte` in the Java programming language.
public byte	getByte(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getByte. Retrieves the value of a JDBC `TINYINT` parameter as a `byte` in the Java programming language.
public byte[]	getBytes(int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getBytes. Retrieves the value of the designated JDBC `BINARY` or `VARBINARY` parameter as an array of `byte` values in the Java programming language.
public byte[]	getBytes(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getBytes. Retrieves the value of a JDBC `BINARY` or `VARBINARY` parameter as an array of `byte` values in the Java programming language.
public Reader	getCharacterStream(int the first parameter is 1, the second is 2, ... parameterIndex) Implements java.sql.CallableStatement.getCharacterStream. Retrieves the value of the designated parameter as a `java.io.Reader` object in the Java programming language.
public Reader	getCharacterStream(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getCharacterStream. Retrieves the value of the designated parameter as a `java.io.Reader` object in the Java programming language.
public Clob	getClob(int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getClob. Retrieves the value of the designated JDBC `CLOB` parameter as a `java.sql.Clob` object in the Java programming language.
public Clob	getClob(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getClob. Retrieves the value of a JDBC `CLOB` parameter as a `java.sql.Clob` object in the Java programming language.
public Date	getDate(int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getDate. Retrieves the value of the designated JDBC `DATE` parameter as a `java.sql.Date` object.
public Date	getDate(int the first parameter is 1, the second is 2, and so on parameterIndex, Calendar the `Calendar` object the driver will use to construct the date cal) Implements java.sql.CallableStatement.getDate. Retrieves the value of the designated JDBC `DATE` parameter as a `java.sql.Date` object, using the given `Calendar` object to construct the date.
public Date	getDate(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getDate. Retrieves the value of a JDBC `DATE` parameter as a `java.sql.Date` object.
public Date	getDate(String the name of the parameter parameterName, Calendar the `Calendar` object the driver will use to construct the date cal) Implements java.sql.CallableStatement.getDate. Retrieves the value of a JDBC `DATE` parameter as a `java.sql.Date` object, using the given `Calendar` object to construct the date.
public double	getDouble(int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getDouble. Retrieves the value of the designated JDBC `DOUBLE` parameter as a `double` in the Java programming language.
public double	getDouble(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getDouble. Retrieves the value of a JDBC `DOUBLE` parameter as a `double` in the Java programming language.
public float	getFloat(int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getFloat. Retrieves the value of the designated JDBC `FLOAT` parameter as a `float` in the Java programming language.
public float	getFloat(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getFloat. Retrieves the value of a JDBC `FLOAT` parameter as a `float` in the Java programming language.
protected static CallableStatement	Returns: CallableStatement getInstance(JdbcConnection the connection creating this statement conn, String the SQL to prepare sql, String the current database db, boolean is it a function call or a procedure call? isFunctionCall) Creates a callable statement instance
protected static CallableStatement	Returns: CallableStatement getInstance(JdbcConnection the connection creating this statement conn, CallableStatement.CallableStatementParamInfo the SQL to prepare paramInfo) Creates a callable statement instance
public int	getInt(int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getInt. Retrieves the value of the designated JDBC `INTEGER` parameter as an `int` in the Java programming language.
public int	getInt(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getInt. Retrieves the value of a JDBC `INTEGER` parameter as an `int` in the Java programming language.
public long	getLong(int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getLong. Retrieves the value of the designated JDBC `BIGINT` parameter as a `long` in the Java programming language.
public long	getLong(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getLong. Retrieves the value of a JDBC `BIGINT` parameter as a `long` in the Java programming language.
protected int	getNamedParamIndex(String paramName, boolean forOut)
public Reader	getNCharacterStream(int the first parameter is 1, the second is 2, ... parameterIndex) Implements java.sql.CallableStatement.getNCharacterStream. Retrieves the value of the designated parameter as a `java.io.Reader` object in the Java programming language.
public Reader	getNCharacterStream(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getNCharacterStream. Retrieves the value of the designated parameter as a `java.io.Reader` object in the Java programming language.
public NClob	getNClob(int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getNClob. Retrieves the value of the designated JDBC `NCLOB` parameter as a `java.sql.NClob` object in the Java programming language.
public NClob	getNClob(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getNClob. Retrieves the value of a JDBC `NCLOB` parameter as a `java.sql.NClob` object in the Java programming language.
public String	getNString(int index of the first parameter is 1, the second is 2, ... parameterIndex) Implements java.sql.CallableStatement.getNString. Retrieves the value of the designated `NCHAR`, `NVARCHAR` or `LONGNVARCHAR` parameter as a `String` in the Java programming language.
public String	getNString(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getNString. Retrieves the value of the designated `NCHAR`, `NVARCHAR` or `LONGNVARCHAR` parameter as a `String` in the Java programming language.
public Object	getObject(int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getObject. Retrieves the value of the designated parameter as an `Object` in the Java programming language.
public Object	getObject(int the first parameter is 1, the second is 2, and so on parameterIndex, Map<String, Class<?>> the mapping from SQL type names to Java classes map) Implements java.sql.CallableStatement.getObject. Returns an object representing the value of OUT parameter `parameterIndex` and uses `map` for the custom mapping of the parameter value.
public Object	getObject(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getObject. Retrieves the value of a parameter as an `Object` in the Java programming language.
public Object	getObject(String the name of the parameter parameterName, Map<String, Class<?>> the mapping from SQL type names to Java classes map) Implements java.sql.CallableStatement.getObject. Returns an object representing the value of OUT parameter `parameterName` and uses `map` for the custom mapping of the parameter value.
public <T> T	getObject(int the first parameter is 1, the second is 2, and so on parameterIndex, Class<T> Class representing the Java data type to convert the designated parameter to. type) Implements java.sql.CallableStatement.getObject. Returns an object representing the value of OUT parameter `parameterIndex` and will convert from the SQL type of the parameter to the requested Java data type, if the conversion is supported.
public <T> T	getObject(String the name of the parameter parameterName, Class<T> Class representing the Java data type to convert the designated parameter to. type) Implements java.sql.CallableStatement.getObject. Returns an object representing the value of OUT parameter `parameterName` and will convert from the SQL type of the parameter to the requested Java data type, if the conversion is supported.
protected ResultSetInternalMethods	Returns: the ResultSet that holds the output parameters getOutputParameters(int parameter index paramIndex) Returns the ResultSet that holds the output parameters, or throws an appropriate exception if none exist, or they weren't returned.
protected int	getParameterIndexOffset() Overrides com.mysql.cj.jdbc.ClientPreparedStatement.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
public ParameterMetaData	getParameterMetaData() Overrides com.mysql.cj.jdbc.ClientPreparedStatement.getParameterMetaData. Implements java.sql.PreparedStatement.getParameterMetaData. Retrieves the number, types and properties of this `PreparedStatement` object's parameters.
public Ref	getRef(int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getRef. Retrieves the value of the designated JDBC `REF(<structured-type>)` parameter as a `java.sql.Ref` object in the Java programming language.
public Ref	getRef(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getRef. Retrieves the value of a JDBC `REF(<structured-type>)` parameter as a `java.sql.Ref` object in the Java programming language.
public RowId	getRowId(int the first parameter is 1, the second is 2,... parameterIndex) Implements java.sql.CallableStatement.getRowId. Retrieves the value of the designated JDBC `ROWID` parameter as a `java.sql.RowId` object.
public RowId	getRowId(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getRowId. Retrieves the value of the designated JDBC `ROWID` parameter as a `java.sql.RowId` object.
public short	getShort(int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getShort. Retrieves the value of the designated JDBC `SMALLINT` parameter as a `short` in the Java programming language.
public short	getShort(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getShort. Retrieves the value of a JDBC `SMALLINT` parameter as a `short` in the Java programming language.
public SQLXML	getSQLXML(int index of the first parameter is 1, the second is 2, ... parameterIndex) Implements java.sql.CallableStatement.getSQLXML. Retrieves the value of the designated `SQL XML` parameter as a `java.sql.SQLXML` object in the Java programming language.
public SQLXML	getSQLXML(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getSQLXML. Retrieves the value of the designated `SQL XML` parameter as a `java.sql.SQLXML` object in the Java programming language.
public String	getString(int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getString. Retrieves the value of the designated JDBC `CHAR`, `VARCHAR`, or `LONGVARCHAR` parameter as a `String` in the Java programming language.
public String	getString(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getString. Retrieves the value of a JDBC `CHAR`, `VARCHAR`, or `LONGVARCHAR` parameter as a `String` in the Java programming language.
public Time	getTime(int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getTime. Retrieves the value of the designated JDBC `TIME` parameter as a `java.sql.Time` object.
public Time	getTime(int the first parameter is 1, the second is 2, and so on parameterIndex, Calendar the `Calendar` object the driver will use to construct the time cal) Implements java.sql.CallableStatement.getTime. Retrieves the value of the designated JDBC `TIME` parameter as a `java.sql.Time` object, using the given `Calendar` object to construct the time.
public Time	getTime(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getTime. Retrieves the value of a JDBC `TIME` parameter as a `java.sql.Time` object.
public Time	getTime(String the name of the parameter parameterName, Calendar the `Calendar` object the driver will use to construct the time cal) Implements java.sql.CallableStatement.getTime. Retrieves the value of a JDBC `TIME` parameter as a `java.sql.Time` object, using the given `Calendar` object to construct the time.
public Timestamp	getTimestamp(int the first parameter is 1, the second is 2, and so on parameterIndex) Implements java.sql.CallableStatement.getTimestamp. Retrieves the value of the designated JDBC `TIMESTAMP` parameter as a `java.sql.Timestamp` object.
public Timestamp	getTimestamp(int the first parameter is 1, the second is 2, and so on parameterIndex, Calendar the `Calendar` object the driver will use to construct the timestamp cal) Implements java.sql.CallableStatement.getTimestamp. Retrieves the value of the designated JDBC `TIMESTAMP` parameter as a `java.sql.Timestamp` object, using the given `Calendar` object to construct the `Timestamp` object.
public Timestamp	getTimestamp(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getTimestamp. Retrieves the value of a JDBC `TIMESTAMP` parameter as a `java.sql.Timestamp` object.
public Timestamp	getTimestamp(String the name of the parameter parameterName, Calendar the `Calendar` object the driver will use to construct the timestamp cal) Implements java.sql.CallableStatement.getTimestamp. Retrieves the value of a JDBC `TIMESTAMP` parameter as a `java.sql.Timestamp` object, using the given `Calendar` object to construct the `Timestamp` object.
public URL	getURL(int the first parameter is 1, the second is 2,... parameterIndex) Implements java.sql.CallableStatement.getURL. Retrieves the value of the designated JDBC `DATALINK` parameter as a `java.net.URL` object.
public URL	getURL(String the name of the parameter parameterName) Implements java.sql.CallableStatement.getURL. Retrieves the value of a JDBC `DATALINK` parameter as a `java.net.URL` object.
private static String	mangleParameterName(String origParameterName)
protected int	mapOutputParameterIndexToRsIndex(int paramIndex)
protected void	registerOutParameter(int parameterIndex, MysqlType mysqlType)
public void	registerOutParameter(int the first parameter is 1, the second is 2, and so on parameterIndex, int the JDBC type code defined by `java.sql.Types`. If the parameter is of JDBC type `NUMERIC` or `DECIMAL`, the version of `registerOutParameter` that accepts a scale value should be used. sqlType) Implements java.sql.CallableStatement.registerOutParameter. Registers the OUT parameter in ordinal position `parameterIndex` to the JDBC type `sqlType`.
public void	registerOutParameter(int the first parameter is 1, the second is 2, and so on parameterIndex, SQLType the JDBC type code defined by `SQLType` to use to register the OUT Parameter. If the parameter is of JDBC type `JDBCType.NUMERIC` or `JDBCType.DECIMAL`, the version of `registerOutParameter` that accepts a scale value should be used. sqlType) Overrides default java.sql.CallableStatement.registerOutParameter. Registers the OUT parameter in ordinal position `parameterIndex` to the JDBC type `sqlType`.
protected void	registerOutParameter(int parameterIndex, MysqlType mysqlType, int scale)
public void	registerOutParameter(int the first parameter is 1, the second is 2, and so on parameterIndex, int the SQL type code defined by `java.sql.Types`. sqlType, int the desired number of digits to the right of the decimal point. It must be greater than or equal to zero. scale) Implements java.sql.CallableStatement.registerOutParameter. Registers the parameter in ordinal position `parameterIndex` to be of JDBC type `sqlType`.
public void	registerOutParameter(int the first parameter is 1, the second is 2, and so on parameterIndex, SQLType the JDBC type code defined by `SQLType` to use to register the OUT Parameter. sqlType, int the desired number of digits to the right of the decimal point. It must be greater than or equal to zero. scale) Overrides default java.sql.CallableStatement.registerOutParameter. Registers the parameter in ordinal position `parameterIndex` to be of JDBC type `sqlType`.
protected void	registerOutParameter(int parameterIndex, MysqlType mysqlType, String typeName)
public void	registerOutParameter(int the first parameter is 1, the second is 2,... parameterIndex, int a value from `java.sql.Types` sqlType, String the fully-qualified name of an SQL structured type typeName) Implements java.sql.CallableStatement.registerOutParameter. Registers the designated output parameter.
public void	registerOutParameter(int the first parameter is 1, the second is 2,... parameterIndex, SQLType the JDBC type code defined by `SQLType` to use to register the OUT Parameter. sqlType, String the fully-qualified name of an SQL structured type typeName) Overrides default java.sql.CallableStatement.registerOutParameter. Registers the designated output parameter.
public void	registerOutParameter(String the name of the parameter parameterName, int the JDBC type code defined by `java.sql.Types`. If the parameter is of JDBC type `NUMERIC` or `DECIMAL`, the version of `registerOutParameter` that accepts a scale value should be used. sqlType) Implements java.sql.CallableStatement.registerOutParameter. Registers the OUT parameter named `parameterName` to the JDBC type `sqlType`.
public void	registerOutParameter(String the name of the parameter parameterName, SQLType the JDBC type code defined by `SQLType` to use to register the OUT Parameter. If the parameter is of JDBC type `JDBCType.NUMERIC` or `JDBCType.DECIMAL`, the version of `registerOutParameter` that accepts a scale value should be used. sqlType) Overrides default java.sql.CallableStatement.registerOutParameter. Registers the OUT parameter named `parameterName` to the JDBC type `sqlType`.
public void	registerOutParameter(String the name of the parameter parameterName, int SQL type code defined by `java.sql.Types`. sqlType, int the desired number of digits to the right of the decimal point. It must be greater than or equal to zero. scale) Implements java.sql.CallableStatement.registerOutParameter. Registers the parameter named `parameterName` to be of JDBC type `sqlType`.
public void	registerOutParameter(String the name of the parameter parameterName, SQLType the JDBC type code defined by `SQLType` to use to register the OUT Parameter. sqlType, int the desired number of digits to the right of the decimal point. It must be greater than or equal to zero. scale) Overrides default java.sql.CallableStatement.registerOutParameter. Registers the parameter named `parameterName` to be of JDBC type `sqlType`.
public void	registerOutParameter(String the name of the parameter parameterName, int a value from `java.sql.Types` sqlType, String the fully-qualified name of an SQL structured type typeName) Implements java.sql.CallableStatement.registerOutParameter. Registers the designated output parameter.
public void	registerOutParameter(String the name of the parameter parameterName, SQLType the JDBC type code defined by `SQLType` to use to register the OUT Parameter. sqlType, String the fully-qualified name of an SQL structured type typeName) Overrides default java.sql.CallableStatement.registerOutParameter. Registers the designated output parameter.
private void	retrieveOutParams() Issues a second query to retrieve all output parameters.
protected byte[]	Returns: bytes s2b(String string s) Converts the given string to bytes, using the connection's character encoding.
public void	setAsciiStream(String the name of the parameter parameterName, InputStream the Java input stream that contains the ASCII parameter value x, int the number of bytes in the stream length) Implements java.sql.CallableStatement.setAsciiStream. Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public void	setAsciiStream(String the name of the parameter parameterName, InputStream the Java input stream that contains the ASCII parameter value x) Implements java.sql.CallableStatement.setAsciiStream. Sets the designated parameter to the given input stream.
public void	setAsciiStream(String the name of the parameter parameterName, InputStream the Java input stream that contains the ASCII parameter value x, long the number of bytes in the stream length) Implements java.sql.CallableStatement.setAsciiStream. Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public void	setBigDecimal(String the name of the parameter parameterName, BigDecimal the parameter value x) Implements java.sql.CallableStatement.setBigDecimal. Sets the designated parameter to the given `java.math.BigDecimal` value.
public void	setBinaryStream(String the name of the parameter parameterName, InputStream the java input stream which contains the binary parameter value x, int the number of bytes in the stream length) Implements java.sql.CallableStatement.setBinaryStream. Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public void	setBinaryStream(String the name of the parameter parameterName, InputStream the java input stream which contains the binary parameter value x) Implements java.sql.CallableStatement.setBinaryStream. Sets the designated parameter to the given input stream.
public void	setBinaryStream(String the name of the parameter parameterName, InputStream the java input stream which contains the binary parameter value x, long the number of bytes in the stream length) Implements java.sql.CallableStatement.setBinaryStream. Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public void	setBlob(String the name of the parameter parameterName, Blob a `Blob` object that maps an SQL `BLOB` value x) Implements java.sql.CallableStatement.setBlob. Sets the designated parameter to the given `java.sql.Blob` object.
public void	setBlob(String the name of the parameter parameterName, InputStream An object that contains the data to set the parameter value to. inputStream) Implements java.sql.CallableStatement.setBlob. Sets the designated parameter to an `InputStream` object.
public void	setBlob(String the name of the parameter to be set the second is 2, ... parameterName, InputStream An object that contains the data to set the parameter value to. inputStream, long the number of bytes in the parameter data. length) Implements java.sql.CallableStatement.setBlob. Sets the designated parameter to an `InputStream` object.
public void	setBoolean(String the name of the parameter parameterName, boolean the parameter value x) Implements java.sql.CallableStatement.setBoolean. Sets the designated parameter to the given Java `boolean` value.
public void	setByte(String the name of the parameter parameterName, byte the parameter value x) Implements java.sql.CallableStatement.setByte. Sets the designated parameter to the given Java `byte` value.
public void	setBytes(String the name of the parameter parameterName, byte[] the parameter value x) Implements java.sql.CallableStatement.setBytes. Sets the designated parameter to the given Java array of bytes.
public void	setCharacterStream(String the name of the parameter parameterName, Reader the `java.io.Reader` object that contains the UNICODE data used as the designated parameter reader, int the number of characters in the stream length) Implements java.sql.CallableStatement.setCharacterStream. Sets the designated parameter to the given `Reader` object, which is the given number of characters long.
public void	setCharacterStream(String the name of the parameter parameterName, Reader the `java.io.Reader` object that contains the Unicode data reader) Implements java.sql.CallableStatement.setCharacterStream. Sets the designated parameter to the given `Reader` object.
public void	setCharacterStream(String the name of the parameter parameterName, Reader the `java.io.Reader` object that contains the UNICODE data used as the designated parameter reader, long the number of characters in the stream length) Implements java.sql.CallableStatement.setCharacterStream. Sets the designated parameter to the given `Reader` object, which is the given number of characters long.
public void	setClob(String the name of the parameter parameterName, Clob a `Clob` object that maps an SQL `CLOB` value x) Implements java.sql.CallableStatement.setClob. Sets the designated parameter to the given `java.sql.Clob` object.
public void	setClob(String the name of the parameter parameterName, Reader An object that contains the data to set the parameter value to. reader) Implements java.sql.CallableStatement.setClob. Sets the designated parameter to a `Reader` object.
public void	setClob(String the name of the parameter to be set parameterName, Reader An object that contains the data to set the parameter value to. reader, long the number of characters in the parameter data. length) Implements java.sql.CallableStatement.setClob. Sets the designated parameter to a `Reader` object.
public void	setDate(String the name of the parameter parameterName, Date the parameter value x) Implements java.sql.CallableStatement.setDate. Sets the designated parameter to the given `java.sql.Date` value using the default time zone of the virtual machine that is running the application.
public void	setDate(String the name of the parameter parameterName, Date the parameter value x, Calendar the `Calendar` object the driver will use to construct the date cal) Implements java.sql.CallableStatement.setDate. Sets the designated parameter to the given `java.sql.Date` value, using the given `Calendar` object.
public void	setDouble(String the name of the parameter parameterName, double the parameter value x) Implements java.sql.CallableStatement.setDouble. Sets the designated parameter to the given Java `double` value.
public void	setFloat(String the name of the parameter parameterName, float the parameter value x) Implements java.sql.CallableStatement.setFloat. Sets the designated parameter to the given Java `float` value.
private void	setInOutParamsOnServer()
public void	setInt(String the name of the parameter parameterName, int the parameter value x) Implements java.sql.CallableStatement.setInt. Sets the designated parameter to the given Java `int` value.
public void	setLong(String the name of the parameter parameterName, long the parameter value x) Implements java.sql.CallableStatement.setLong. Sets the designated parameter to the given Java `long` value.
public void	setNCharacterStream(String the name of the parameter parameterName, Reader the parameter value value) Implements java.sql.CallableStatement.setNCharacterStream. Sets the designated parameter to a `Reader` object.
public void	setNCharacterStream(String the name of the parameter to be set parameterName, Reader the parameter value value, long the number of characters in the parameter data. length) Implements java.sql.CallableStatement.setNCharacterStream. Sets the designated parameter to a `Reader` object.
public void	setNClob(String the name of the parameter to be set parameterName, NClob the parameter value value) Implements java.sql.CallableStatement.setNClob. Sets the designated parameter to a `java.sql.NClob` object.
public void	setNClob(String the name of the parameter parameterName, Reader An object that contains the data to set the parameter value to. reader) Implements java.sql.CallableStatement.setNClob. Sets the designated parameter to a `Reader` object.
public void	setNClob(String the name of the parameter to be set parameterName, Reader An object that contains the data to set the parameter value to. reader, long the number of characters in the parameter data. length) Implements java.sql.CallableStatement.setNClob. Sets the designated parameter to a `Reader` object.
public void	setNString(String the name of the parameter to be set parameterName, String the parameter value value) Implements java.sql.CallableStatement.setNString. Sets the designated parameter to the given `String` object.
public void	setNull(String the name of the parameter parameterName, int the SQL type code defined in `java.sql.Types` sqlType) Implements java.sql.CallableStatement.setNull. Sets the designated parameter to SQL `NULL`.
public void	setNull(String the name of the parameter parameterName, int a value from `java.sql.Types` sqlType, String the fully-qualified name of an SQL user-defined type; ignored if the parameter is not a user-defined type or SQL `REF` value typeName) Implements java.sql.CallableStatement.setNull. Sets the designated parameter to SQL `NULL`.
public void	setObject(String the name of the parameter parameterName, Object the object containing the input parameter value x) Implements java.sql.CallableStatement.setObject. Sets the value of the designated parameter with the given object.
public void	setObject(String the name of the parameter parameterName, Object the object containing the input parameter value x, int the SQL type (as defined in java.sql.Types) to be sent to the database targetSqlType) Implements java.sql.CallableStatement.setObject. Sets the value of the designated parameter with the given object.
public void	setObject(String the name of the parameter parameterName, Object the object containing the input parameter value x, SQLType the SQL type to be sent to the database targetSqlType) Overrides default java.sql.CallableStatement.setObject. Sets the value of the designated parameter with the given object.
public void	setObject(String the name of the parameter parameterName, Object the object containing the input parameter value x, int the SQL type (as defined in java.sql.Types) to be sent to the database. The scale argument may further qualify this type. targetSqlType, int for java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types, this is the number of digits after the decimal point. For all other types, this value will be ignored. scale) Implements java.sql.CallableStatement.setObject. Sets the value of the designated parameter with the given object.
public void	setObject(String the name of the parameter parameterName, Object the object containing the input parameter value x, SQLType the SQL type to be sent to the database. The scale argument may further qualify this type. targetSqlType, int for `java.sql.JDBCType.DECIMAL` or `java.sql.JDBCType.NUMERIC types`, this is the number of digits after the decimal point. For Java Object types `InputStream` and `Reader`, this is the length of the data in the stream or reader. For all other types, this value will be ignored. scaleOrLength) Overrides default java.sql.CallableStatement.setObject. Sets the value of the designated parameter with the given object.
private void	setOutParams()
public void	setRowId(String the name of the parameter parameterName, RowId the parameter value x) Implements java.sql.CallableStatement.setRowId. Sets the designated parameter to the given `java.sql.RowId` object.
public void	setShort(String the name of the parameter parameterName, short the parameter value x) Implements java.sql.CallableStatement.setShort. Sets the designated parameter to the given Java `short` value.
public void	setSQLXML(String the name of the parameter parameterName, SQLXML a `SQLXML` object that maps an `SQL XML` value xmlObject) Implements java.sql.CallableStatement.setSQLXML. Sets the designated parameter to the given `java.sql.SQLXML` object.
public void	setString(String the name of the parameter parameterName, String the parameter value x) Implements java.sql.CallableStatement.setString. Sets the designated parameter to the given Java `String` value.
public void	setTime(String the name of the parameter parameterName, Time the parameter value x) Implements java.sql.CallableStatement.setTime. Sets the designated parameter to the given `java.sql.Time` value.
public void	setTime(String the name of the parameter parameterName, Time the parameter value x, Calendar the `Calendar` object the driver will use to construct the time cal) Implements java.sql.CallableStatement.setTime. Sets the designated parameter to the given `java.sql.Time` value, using the given `Calendar` object.
public void	setTimestamp(String the name of the parameter parameterName, Timestamp the parameter value x) Implements java.sql.CallableStatement.setTimestamp. Sets the designated parameter to the given `java.sql.Timestamp` value.
public void	setTimestamp(String the name of the parameter parameterName, Timestamp the parameter value x, Calendar the `Calendar` object the driver will use to construct the timestamp cal) Implements java.sql.CallableStatement.setTimestamp. Sets the designated parameter to the given `java.sql.Timestamp` value, using the given `Calendar` object.
public void	setURL(String the name of the parameter parameterName, URL the parameter value val) Implements java.sql.CallableStatement.setURL. Sets the designated parameter to the given `java.net.URL` object.
public boolean	wasNull() Implements java.sql.CallableStatement.wasNull. Retrieves whether the last OUT parameter read had the value of SQL `NULL`.

Inherited from com.mysql.cj.jdbc.ClientPreparedStatement:: addBatch checkBounds clearBatch containsOnDuplicateKeyUpdate doClose executeBatchInternal executeBatchSerially executeBatchWithMultiValuesClause executeInternal executePreparedBatchAsMultiStatement executeUpdateInternal executeUpdateInternal getBytesRepresentation getCoreParameterIndex getInstance getInstance getMetaData getParameterBindings getPreparedSql getQueryBindings getQueryInfo getUpdateCount initQuery isNull isResultSetProducingQuery prepareBatchedInsertSQL setArray setAsciiStream setAsciiStream setAsciiStream setBigDecimal setBigInteger setBinaryStream setBinaryStream setBinaryStream setBlob setBlob setBlob setBoolean setByte setBytes 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 setOneBatchedParameterSet setRef setRetrieveGeneratedKeys setRowId setShort setSQLXML setString setTime setTime setTimestamp setTimestamp setUnicodeStream setURL toString

public Class CallableStatement

Nested and Inner Type Summary

Field Summary

Constructor Summary

Method Summary