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.FBStatementFBStatement.StatementResult
 
- 
 - 
Field SummaryFields Modifier and Type Field Description protected FBProcedureCallprocedureCallprotected booleanselectableProcedure- 
Fields inherited from class org.firebirdsql.jdbc.AbstractPreparedStatementbatchList, METHOD_NOT_SUPPORTED
 - 
Fields inherited from class org.firebirdsql.jdbc.FBStatementcompleted, connection, currentStatementResult, fbStatement, fetchSize, firstWarning, gdsHelper, isSingletonResult, jdbcVersionSupport, maxRows, specialResult, statementListener
 - 
Fields inherited from interface org.firebirdsql.jdbc.FirebirdPreparedStatementTYPE_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 SummaryConstructors 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 SummaryAll 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.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.FBPreparedStatementsetObject, setObject
 - 
Methods inherited from class org.firebirdsql.jdbc.AbstractPreparedStatementaddBatch, 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.FBStatementaddWarning, 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.Objectclone, getClass, notify, notifyAll, toString, wait, wait, wait
 - 
Methods inherited from interface java.sql.CallableStatementregisterOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, setObject, setObject
 - 
Methods inherited from interface org.firebirdsql.jdbc.FirebirdPreparedStatementgetExecutionPlan, getExplainedExecutionPlan, getStatementType
 - 
Methods inherited from interface org.firebirdsql.jdbc.FirebirdStatementgetDeletedRowsCount, getInsertedRowsCount, getLastExecutionPlan, getLastExplainedExecutionPlan, getLocalStatementId, getUpdatedRowsCount, hasOpenResultSet, isValid
 - 
Methods inherited from interface java.sql.PreparedStatementclearParameters, executeLargeUpdate, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setObject, setObject, setRef, setRowId, setSQLXML, setUnicodeStream, setURL
 - 
Methods inherited from interface java.sql.StatementaddBatch, 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- 
selectableProcedureprotected boolean selectableProcedure 
 - 
procedureCallprotected FBProcedureCall procedureCall 
 
- 
 - 
Constructor Detail- 
AbstractCallableStatementprotected 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- 
getParameterMetaDatapublic java.sql.ParameterMetaData getParameterMetaData() throws java.sql.SQLException- Specified by:
- getParameterMetaDatain interface- java.sql.PreparedStatement
- Overrides:
- getParameterMetaDatain class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
addBatchpublic void addBatch() throws java.sql.SQLException- Specified by:
- addBatchin interface- java.sql.PreparedStatement
- Overrides:
- addBatchin class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
executeBatchInternalprotected java.util.List<java.lang.Long> executeBatchInternal() throws java.sql.SQLException- Overrides:
- executeBatchInternalin class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setSelectableProcedurepublic 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 interface- FirebirdCallableStatement
- Parameters:
- selectableProcedure-- trueif the called procedure is selectable.
- See Also:
- FirebirdCallableStatement.isSelectableProcedure()
 
 - 
isSelectableProcedurepublic 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 interface- FirebirdCallableStatement
- Returns:
- trueif the called procedure is selectable, false otherwise
- See Also:
- FirebirdCallableStatement.setSelectableProcedure(boolean)
 
 - 
setRequiredTypesprotected void setRequiredTypes() throws java.sql.SQLExceptionSet required types for output parameters.- Throws:
- java.sql.SQLException- if something went wrong.
 
 - 
prepareFixedStatementprotected 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 class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
getMetaDatapublic 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 interface- java.sql.PreparedStatement
- Overrides:
- getMetaDatain class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
executepublic boolean execute() throws java.sql.SQLException- Specified by:
- executein interface- java.sql.PreparedStatement
- Overrides:
- executein class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
executeQuerypublic java.sql.ResultSet executeQuery() throws java.sql.SQLException- Specified by:
- executeQueryin interface- java.sql.PreparedStatement
- Overrides:
- executeQueryin class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
executeUpdatepublic int executeUpdate() throws java.sql.SQLException- Specified by:
- executeUpdatein interface- java.sql.PreparedStatement
- Overrides:
- executeUpdatein class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
internalExecuteprotected 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 class- AbstractPreparedStatement
- 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
 
 - 
