Class AbstractCallableStatement
- java.lang.Object
-
- org.firebirdsql.jdbc.FBStatement
-
- org.firebirdsql.jdbc.AbstractPreparedStatement
-
- org.firebirdsql.jdbc.FBPreparedStatement
-
- org.firebirdsql.jdbc.AbstractCallableStatement
-
- All Implemented Interfaces:
java.lang.AutoCloseable,java.sql.CallableStatement,java.sql.PreparedStatement,java.sql.Statement,java.sql.Wrapper,FirebirdCallableStatement,FirebirdPreparedStatement,FirebirdStatement,Synchronizable
- Direct Known Subclasses:
FBCallableStatement
public abstract class AbstractCallableStatement extends FBPreparedStatement implements java.sql.CallableStatement, FirebirdCallableStatement
Abstract implementation ofCallableStatement.- Author:
- David Jencks, Roman Rokytskyy, Steven Jardine, Mark Rotteveel
-
-
Nested Class Summary
-
Nested classes/interfaces inherited from class org.firebirdsql.jdbc.FBStatement
FBStatement.StatementResult
-
-
Field Summary
Fields Modifier and Type Field Description protected FBProcedureCallprocedureCallprotected booleanselectableProcedure-
Fields inherited from class org.firebirdsql.jdbc.AbstractPreparedStatement
batchList, METHOD_NOT_SUPPORTED
-
Fields inherited from class org.firebirdsql.jdbc.FBStatement
completed, connection, currentStatementResult, fbStatement, fetchSize, firstWarning, gdsHelper, isSingletonResult, jdbcVersionSupport, maxRows, specialResult, statementListener
-
Fields inherited from interface org.firebirdsql.jdbc.FirebirdPreparedStatement
TYPE_COMMIT, TYPE_DDL, TYPE_DELETE, TYPE_EXEC_PROCEDURE, TYPE_GET_SEGMENT, TYPE_INSERT, TYPE_PUT_SEGMENT, TYPE_ROLLBACK, TYPE_SELECT, TYPE_SELECT_FOR_UPDATE, TYPE_SET_GENERATOR, TYPE_START_TRANS, TYPE_UPDATE
-
-
Constructor Summary
Constructors Modifier Constructor Description protectedAbstractCallableStatement(GDSHelper c, java.lang.String sql, int rsType, int rsConcurrency, int rsHoldability, StoredProcedureMetaData storedProcMetaData, FBObjectListener.StatementListener statementListener, FBObjectListener.BlobListener blobListener)
-
Method Summary
All Methods Instance Methods Concrete Methods Deprecated Methods Modifier and Type Method Description voidaddBatch()protected voidassertHasData(java.sql.ResultSet rs)Asserts if the current statement has data to return.protected FBResultSetcreateSpecialResultSet(FBObjectListener.ResultSetListener resultSetListener)Create the result set forspecialResult.booleanexecute()protected java.util.List<java.lang.Long>executeBatchInternal()java.sql.ResultSetexecuteQuery()intexecuteUpdate()protected intfindOutParameter(java.lang.String paramName)Helper method to identify the right result set column for the give OUT parameter name.protected java.sql.ResultSetgetAndAssertSingletonResultSet()Returns the result set for the singleton row of the callable statement and asserts it has data.java.sql.ArraygetArray(int parameterIndex)java.sql.ArraygetArray(java.lang.String colName)java.math.BigDecimalgetBigDecimal(int parameterIndex)java.math.BigDecimalgetBigDecimal(int parameterIndex, int scale)Deprecated.java.math.BigDecimalgetBigDecimal(java.lang.String colName)java.sql.BlobgetBlob(int parameterIndex)java.sql.BlobgetBlob(java.lang.String colName)booleangetBoolean(int parameterIndex)booleangetBoolean(java.lang.String colName)bytegetByte(int parameterIndex)bytegetByte(java.lang.String colName)byte[]getBytes(int parameterIndex)byte[]getBytes(java.lang.String colName)java.io.ReadergetCharacterStream(int parameterIndex)java.io.ReadergetCharacterStream(java.lang.String parameterName)java.sql.ClobgetClob(int parameterIndex)java.sql.ClobgetClob(java.lang.String colName)java.sql.ResultSetgetCurrentResultSet()Get current result set.java.sql.DategetDate(int parameterIndex)java.sql.DategetDate(int parameterIndex, java.util.Calendar cal)java.sql.DategetDate(java.lang.String colName)java.sql.DategetDate(java.lang.String colName, java.util.Calendar cal)doublegetDouble(int parameterIndex)doublegetDouble(java.lang.String colName)floatgetFloat(int parameterIndex)floatgetFloat(java.lang.String colName)java.sql.ResultSetgetGeneratedKeys()intgetInt(int parameterIndex)intgetInt(java.lang.String colName)longgetLong(int parameterIndex)longgetLong(java.lang.String colName)java.sql.ResultSetMetaDatagetMetaData()java.io.ReadergetNCharacterStream(int parameterIndex)java.io.ReadergetNCharacterStream(java.lang.String parameterName)java.sql.NClobgetNClob(int parameterIndex)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 parameterIndex, java.util.Map<java.lang.String,java.lang.Class<?>> map)java.lang.ObjectgetObject(java.lang.String colName)<T> TgetObject(java.lang.String parameterName, java.lang.Class<T> type)java.lang.ObjectgetObject(java.lang.String colName, java.util.Map<java.lang.String,java.lang.Class<?>> map)java.sql.ParameterMetaDatagetParameterMetaData()java.sql.RefgetRef(int parameterIndex)java.sql.RefgetRef(java.lang.String colName)java.sql.ResultSetgetResultSet()java.sql.RowIdgetRowId(int parameterIndex)java.sql.RowIdgetRowId(java.lang.String parameterName)shortgetShort(int parameterIndex)shortgetShort(java.lang.String colName)java.sql.SQLXMLgetSQLXML(int parameterIndex)java.sql.SQLXMLgetSQLXML(java.lang.String parameterName)java.lang.StringgetString(int parameterIndex)java.lang.StringgetString(java.lang.String colName)java.sql.TimegetTime(int parameterIndex)java.sql.TimegetTime(int parameterIndex, java.util.Calendar cal)java.sql.TimegetTime(java.lang.String colName)java.sql.TimegetTime(java.lang.String colName, java.util.Calendar cal)java.sql.TimestampgetTimestamp(int parameterIndex)java.sql.TimestampgetTimestamp(int parameterIndex, java.util.Calendar cal)java.sql.TimestampgetTimestamp(java.lang.String colName)java.sql.TimestampgetTimestamp(java.lang.String colName, java.util.Calendar cal)java.net.URLgetURL(int parameterIndex)java.net.URLgetURL(java.lang.String colName)protected booleaninternalExecute(boolean sendOutParams)Execute this statement.booleanisSelectableProcedure()Retrieve if this callable statement has been marked as selectable.protected voidprepareFixedStatement(java.lang.String sql)We allow multiple calls to this method without re-preparing the statement.voidregisterOutParameter(int parameterIndex, int sqlType)voidregisterOutParameter(int parameterIndex, int sqlType, int scale)voidregisterOutParameter(int parameterIndex, int sqlType, java.lang.String typeName)voidregisterOutParameter(java.lang.String param1, int param2)voidregisterOutParameter(java.lang.String param1, int param2, int param3)voidregisterOutParameter(java.lang.String param1, int param2, java.lang.String param3)voidsetAsciiStream(java.lang.String parameterName, java.io.InputStream x)voidsetAsciiStream(java.lang.String param1, java.io.InputStream param2, int param3)voidsetAsciiStream(java.lang.String parameterName, java.io.InputStream x, long length)voidsetBigDecimal(int parameterIndex, java.math.BigDecimal x)voidsetBigDecimal(java.lang.String param1, java.math.BigDecimal param2)voidsetBinaryStream(int parameterIndex, java.io.InputStream inputStream)voidsetBinaryStream(int parameterIndex, java.io.InputStream inputStream, int length)voidsetBinaryStream(int parameterIndex, java.io.InputStream inputStream, long length)voidsetBinaryStream(java.lang.String parameterName, java.io.InputStream x)voidsetBinaryStream(java.lang.String param1, java.io.InputStream param2, int param3)voidsetBinaryStream(java.lang.String parameterName, java.io.InputStream x, long length)voidsetBlob(int parameterIndex, java.io.InputStream inputStream)voidsetBlob(int parameterIndex, java.io.InputStream inputStream, long length)voidsetBlob(int parameterIndex, java.sql.Blob blob)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(int parameterIndex, boolean x)voidsetBoolean(java.lang.String param1, boolean param2)voidsetByte(int parameterIndex, byte x)voidsetByte(java.lang.String param1, byte param2)voidsetBytes(int parameterIndex, byte[] x)voidsetBytes(java.lang.String param1, byte[] param2)voidsetCharacterStream(int parameterIndex, java.io.Reader reader)voidsetCharacterStream(int parameterIndex, java.io.Reader reader, int length)voidsetCharacterStream(int parameterIndex, java.io.Reader reader, long length)voidsetCharacterStream(java.lang.String parameterName, java.io.Reader reader)voidsetCharacterStream(java.lang.String param1, java.io.Reader param2, int param3)voidsetCharacterStream(java.lang.String parameterName, java.io.Reader reader, long length)voidsetClob(int parameterIndex, java.io.Reader reader)voidsetClob(int parameterIndex, java.io.Reader reader, long length)voidsetClob(int parameterIndex, java.sql.Clob x)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(int parameterIndex, java.sql.Date x)voidsetDate(int parameterIndex, java.sql.Date x, java.util.Calendar cal)voidsetDate(java.lang.String param1, java.sql.Date param2)voidsetDate(java.lang.String param1, java.sql.Date param2, java.util.Calendar param3)voidsetDouble(int parameterIndex, double x)voidsetDouble(java.lang.String param1, double param2)voidsetFloat(int parameterIndex, float x)voidsetFloat(java.lang.String param1, float param2)voidsetInt(int parameterIndex, int x)voidsetInt(java.lang.String param1, int param2)voidsetLong(int parameterIndex, long x)voidsetLong(java.lang.String param1, long param2)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(int parameterIndex, int sqlType)voidsetNull(int parameterIndex, int sqlType, java.lang.String typeName)voidsetNull(java.lang.String param1, int param2)voidsetNull(java.lang.String param1, int param2, java.lang.String param3)voidsetObject(int parameterIndex, java.lang.Object x)voidsetObject(int parameterIndex, java.lang.Object x, int targetSqlType)voidsetObject(int parameterIndex, java.lang.Object x, int targetSqlType, int scale)voidsetObject(java.lang.String param1, java.lang.Object param2)voidsetObject(java.lang.String param1, java.lang.Object param2, int param3)voidsetObject(java.lang.String param1, java.lang.Object param2, int param3, int param4)protected voidsetRequiredTypes()Set required types for output parameters.voidsetRowId(java.lang.String parameterName, java.sql.RowId x)voidsetSelectableProcedure(boolean selectableProcedure)Mark this callable statement as a call of the selectable procedure.voidsetShort(int parameterIndex, short x)voidsetShort(java.lang.String param1, short param2)voidsetSQLXML(java.lang.String parameterName, java.sql.SQLXML xmlObject)voidsetString(int parameterIndex, java.lang.String x)voidsetString(java.lang.String param1, java.lang.String param2)voidsetTime(int parameterIndex, java.sql.Time x)voidsetTime(int parameterIndex, java.sql.Time x, java.util.Calendar cal)voidsetTime(java.lang.String param1, java.sql.Time param2)voidsetTime(java.lang.String param1, java.sql.Time param2, java.util.Calendar param3)voidsetTimestamp(int parameterIndex, java.sql.Timestamp x)voidsetTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar cal)voidsetTimestamp(java.lang.String param1, java.sql.Timestamp param2)voidsetTimestamp(java.lang.String param1, java.sql.Timestamp param2, java.util.Calendar param3)voidsetURL(java.lang.String param1, java.net.URL param2)booleanwasNull()-
Methods inherited from class org.firebirdsql.jdbc.FBPreparedStatement
setObject, setObject
-
Methods inherited from class org.firebirdsql.jdbc.AbstractPreparedStatement
addBatch, clearBatch, clearParameters, completeStatement, execute, execute, execute, execute, executeLargeUpdate, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getExecutionPlan, getExplainedExecutionPlan, getField, getFirebirdParameterMetaData, getParameterDescriptor, getStatementType, isGeneratedKeyQuery, notifyStatementCompleted, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setRef, setRowId, setSQLXML, setStringForced, setUnicodeStream, setURL
-
Methods inherited from class org.firebirdsql.jdbc.FBStatement
addWarning, cancel, checkValidity, clearWarnings, close, closeOnCompletion, completeStatement, createStatementListener, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, equals, executeBatch, executeImpl, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, finalize, forgetResultSet, getConnection, getDeletedRowsCount, getFetchDirection, getFetchSize, getInsertedRowsCount, getLargeMaxRows, getLargeUpdateCount, getLastExecutionPlan, getLastExplainedExecutionPlan, getLocalStatementId, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getSynchronizationObject, getUpdateCount, getUpdatedRowsCount, getWarnings, hashCode, hasOpenResultSet, internalExecute, isClosed, isCloseOnCompletion, isExecuteProcedureStatement, isPoolable, isSimpleIdentifier, isValid, isWrapperFor, nativeSQL, notifyStatementCompleted, notifyStatementStarted, notifyStatementStarted, requireStatement, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, toArray, toLargeArray, unwrap
-
Methods inherited from class java.lang.Object
clone, getClass, notify, notifyAll, toString, wait, wait, wait
-
Methods inherited from interface java.sql.CallableStatement
registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, setObject, setObject
-
Methods inherited from interface org.firebirdsql.jdbc.FirebirdPreparedStatement
getExecutionPlan, getExplainedExecutionPlan, getStatementType
-
Methods inherited from interface org.firebirdsql.jdbc.FirebirdStatement
getDeletedRowsCount, getInsertedRowsCount, getLastExecutionPlan, getLastExplainedExecutionPlan, getLocalStatementId, getUpdatedRowsCount, hasOpenResultSet, isValid
-
Methods inherited from interface java.sql.PreparedStatement
clearParameters, executeLargeUpdate, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setObject, setObject, setRef, setRowId, setSQLXML, setUnicodeStream, setURL
-
Methods inherited from interface java.sql.Statement
addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, execute, execute, execute, execute, executeBatch, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isSimpleIdentifier, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout
-
-
-
-
Field Detail
-
selectableProcedure
protected boolean selectableProcedure
-
procedureCall
protected FBProcedureCall procedureCall
-
-
Constructor Detail
-
AbstractCallableStatement
protected AbstractCallableStatement(GDSHelper c, java.lang.String sql, int rsType, int rsConcurrency, int rsHoldability, StoredProcedureMetaData storedProcMetaData, FBObjectListener.StatementListener statementListener, FBObjectListener.BlobListener blobListener) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
-
Method Detail
-
getParameterMetaData
public java.sql.ParameterMetaData getParameterMetaData() throws java.sql.SQLException- Specified by:
getParameterMetaDatain interfacejava.sql.PreparedStatement- Overrides:
getParameterMetaDatain classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
addBatch
public void addBatch() throws java.sql.SQLException- Specified by:
addBatchin interfacejava.sql.PreparedStatement- Overrides:
addBatchin classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
executeBatchInternal
protected java.util.List<java.lang.Long> executeBatchInternal() throws java.sql.SQLException- Overrides:
executeBatchInternalin classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setSelectableProcedure
public void setSelectableProcedure(boolean selectableProcedure)
Description copied from interface:FirebirdCallableStatementMark this callable statement as a call of the selectable procedure. By default callable statement uses "EXECUTE PROCEDURE" SQL statement to invoke stored procedures that return single row of output parameters or a result set. In former case it retrieves only the first row of the result set.- Specified by:
setSelectableProcedurein interfaceFirebirdCallableStatement- Parameters:
selectableProcedure-trueif the called procedure is selectable.- See Also:
FirebirdCallableStatement.isSelectableProcedure()
-
isSelectableProcedure
public boolean isSelectableProcedure()
Description copied from interface:FirebirdCallableStatementRetrieve if this callable statement has been marked as selectable. Starting from Firebird 2.1, this value is set automatically from metadata stored in the database. Prior to Firebird 2.1, it must be set manually.- Specified by:
isSelectableProcedurein interfaceFirebirdCallableStatement- Returns:
trueif the called procedure is selectable, false otherwise- See Also:
FirebirdCallableStatement.setSelectableProcedure(boolean)
-
setRequiredTypes
protected void setRequiredTypes() throws java.sql.SQLExceptionSet required types for output parameters.- Throws:
java.sql.SQLException- if something went wrong.
-
prepareFixedStatement
protected void prepareFixedStatement(java.lang.String sql) throws java.sql.SQLExceptionWe allow multiple calls to this method without re-preparing the statement. This is an workaround to the issue that the statement is actually prepared only after all OUT parameters are registered.- Overrides:
prepareFixedStatementin classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
getMetaData
public java.sql.ResultSetMetaData getMetaData() throws java.sql.SQLExceptionSince we deferred the statement preparation until all OUT params are registered, we ensure that the statement is prepared before the meta data for the callable statement is obtained.
- Specified by:
getMetaDatain interfacejava.sql.PreparedStatement- Overrides:
getMetaDatain classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
execute
public boolean execute() throws java.sql.SQLException- Specified by:
executein interfacejava.sql.PreparedStatement- Overrides:
executein classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
executeQuery
public java.sql.ResultSet executeQuery() throws java.sql.SQLException- Specified by:
executeQueryin interfacejava.sql.PreparedStatement- Overrides:
executeQueryin classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
executeUpdate
public int executeUpdate() throws java.sql.SQLException- Specified by:
executeUpdatein interfacejava.sql.PreparedStatement- Overrides:
executeUpdatein classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
internalExecute
protected boolean internalExecute(boolean sendOutParams) throws java.sql.SQLExceptionDescription copied from class:AbstractPreparedStatementExecute this statement. Method checks whether all parameters are set, flushes all "flushable" fields that might contain cached data and executes the statement.- Overrides:
internalExecutein classAbstractPreparedStatement- Parameters:
sendOutParams- Determines if the XSQLDA structure should be sent to the database- Returns:
trueif the statement has more result sets.- Throws:
java.sql.SQLException
-
createSpecialResultSet
protected FBResultSet createSpecialResultSet(FBObjectListener.ResultSetListener resultSetListener) throws java.sql.SQLException
Description copied from class:FBStatementCreate the result set forspecialResult.Should only be called from
FBStatement.getResultSet(boolean). This exists becauseFBCallableStatementneeds to create the result set in a slightly different way to account for the fact that the blobs were already cached earlier.- Overrides:
createSpecialResultSetin classFBStatement- Parameters:
resultSetListener- result set listener (can benull)- Returns:
- result set wrapping
specialResult - Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, int sqlType) throws java.sql.SQLException- Specified by:
registerOutParameterin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, int sqlType, int scale) throws java.sql.SQLExceptionImplementation note: This method will behave the same as calling
registerOutParameter(int, int).- Specified by:
registerOutParameterin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
wasNull
public boolean wasNull() throws java.sql.SQLException- Specified by:
wasNullin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getString
public java.lang.String getString(int parameterIndex) throws java.sql.SQLException- Specified by:
getStringin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getBoolean
public boolean getBoolean(int parameterIndex) throws java.sql.SQLException- Specified by:
getBooleanin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getByte
public byte getByte(int parameterIndex) throws java.sql.SQLException- Specified by:
getBytein interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getShort
public short getShort(int parameterIndex) throws java.sql.SQLException- Specified by:
getShortin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getInt
public int getInt(int parameterIndex) throws java.sql.SQLException- Specified by:
getIntin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getLong
public long getLong(int parameterIndex) throws java.sql.SQLException- Specified by:
getLongin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getFloat
public float getFloat(int parameterIndex) throws java.sql.SQLException- Specified by:
getFloatin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getDouble
public double getDouble(int parameterIndex) throws java.sql.SQLException- Specified by:
getDoublein interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getBigDecimal
@Deprecated public java.math.BigDecimal getBigDecimal(int parameterIndex, int scale) throws java.sql.SQLExceptionDeprecated.- Specified by:
getBigDecimalin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getBytes
public byte[] getBytes(int parameterIndex) throws java.sql.SQLException- Specified by:
getBytesin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getDate
public java.sql.Date getDate(int parameterIndex) throws java.sql.SQLException- Specified by:
getDatein interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getTime
public java.sql.Time getTime(int parameterIndex) throws java.sql.SQLException- Specified by:
getTimein interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getTimestamp
public java.sql.Timestamp getTimestamp(int parameterIndex) throws java.sql.SQLException- Specified by:
getTimestampin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getObject
public java.lang.Object getObject(int parameterIndex) throws java.sql.SQLExceptionImplementation note: the registered type is ignored, and the type derived from the actual datatype will be used.
- Specified by:
getObjectin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getObject
public java.lang.Object getObject(java.lang.String colName) throws java.sql.SQLExceptionImplementation note: the registered type is ignored, and the type derived from the actual datatype will be used.
- Specified by:
getObjectin 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.SQLExceptionImplementation note: the registered type is ignored, and the type derived from the actual datatype will be used.
- Specified by:
getObjectin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getObject
public java.lang.Object getObject(java.lang.String colName, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLExceptionImplementation note: the registered type is ignored, and the type derived from the actual datatype will be used.
- Specified by:
getObjectin 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:
getObjectin 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:
getObjectin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getBigDecimal
public java.math.BigDecimal getBigDecimal(int parameterIndex) throws java.sql.SQLException- Specified by:
getBigDecimalin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getRef
public java.sql.Ref getRef(int parameterIndex) throws java.sql.SQLException- Specified by:
getRefin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getBlob
public java.sql.Blob getBlob(int parameterIndex) throws java.sql.SQLException- Specified by:
getBlobin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getClob
public java.sql.Clob getClob(int parameterIndex) throws java.sql.SQLException- Specified by:
getClobin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getArray
public java.sql.Array getArray(int parameterIndex) throws java.sql.SQLException- Specified by:
getArrayin 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:
getDatein 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:
getTimein 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:
getTimestampin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getURL
public java.net.URL getURL(int parameterIndex) throws java.sql.SQLException- Specified by:
getURLin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getString
public java.lang.String getString(java.lang.String colName) throws java.sql.SQLException- Specified by:
getStringin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getBoolean
public boolean getBoolean(java.lang.String colName) throws java.sql.SQLException- Specified by:
getBooleanin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getByte
public byte getByte(java.lang.String colName) throws java.sql.SQLException- Specified by:
getBytein interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getShort
public short getShort(java.lang.String colName) throws java.sql.SQLException- Specified by:
getShortin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getInt
public int getInt(java.lang.String colName) throws java.sql.SQLException- Specified by:
getIntin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getLong
public long getLong(java.lang.String colName) throws java.sql.SQLException- Specified by:
getLongin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getFloat
public float getFloat(java.lang.String colName) throws java.sql.SQLException- Specified by:
getFloatin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getDouble
public double getDouble(java.lang.String colName) throws java.sql.SQLException- Specified by:
getDoublein interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getBytes
public byte[] getBytes(java.lang.String colName) throws java.sql.SQLException- Specified by:
getBytesin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getDate
public java.sql.Date getDate(java.lang.String colName) throws java.sql.SQLException- Specified by:
getDatein interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getTime
public java.sql.Time getTime(java.lang.String colName) throws java.sql.SQLException- Specified by:
getTimein interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getTimestamp
public java.sql.Timestamp getTimestamp(java.lang.String colName) throws java.sql.SQLException- Specified by:
getTimestampin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getBigDecimal
public java.math.BigDecimal getBigDecimal(java.lang.String colName) throws java.sql.SQLException- Specified by:
getBigDecimalin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getRef
public java.sql.Ref getRef(java.lang.String colName) throws java.sql.SQLException- Specified by:
getRefin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getBlob
public java.sql.Blob getBlob(java.lang.String colName) throws java.sql.SQLException- Specified by:
getBlobin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getClob
public java.sql.Clob getClob(java.lang.String colName) throws java.sql.SQLException- Specified by:
getClobin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getArray
public java.sql.Array getArray(java.lang.String colName) throws java.sql.SQLException- Specified by:
getArrayin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getDate
public java.sql.Date getDate(java.lang.String colName, java.util.Calendar cal) throws java.sql.SQLException- Specified by:
getDatein interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getTime
public java.sql.Time getTime(java.lang.String colName, java.util.Calendar cal) throws java.sql.SQLException- Specified by:
getTimein interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getTimestamp
public java.sql.Timestamp getTimestamp(java.lang.String colName, java.util.Calendar cal) throws java.sql.SQLException- Specified by:
getTimestampin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getURL
public java.net.URL getURL(java.lang.String colName) throws java.sql.SQLException- Specified by:
getURLin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getCharacterStream
public java.io.Reader getCharacterStream(int parameterIndex) throws java.sql.SQLException- Specified by:
getCharacterStreamin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getCharacterStream
public java.io.Reader getCharacterStream(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getCharacterStreamin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getNCharacterStream
public java.io.Reader getNCharacterStream(int parameterIndex) throws java.sql.SQLExceptionImplementation note: This method behaves exactly the same as
getCharacterStream(int).- Specified by:
getNCharacterStreamin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getNCharacterStream
public java.io.Reader getNCharacterStream(java.lang.String parameterName) throws java.sql.SQLExceptionImplementation note: This method behaves exactly the same as
getCharacterStream(String).- Specified by:
getNCharacterStreamin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getNString
public java.lang.String getNString(int parameterIndex) throws java.sql.SQLExceptionImplementation note: This method behaves exactly the same as
getString(int).- Specified by:
getNStringin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getNString
public java.lang.String getNString(java.lang.String parameterName) throws java.sql.SQLExceptionImplementation note: This method behaves exactly the same as
getString(String).- Specified by:
getNStringin 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:
setAsciiStreamin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setAsciiStream
public 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 void setBinaryStream(java.lang.String parameterName, java.io.InputStream x, long length) throws java.sql.SQLException- Specified by:
setBinaryStreamin 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:
setBinaryStreamin 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:
setBlobin 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:
setBlobin 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:
setBlobin 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:
setCharacterStreamin 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:
setCharacterStreamin 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:
setClobin 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:
setClobin 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:
setClobin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setNCharacterStream
public void setNCharacterStream(java.lang.String parameterName, java.io.Reader value, long length) throws java.sql.SQLExceptionImplementation note: This method behaves exactly the same as
setCharacterStream(String, Reader, long).- Specified by:
setNCharacterStreamin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setNCharacterStream
public void setNCharacterStream(java.lang.String parameterName, java.io.Reader value) throws java.sql.SQLExceptionImplementation note: This method behaves exactly the same as
setCharacterStream(String, Reader).- Specified by:
setNCharacterStreamin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setNClob
public void setNClob(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLExceptionImplementation note: This method behaves exactly the same as
setClob(String, Reader, long).- Specified by:
setNClobin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setNClob
public void setNClob(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLExceptionImplementation note: This method behaves exactly the same as
setClob(String, Reader).- Specified by:
setNClobin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setNString
public void setNString(java.lang.String parameterName, java.lang.String value) throws java.sql.SQLExceptionImplementation note: This method behaves exactly the same as
setString(String, String).- Specified by:
setNStringin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(java.lang.String param1, int param2) throws java.sql.SQLException- Specified by:
registerOutParameterin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(java.lang.String param1, int param2, int param3) throws java.sql.SQLException- Specified by:
registerOutParameterin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(java.lang.String param1, int param2, java.lang.String param3) throws java.sql.SQLException- Specified by:
registerOutParameterin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setURL
public void setURL(java.lang.String param1, java.net.URL param2) throws java.sql.SQLException- Specified by:
setURLin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setNull
public void setNull(java.lang.String param1, int param2) throws java.sql.SQLException- Specified by:
setNullin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setBoolean
public void setBoolean(java.lang.String param1, boolean param2) throws java.sql.SQLException- Specified by:
setBooleanin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setByte
public void setByte(java.lang.String param1, byte param2) throws java.sql.SQLException- Specified by:
setBytein interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setShort
public void setShort(java.lang.String param1, short param2) throws java.sql.SQLException- Specified by:
setShortin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setInt
public void setInt(java.lang.String param1, int param2) throws java.sql.SQLException- Specified by:
setIntin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setLong
public void setLong(java.lang.String param1, long param2) throws java.sql.SQLException- Specified by:
setLongin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setFloat
public void setFloat(java.lang.String param1, float param2) throws java.sql.SQLException- Specified by:
setFloatin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setDouble
public void setDouble(java.lang.String param1, double param2) throws java.sql.SQLException- Specified by:
setDoublein interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setBigDecimal
public void setBigDecimal(java.lang.String param1, java.math.BigDecimal param2) throws java.sql.SQLException- Specified by:
setBigDecimalin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setString
public void setString(java.lang.String param1, java.lang.String param2) throws java.sql.SQLException- Specified by:
setStringin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setBytes
public void setBytes(java.lang.String param1, byte[] param2) throws java.sql.SQLException- Specified by:
setBytesin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setDate
public void setDate(java.lang.String param1, java.sql.Date param2) throws java.sql.SQLException- Specified by:
setDatein interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setTime
public void setTime(java.lang.String param1, java.sql.Time param2) throws java.sql.SQLException- Specified by:
setTimein interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setTimestamp
public void setTimestamp(java.lang.String param1, java.sql.Timestamp param2) throws java.sql.SQLException- Specified by:
setTimestampin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setAsciiStream
public void setAsciiStream(java.lang.String param1, java.io.InputStream param2, int param3) throws java.sql.SQLException- Specified by:
setAsciiStreamin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setBinaryStream
public void setBinaryStream(java.lang.String param1, java.io.InputStream param2, int param3) throws java.sql.SQLException- Specified by:
setBinaryStreamin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setObject
public void setObject(java.lang.String param1, java.lang.Object param2, int param3, int param4) throws java.sql.SQLException- Specified by:
setObjectin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setObject
public void setObject(java.lang.String param1, java.lang.Object param2, int param3) throws java.sql.SQLException- Specified by:
setObjectin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setObject
public void setObject(java.lang.String param1, java.lang.Object param2) throws java.sql.SQLException- Specified by:
setObjectin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setCharacterStream
public void setCharacterStream(java.lang.String param1, java.io.Reader param2, int param3) throws java.sql.SQLException- Specified by:
setCharacterStreamin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setDate
public void setDate(java.lang.String param1, java.sql.Date param2, java.util.Calendar param3) throws java.sql.SQLException- Specified by:
setDatein interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setTime
public void setTime(java.lang.String param1, java.sql.Time param2, java.util.Calendar param3) throws java.sql.SQLException- Specified by:
setTimein interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setTimestamp
public void setTimestamp(java.lang.String param1, java.sql.Timestamp param2, java.util.Calendar param3) throws java.sql.SQLException- Specified by:
setTimestampin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setNull
public void setNull(java.lang.String param1, int param2, java.lang.String param3) throws java.sql.SQLException- Specified by:
setNullin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, int sqlType, java.lang.String typeName) throws java.sql.SQLException- Specified by:
registerOutParameterin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getGeneratedKeys
public java.sql.ResultSet getGeneratedKeys() throws java.sql.SQLException- Specified by:
getGeneratedKeysin interfacejava.sql.Statement- Overrides:
getGeneratedKeysin classFBStatement- Throws:
java.sql.SQLException
-
assertHasData
protected void assertHasData(java.sql.ResultSet rs) throws java.sql.SQLExceptionAsserts if the current statement has data to return. It checks if the result set has a row with data.- Parameters:
rs- result set to test- Throws:
java.sql.SQLException- when the result set has no data.
-
getCurrentResultSet
public java.sql.ResultSet getCurrentResultSet() throws java.sql.SQLExceptionDescription copied from interface:FirebirdStatementGet current result set. Behaviour of this method is similar to the behavior of theStatement.getResultSet(), except that this method can be called as much as you like.- Specified by:
getCurrentResultSetin interfaceFirebirdStatement- Overrides:
getCurrentResultSetin classFBStatement- Returns:
- instance of
ResultSetrepresenting current result set ornullif it is not available. - Throws:
java.sql.SQLException- if database access error happened.
-
getAndAssertSingletonResultSet
protected java.sql.ResultSet getAndAssertSingletonResultSet() throws java.sql.SQLExceptionReturns the result set for the singleton row of the callable statement and asserts it has data. If this is a selectable procedure, or there is no singleton row, it will return the normal result set.This should fix the problem described in JDBC-350 in most circumstances.
- Returns:
- Either the singleton result set, or the current result set as described above
- Throws:
java.sql.SQLException- For database access errors
-
getResultSet
public java.sql.ResultSet getResultSet() throws java.sql.SQLExceptionCalling this method twice with autocommit on and used will probably throw an inappropriate or uninformative exception.
- Specified by:
getResultSetin interfacejava.sql.Statement- Overrides:
getResultSetin classFBStatement- Throws:
java.sql.SQLException
-
setBigDecimal
public void setBigDecimal(int parameterIndex, java.math.BigDecimal x) throws java.sql.SQLException- Specified by:
setBigDecimalin interfacejava.sql.PreparedStatement- Overrides:
setBigDecimalin classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setBinaryStream
public void setBinaryStream(int parameterIndex, java.io.InputStream inputStream, int length) throws java.sql.SQLException- Specified by:
setBinaryStreamin interfacejava.sql.PreparedStatement- Overrides:
setBinaryStreamin classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setBinaryStream
public void setBinaryStream(int parameterIndex, java.io.InputStream inputStream, long length) throws java.sql.SQLException- Specified by:
setBinaryStreamin interfacejava.sql.PreparedStatement- Overrides:
setBinaryStreamin classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setBinaryStream
public void setBinaryStream(int parameterIndex, java.io.InputStream inputStream) throws java.sql.SQLException- Specified by:
setBinaryStreamin interfacejava.sql.PreparedStatement- Overrides:
setBinaryStreamin classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setBlob
public void setBlob(int parameterIndex, java.sql.Blob blob) throws java.sql.SQLException- Specified by:
setBlobin interfacejava.sql.PreparedStatement- Overrides:
setBlobin classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setBlob
public void setBlob(int parameterIndex, java.io.InputStream inputStream, long length) throws java.sql.SQLException- Specified by:
setBlobin interfacejava.sql.PreparedStatement- Overrides:
setBlobin classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setBlob
public void setBlob(int parameterIndex, java.io.InputStream inputStream) throws java.sql.SQLException- Specified by:
setBlobin interfacejava.sql.PreparedStatement- Overrides:
setBlobin classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setBoolean
public void setBoolean(int parameterIndex, boolean x) throws java.sql.SQLException- Specified by:
setBooleanin interfacejava.sql.PreparedStatement- Overrides:
setBooleanin classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setByte
public void setByte(int parameterIndex, byte x) throws java.sql.SQLException- Specified by:
setBytein interfacejava.sql.PreparedStatement- Overrides:
setBytein classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setBytes
public void setBytes(int parameterIndex, byte[] x) throws java.sql.SQLException- Specified by:
setBytesin interfacejava.sql.PreparedStatement- Overrides:
setBytesin classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setCharacterStream
public void setCharacterStream(int parameterIndex, java.io.Reader reader, int length) throws java.sql.SQLException- Specified by:
setCharacterStreamin interfacejava.sql.PreparedStatement- Overrides:
setCharacterStreamin classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setCharacterStream
public void setCharacterStream(int parameterIndex, java.io.Reader reader, long length) throws java.sql.SQLException- Specified by:
setCharacterStreamin interfacejava.sql.PreparedStatement- Overrides:
setCharacterStreamin classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setCharacterStream
public void setCharacterStream(int parameterIndex, java.io.Reader reader) throws java.sql.SQLException- Specified by:
setCharacterStreamin interfacejava.sql.PreparedStatement- Overrides:
setCharacterStreamin classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setClob
public void setClob(int parameterIndex, java.sql.Clob x) throws java.sql.SQLException- Specified by:
setClobin interfacejava.sql.PreparedStatement- Overrides:
setClobin classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setClob
public void setClob(int parameterIndex, java.io.Reader reader, long length) throws java.sql.SQLException- Specified by:
setClobin interfacejava.sql.PreparedStatement- Overrides:
setClobin classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setClob
public void setClob(int parameterIndex, java.io.Reader reader) throws java.sql.SQLException- Specified by:
setClobin interfacejava.sql.PreparedStatement- Overrides:
setClobin classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setDate
public void setDate(int parameterIndex, java.sql.Date x, java.util.Calendar cal) throws java.sql.SQLException- Specified by:
setDatein interfacejava.sql.PreparedStatement- Overrides:
setDatein classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setDate
public void setDate(int parameterIndex, java.sql.Date x) throws java.sql.SQLException- Specified by:
setDatein interfacejava.sql.PreparedStatement- Overrides:
setDatein classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setDouble
public void setDouble(int parameterIndex, double x) throws java.sql.SQLException- Specified by:
setDoublein interfacejava.sql.PreparedStatement- Overrides:
setDoublein classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setFloat
public void setFloat(int parameterIndex, float x) throws java.sql.SQLException- Specified by:
setFloatin interfacejava.sql.PreparedStatement- Overrides:
setFloatin classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setInt
public void setInt(int parameterIndex, int x) throws java.sql.SQLException- Specified by:
setIntin interfacejava.sql.PreparedStatement- Overrides:
setIntin classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setLong
public void setLong(int parameterIndex, long x) throws java.sql.SQLException- Specified by:
setLongin interfacejava.sql.PreparedStatement- Overrides:
setLongin classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setNull
public void setNull(int parameterIndex, int sqlType, java.lang.String typeName) throws java.sql.SQLException- Specified by:
setNullin interfacejava.sql.PreparedStatement- Overrides:
setNullin classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setNull
public void setNull(int parameterIndex, int sqlType) throws java.sql.SQLException- Specified by:
setNullin interfacejava.sql.PreparedStatement- Overrides:
setNullin classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setObject
public void setObject(int parameterIndex, java.lang.Object x, int targetSqlType, int scale) throws java.sql.SQLExceptionDescription copied from class:AbstractPreparedStatementImplementation note: ignores
scaleandtargetSqlTypeand works asAbstractPreparedStatement.setObject(int, Object).- Specified by:
setObjectin interfacejava.sql.PreparedStatement- Overrides:
setObjectin classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setObject
public void setObject(int parameterIndex, java.lang.Object x, int targetSqlType) throws java.sql.SQLExceptionDescription copied from class:AbstractPreparedStatementImplementation note: ignores
targetSqlTypeand works asAbstractPreparedStatement.setObject(int, Object).- Specified by:
setObjectin interfacejava.sql.PreparedStatement- Overrides:
setObjectin classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setObject
public void setObject(int parameterIndex, java.lang.Object x) throws java.sql.SQLException- Specified by:
setObjectin interfacejava.sql.PreparedStatement- Overrides:
setObjectin classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setShort
public void setShort(int parameterIndex, short x) throws java.sql.SQLException- Specified by:
setShortin interfacejava.sql.PreparedStatement- Overrides:
setShortin classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setString
public void setString(int parameterIndex, java.lang.String x) throws java.sql.SQLException- Specified by:
setStringin interfacejava.sql.PreparedStatement- Overrides:
setStringin classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setTime
public void setTime(int parameterIndex, java.sql.Time x, java.util.Calendar cal) throws java.sql.SQLException- Specified by:
setTimein interfacejava.sql.PreparedStatement- Overrides:
setTimein classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setTime
public void setTime(int parameterIndex, java.sql.Time x) throws java.sql.SQLException- Specified by:
setTimein interfacejava.sql.PreparedStatement- Overrides:
setTimein classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setTimestamp
public void setTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar cal) throws java.sql.SQLException- Specified by:
setTimestampin interfacejava.sql.PreparedStatement- Overrides:
setTimestampin classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
setTimestamp
public void setTimestamp(int parameterIndex, java.sql.Timestamp x) throws java.sql.SQLException- Specified by:
setTimestampin interfacejava.sql.PreparedStatement- Overrides:
setTimestampin classAbstractPreparedStatement- Throws:
java.sql.SQLException
-
findOutParameter
protected int findOutParameter(java.lang.String paramName) throws java.sql.SQLExceptionHelper method to identify the right result set column for the give OUT parameter name.- Parameters:
paramName- Name of the OUT parameter- Throws:
java.sql.SQLException
-
getNClob
public java.sql.NClob getNClob(int parameterIndex) throws java.sql.SQLExceptionImplementation note: This method behaves exactly the same as
getClob(int).- Specified by:
getNClobin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getNClob
public java.sql.NClob getNClob(java.lang.String parameterName) throws java.sql.SQLExceptionImplementation note: This method behaves exactly the same as
getClob(String).- Specified by:
getNClobin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getRowId
public java.sql.RowId getRowId(int parameterIndex) throws java.sql.SQLException- Specified by:
getRowIdin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getRowId
public java.sql.RowId getRowId(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getRowIdin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getSQLXML
public java.sql.SQLXML getSQLXML(int parameterIndex) throws java.sql.SQLException- Specified by:
getSQLXMLin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
getSQLXML
public java.sql.SQLXML getSQLXML(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
getSQLXMLin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
setNClob
public void setNClob(java.lang.String parameterName, java.sql.NClob value) throws java.sql.SQLExceptionImplementation note: This method behaves exactly the same as
setClob(String, Clob).- Specified by:
setNClobin 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:
setRowIdin 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:
setSQLXMLin interfacejava.sql.CallableStatement- Throws:
java.sql.SQLException
-
-