Package org.apache.derby.impl.jdbc
Class EmbedCallableStatement
- java.lang.Object
-
- org.apache.derby.impl.jdbc.ConnectionChild
-
- org.apache.derby.impl.jdbc.EmbedStatement
-
- org.apache.derby.impl.jdbc.EmbedPreparedStatement
-
- org.apache.derby.impl.jdbc.EmbedCallableStatement
-
- All Implemented Interfaces:
java.lang.AutoCloseable,java.sql.CallableStatement,java.sql.PreparedStatement,java.sql.Statement,java.sql.Wrapper,EngineCallableStatement,EnginePreparedStatement,EngineStatement
- Direct Known Subclasses:
EmbedCallableStatement42
public class EmbedCallableStatement extends EmbedPreparedStatement implements EngineCallableStatement
Local implementation.
-
-
Field Summary
Fields Modifier and Type Field Description private booleanhasReturnOutputParameterprotected booleanwasNull-
Fields inherited from class org.apache.derby.impl.jdbc.EmbedPreparedStatement
preparedStatement, rMetaData
-
Fields inherited from class org.apache.derby.impl.jdbc.EmbedStatement
applicationStatement, batchStatements, isPoolable, lcc, MaxFieldSize, maxRows, results, resultSetConcurrency, resultSetType, SQLText, timeoutMillis, updateCount
-
Fields inherited from class org.apache.derby.impl.jdbc.ConnectionChild
factory, localConn
-
-
Constructor Summary
Constructors Constructor Description EmbedCallableStatement(EmbedConnection conn, java.lang.String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
-
Method Summary
All Methods Instance Methods Concrete Methods Deprecated Methods Modifier and Type Method Description voidaddBatch()JDBC 2.0 Add a set of parameters to the batch.protected voidcheckRequiresCallableStatement(Activation activation)Check to see if a statement requires to be executed via a callable statement.protected booleanexecuteStatement(Activation a, boolean executeQuery, boolean executeUpdate)Execute the current statement.java.sql.ArraygetArray(int i)JDBC 2.0 Get an Array OUT parameter.java.sql.ArraygetArray(java.lang.String parameterName)JDBC 3.0 Retrieves the value of a JDBC ARRAY parameter as an Array object in the Java programming language.java.math.BigDecimalgetBigDecimal(int parameterIndex)JDBC 2.0 Get the value of a NUMERIC parameter as a java.math.BigDecimal object.java.math.BigDecimalgetBigDecimal(int parameterIndex, int scale)Deprecated.java.math.BigDecimalgetBigDecimal(java.lang.String parameterName)JDBC 3.0 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 containsprivate java.io.InputStreamgetBinaryStream(int parameterIndex)Get binary stream for a parameter.java.sql.BlobgetBlob(int parameterIndex)JDBC 2.0 Get a BLOB OUT parameter.java.sql.BlobgetBlob(java.lang.String parameterName)JDBC 3.0 Retrieves the value of a JDBC BLOB parameter as a Blob object in the Java programming language.booleangetBoolean(int parameterIndex)booleangetBoolean(java.lang.String parameterName)JDBC 3.0 Retrieves the value of a JDBC BIT parameter as a boolean in the Java programming language.bytegetByte(int parameterIndex)bytegetByte(java.lang.String parameterName)JDBC 3.0 Retrieves the value of a JDBC TINYINT parameter as a byte in the Java programming language.byte[]getBytes(int parameterIndex)byte[]getBytes(java.lang.String parameterName)JDBC 3.0 Retrieves the value of a JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language.java.io.ReadergetCharacterStream(int parameterIndex)Retrieves the value of the designated parameter as ajava.io.Readerobject in the Java programming language.java.io.ReadergetCharacterStream(java.lang.String parameterName)java.sql.ClobgetClob(int parameterIndex)JDBC 2.0 Get a CLOB OUT parameter.java.sql.ClobgetClob(java.lang.String parameterName)JDBC 3.0 Retrieves the value of a JDBC CLOB parameter as a Clob object in the Java programming language.java.sql.DategetDate(int parameterIndex)Get the value of a SQL DATE parameter as a java.sql.Date objectjava.sql.DategetDate(int parameterIndex, java.util.Calendar cal)java.sql.DategetDate(java.lang.String parameterName)JDBC 3.0 Retrieves the value of a JDBC DATE parameter as a java.sql.Date objectjava.sql.DategetDate(java.lang.String parameterName, java.util.Calendar cal)JDBC 3.0 Retrieves the value of a JDBC DATE parameter as a java.sql.Date object, using the given Calendar object to construct the date object.doublegetDouble(int parameterIndex)doublegetDouble(java.lang.String parameterName)JDBC 3.0 Retrieves the value of a JDBC DOUBLE parameter as a double in the Java programming language.floatgetFloat(int parameterIndex)floatgetFloat(java.lang.String parameterName)JDBC 3.0 Retrieves the value of a JDBC FLOAT parameter as a float in the Java programming language.intgetInt(int parameterIndex)intgetInt(java.lang.String parameterName)JDBC 3.0 Retrieves the value of a JDBC INTEGER parameter as a int in the Java programming language.longgetLong(int parameterIndex)longgetLong(java.lang.String parameterName)JDBC 3.0 Retrieves the value of a JDBC BIGINT parameter as a long in the Java programming language.java.io.ReadergetNCharacterStream(int parameterIndex)java.io.ReadergetNCharacterStream(java.lang.String parameterName)java.sql.NClobgetNClob(int i)java.sql.NClobgetNClob(java.lang.String parameterName)java.lang.StringgetNString(int parameterIndex)java.lang.StringgetNString(java.lang.String parameterName)java.lang.ObjectgetObject(int parameterIndex)<T> TgetObject(int parameterIndex, java.lang.Class<T> type)java.lang.ObjectgetObject(int i, java.util.Map<java.lang.String,java.lang.Class<?>> map)JDBC 2.0 Returns an object representing the value of OUT parameteri.java.lang.ObjectgetObject(java.lang.String parameterName)JDBC 3.0 Retrieves the value of a parameter as an Object in the java programming language.<T> TgetObject(java.lang.String parameterName, java.lang.Class<T> type)java.lang.ObjectgetObject(java.lang.String parameterName, java.util.Map<java.lang.String,java.lang.Class<?>> map)JDBC 3.0 Returns an object representing the value of OUT parameter i and uses map for the custom mapping of the parameter value.java.sql.RefgetRef(int i)JDBC 2.0 Get a REF(<structured-type>) OUT parameter.java.sql.RefgetRef(java.lang.String parameterName)JDBC 3.0 Retrieves the value of a JDBC REF (structured-type) parameter as a Ref object in the Java programming language.java.sql.RowIdgetRowId(int parameterIndex)java.sql.RowIdgetRowId(java.lang.String parameterName)shortgetShort(int parameterIndex)shortgetShort(java.lang.String parameterName)JDBC 3.0 Retrieves the value of a JDBC SMALLINT parameter as a short in the Java programming language.java.sql.SQLXMLgetSQLXML(int parameterIndex)java.sql.SQLXMLgetSQLXML(java.lang.String parametername)java.lang.StringgetString(int parameterIndex)java.lang.StringgetString(java.lang.String parameterName)JDBC 3.0 Retrieves the value of a JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.java.sql.TimegetTime(int parameterIndex)Get the value of a SQL TIME parameter as a java.sql.Time object.java.sql.TimegetTime(int parameterIndex, java.util.Calendar cal)java.sql.TimegetTime(java.lang.String parameterName)JDBC 3.0 Retrieves the value of a JDBC TIME parameter as ajava.sql.Time objectjava.sql.TimegetTime(java.lang.String parameterName, java.util.Calendar cal)JDBC 3.0 Retrieves the value of a JDBC TIME parameter as a java.sql.Time object, using the given Calendar object to construct the time object.java.sql.TimestampgetTimestamp(int parameterIndex)Get the value of a SQL TIMESTAMP parameter as a java.sql.Timestamp object.java.sql.TimestampgetTimestamp(int parameterIndex, java.util.Calendar cal)java.sql.TimestampgetTimestamp(java.lang.String parameterName)JDBC 3.0 Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp objectjava.sql.TimestampgetTimestamp(java.lang.String parameterName, java.util.Calendar cal)JDBC 3.0 Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object, using the given Calendar object to construct the Timestamp object.java.net.URLgetURL(int parameterIndex)JDBC 3.0 Retrieve the value of the designated JDBC DATALINK parameter as a java.net.URL objectjava.net.URLgetURL(java.lang.String parameterName)JDBC 3.0 Retrieves the value of a JDBC DATALINK parameter as a java.net.URL objectprivate java.sql.SQLExceptionmismatchException(java.lang.String targetTypeName, int parameterIndex)voidregisterOutParameter(int parameterIndex, int sqlType)voidregisterOutParameter(int parameterIndex, int sqlType, int scale)voidregisterOutParameter(int parameterIndex, int sqlType, java.lang.String typeName)JDBC 2.0 Derby ignores the typeName argument because UDTs don't need it.voidregisterOutParameter(java.lang.String parameterName, int sqlType)JDBC 3.0 Registers the OUT parameter named parameterName to the JDBC type sqlType.voidregisterOutParameter(java.lang.String parameterName, int sqlType, int scale)JDBC 3.0 Registers the parameter named parameterName to the JDBC type sqlType.voidregisterOutParameter(java.lang.String parameterName, int sqlType, java.lang.String typeName)JDBC 3.0 Registers the designated output parameter.voidsetAsciiStream(java.lang.String parameterName, java.io.InputStream x)voidsetAsciiStream(java.lang.String parameterName, java.io.InputStream x, int length)JDBC 3.0 Sets the designated parameter to the given input stream, which will have the specified number of bytes.voidsetAsciiStream(java.lang.String parameterName, java.io.InputStream x, long length)Sets the designated parameter to the given input stream, which will have the specified number of bytes.voidsetBigDecimal(java.lang.String parameterName, java.math.BigDecimal x)JDBC 3.0 Sets the designated parameter to the given java.math.BigDecimal value.voidsetBinaryStream(java.lang.String parameterName, java.io.InputStream x)voidsetBinaryStream(java.lang.String parameterName, java.io.InputStream x, int length)JDBC 3.0 Sets the designated parameter to the given input stream, which will have the specified number of bytes.voidsetBinaryStream(java.lang.String parameterName, java.io.InputStream x, long length)Sets the designated parameter to the given input stream, which will have the specified number of bytes.voidsetBlob(java.lang.String parameterName, java.io.InputStream inputStream)voidsetBlob(java.lang.String parameterName, java.io.InputStream inputStream, long length)voidsetBlob(java.lang.String parameterName, java.sql.Blob x)voidsetBoolean(java.lang.String parameterName, boolean x)JDBC 3.0 Sets the designated parameter to the given Java boolean value.voidsetByte(java.lang.String parameterName, byte x)JDBC 3.0 Sets the designated parameter to the given Java byte value.voidsetBytes(java.lang.String parameterName, byte[] x)JDBC 3.0 Sets the designated parameter to the given Java array of bytes.voidsetCharacterStream(java.lang.String parameterName, java.io.Reader reader)voidsetCharacterStream(java.lang.String parameterName, java.io.Reader reader, int length)JDBC 3.0 Sets the designated parameter to the given Reader object, which is the given number of characters long.voidsetCharacterStream(java.lang.String parameterName, java.io.Reader x, long length)Sets the designated parameter to the given Reader, which will have the specified number of bytes.voidsetClob(java.lang.String parameterName, java.io.Reader reader)voidsetClob(java.lang.String parameterName, java.io.Reader reader, long length)voidsetClob(java.lang.String parameterName, java.sql.Clob x)voidsetDate(java.lang.String parameterName, java.sql.Date x)JDBC 3.0 Sets the designated parameter to the given java.sql.Date value.voidsetDate(java.lang.String parameterName, java.sql.Date x, java.util.Calendar cal)JDBC 3.0 Sets the designated parameter to the given java.sql.Date value, using the given Calendar object.voidsetDouble(java.lang.String parameterName, double x)JDBC 3.0 Sets the designated parameter to the given Java double value.voidsetFloat(java.lang.String parameterName, float x)JDBC 3.0 Sets the designated parameter to the given Java float value.voidsetInt(java.lang.String parameterName, int x)JDBC 3.0 Sets the designated parameter to the given Java int value.voidsetLong(java.lang.String parameterName, long x)JDBC 3.0 Sets the designated parameter to the given Java long value.voidsetNCharacterStream(java.lang.String parameterName, java.io.Reader value)voidsetNCharacterStream(java.lang.String parameterName, java.io.Reader value, long length)voidsetNClob(java.lang.String parameterName, java.io.Reader reader)voidsetNClob(java.lang.String parameterName, java.io.Reader reader, long length)voidsetNClob(java.lang.String parameterName, java.sql.NClob value)voidsetNString(java.lang.String parameterName, java.lang.String value)voidsetNull(java.lang.String parameterName, int sqlType)JDBC 3.0 Sets the designated parameter to SQL NULL.voidsetNull(java.lang.String parameterName, int sqlType, java.lang.String typeName)JDBC 3.0 Sets the designated parameter to SQL NULL.voidsetObject(java.lang.String parameterName, java.lang.Object x)JDBC 3.0 Sets the value of the designated parameter with the given object.voidsetObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType)JDBC 3.0 Sets the value of the designated parameter with the given object.voidsetObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType, int scale)JDBC 3.0 Sets the value of the designated parameter with the given object.voidsetRowId(java.lang.String parameterName, java.sql.RowId x)voidsetShort(java.lang.String parameterName, short x)JDBC 3.0 Sets the designated parameter to the given Java short value.voidsetSQLXML(java.lang.String parameterName, java.sql.SQLXML xmlObject)voidsetString(java.lang.String parameterName, java.lang.String x)JDBC 3.0 Sets the designated parameter to the given Java String value.voidsetTime(java.lang.String parameterName, java.sql.Time x)JDBC 3.0 Sets the designated parameter to the given java.sql.Time value.voidsetTime(java.lang.String parameterName, java.sql.Time x, java.util.Calendar cal)JDBC 3.0 Sets the designated parameter to the given java.sql.Time value using the Calendar objectvoidsetTimestamp(java.lang.String parameterName, java.sql.Timestamp x)JDBC 3.0 Sets the designated parameter to the given java.sql.Timestamp value.voidsetTimestamp(java.lang.String parameterName, java.sql.Timestamp x, java.util.Calendar cal)JDBC 3.0 Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar objectvoidsetURL(java.lang.String parameterName, java.net.URL val)JDBC 3.0 Sets the designated parameter to the given java.net.URL object.booleanwasNull()-
Methods inherited from class org.apache.derby.impl.jdbc.EmbedPreparedStatement
addBatch, clearParameters, closeActions, dataTypeConversion, execute, execute, execute, execute, execute, executeBatchElement, executeLargeUpdate, executeQuery, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, executeUpdate, finalize, getMetaData, getParameterJDBCType, getParameterMetaData, getParameterSQLType, getParms, getVersionCounter, newEmbedResultSetMetaData, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setBrokeredConnectionControl, 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, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL, toString, transferParameters
-
Methods inherited from class org.apache.derby.impl.jdbc.EmbedStatement
addWarning, cancel, checkExecStatus, checkIfInMiddleOfBatch, checkStatus, clearBatch, clearResultSets, clearWarnings, close, closeMeOnCompletion, closeOnCompletion, executeBatch, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getParameterValueSet, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getSQLText, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isWrapperFor, processDynamicResult, resultSetClosing, setApplicationStatement, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, transferBatch, unwrap
-
Methods inherited from class org.apache.derby.impl.jdbc.ConnectionChild
commitIfAutoCommit, commitIfNeeded, getCal, getConnectionSynchronization, getEmbedConnection, getLanguageConnectionContext, getLCC, handleException, needCommit, newSQLException, restoreContextStack, restoreIntrFlagIfSeen, setupContextStack
-
Methods inherited from class java.lang.Object
clone, equals, getClass, hashCode, notify, notifyAll, wait, wait, wait
-
Methods inherited from interface java.sql.CallableStatement
registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, setObject, setObject
-
Methods inherited from interface org.apache.derby.iapi.jdbc.EngineStatement
closeOnCompletion, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, getLargeMaxRows, getLargeUpdateCount, isCloseOnCompletion, setLargeMaxRows
-
Methods inherited from interface java.sql.PreparedStatement
clearParameters, execute, executeQuery, executeUpdate, getMetaData, getParameterMetaData, 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 java.sql.Statement
addBatch, cancel, clearBatch, clearWarnings, close, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isPoolable, isSimpleIdentifier, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout
-
-
-
-
Constructor Detail
-
EmbedCallableStatement
public EmbedCallableStatement(EmbedConnection conn, java.lang.String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws java.sql.SQLException
- Throws:
java.sql.SQLException- thrown on failure
-
-
Method Detail
-
checkRequiresCallableStatement
protected void checkRequiresCallableStatement(Activation activation)
Description copied from class:EmbedStatementCheck to see if a statement requires to be executed via a callable statement.- Overrides:
checkRequiresCallableStatementin classEmbedStatement
-
executeStatement
protected final boolean executeStatement(Activation a, boolean executeQuery, boolean executeUpdate) throws java.sql.SQLException
Description copied from class:EmbedStatementExecute the current statement.- Overrides:
executeStatementin classEmbedPreparedStatement- Throws:
java.sql.SQLException- thrown on failure.
-
registerOutParameter
public final void registerOutParameter(int parameterIndex, int sqlType) throws java.sql.SQLException- Specified by:
registerOutParameterin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException- NoOutputParameters thrown.- See Also:
CallableStatement.registerOutParameter(int, int)
-
registerOutParameter
public final void registerOutParameter(int parameterIndex, int sqlType, int scale) throws java.sql.SQLException- Specified by:
registerOutParameterin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException- NoOutputParameters thrown.- See Also:
CallableStatement.registerOutParameter(int, int)
-
registerOutParameter
public void registerOutParameter(int parameterIndex, int sqlType, java.lang.String typeName) throws java.sql.SQLExceptionJDBC 2.0 Derby ignores the typeName argument because UDTs don't need it.- Specified by:
registerOutParameterin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException- if a database-access error occurs.
-
wasNull
public boolean wasNull() throws java.sql.SQLException- Specified by:
wasNullin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException- NoOutputParameters thrown.- See Also:
CallableStatement.wasNull()
-
getString
public java.lang.String getString(int parameterIndex) throws java.sql.SQLException- Specified by:
getStringin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException- NoOutputParameters thrown.- See Also:
CallableStatement.getString(int)
-
getBoolean
public boolean getBoolean(int parameterIndex) throws java.sql.SQLException- Specified by:
getBooleanin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException- NoOutputParameters thrown.- See Also:
CallableStatement.getBoolean(int)
-
getByte
public byte getByte(int parameterIndex) throws java.sql.SQLException- Specified by:
getBytein interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException- NoOutputParameters thrown.- See Also:
CallableStatement.getByte(int)
-
getShort
public short getShort(int parameterIndex) throws java.sql.SQLException- Specified by:
getShortin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException- NoOutputParameters thrown.- See Also:
CallableStatement.getShort(int)
-
getInt
public int getInt(int parameterIndex) throws java.sql.SQLException- Specified by:
getIntin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException- NoOutputParameters thrown.- See Also:
CallableStatement.getInt(int)
-
getLong
public long getLong(int parameterIndex) throws java.sql.SQLException- Specified by:
getLongin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException- NoOutputParameters thrown.- See Also:
CallableStatement.getLong(int)
-
getBigDecimal
public final java.math.BigDecimal getBigDecimal(int parameterIndex) throws java.sql.SQLExceptionJDBC 2.0 Get the value of a NUMERIC parameter as a java.math.BigDecimal object.- Specified by:
getBigDecimalin interfacejava.sql.CallableStatement- Parameters:
parameterIndex- the first parameter is 1, the second is 2, ...- Returns:
- the parameter value (full precision); if the value is SQL NULL, the result is null
- Throws:
java.sql.SQLException- if a database-access error occurs.
-
getBigDecimal
public final java.math.BigDecimal getBigDecimal(int parameterIndex, int scale) throws java.sql.SQLExceptionDeprecated.- Specified by:
getBigDecimalin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException- NoOutputParameters thrown.- See Also:
CallableStatement.getBigDecimal(int, int)
-
getFloat
public float getFloat(int parameterIndex) throws java.sql.SQLException- Specified by:
getFloatin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException- NoOutputParameters thrown.- See Also:
CallableStatement.getFloat(int)
-
getDouble
public double getDouble(int parameterIndex) throws java.sql.SQLException- Specified by:
getDoublein interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException- NoOutputParameters thrown.- See Also:
CallableStatement.getDouble(int)
-
getBytes
public byte[] getBytes(int parameterIndex) throws java.sql.SQLException- Specified by:
getBytesin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException- NoOutputParameters thrown.- See Also:
CallableStatement.getBytes(int)
-
getDate
public java.sql.Date getDate(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException- Specified by:
getDatein interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException- NoOutputParameters thrown.- See Also:
CallableStatement.getDate(int)
-
getTime
public java.sql.Time getTime(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException- Specified by:
getTimein interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException- NoOutputParameters thrown.- See Also:
CallableStatement.getTime(int)
-
getTimestamp
public java.sql.Timestamp getTimestamp(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException- Specified by:
getTimestampin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException- NoOutputParameters thrown.- See Also:
CallableStatement.getTimestamp(int)
-
getDate
public java.sql.Date getDate(int parameterIndex) throws java.sql.SQLExceptionGet the value of a SQL DATE parameter as a java.sql.Date object- Specified by:
getDatein interfacejava.sql.CallableStatement- Parameters:
parameterIndex- the first parameter is 1, the second is 2, ...- Returns:
- the parameter value; if the value is SQL NULL, the result is null
- Throws:
java.sql.SQLException- if a database-access error occurs.
-
getTime
public java.sql.Time getTime(int parameterIndex) throws java.sql.SQLExceptionGet the value of a SQL TIME parameter as a java.sql.Time object.- Specified by:
getTimein interfacejava.sql.CallableStatement- Parameters:
parameterIndex- the first parameter is 1, the second is 2, ...- Returns:
- the parameter value; if the value is SQL NULL, the result is null
- Throws:
java.sql.SQLException- if a database-access error occurs.
-
getTimestamp
public java.sql.Timestamp getTimestamp(int parameterIndex) throws java.sql.SQLExceptionGet the value of a SQL TIMESTAMP parameter as a java.sql.Timestamp object.- Specified by:
getTimestampin interfacejava.sql.CallableStatement- Parameters:
parameterIndex- the first parameter is 1, the second is 2, ...- Returns:
- the parameter value; if the value is SQL NULL, the result is null
- Throws:
java.sql.SQLException- if a database-access error occurs.
-
getObject
public final java.lang.Object getObject(int parameterIndex) throws java.sql.SQLException- Specified by:
getObjectin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException- NoOutputParameters thrown.- See Also:
CallableStatement.getObject(int)
-
getURL
public java.net.URL getURL(int parameterIndex) throws java.sql.SQLExceptionJDBC 3.0 Retrieve the value of the designated JDBC DATALINK parameter as a java.net.URL object- Specified by:
getURLin interfacejava.sql.CallableStatement- Parameters:
parameterIndex- - the first parameter is 1, the second is 2- Returns:
- a java.net.URL object that represents the JDBC DATALINK value used as the designated parameter
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
setURL
public void setURL(java.lang.String parameterName, java.net.URL val) throws java.sql.SQLExceptionJDBC 3.0 Sets the designated parameter to the given java.net.URL object. The driver converts this to an SQL DATALINK value when it sends it to the database.- Specified by:
setURLin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameterval- - the parameter value- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getURL
public java.net.URL getURL(java.lang.String parameterName) throws java.sql.SQLExceptionJDBC 3.0 Retrieves the value of a JDBC DATALINK parameter as a java.net.URL object- Specified by:
getURLin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameter- Returns:
- the parameter value. If the value is SQL NULL, the result is null.
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getBlob
public java.sql.Blob getBlob(int parameterIndex) throws java.sql.SQLExceptionJDBC 2.0 Get a BLOB OUT parameter.- Specified by:
getBlobin interfacejava.sql.CallableStatement- Parameters:
parameterIndex- the first parameter is 1, the second is 2, ...- Returns:
- an object representing a BLOB
- Throws:
java.sql.SQLException- if a database-access error occurs.
-
getClob
public java.sql.Clob getClob(int parameterIndex) throws java.sql.SQLExceptionJDBC 2.0 Get a CLOB OUT parameter.- Specified by:
getClobin interfacejava.sql.CallableStatement- Parameters:
parameterIndex- the first parameter is 1, the second is 2, ...- Returns:
- an object representing a CLOB
- Throws:
java.sql.SQLException- if a database-access error occurs.
-
addBatch
public void addBatch() throws java.sql.SQLExceptionDescription copied from class:EmbedPreparedStatementJDBC 2.0 Add a set of parameters to the batch.- Specified by:
addBatchin interfacejava.sql.PreparedStatement- Overrides:
addBatchin classEmbedPreparedStatement- Throws:
java.sql.SQLException- if a database-access error occurs.
-
getObject
public final java.lang.Object getObject(int i, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLExceptionJDBC 2.0 Returns an object representing the value of OUT parameteri. Use the map to determine the class from which to construct data of SQL structured and distinct types.- Specified by:
getObjectin interfacejava.sql.CallableStatement- Parameters:
i- the first parameter is 1, the second is 2, ...map- the mapping from SQL type names to Java classes- Returns:
- a java.lang.Object holding the OUT parameter value.
- Throws:
java.sql.SQLException- if a database-access error occurs.
-
getRef
public final java.sql.Ref getRef(int i) throws java.sql.SQLExceptionJDBC 2.0 Get a REF(<structured-type>) OUT parameter.- Specified by:
getRefin interfacejava.sql.CallableStatement- Parameters:
i- the first parameter is 1, the second is 2, ...- Returns:
- an object representing data of an SQL REF Type
- Throws:
java.sql.SQLException- if a database-access error occurs.
-
getArray
public final java.sql.Array getArray(int i) throws java.sql.SQLExceptionJDBC 2.0 Get an Array OUT parameter.- Specified by:
getArrayin interfacejava.sql.CallableStatement- Parameters:
i- the first parameter is 1, the second is 2, ...- Returns:
- an object representing an SQL array
- Throws:
java.sql.SQLException- if a database-access error occurs.
-
registerOutParameter
public final void registerOutParameter(java.lang.String parameterName, int sqlType) throws java.sql.SQLExceptionJDBC 3.0 Registers the OUT parameter named parameterName to the JDBC type sqlType. All OUT parameters must be registered before a stored procedure is executed.- Specified by:
registerOutParameterin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parametersqlType- - 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.- Throws:
java.sql.SQLException- Feature not implemented for now.
-
registerOutParameter
public final void registerOutParameter(java.lang.String parameterName, int sqlType, java.lang.String typeName) throws java.sql.SQLExceptionJDBC 3.0 Registers the designated output parameter. This version of the method registerOutParameter should be used for a user-named or REF output parameter.- Specified by:
registerOutParameterin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parametersqlType- - the SQL type code defined by java.sql.Types.typeName- - the fully-qualified name of an SQL structure type- Throws:
java.sql.SQLException- Feature not implemented for now.
-
registerOutParameter
public final void registerOutParameter(java.lang.String parameterName, int sqlType, int scale) throws java.sql.SQLExceptionJDBC 3.0 Registers the parameter named parameterName to the JDBC type sqlType. This method must be called before a stored procedure is executed.- Specified by:
registerOutParameterin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parametersqlType- - the SQL type code defined by java.sql.Types.scale- - the desired number of digits to the right of the decimal point. It must be greater than or equal to zero.- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getRef
public final java.sql.Ref getRef(java.lang.String parameterName) throws java.sql.SQLExceptionJDBC 3.0 Retrieves the value of a JDBC REF (structured-type) parameter as a Ref object in the Java programming language.- Specified by:
getRefin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameter- Returns:
- the parameter value as a Ref object in the Java Programming language. If the value is SQL NULL, the result is null.
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getBlob
public final java.sql.Blob getBlob(java.lang.String parameterName) throws java.sql.SQLExceptionJDBC 3.0 Retrieves the value of a JDBC BLOB parameter as a Blob object in the Java programming language.- Specified by:
getBlobin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameter- Returns:
- the parameter value as a Blob object in the Java Programming language. If the value is SQL NULL, the result is null.
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getClob
public final java.sql.Clob getClob(java.lang.String parameterName) throws java.sql.SQLExceptionJDBC 3.0 Retrieves the value of a JDBC CLOB parameter as a Clob object in the Java programming language.- Specified by:
getClobin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameter- Returns:
- the parameter value as a Clob object in the Java Programming language. If the value is SQL NULL, the result is null.
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getArray
public final java.sql.Array getArray(java.lang.String parameterName) throws java.sql.SQLExceptionJDBC 3.0 Retrieves the value of a JDBC ARRAY parameter as an Array object in the Java programming language.- Specified by:
getArrayin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameter- Returns:
- the parameter value as a Array object in the Java Programming language. If the value is SQL NULL, the result is null.
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
setNull
public final void setNull(java.lang.String parameterName, int sqlType) throws java.sql.SQLExceptionJDBC 3.0 Sets the designated parameter to SQL NULL.- Specified by:
setNullin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parametersqlType- - the SQL type code defined in java.sql.Types- Throws:
java.sql.SQLException- Feature not implemented for now.
-
setNull
public final void setNull(java.lang.String parameterName, int sqlType, java.lang.String typeName) throws java.sql.SQLExceptionJDBC 3.0 Sets the designated parameter to SQL NULL.- Specified by:
setNullin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parametersqlType- - the SQL type code defined in java.sql.TypestypeName- - the fully-qualified name of an SQL user-defined type- Throws:
java.sql.SQLException- Feature not implemented for now.
-
setBoolean
public final void setBoolean(java.lang.String parameterName, boolean x) throws java.sql.SQLExceptionJDBC 3.0 Sets the designated parameter to the given Java boolean value. The driver converts this to an SQL BIT value when it sends it to the database.- Specified by:
setBooleanin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameterx- - the parameter value- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getBoolean
public final boolean getBoolean(java.lang.String parameterName) throws java.sql.SQLExceptionJDBC 3.0 Retrieves the value of a JDBC BIT parameter as a boolean in the Java programming language.- Specified by:
getBooleanin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameter- Returns:
- the parameter value. If the value is SQL NULL, the result is false.
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
setByte
public final void setByte(java.lang.String parameterName, byte x) throws java.sql.SQLExceptionJDBC 3.0 Sets the designated parameter to the given Java byte value. The driver converts this to an SQL TINYINT value when it sends it to the database.- Specified by:
setBytein interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameterx- - the parameter value- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getByte
public final byte getByte(java.lang.String parameterName) throws java.sql.SQLExceptionJDBC 3.0 Retrieves the value of a JDBC TINYINT parameter as a byte in the Java programming language.- Specified by:
getBytein interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameter- Returns:
- the parameter value. If the value is SQL NULL, the result is 0.
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
setShort
public final void setShort(java.lang.String parameterName, short x) throws java.sql.SQLExceptionJDBC 3.0 Sets the designated parameter to the given Java short value. The driver converts this to an SQL SMALLINT value when it sends it to the database.- Specified by:
setShortin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameterx- - the parameter value- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getShort
public final short getShort(java.lang.String parameterName) throws java.sql.SQLExceptionJDBC 3.0 Retrieves the value of a JDBC SMALLINT parameter as a short in the Java programming language.- Specified by:
getShortin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameter- Returns:
- the parameter value. If the value is SQL NULL, the result is 0.
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
setInt
public final void setInt(java.lang.String parameterName, int x) throws java.sql.SQLExceptionJDBC 3.0 Sets the designated parameter to the given Java int value. The driver converts this to an SQL INTEGER value when it sends it to the database.- Specified by:
setIntin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameterx- - the parameter value- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getInt
public final int getInt(java.lang.String parameterName) throws java.sql.SQLExceptionJDBC 3.0 Retrieves the value of a JDBC INTEGER parameter as a int in the Java programming language.- Specified by:
getIntin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameter- Returns:
- the parameter value. If the value is SQL NULL, the result is 0.
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
setLong
public final void setLong(java.lang.String parameterName, long x) throws java.sql.SQLExceptionJDBC 3.0 Sets the designated parameter to the given Java long value. The driver converts this to an SQL BIGINT value when it sends it to the database.- Specified by:
setLongin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameterx- - the parameter value- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getLong
public final long getLong(java.lang.String parameterName) throws java.sql.SQLExceptionJDBC 3.0 Retrieves the value of a JDBC BIGINT parameter as a long in the Java programming language.- Specified by:
getLongin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameter- Returns:
- the parameter value. If the value is SQL NULL, the result is 0.
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
setFloat
public final void setFloat(java.lang.String parameterName, float x) throws java.sql.SQLExceptionJDBC 3.0 Sets the designated parameter to the given Java float value. The driver converts this to an SQL FLOAT value when it sends it to the database.- Specified by:
setFloatin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameterx- - the parameter value- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getFloat
public final float getFloat(java.lang.String parameterName) throws java.sql.SQLExceptionJDBC 3.0 Retrieves the value of a JDBC FLOAT parameter as a float in the Java programming language.- Specified by:
getFloatin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameter- Returns:
- the parameter value. If the value is SQL NULL, the result is 0.
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
setDouble
public final void setDouble(java.lang.String parameterName, double x) throws java.sql.SQLExceptionJDBC 3.0 Sets the designated parameter to the given Java double value. The driver converts this to an SQL DOUBLE value when it sends it to the database.- Specified by:
setDoublein interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameterx- - the parameter value- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getDouble
public final double getDouble(java.lang.String parameterName) throws java.sql.SQLExceptionJDBC 3.0 Retrieves the value of a JDBC DOUBLE parameter as a double in the Java programming language.- Specified by:
getDoublein interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameter- Returns:
- the parameter value. If the value is SQL NULL, the result is 0.
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
setBigDecimal
public final void setBigDecimal(java.lang.String parameterName, java.math.BigDecimal x) throws java.sql.SQLExceptionJDBC 3.0 Sets the designated parameter to the given java.math.BigDecimal value. The driver converts this to an SQL NUMERIC value when it sends it to the database.- Specified by:
setBigDecimalin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameterx- - the parameter value- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getBigDecimal
public final java.math.BigDecimal getBigDecimal(java.lang.String parameterName) throws java.sql.SQLExceptionJDBC 3.0 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- Specified by:
getBigDecimalin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameter- Returns:
- the parameter value. If the value is SQL NULL, the result is 0.
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
setString
public final void setString(java.lang.String parameterName, java.lang.String x) throws java.sql.SQLExceptionJDBC 3.0 Sets the designated parameter to the given Java String value. The driver converts this to an SQL VARCHAR OR LONGVARCHAR value (depending on the argument's size relative the driver's limits on VARCHAR values) when it sends it to the database.- Specified by:
setStringin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameterx- - the parameter value- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getString
public final java.lang.String getString(java.lang.String parameterName) throws java.sql.SQLExceptionJDBC 3.0 Retrieves the value of a JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.- Specified by:
getStringin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameter- Returns:
- the parameter value. If the value is SQL NULL, the result is null.
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
setBytes
public final void setBytes(java.lang.String parameterName, byte[] x) throws java.sql.SQLExceptionJDBC 3.0 Sets the designated parameter to the given Java array of bytes. The driver converts this to an SQL VARBINARY OR LONGVARBINARY (depending on the argument's size relative to the driver's limits on VARBINARY values)when it sends it to the database.- Specified by:
setBytesin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameterx- - the parameter value- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getBytes
public final byte[] getBytes(java.lang.String parameterName) throws java.sql.SQLExceptionJDBC 3.0 Retrieves the value of a JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language.- Specified by:
getBytesin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameter- Returns:
- the parameter value. If the value is SQL NULL, the result is null.
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
setDate
public final void setDate(java.lang.String parameterName, java.sql.Date x) throws java.sql.SQLExceptionJDBC 3.0 Sets the designated parameter to the given java.sql.Date value. The driver converts this to an SQL DATE value when it sends it to the database.- Specified by:
setDatein interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameterx- - the parameter value- Throws:
java.sql.SQLException- Feature not implemented for now.
-
setDate
public final void setDate(java.lang.String parameterName, java.sql.Date x, java.util.Calendar cal) throws java.sql.SQLExceptionJDBC 3.0 Sets the designated parameter to the given java.sql.Date value, using the given Calendar object.- Specified by:
setDatein interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameterx- - the parameter valuecal- - the Calendar object the driver will use to construct the date- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getDate
public final java.sql.Date getDate(java.lang.String parameterName) throws java.sql.SQLExceptionJDBC 3.0 Retrieves the value of a JDBC DATE parameter as a java.sql.Date object- Specified by:
getDatein interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameter- Returns:
- the parameter value. If the value is SQL NULL, the result is null.
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getDate
public final java.sql.Date getDate(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLExceptionJDBC 3.0 Retrieves the value of a JDBC DATE parameter as a java.sql.Date object, using the given Calendar object to construct the date object.- Specified by:
getDatein interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parametercal- - the Calendar object the driver will use to construct the date- Returns:
- the parameter value. If the value is SQL NULL, the result is null.
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
setTime
public final void setTime(java.lang.String parameterName, java.sql.Time x) throws java.sql.SQLExceptionJDBC 3.0 Sets the designated parameter to the given java.sql.Time value. The driver converts this to an SQL TIME value when it sends it to the database.- Specified by:
setTimein interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameterx- - the parameter value- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getTime
public final java.sql.Time getTime(java.lang.String parameterName) throws java.sql.SQLExceptionJDBC 3.0 Retrieves the value of a JDBC TIME parameter as ajava.sql.Time object- Specified by:
getTimein interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameter- Returns:
- the parameter value. If the value is SQL NULL, the result is null.
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getTime
public final java.sql.Time getTime(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLExceptionJDBC 3.0 Retrieves the value of a JDBC TIME parameter as a java.sql.Time object, using the given Calendar object to construct the time object.- Specified by:
getTimein interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parametercal- - the Calendar object the driver will use to construct the time- Returns:
- the parameter value. If the value is SQL NULL, the result is null.
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
setTime
public final void setTime(java.lang.String parameterName, java.sql.Time x, java.util.Calendar cal) throws java.sql.SQLExceptionJDBC 3.0 Sets the designated parameter to the given java.sql.Time value using the Calendar object- Specified by:
setTimein interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameterx- - the parameter valuecal- - the Calendar object the driver will use to construct the time- Throws:
java.sql.SQLException- Feature not implemented for now.
-
setTimestamp
public final void setTimestamp(java.lang.String parameterName, java.sql.Timestamp x) throws java.sql.SQLExceptionJDBC 3.0 Sets the designated parameter to the given java.sql.Timestamp value. The driver converts this to an SQL TIMESTAMP value when it sends it to the database.- Specified by:
setTimestampin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameterx- - the parameter value- Throws:
java.sql.SQLException- Feature not implemented for now.
-
setTimestamp
public final void setTimestamp(java.lang.String parameterName, java.sql.Timestamp x, java.util.Calendar cal) throws java.sql.SQLExceptionJDBC 3.0 Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object- Specified by:
setTimestampin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameterx- - the parameter valuecal- - the Calendar object the driver will use to construct the timestamp.- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getTimestamp
public final java.sql.Timestamp getTimestamp(java.lang.String parameterName) throws java.sql.SQLExceptionJDBC 3.0 Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object- Specified by:
getTimestampin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameter- Returns:
- the parameter value. If the value is SQL NULL, the result is null.
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getTimestamp
public final java.sql.Timestamp getTimestamp(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLExceptionJDBC 3.0 Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object, using the given Calendar object to construct the Timestamp object.- Specified by:
getTimestampin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parametercal- - the Calendar object the driver will use to construct the Timestamp- Returns:
- the parameter value. If the value is SQL NULL, the result is null.
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
setAsciiStream
public final void setAsciiStream(java.lang.String parameterName, java.io.InputStream x, int length) throws java.sql.SQLExceptionJDBC 3.0 Sets the designated parameter to the given input stream, which will have the specified number of bytes.- Specified by:
setAsciiStreamin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameterx- - the Java input stream that contains the ASCII parameter valuelength- - the number of bytes in the stream- Throws:
java.sql.SQLException- Feature not implemented for now.
-
setBinaryStream
public final void setBinaryStream(java.lang.String parameterName, java.io.InputStream x, int length) throws java.sql.SQLExceptionJDBC 3.0 Sets the designated parameter to the given input stream, which will have the specified number of bytes.- Specified by:
setBinaryStreamin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameterx- - the Java input stream that contains the binary parameter valuelength- - the number of bytes in the stream- Throws:
java.sql.SQLException- Feature not implemented for now.
-
setCharacterStream
public final void setCharacterStream(java.lang.String parameterName, java.io.Reader reader, int length) throws java.sql.SQLExceptionJDBC 3.0 Sets the designated parameter to the given Reader object, which is the given number of characters long.- Specified by:
setCharacterStreamin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameterreader- - the java.io.Reader object that contains the UNICODE datalength- - the number of characters in the stream- Throws:
java.sql.SQLException- Feature not implemented for now.
-
setObject
public final void setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType, int scale) throws java.sql.SQLExceptionJDBC 3.0 Sets the value of the designated parameter with the given object. The second argument must be an object type; for integral values, the java.lang equivalent objects should be used.- Specified by:
setObjectin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameterx- - the object containing the input parameter valuetargetSqlType- - the SQL type (as defined in java.sql.Types) to be sent to the database. The scale argument may further qualify this type.scale- - 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.- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getObject
public final java.lang.Object getObject(java.lang.String parameterName) throws java.sql.SQLExceptionJDBC 3.0 Retrieves the value of a parameter as an Object in the java programming language.- Specified by:
getObjectin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameter- Returns:
- a java.lang.Object holding the OUT parameter value
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getObject
public final java.lang.Object getObject(java.lang.String parameterName, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLExceptionJDBC 3.0 Returns an object representing the value of OUT parameter i and uses map for the custom mapping of the parameter value.- Specified by:
getObjectin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parametermap- - the mapping from SQL type names to Java classes- Returns:
- a java.lang.Object holding the OUT parameter value
- Throws:
java.sql.SQLException- Feature not implemented for now.
-
setObject
public final void setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType) throws java.sql.SQLExceptionJDBC 3.0 Sets the value of the designated parameter with the given object. This method is like the method setObject above, except that it assumes a scale of zero.- Specified by:
setObjectin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameterx- - the object containing the input parameter valuetargetSqlType- - the SQL type (as defined in java.sql.Types) to be sent to the database.- Throws:
java.sql.SQLException- Feature not implemented for now.
-
setObject
public final void setObject(java.lang.String parameterName, java.lang.Object x) throws java.sql.SQLExceptionJDBC 3.0 Sets the value of the designated parameter with the given object. The second parameter must be of type Object; therefore, the java.lang equivalent objects should be used for built-in types.- Specified by:
setObjectin interfacejava.sql.CallableStatement- Parameters:
parameterName- - the name of the parameterx- - the object containing the input parameter value- Throws:
java.sql.SQLException- Feature not implemented for now.
-
getCharacterStream
public final java.io.Reader getCharacterStream(int parameterIndex) throws java.sql.SQLExceptionRetrieves the value of the designated parameter as ajava.io.Readerobject in the Java programming language. Introduced in JDBC 4.0.- Specified by:
getCharacterStreamin interfacejava.sql.CallableStatement- Parameters:
parameterIndex- the first parameter is 1, the second is 2, ...- Returns:
- a
java.io.Readerobject that contains the parameter value; if the value is SQLNULL, the value returned isnullin the Java programming language. - Throws:
java.sql.SQLException- if a database access error occurs or this method is called on a closedCallableStatement
-
getBinaryStream
private java.io.InputStream getBinaryStream(int parameterIndex) throws java.sql.SQLExceptionGet binary stream for a parameter.- Parameters:
parameterIndex- first parameter is 1, second is 2 etc.- Returns:
- a stream for the binary parameter, or
null. - Throws:
java.sql.SQLException- if a database access error occurs.
-
getCharacterStream
public final java.io.Reader getCharacterStream(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getCharacterStreamin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getNCharacterStream
public final java.io.Reader getNCharacterStream(int parameterIndex) throws java.sql.SQLException- Specified by:
getNCharacterStreamin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getNCharacterStream
public final java.io.Reader getNCharacterStream(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getNCharacterStreamin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getNString
public final java.lang.String getNString(int parameterIndex) throws java.sql.SQLException- Specified by:
getNStringin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getNString
public final java.lang.String getNString(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getNStringin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setBlob
public final void setBlob(java.lang.String parameterName, java.sql.Blob x) throws java.sql.SQLException- Specified by:
setBlobin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setClob
public final void setClob(java.lang.String parameterName, java.sql.Clob x) throws java.sql.SQLException- Specified by:
setClobin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getRowId
public final java.sql.RowId getRowId(int parameterIndex) throws java.sql.SQLException- Specified by:
getRowIdin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getRowId
public final java.sql.RowId getRowId(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getRowIdin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setRowId
public final void setRowId(java.lang.String parameterName, java.sql.RowId x) throws java.sql.SQLException- Specified by:
setRowIdin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setNString
public final void setNString(java.lang.String parameterName, java.lang.String value) throws java.sql.SQLException- Specified by:
setNStringin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setNCharacterStream
public final void setNCharacterStream(java.lang.String parameterName, java.io.Reader value, long length) throws java.sql.SQLException- Specified by:
setNCharacterStreamin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setNClob
public final void setNClob(java.lang.String parameterName, java.sql.NClob value) throws java.sql.SQLException- Specified by:
setNClobin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setClob
public final void setClob(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException- Specified by:
setClobin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setBlob
public final void setBlob(java.lang.String parameterName, java.io.InputStream inputStream, long length) throws java.sql.SQLException- Specified by:
setBlobin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setNClob
public final void setNClob(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException- Specified by:
setNClobin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getNClob
public final java.sql.NClob getNClob(int i) throws java.sql.SQLException- Specified by:
getNClobin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getNClob
public final java.sql.NClob getNClob(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getNClobin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setSQLXML
public final void setSQLXML(java.lang.String parameterName, java.sql.SQLXML xmlObject) throws java.sql.SQLException- Specified by:
setSQLXMLin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getSQLXML
public final java.sql.SQLXML getSQLXML(int parameterIndex) throws java.sql.SQLException- Specified by:
getSQLXMLin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getSQLXML
public final java.sql.SQLXML getSQLXML(java.lang.String parametername) throws java.sql.SQLException- Specified by:
getSQLXMLin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setAsciiStream
public final void setAsciiStream(java.lang.String parameterName, java.io.InputStream x) throws java.sql.SQLException- Specified by:
setAsciiStreamin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setBinaryStream
public final void setBinaryStream(java.lang.String parameterName, java.io.InputStream x) throws java.sql.SQLException- Specified by:
setBinaryStreamin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setBlob
public final void setBlob(java.lang.String parameterName, java.io.InputStream inputStream) throws java.sql.SQLException- Specified by:
setBlobin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setCharacterStream
public final void setCharacterStream(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException- Specified by:
setCharacterStreamin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setClob
public final void setClob(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException- Specified by:
setClobin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setNCharacterStream
public final void setNCharacterStream(java.lang.String parameterName, java.io.Reader value) throws java.sql.SQLException- Specified by:
setNCharacterStreamin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setNClob
public final void setNClob(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException- Specified by:
setNClobin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setAsciiStream
public final void setAsciiStream(java.lang.String parameterName, java.io.InputStream x, long length) throws java.sql.SQLExceptionSets the designated parameter to the given input stream, which will have the specified number of bytes.- Specified by:
setAsciiStreamin interfacejava.sql.CallableStatement- Parameters:
parameterName- the name of the first parameterx- the java input stream which contains the ASCII parameter valuelength- the number of bytes in the stream- Throws:
java.sql.SQLException- thrown on failure.
-
setBinaryStream
public final void setBinaryStream(java.lang.String parameterName, java.io.InputStream x, long length) throws java.sql.SQLExceptionSets the designated parameter to the given input stream, which will have the specified number of bytes.- Specified by:
setBinaryStreamin interfacejava.sql.CallableStatement- Parameters:
parameterName- the name of the first parameterx- the java input stream which contains the binary parameter valuelength- the number of bytes in the stream- Throws:
java.sql.SQLException- thrown on failure.
-
setCharacterStream
public final void setCharacterStream(java.lang.String parameterName, java.io.Reader x, long length) throws java.sql.SQLExceptionSets the designated parameter to the given Reader, which will have the specified number of bytes.- Specified by:
setCharacterStreamin interfacejava.sql.CallableStatement- Parameters:
parameterName- the name of the first parameterx- the java Reader which contains the UNICODE valuelength- the number of bytes in the stream- Throws:
java.sql.SQLException- thrown on failure.
-
getObject
public final <T> T getObject(int parameterIndex, java.lang.Class<T> type) throws java.sql.SQLException- Specified by:
getObjectin interfacejava.sql.CallableStatement- Specified by:
getObjectin interfaceEngineCallableStatement- Throws:
java.sql.SQLException
-
mismatchException
private java.sql.SQLException mismatchException(java.lang.String targetTypeName, int parameterIndex) throws java.sql.SQLException- Throws:
java.sql.SQLException
-
getObject
public final <T> T getObject(java.lang.String parameterName, java.lang.Class<T> type) throws java.sql.SQLException- Specified by:
getObjectin interfacejava.sql.CallableStatement- Specified by:
getObjectin interfaceEngineCallableStatement- Throws:
java.sql.SQLException
-
-