registerOutParameterpublic void registerOutParameter(int parameterIndex, int sqlType) throws java.sql.SQLException- Specified by:
- registerOutParameterin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
registerOutParameterpublic 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 interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
wasNullpublic boolean wasNull() throws java.sql.SQLException- Specified by:
- wasNullin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getStringpublic java.lang.String getString(int parameterIndex) throws java.sql.SQLException- Specified by:
- getStringin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getBooleanpublic boolean getBoolean(int parameterIndex) throws java.sql.SQLException- Specified by:
- getBooleanin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getBytepublic byte getByte(int parameterIndex) throws java.sql.SQLException- Specified by:
- getBytein interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getShortpublic short getShort(int parameterIndex) throws java.sql.SQLException- Specified by:
- getShortin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getIntpublic int getInt(int parameterIndex) throws java.sql.SQLException- Specified by:
- getIntin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getLongpublic long getLong(int parameterIndex) throws java.sql.SQLException- Specified by:
- getLongin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getFloatpublic float getFloat(int parameterIndex) throws java.sql.SQLException- Specified by:
- getFloatin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getDoublepublic double getDouble(int parameterIndex) throws java.sql.SQLException- Specified by:
- getDoublein interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getBigDecimal@Deprecated public java.math.BigDecimal getBigDecimal(int parameterIndex, int scale) throws java.sql.SQLExceptionDeprecated.- Specified by:
- getBigDecimalin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getBytespublic byte[] getBytes(int parameterIndex) throws java.sql.SQLException- Specified by:
- getBytesin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getDatepublic java.sql.Date getDate(int parameterIndex) throws java.sql.SQLException- Specified by:
- getDatein interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getTimepublic java.sql.Time getTime(int parameterIndex) throws java.sql.SQLException- Specified by:
- getTimein interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getTimestamppublic java.sql.Timestamp getTimestamp(int parameterIndex) throws java.sql.SQLException- Specified by:
- getTimestampin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getObjectpublic 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 interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getObjectpublic 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 interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getObjectpublic 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 interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getObjectpublic 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 interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getObjectpublic <T> T getObject(int parameterIndex, java.lang.Class<T> type) throws java.sql.SQLException- Specified by:
- getObjectin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getObjectpublic <T> T getObject(java.lang.String parameterName, java.lang.Class<T> type) throws java.sql.SQLException- Specified by:
- getObjectin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getBigDecimalpublic java.math.BigDecimal getBigDecimal(int parameterIndex) throws java.sql.SQLException- Specified by:
- getBigDecimalin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getRefpublic java.sql.Ref getRef(int parameterIndex) throws java.sql.SQLException- Specified by:
- getRefin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getBlobpublic java.sql.Blob getBlob(int parameterIndex) throws java.sql.SQLException- Specified by:
- getBlobin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getClobpublic java.sql.Clob getClob(int parameterIndex) throws java.sql.SQLException- Specified by:
- getClobin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getArraypublic java.sql.Array getArray(int parameterIndex) throws java.sql.SQLException- Specified by:
- getArrayin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getDatepublic java.sql.Date getDate(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException- Specified by:
- getDatein interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getTimepublic java.sql.Time getTime(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException- Specified by:
- getTimein interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getTimestamppublic java.sql.Timestamp getTimestamp(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException- Specified by:
- getTimestampin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getURLpublic java.net.URL getURL(int parameterIndex) throws java.sql.SQLException- Specified by:
- getURLin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getStringpublic java.lang.String getString(java.lang.String colName) throws java.sql.SQLException- Specified by:
- getStringin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getBooleanpublic boolean getBoolean(java.lang.String colName) throws java.sql.SQLException- Specified by:
- getBooleanin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getBytepublic byte getByte(java.lang.String colName) throws java.sql.SQLException- Specified by:
- getBytein interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getShortpublic short getShort(java.lang.String colName) throws java.sql.SQLException- Specified by:
- getShortin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getIntpublic int getInt(java.lang.String colName) throws java.sql.SQLException- Specified by:
- getIntin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getLongpublic long getLong(java.lang.String colName) throws java.sql.SQLException- Specified by:
- getLongin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getFloatpublic float getFloat(java.lang.String colName) throws java.sql.SQLException- Specified by:
- getFloatin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getDoublepublic double getDouble(java.lang.String colName) throws java.sql.SQLException- Specified by:
- getDoublein interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getBytespublic byte[] getBytes(java.lang.String colName) throws java.sql.SQLException- Specified by:
- getBytesin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getDatepublic java.sql.Date getDate(java.lang.String colName) throws java.sql.SQLException- Specified by:
- getDatein interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getTimepublic java.sql.Time getTime(java.lang.String colName) throws java.sql.SQLException- Specified by:
- getTimein interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getTimestamppublic java.sql.Timestamp getTimestamp(java.lang.String colName) throws java.sql.SQLException- Specified by:
- getTimestampin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getBigDecimalpublic java.math.BigDecimal getBigDecimal(java.lang.String colName) throws java.sql.SQLException- Specified by:
- getBigDecimalin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getRefpublic java.sql.Ref getRef(java.lang.String colName) throws java.sql.SQLException- Specified by:
- getRefin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getBlobpublic java.sql.Blob getBlob(java.lang.String colName) throws java.sql.SQLException- Specified by:
- getBlobin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getClobpublic java.sql.Clob getClob(java.lang.String colName) throws java.sql.SQLException- Specified by:
- getClobin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getArraypublic java.sql.Array getArray(java.lang.String colName) throws java.sql.SQLException- Specified by:
- getArrayin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getDatepublic java.sql.Date getDate(java.lang.String colName, java.util.Calendar cal) throws java.sql.SQLException- Specified by:
- getDatein interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getTimepublic java.sql.Time getTime(java.lang.String colName, java.util.Calendar cal) throws java.sql.SQLException- Specified by:
- getTimein interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getTimestamppublic java.sql.Timestamp getTimestamp(java.lang.String colName, java.util.Calendar cal) throws java.sql.SQLException- Specified by:
- getTimestampin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getURLpublic java.net.URL getURL(java.lang.String colName) throws java.sql.SQLException- Specified by:
- getURLin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getCharacterStreampublic java.io.Reader getCharacterStream(int parameterIndex) throws java.sql.SQLException- Specified by:
- getCharacterStreamin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getCharacterStreampublic java.io.Reader getCharacterStream(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
- getCharacterStreamin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getNCharacterStreampublic java.io.Reader getNCharacterStream(int parameterIndex) throws java.sql.SQLExceptionImplementation note: This method behaves exactly the same as getCharacterStream(int).- Specified by:
- getNCharacterStreamin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getNCharacterStreampublic 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 interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getNStringpublic java.lang.String getNString(int parameterIndex) throws java.sql.SQLExceptionImplementation note: This method behaves exactly the same as getString(int).- Specified by:
- getNStringin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getNStringpublic 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 interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setAsciiStreampublic void setAsciiStream(java.lang.String parameterName, java.io.InputStream x, long length) throws java.sql.SQLException- Specified by:
- setAsciiStreamin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setAsciiStreampublic void setAsciiStream(java.lang.String parameterName, java.io.InputStream x) throws java.sql.SQLException- Specified by:
- setAsciiStreamin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setBinaryStreampublic void setBinaryStream(java.lang.String parameterName, java.io.InputStream x, long length) throws java.sql.SQLException- Specified by:
- setBinaryStreamin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setBinaryStreampublic void setBinaryStream(java.lang.String parameterName, java.io.InputStream x) throws java.sql.SQLException- Specified by:
- setBinaryStreamin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setBlobpublic void setBlob(java.lang.String parameterName, java.sql.Blob x) throws java.sql.SQLException- Specified by:
- setBlobin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setBlobpublic void setBlob(java.lang.String parameterName, java.io.InputStream inputStream, long length) throws java.sql.SQLException- Specified by:
- setBlobin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setBlobpublic void setBlob(java.lang.String parameterName, java.io.InputStream inputStream) throws java.sql.SQLException- Specified by:
- setBlobin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setCharacterStreampublic void setCharacterStream(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException- Specified by:
- setCharacterStreamin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setCharacterStreampublic void setCharacterStream(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException- Specified by:
- setCharacterStreamin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setClobpublic void setClob(java.lang.String parameterName, java.sql.Clob x) throws java.sql.SQLException- Specified by:
- setClobin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setClobpublic void setClob(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException- Specified by:
- setClobin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setClobpublic void setClob(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException- Specified by:
- setClobin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setNCharacterStreampublic 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 interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setNCharacterStreampublic 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 interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setNClobpublic 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 interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setNClobpublic 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 interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setNStringpublic 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 interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
registerOutParameterpublic void registerOutParameter(java.lang.String param1, int param2) throws java.sql.SQLException- Specified by:
- registerOutParameterin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
registerOutParameterpublic void registerOutParameter(java.lang.String param1, int param2, int param3) throws java.sql.SQLException- Specified by:
- registerOutParameterin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
registerOutParameterpublic void registerOutParameter(java.lang.String param1, int param2, java.lang.String param3) throws java.sql.SQLException- Specified by:
- registerOutParameterin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setURLpublic void setURL(java.lang.String param1, java.net.URL param2) throws java.sql.SQLException- Specified by:
- setURLin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setNullpublic void setNull(java.lang.String param1, int param2) throws java.sql.SQLException- Specified by:
- setNullin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setBooleanpublic void setBoolean(java.lang.String param1, boolean param2) throws java.sql.SQLException- Specified by:
- setBooleanin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setBytepublic void setByte(java.lang.String param1, byte param2) throws java.sql.SQLException- Specified by:
- setBytein interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setShortpublic void setShort(java.lang.String param1, short param2) throws java.sql.SQLException- Specified by:
- setShortin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setIntpublic void setInt(java.lang.String param1, int param2) throws java.sql.SQLException- Specified by:
- setIntin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setLongpublic void setLong(java.lang.String param1, long param2) throws java.sql.SQLException- Specified by:
- setLongin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setFloatpublic void setFloat(java.lang.String param1, float param2) throws java.sql.SQLException- Specified by:
- setFloatin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setDoublepublic void setDouble(java.lang.String param1, double param2) throws java.sql.SQLException- Specified by:
- setDoublein interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setBigDecimalpublic void setBigDecimal(java.lang.String param1, java.math.BigDecimal param2) throws java.sql.SQLException- Specified by:
- setBigDecimalin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setStringpublic void setString(java.lang.String param1, java.lang.String param2) throws java.sql.SQLException- Specified by:
- setStringin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setBytespublic void setBytes(java.lang.String param1, byte[] param2) throws java.sql.SQLException- Specified by:
- setBytesin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setDatepublic void setDate(java.lang.String param1, java.sql.Date param2) throws java.sql.SQLException- Specified by:
- setDatein interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setTimepublic void setTime(java.lang.String param1, java.sql.Time param2) throws java.sql.SQLException- Specified by:
- setTimein interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setTimestamppublic void setTimestamp(java.lang.String param1, java.sql.Timestamp param2) throws java.sql.SQLException- Specified by:
- setTimestampin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setAsciiStreampublic void setAsciiStream(java.lang.String param1, java.io.InputStream param2, int param3) throws java.sql.SQLException- Specified by:
- setAsciiStreamin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setBinaryStreampublic void setBinaryStream(java.lang.String param1, java.io.InputStream param2, int param3) throws java.sql.SQLException- Specified by:
- setBinaryStreamin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setObjectpublic void setObject(java.lang.String param1, java.lang.Object param2, int param3, int param4) throws java.sql.SQLException- Specified by:
- setObjectin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setObjectpublic void setObject(java.lang.String param1, java.lang.Object param2, int param3) throws java.sql.SQLException- Specified by:
- setObjectin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setObjectpublic void setObject(java.lang.String param1, java.lang.Object param2) throws java.sql.SQLException- Specified by:
- setObjectin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setCharacterStreampublic void setCharacterStream(java.lang.String param1, java.io.Reader param2, int param3) throws java.sql.SQLException- Specified by:
- setCharacterStreamin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setDatepublic void setDate(java.lang.String param1, java.sql.Date param2, java.util.Calendar param3) throws java.sql.SQLException- Specified by:
- setDatein interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setTimepublic void setTime(java.lang.String param1, java.sql.Time param2, java.util.Calendar param3) throws java.sql.SQLException- Specified by:
- setTimein interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setTimestamppublic void setTimestamp(java.lang.String param1, java.sql.Timestamp param2, java.util.Calendar param3) throws java.sql.SQLException- Specified by:
- setTimestampin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setNullpublic void setNull(java.lang.String param1, int param2, java.lang.String param3) throws java.sql.SQLException- Specified by:
- setNullin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
registerOutParameterpublic void registerOutParameter(int parameterIndex, int sqlType, java.lang.String typeName) throws java.sql.SQLException- Specified by:
- registerOutParameterin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getGeneratedKeyspublic java.sql.ResultSet getGeneratedKeys() throws java.sql.SQLException- Specified by:
- getGeneratedKeysin interface- java.sql.Statement
- Overrides:
- getGeneratedKeysin class- FBStatement
- Throws:
- java.sql.SQLException
 
 - 
assertHasDataprotected 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.
 
 - 
getCurrentResultSetpublic 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 interface- FirebirdStatement
- Overrides:
- getCurrentResultSetin class- FBStatement
- Returns:
- instance of ResultSetrepresenting current result set ornullif it is not available.
- Throws:
- java.sql.SQLException- if database access error happened.
 
 - 
getAndAssertSingletonResultSetprotected 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
 
 - 
getResultSetpublic 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 interface- java.sql.Statement
- Overrides:
- getResultSetin class- FBStatement
- Throws:
- java.sql.SQLException
 
 - 
setBigDecimalpublic void setBigDecimal(int parameterIndex, java.math.BigDecimal x) throws java.sql.SQLException- Specified by:
- setBigDecimalin interface- java.sql.PreparedStatement
- Overrides:
- setBigDecimalin class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setBinaryStreampublic void setBinaryStream(int parameterIndex, java.io.InputStream inputStream, int length) throws java.sql.SQLException- Specified by:
- setBinaryStreamin interface- java.sql.PreparedStatement
- Overrides:
- setBinaryStreamin class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setBinaryStreampublic void setBinaryStream(int parameterIndex, java.io.InputStream inputStream, long length) throws java.sql.SQLException- Specified by:
- setBinaryStreamin interface- java.sql.PreparedStatement
- Overrides:
- setBinaryStreamin class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setBinaryStreampublic void setBinaryStream(int parameterIndex, java.io.InputStream inputStream) throws java.sql.SQLException- Specified by:
- setBinaryStreamin interface- java.sql.PreparedStatement
- Overrides:
- setBinaryStreamin class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setBlobpublic void setBlob(int parameterIndex, java.sql.Blob blob) throws java.sql.SQLException- Specified by:
- setBlobin interface- java.sql.PreparedStatement
- Overrides:
- setBlobin class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setBlobpublic void setBlob(int parameterIndex, java.io.InputStream inputStream, long length) throws java.sql.SQLException- Specified by:
- setBlobin interface- java.sql.PreparedStatement
- Overrides:
- setBlobin class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setBlobpublic void setBlob(int parameterIndex, java.io.InputStream inputStream) throws java.sql.SQLException- Specified by:
- setBlobin interface- java.sql.PreparedStatement
- Overrides:
- setBlobin class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setBooleanpublic void setBoolean(int parameterIndex, boolean x) throws java.sql.SQLException- Specified by:
- setBooleanin interface- java.sql.PreparedStatement
- Overrides:
- setBooleanin class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setBytepublic void setByte(int parameterIndex, byte x) throws java.sql.SQLException- Specified by:
- setBytein interface- java.sql.PreparedStatement
- Overrides:
- setBytein class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setBytespublic void setBytes(int parameterIndex, byte[] x) throws java.sql.SQLException- Specified by:
- setBytesin interface- java.sql.PreparedStatement
- Overrides:
- setBytesin class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setCharacterStreampublic void setCharacterStream(int parameterIndex, java.io.Reader reader, int length) throws java.sql.SQLException- Specified by:
- setCharacterStreamin interface- java.sql.PreparedStatement
- Overrides:
- setCharacterStreamin class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setCharacterStreampublic void setCharacterStream(int parameterIndex, java.io.Reader reader, long length) throws java.sql.SQLException- Specified by:
- setCharacterStreamin interface- java.sql.PreparedStatement
- Overrides:
- setCharacterStreamin class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setCharacterStreampublic void setCharacterStream(int parameterIndex, java.io.Reader reader) throws java.sql.SQLException- Specified by:
- setCharacterStreamin interface- java.sql.PreparedStatement
- Overrides:
- setCharacterStreamin class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setClobpublic void setClob(int parameterIndex, java.sql.Clob x) throws java.sql.SQLException- Specified by:
- setClobin interface- java.sql.PreparedStatement
- Overrides:
- setClobin class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setClobpublic void setClob(int parameterIndex, java.io.Reader reader, long length) throws java.sql.SQLException- Specified by:
- setClobin interface- java.sql.PreparedStatement
- Overrides:
- setClobin class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setClobpublic void setClob(int parameterIndex, java.io.Reader reader) throws java.sql.SQLException- Specified by:
- setClobin interface- java.sql.PreparedStatement
- Overrides:
- setClobin class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setDatepublic void setDate(int parameterIndex, java.sql.Date x, java.util.Calendar cal) throws java.sql.SQLException- Specified by:
- setDatein interface- java.sql.PreparedStatement
- Overrides:
- setDatein class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setDatepublic void setDate(int parameterIndex, java.sql.Date x) throws java.sql.SQLException- Specified by:
- setDatein interface- java.sql.PreparedStatement
- Overrides:
- setDatein class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setDoublepublic void setDouble(int parameterIndex, double x) throws java.sql.SQLException- Specified by:
- setDoublein interface- java.sql.PreparedStatement
- Overrides:
- setDoublein class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setFloatpublic void setFloat(int parameterIndex, float x) throws java.sql.SQLException- Specified by:
- setFloatin interface- java.sql.PreparedStatement
- Overrides:
- setFloatin class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setIntpublic void setInt(int parameterIndex, int x) throws java.sql.SQLException- Specified by:
- setIntin interface- java.sql.PreparedStatement
- Overrides:
- setIntin class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setLongpublic void setLong(int parameterIndex, long x) throws java.sql.SQLException- Specified by:
- setLongin interface- java.sql.PreparedStatement
- Overrides:
- setLongin class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setNullpublic void setNull(int parameterIndex, int sqlType, java.lang.String typeName) throws java.sql.SQLException- Specified by:
- setNullin interface- java.sql.PreparedStatement
- Overrides:
- setNullin class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setNullpublic void setNull(int parameterIndex, int sqlType) throws java.sql.SQLException- Specified by:
- setNullin interface- java.sql.PreparedStatement
- Overrides:
- setNullin class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setObjectpublic 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 interface- java.sql.PreparedStatement
- Overrides:
- setObjectin class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setObjectpublic 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 interface- java.sql.PreparedStatement
- Overrides:
- setObjectin class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setObjectpublic void setObject(int parameterIndex, java.lang.Object x) throws java.sql.SQLException- Specified by:
- setObjectin interface- java.sql.PreparedStatement
- Overrides:
- setObjectin class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setShortpublic void setShort(int parameterIndex, short x) throws java.sql.SQLException- Specified by:
- setShortin interface- java.sql.PreparedStatement
- Overrides:
- setShortin class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setStringpublic void setString(int parameterIndex, java.lang.String x) throws java.sql.SQLException- Specified by:
- setStringin interface- java.sql.PreparedStatement
- Overrides:
- setStringin class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setTimepublic void setTime(int parameterIndex, java.sql.Time x, java.util.Calendar cal) throws java.sql.SQLException- Specified by:
- setTimein interface- java.sql.PreparedStatement
- Overrides:
- setTimein class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setTimepublic void setTime(int parameterIndex, java.sql.Time x) throws java.sql.SQLException- Specified by:
- setTimein interface- java.sql.PreparedStatement
- Overrides:
- setTimein class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setTimestamppublic void setTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar cal) throws java.sql.SQLException- Specified by:
- setTimestampin interface- java.sql.PreparedStatement
- Overrides:
- setTimestampin class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setTimestamppublic void setTimestamp(int parameterIndex, java.sql.Timestamp x) throws java.sql.SQLException- Specified by:
- setTimestampin interface- java.sql.PreparedStatement
- Overrides:
- setTimestampin class- AbstractPreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
findOutParameterprotected 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
 
 - 
getNClobpublic java.sql.NClob getNClob(int parameterIndex) throws java.sql.SQLExceptionImplementation note: This method behaves exactly the same as getClob(int).- Specified by:
- getNClobin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getNClobpublic 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 interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getRowIdpublic java.sql.RowId getRowId(int parameterIndex) throws java.sql.SQLException- Specified by:
- getRowIdin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getRowIdpublic java.sql.RowId getRowId(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
- getRowIdin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getSQLXMLpublic java.sql.SQLXML getSQLXML(int parameterIndex) throws java.sql.SQLException- Specified by:
- getSQLXMLin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
getSQLXMLpublic java.sql.SQLXML getSQLXML(java.lang.String parameterName) throws java.sql.SQLException- Specified by:
- getSQLXMLin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setNClobpublic 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 interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setRowIdpublic void setRowId(java.lang.String parameterName, java.sql.RowId x) throws java.sql.SQLException- Specified by:
- setRowIdin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 - 
setSQLXMLpublic void setSQLXML(java.lang.String parameterName, java.sql.SQLXML xmlObject) throws java.sql.SQLException- Specified by:
- setSQLXMLin interface- java.sql.CallableStatement
- Throws:
- java.sql.SQLException
 
 
- 
 
-