Package com.mysql.cj.jdbc
Class CallableStatement
java.lang.Object
com.mysql.cj.jdbc.StatementImpl
com.mysql.cj.jdbc.ClientPreparedStatement
com.mysql.cj.jdbc.CallableStatement
- All Implemented Interfaces:
JdbcPreparedStatement
,JdbcStatement
,Query
,java.lang.AutoCloseable
,java.sql.CallableStatement
,java.sql.PreparedStatement
,java.sql.Statement
,java.sql.Wrapper
public class CallableStatement extends ClientPreparedStatement implements java.sql.CallableStatement
Representation of stored procedures for JDBC
-
Nested Class Summary
Nested Classes Modifier and Type Class Description protected static class
CallableStatement.CallableStatementParam
class
CallableStatement.CallableStatementParamInfo
-
Field Summary
Fields Modifier and Type Field Description protected boolean
outputParamWasNull
protected CallableStatement.CallableStatementParamInfo
paramInfo
Fields inherited from class com.mysql.cj.jdbc.ClientPreparedStatement
batchedValuesClause, batchHasPlainStatements, parameterMetaData, 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, session, updateCount, USES_VARIABLES_FALSE, USES_VARIABLES_TRUE, USES_VARIABLES_UNKNOWN, useUsageAdvisor, warningChain
-
Constructor Summary
Constructors Constructor Description CallableStatement(JdbcConnection conn, CallableStatement.CallableStatementParamInfo paramInfo)
Creates a new CallableStatementCallableStatement(JdbcConnection conn, java.lang.String sql, java.lang.String db, boolean isFunctionCall)
Creates a new CallableStatement -
Method Summary
Modifier and Type Method Description void
addBatch()
protected boolean
checkReadOnlySafeStatement()
Check to see if the statement is safe for read-only replicas after failover.void
clearParameters()
boolean
execute()
int[]
executeBatch()
long[]
executeLargeBatch()
long
executeLargeUpdate()
java.sql.ResultSet
executeQuery()
int
executeUpdate()
protected java.lang.String
fixParameterName(java.lang.String paramNameIn)
Adds 'at' symbol to beginning of parameter names if needed.java.sql.Array
getArray(int i)
java.sql.Array
getArray(java.lang.String parameterName)
java.math.BigDecimal
getBigDecimal(int parameterIndex)
java.math.BigDecimal
getBigDecimal(int parameterIndex, int scale)
Deprecated.java.math.BigDecimal
getBigDecimal(java.lang.String parameterName)
java.sql.Blob
getBlob(int parameterIndex)
java.sql.Blob
getBlob(java.lang.String parameterName)
boolean
getBoolean(int parameterIndex)
boolean
getBoolean(java.lang.String parameterName)
byte
getByte(int parameterIndex)
byte
getByte(java.lang.String parameterName)
byte[]
getBytes(int parameterIndex)
byte[]
getBytes(java.lang.String parameterName)
java.io.Reader
getCharacterStream(int parameterIndex)
java.io.Reader
getCharacterStream(java.lang.String parameterName)
java.sql.Clob
getClob(int parameterIndex)
java.sql.Clob
getClob(java.lang.String parameterName)
java.sql.Date
getDate(int parameterIndex)
java.sql.Date
getDate(int parameterIndex, java.util.Calendar cal)
java.sql.Date
getDate(java.lang.String parameterName)
java.sql.Date
getDate(java.lang.String parameterName, java.util.Calendar cal)
double
getDouble(int parameterIndex)
double
getDouble(java.lang.String parameterName)
float
getFloat(int parameterIndex)
float
getFloat(java.lang.String parameterName)
protected static CallableStatement
getInstance(JdbcConnection conn, CallableStatement.CallableStatementParamInfo paramInfo)
Creates a callable statement instanceprotected static CallableStatement
getInstance(JdbcConnection conn, java.lang.String sql, java.lang.String db, boolean isFunctionCall)
Creates a callable statement instanceint
getInt(int parameterIndex)
int
getInt(java.lang.String parameterName)
long
getLong(int parameterIndex)
long
getLong(java.lang.String parameterName)
protected int
getNamedParamIndex(java.lang.String paramName, boolean forOut)
java.io.Reader
getNCharacterStream(int parameterIndex)
java.io.Reader
getNCharacterStream(java.lang.String parameterName)
java.sql.NClob
getNClob(int parameterIndex)
java.sql.NClob
getNClob(java.lang.String parameterName)
java.lang.String
getNString(int parameterIndex)
java.lang.String
getNString(java.lang.String parameterName)
java.lang.Object
getObject(int parameterIndex)
<T> T
getObject(int parameterIndex, java.lang.Class<T> type)
java.lang.Object
getObject(int parameterIndex, java.util.Map<java.lang.String,java.lang.Class<?>> map)
java.lang.Object
getObject(java.lang.String parameterName)
<T> T
getObject(java.lang.String parameterName, java.lang.Class<T> type)
java.lang.Object
getObject(java.lang.String parameterName, java.util.Map<java.lang.String,java.lang.Class<?>> map)
protected ResultSetInternalMethods
getOutputParameters(int 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()
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 0java.sql.ParameterMetaData
getParameterMetaData()
java.sql.Ref
getRef(int parameterIndex)
java.sql.Ref
getRef(java.lang.String parameterName)
java.sql.RowId
getRowId(int parameterIndex)
java.sql.RowId
getRowId(java.lang.String parameterName)
short
getShort(int parameterIndex)
short
getShort(java.lang.String parameterName)
java.sql.SQLXML
getSQLXML(int parameterIndex)
java.sql.SQLXML
getSQLXML(java.lang.String parameterName)
java.lang.String
getString(int parameterIndex)
java.lang.String
getString(java.lang.String parameterName)
java.sql.Time
getTime(int parameterIndex)
java.sql.Time
getTime(int parameterIndex, java.util.Calendar cal)
java.sql.Time
getTime(java.lang.String parameterName)
java.sql.Time
getTime(java.lang.String parameterName, java.util.Calendar cal)
java.sql.Timestamp
getTimestamp(int parameterIndex)
java.sql.Timestamp
getTimestamp(int parameterIndex, java.util.Calendar cal)
java.sql.Timestamp
getTimestamp(java.lang.String parameterName)
java.sql.Timestamp
getTimestamp(java.lang.String parameterName, java.util.Calendar cal)
java.net.URL
getURL(int parameterIndex)
java.net.URL
getURL(java.lang.String parameterName)
protected int
mapOutputParameterIndexToRsIndex(int paramIndex)
void
registerOutParameter(int parameterIndex, int sqlType)
void
registerOutParameter(int parameterIndex, int sqlType, int scale)
void
registerOutParameter(int parameterIndex, int sqlType, java.lang.String typeName)
protected void
registerOutParameter(int parameterIndex, MysqlType mysqlType)
protected void
registerOutParameter(int parameterIndex, MysqlType mysqlType, int scale)
protected void
registerOutParameter(int parameterIndex, MysqlType mysqlType, java.lang.String typeName)
void
registerOutParameter(int parameterIndex, java.sql.SQLType sqlType)
void
registerOutParameter(int parameterIndex, java.sql.SQLType sqlType, int scale)
void
registerOutParameter(int parameterIndex, java.sql.SQLType sqlType, java.lang.String typeName)
void
registerOutParameter(java.lang.String parameterName, int sqlType)
void
registerOutParameter(java.lang.String parameterName, int sqlType, int scale)
void
registerOutParameter(java.lang.String parameterName, int sqlType, java.lang.String typeName)
void
registerOutParameter(java.lang.String parameterName, java.sql.SQLType sqlType)
void
registerOutParameter(java.lang.String parameterName, java.sql.SQLType sqlType, int scale)
void
registerOutParameter(java.lang.String parameterName, java.sql.SQLType sqlType, java.lang.String typeName)
protected byte[]
s2b(java.lang.String s)
Converts the given string to bytes, using the connection's character encoding.void
setAsciiStream(java.lang.String parameterName, java.io.InputStream x)
void
setAsciiStream(java.lang.String parameterName, java.io.InputStream x, int length)
void
setAsciiStream(java.lang.String parameterName, java.io.InputStream x, long length)
void
setBigDecimal(java.lang.String parameterName, java.math.BigDecimal x)
void
setBinaryStream(java.lang.String parameterName, java.io.InputStream x)
void
setBinaryStream(java.lang.String parameterName, java.io.InputStream x, int length)
void
setBinaryStream(java.lang.String parameterName, java.io.InputStream x, long length)
void
setBlob(java.lang.String parameterName, java.io.InputStream inputStream)
void
setBlob(java.lang.String parameterName, java.io.InputStream inputStream, long length)
void
setBlob(java.lang.String parameterName, java.sql.Blob x)
void
setBoolean(java.lang.String parameterName, boolean x)
void
setByte(java.lang.String parameterName, byte x)
void
setBytes(java.lang.String parameterName, byte[] x)
void
setCharacterStream(java.lang.String parameterName, java.io.Reader reader)
void
setCharacterStream(java.lang.String parameterName, java.io.Reader reader, int length)
void
setCharacterStream(java.lang.String parameterName, java.io.Reader reader, long length)
void
setClob(java.lang.String parameterName, java.io.Reader reader)
void
setClob(java.lang.String parameterName, java.io.Reader reader, long length)
void
setClob(java.lang.String parameterName, java.sql.Clob x)
void
setDate(java.lang.String parameterName, java.sql.Date x)
void
setDate(java.lang.String parameterName, java.sql.Date x, java.util.Calendar cal)
void
setDouble(java.lang.String parameterName, double x)
void
setFloat(java.lang.String parameterName, float x)
void
setInt(java.lang.String parameterName, int x)
void
setLong(java.lang.String parameterName, long x)
void
setNCharacterStream(java.lang.String parameterName, java.io.Reader value)
void
setNCharacterStream(java.lang.String parameterName, java.io.Reader value, long length)
void
setNClob(java.lang.String parameterName, java.io.Reader reader)
void
setNClob(java.lang.String parameterName, java.io.Reader reader, long length)
void
setNClob(java.lang.String parameterName, java.sql.NClob value)
void
setNString(java.lang.String parameterName, java.lang.String value)
void
setNull(java.lang.String parameterName, int sqlType)
void
setNull(java.lang.String parameterName, int sqlType, java.lang.String typeName)
void
setObject(java.lang.String parameterName, java.lang.Object x)
void
setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType)
void
setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType, int scale)
void
setObject(java.lang.String parameterName, java.lang.Object x, java.sql.SQLType targetSqlType)
void
setObject(java.lang.String parameterName, java.lang.Object x, java.sql.SQLType targetSqlType, int scaleOrLength)
void
setRowId(java.lang.String parameterName, java.sql.RowId x)
void
setShort(java.lang.String parameterName, short x)
void
setSQLXML(java.lang.String parameterName, java.sql.SQLXML xmlObject)
void
setString(java.lang.String parameterName, java.lang.String x)
void
setTime(java.lang.String parameterName, java.sql.Time x)
void
setTime(java.lang.String parameterName, java.sql.Time x, java.util.Calendar cal)
void
setTimestamp(java.lang.String parameterName, java.sql.Timestamp x)
void
setTimestamp(java.lang.String parameterName, java.sql.Timestamp x, java.util.Calendar cal)
void
setURL(java.lang.String parameterName, java.net.URL val)
boolean
wasNull()
Methods inherited from class com.mysql.cj.jdbc.ClientPreparedStatement
addBatch, asSql, asSql, checkBounds, clearBatch, containsOnDuplicateKeyUpdateInSQL, executeBatchedInserts, executeBatchInternal, executeBatchSerially, executeInternal, executePreparedBatchAsMultiStatement, executeUpdateInternal, executeUpdateInternal, getBytesRepresentation, getCoreParameterIndex, getInstance, getInstance, getMetaData, getOrigBytes, getParameterBindings, getParseInfo, getPreparedSql, getQueryBindings, getUpdateCount, initQuery, isNull, isSelectQuery, prepareBatchedInsertSQL, realClose, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBigInteger, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setBytes, setBytesNoEscape, setBytesNoEscapeNoQuotes, 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, setTimestamp, setUnicodeStream, setURL, toString
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, 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.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, setNClob, setNString, setNull, setNull, setObject, setObject, setObject, setObject, setObject, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL
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
Methods inherited from interface java.sql.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
-
Field Details
-
outputParamWasNull
protected boolean outputParamWasNull -
paramInfo
-
-
Constructor Details
-
CallableStatement
public CallableStatement(JdbcConnection conn, CallableStatement.CallableStatementParamInfo paramInfo) throws java.sql.SQLExceptionCreates a new CallableStatement- Parameters:
conn
- the connection creating this statementparamInfo
- the SQL to prepare- Throws:
java.sql.SQLException
- if an error occurs
-
CallableStatement
public CallableStatement(JdbcConnection conn, java.lang.String sql, java.lang.String db, boolean isFunctionCall) throws java.sql.SQLExceptionCreates a new CallableStatement- Parameters:
conn
- the connection creating this statementsql
- the SQL to preparedb
- the current databaseisFunctionCall
- is it a function call or a procedure call?- Throws:
java.sql.SQLException
- if an error occurs
-
-
Method Details
-
getInstance
protected static CallableStatement getInstance(JdbcConnection conn, java.lang.String sql, java.lang.String db, boolean isFunctionCall) throws java.sql.SQLExceptionCreates a callable statement instance- Parameters:
conn
- the connection creating this statementsql
- the SQL to preparedb
- the current databaseisFunctionCall
- is it a function call or a procedure call?- Returns:
- CallableStatement
- Throws:
java.sql.SQLException
- if an error occurs
-
getInstance
protected static CallableStatement getInstance(JdbcConnection conn, CallableStatement.CallableStatementParamInfo paramInfo) throws java.sql.SQLExceptionCreates a callable statement instance- Parameters:
conn
- the connection creating this statementparamInfo
- the SQL to prepare- Returns:
- CallableStatement
- Throws:
java.sql.SQLException
- if an error occurs
-
addBatch
public void addBatch() throws java.sql.SQLException- Specified by:
addBatch
in interfacejava.sql.PreparedStatement
- Overrides:
addBatch
in classClientPreparedStatement
- Throws:
java.sql.SQLException
-
clearParameters
public void clearParameters() throws java.sql.SQLException- Specified by:
clearParameters
in interfacejava.sql.PreparedStatement
- Overrides:
clearParameters
in classClientPreparedStatement
- Throws:
java.sql.SQLException
-
execute
public boolean execute() throws java.sql.SQLException- Specified by:
execute
in interfacejava.sql.PreparedStatement
- Overrides:
execute
in classClientPreparedStatement
- Throws:
java.sql.SQLException
-
executeQuery
public java.sql.ResultSet executeQuery() throws java.sql.SQLException- Specified by:
executeQuery
in interfacejava.sql.PreparedStatement
- Overrides:
executeQuery
in classClientPreparedStatement
- Throws:
java.sql.SQLException
-
executeUpdate
public int executeUpdate() throws java.sql.SQLException- Specified by:
executeUpdate
in interfacejava.sql.PreparedStatement
- Overrides:
executeUpdate
in classClientPreparedStatement
- Throws:
java.sql.SQLException
-
fixParameterName
protected java.lang.String fixParameterName(java.lang.String paramNameIn) throws java.sql.SQLExceptionAdds 'at' symbol to beginning of parameter names if needed.- Parameters:
paramNameIn
- the parameter name to 'fix'- Returns:
- the parameter name with an 'a' prepended, if needed
- Throws:
java.sql.SQLException
- if the parameter name is null or empty.
-
getArray
public java.sql.Array getArray(int i) throws java.sql.SQLException- Specified by:
getArray
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getArray
public java.sql.Array getArray(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getArray
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBigDecimal
public java.math.BigDecimal getBigDecimal(int parameterIndex) throws java.sql.SQLException- Specified by:
getBigDecimal
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBigDecimal
@Deprecated public java.math.BigDecimal getBigDecimal(int parameterIndex, int scale) throws java.sql.SQLExceptionDeprecated.- Specified by:
getBigDecimal
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBigDecimal
public java.math.BigDecimal getBigDecimal(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getBigDecimal
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBlob
public java.sql.Blob getBlob(int parameterIndex) throws java.sql.SQLException- Specified by:
getBlob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBlob
public java.sql.Blob getBlob(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getBlob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBoolean
public boolean getBoolean(int parameterIndex) throws java.sql.SQLException- Specified by:
getBoolean
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBoolean
public boolean getBoolean(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getBoolean
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getByte
public byte getByte(int parameterIndex) throws java.sql.SQLException- Specified by:
getByte
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getByte
public byte getByte(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getByte
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBytes
public byte[] getBytes(int parameterIndex) throws java.sql.SQLException- Specified by:
getBytes
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBytes
public byte[] getBytes(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getBytes
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getClob
public java.sql.Clob getClob(int parameterIndex) throws java.sql.SQLException- Specified by:
getClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getClob
public java.sql.Clob getClob(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getDate
public java.sql.Date getDate(int parameterIndex) throws java.sql.SQLException- Specified by:
getDate
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getDate
public java.sql.Date getDate(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException- Specified by:
getDate
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getDate
public java.sql.Date getDate(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getDate
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getDate
public java.sql.Date getDate(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLException- Specified by:
getDate
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getDouble
public double getDouble(int parameterIndex) throws java.sql.SQLException- Specified by:
getDouble
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getDouble
public double getDouble(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getDouble
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getFloat
public float getFloat(int parameterIndex) throws java.sql.SQLException- Specified by:
getFloat
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getFloat
public float getFloat(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getFloat
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getInt
public int getInt(int parameterIndex) throws java.sql.SQLException- Specified by:
getInt
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getInt
public int getInt(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getInt
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getLong
public long getLong(int parameterIndex) throws java.sql.SQLException- Specified by:
getLong
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getLong
public long getLong(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getLong
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getNamedParamIndex
protected int getNamedParamIndex(java.lang.String paramName, boolean forOut) throws java.sql.SQLException- Throws:
java.sql.SQLException
-
getObject
public java.lang.Object getObject(int parameterIndex) throws java.sql.SQLException- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getObject
public java.lang.Object getObject(int parameterIndex, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getObject
public java.lang.Object getObject(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getObject
public java.lang.Object getObject(java.lang.String parameterName, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getObject
public <T> T getObject(int parameterIndex, java.lang.Class<T> type) throws java.sql.SQLException- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getObject
public <T> T getObject(java.lang.String parameterName, java.lang.Class<T> type) throws java.sql.SQLException- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getOutputParameters
protected ResultSetInternalMethods getOutputParameters(int paramIndex) throws java.sql.SQLExceptionReturns the ResultSet that holds the output parameters, or throws an appropriate exception if none exist, or they weren't returned.- Parameters:
paramIndex
- parameter index- Returns:
- the ResultSet that holds the output parameters
- Throws:
java.sql.SQLException
- if no output parameters were defined, or if no output parameters were returned.
-
getParameterMetaData
public java.sql.ParameterMetaData getParameterMetaData() throws java.sql.SQLException- Specified by:
getParameterMetaData
in interfacejava.sql.PreparedStatement
- Overrides:
getParameterMetaData
in classClientPreparedStatement
- Throws:
java.sql.SQLException
-
getRef
public java.sql.Ref getRef(int parameterIndex) throws java.sql.SQLException- Specified by:
getRef
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getRef
public java.sql.Ref getRef(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getRef
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getShort
public short getShort(int parameterIndex) throws java.sql.SQLException- Specified by:
getShort
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getShort
public short getShort(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getShort
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getString
public java.lang.String getString(int parameterIndex) throws java.sql.SQLException- Specified by:
getString
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getString
public java.lang.String getString(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getString
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTime
public java.sql.Time getTime(int parameterIndex) throws java.sql.SQLException- Specified by:
getTime
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTime
public java.sql.Time getTime(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException- Specified by:
getTime
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTime
public java.sql.Time getTime(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getTime
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTime
public java.sql.Time getTime(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLException- Specified by:
getTime
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTimestamp
public java.sql.Timestamp getTimestamp(int parameterIndex) throws java.sql.SQLException- Specified by:
getTimestamp
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTimestamp
public java.sql.Timestamp getTimestamp(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException- Specified by:
getTimestamp
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTimestamp
public java.sql.Timestamp getTimestamp(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getTimestamp
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTimestamp
public java.sql.Timestamp getTimestamp(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLException- Specified by:
getTimestamp
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getURL
public java.net.URL getURL(int parameterIndex) throws java.sql.SQLException- Specified by:
getURL
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getURL
public java.net.URL getURL(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getURL
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
mapOutputParameterIndexToRsIndex
protected int mapOutputParameterIndexToRsIndex(int paramIndex) throws java.sql.SQLException- Throws:
java.sql.SQLException
-
registerOutParameter
protected void registerOutParameter(int parameterIndex, MysqlType mysqlType) throws java.sql.SQLException- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, int sqlType) throws java.sql.SQLException- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, java.sql.SQLType sqlType) throws java.sql.SQLException- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
protected void registerOutParameter(int parameterIndex, MysqlType mysqlType, int scale) throws java.sql.SQLException- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, int sqlType, int scale) throws java.sql.SQLException- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, java.sql.SQLType sqlType, int scale) throws java.sql.SQLException- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
protected void registerOutParameter(int parameterIndex, MysqlType mysqlType, java.lang.String typeName) throws java.sql.SQLException- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, int sqlType, java.lang.String typeName) throws java.sql.SQLException- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, java.sql.SQLType sqlType, java.lang.String typeName) throws java.sql.SQLException- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(java.lang.String parameterName, int sqlType) throws java.sql.SQLException- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(java.lang.String parameterName, java.sql.SQLType sqlType) throws java.sql.SQLException- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(java.lang.String parameterName, int sqlType, int scale) throws java.sql.SQLException- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(java.lang.String parameterName, java.sql.SQLType sqlType, int scale) throws java.sql.SQLException- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(java.lang.String parameterName, int sqlType, java.lang.String typeName) throws java.sql.SQLException- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(java.lang.String parameterName, java.sql.SQLType sqlType, java.lang.String typeName) throws java.sql.SQLException- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setAsciiStream
public void setAsciiStream(java.lang.String parameterName, java.io.InputStream x, int length) throws java.sql.SQLException- Specified by:
setAsciiStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBigDecimal
public void setBigDecimal(java.lang.String parameterName, java.math.BigDecimal x) throws java.sql.SQLException- Specified by:
setBigDecimal
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBinaryStream
public void setBinaryStream(java.lang.String parameterName, java.io.InputStream x, int length) throws java.sql.SQLException- Specified by:
setBinaryStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBoolean
public void setBoolean(java.lang.String parameterName, boolean x) throws java.sql.SQLException- Specified by:
setBoolean
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setByte
public void setByte(java.lang.String parameterName, byte x) throws java.sql.SQLException- Specified by:
setByte
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBytes
public void setBytes(java.lang.String parameterName, byte[] x) throws java.sql.SQLException- Specified by:
setBytes
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setCharacterStream
public void setCharacterStream(java.lang.String parameterName, java.io.Reader reader, int length) throws java.sql.SQLException- Specified by:
setCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setDate
public void setDate(java.lang.String parameterName, java.sql.Date x) throws java.sql.SQLException- Specified by:
setDate
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setDate
public void setDate(java.lang.String parameterName, java.sql.Date x, java.util.Calendar cal) throws java.sql.SQLException- Specified by:
setDate
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setDouble
public void setDouble(java.lang.String parameterName, double x) throws java.sql.SQLException- Specified by:
setDouble
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setFloat
public void setFloat(java.lang.String parameterName, float x) throws java.sql.SQLException- Specified by:
setFloat
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setInt
public void setInt(java.lang.String parameterName, int x) throws java.sql.SQLException- Specified by:
setInt
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setLong
public void setLong(java.lang.String parameterName, long x) throws java.sql.SQLException- Specified by:
setLong
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNull
public void setNull(java.lang.String parameterName, int sqlType) throws java.sql.SQLException- Specified by:
setNull
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNull
public void setNull(java.lang.String parameterName, int sqlType, java.lang.String typeName) throws java.sql.SQLException- Specified by:
setNull
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setObject
public void setObject(java.lang.String parameterName, java.lang.Object x) throws java.sql.SQLException- Specified by:
setObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setObject
public void setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType) throws java.sql.SQLException- Specified by:
setObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setObject
public void setObject(java.lang.String parameterName, java.lang.Object x, java.sql.SQLType targetSqlType) throws java.sql.SQLException- Specified by:
setObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setObject
public void setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType, int scale) throws java.sql.SQLException- Specified by:
setObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setObject
public void setObject(java.lang.String parameterName, java.lang.Object x, java.sql.SQLType targetSqlType, int scaleOrLength) throws java.sql.SQLException- Specified by:
setObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setShort
public void setShort(java.lang.String parameterName, short x) throws java.sql.SQLException- Specified by:
setShort
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setString
public void setString(java.lang.String parameterName, java.lang.String x) throws java.sql.SQLException- Specified by:
setString
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setTime
public void setTime(java.lang.String parameterName, java.sql.Time x) throws java.sql.SQLException- Specified by:
setTime
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setTime
public void setTime(java.lang.String parameterName, java.sql.Time x, java.util.Calendar cal) throws java.sql.SQLException- Specified by:
setTime
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setTimestamp
public void setTimestamp(java.lang.String parameterName, java.sql.Timestamp x) throws java.sql.SQLException- Specified by:
setTimestamp
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setTimestamp
public void setTimestamp(java.lang.String parameterName, java.sql.Timestamp x, java.util.Calendar cal) throws java.sql.SQLException- Specified by:
setTimestamp
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setURL
public void setURL(java.lang.String parameterName, java.net.URL val) throws java.sql.SQLException- Specified by:
setURL
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
wasNull
public boolean wasNull() throws java.sql.SQLException- Specified by:
wasNull
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
executeBatch
public int[] executeBatch() throws java.sql.SQLException- Specified by:
executeBatch
in interfacejava.sql.Statement
- Overrides:
executeBatch
in classStatementImpl
- Throws:
java.sql.SQLException
-
getParameterIndexOffset
protected int getParameterIndexOffset()Description copied from class:ClientPreparedStatement
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- Overrides:
getParameterIndexOffset
in classClientPreparedStatement
- Returns:
- offset
-
setAsciiStream
public void setAsciiStream(java.lang.String parameterName, java.io.InputStream x) throws java.sql.SQLException- Specified by:
setAsciiStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setAsciiStream
public void setAsciiStream(java.lang.String parameterName, java.io.InputStream x, long length) throws java.sql.SQLException- Specified by:
setAsciiStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBinaryStream
public void setBinaryStream(java.lang.String parameterName, java.io.InputStream x) throws java.sql.SQLException- Specified by:
setBinaryStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBinaryStream
public void setBinaryStream(java.lang.String parameterName, java.io.InputStream x, long length) throws java.sql.SQLException- Specified by:
setBinaryStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBlob
public void setBlob(java.lang.String parameterName, java.sql.Blob x) throws java.sql.SQLException- Specified by:
setBlob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBlob
public void setBlob(java.lang.String parameterName, java.io.InputStream inputStream) throws java.sql.SQLException- Specified by:
setBlob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBlob
public void setBlob(java.lang.String parameterName, java.io.InputStream inputStream, long length) throws java.sql.SQLException- Specified by:
setBlob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setCharacterStream
public void setCharacterStream(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException- Specified by:
setCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setCharacterStream
public void setCharacterStream(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException- Specified by:
setCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setClob
public void setClob(java.lang.String parameterName, java.sql.Clob x) throws java.sql.SQLException- Specified by:
setClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setClob
public void setClob(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException- Specified by:
setClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setClob
public void setClob(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException- Specified by:
setClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNCharacterStream
public void setNCharacterStream(java.lang.String parameterName, java.io.Reader value) throws java.sql.SQLException- Specified by:
setNCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNCharacterStream
public void setNCharacterStream(java.lang.String parameterName, java.io.Reader value, long length) throws java.sql.SQLException- Specified by:
setNCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
checkReadOnlySafeStatement
protected boolean checkReadOnlySafeStatement() throws java.sql.SQLExceptionDescription copied from class:ClientPreparedStatement
Check to see if the statement is safe for read-only replicas after failover.- Overrides:
checkReadOnlySafeStatement
in classClientPreparedStatement
- 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
-
getRowId
public java.sql.RowId getRowId(int parameterIndex) throws java.sql.SQLException- Specified by:
getRowId
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getRowId
public java.sql.RowId getRowId(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getRowId
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setRowId
public void setRowId(java.lang.String parameterName, java.sql.RowId x) throws java.sql.SQLException- Specified by:
setRowId
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNString
public void setNString(java.lang.String parameterName, java.lang.String value) throws java.sql.SQLException- Specified by:
setNString
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNClob
public void setNClob(java.lang.String parameterName, java.sql.NClob value) throws java.sql.SQLException- Specified by:
setNClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNClob
public void setNClob(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException- Specified by:
setNClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNClob
public void setNClob(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException- Specified by:
setNClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setSQLXML
public void setSQLXML(java.lang.String parameterName, java.sql.SQLXML xmlObject) throws java.sql.SQLException- Specified by:
setSQLXML
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getSQLXML
public java.sql.SQLXML getSQLXML(int parameterIndex) throws java.sql.SQLException- Specified by:
getSQLXML
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getSQLXML
public java.sql.SQLXML getSQLXML(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getSQLXML
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getNString
public java.lang.String getNString(int parameterIndex) throws java.sql.SQLException- Specified by:
getNString
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getNString
public java.lang.String getNString(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getNString
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getNCharacterStream
public java.io.Reader getNCharacterStream(int parameterIndex) throws java.sql.SQLException- Specified by:
getNCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getNCharacterStream
public java.io.Reader getNCharacterStream(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getNCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getCharacterStream
public java.io.Reader getCharacterStream(int parameterIndex) throws java.sql.SQLException- Specified by:
getCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getCharacterStream
public java.io.Reader getCharacterStream(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getNClob
public java.sql.NClob getNClob(int parameterIndex) throws java.sql.SQLException- Specified by:
getNClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getNClob
public java.sql.NClob getNClob(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getNClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
s2b
protected byte[] s2b(java.lang.String s)Converts the given string to bytes, using the connection's character encoding.- Parameters:
s
- string- Returns:
- bytes
-
executeLargeUpdate
public long executeLargeUpdate() throws java.sql.SQLException- Specified by:
executeLargeUpdate
in interfacejava.sql.PreparedStatement
- Overrides:
executeLargeUpdate
in classClientPreparedStatement
- Throws:
java.sql.SQLException
-
executeLargeBatch
public long[] executeLargeBatch() throws java.sql.SQLException- Specified by:
executeLargeBatch
in interfacejava.sql.Statement
- Overrides:
executeLargeBatch
in classStatementImpl
- Throws:
java.sql.SQLException
-