public class FBCallableStatement extends FBPreparedStatement implements java.sql.CallableStatement, FirebirdCallableStatement
CallableStatement.FBStatement.StatementResult| Modifier and Type | Field and Description |
|---|---|
protected FBProcedureCall |
procedureCall |
protected boolean |
selectableProcedure |
METHOD_NOT_SUPPORTEDcompleted, connection, currentStatementResult, fbStatement, fetchSize, firstWarning, gdsHelper, isSingletonResult, maxRows, specialResult, statementListenerTYPE_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| Modifier | Constructor and Description |
|---|---|
protected |
FBCallableStatement(GDSHelper c,
java.lang.String sql,
int rsType,
int rsConcurrency,
int rsHoldability,
StoredProcedureMetaData storedProcMetaData,
FBObjectListener.StatementListener statementListener,
FBObjectListener.BlobListener blobListener) |
| Modifier and Type | Method and Description |
|---|---|
void |
addBatch() |
protected void |
assertHasData(java.sql.ResultSet rs)
Asserts if the current statement has data to return.
|
void |
clearBatch() |
protected FBResultSet |
createSpecialResultSet(FBObjectListener.ResultSetListener resultSetListener)
Create the result set for
specialResult. |
boolean |
execute() |
protected java.util.List<java.lang.Long> |
executeBatchInternal() |
java.sql.ResultSet |
executeQuery() |
int |
executeUpdate() |
protected int |
findOutParameter(java.lang.String paramName)
Helper method to identify the right result set column for the give OUT parameter name.
|
protected java.sql.ResultSet |
getAndAssertSingletonResultSet()
Returns the result set for the singleton row of the callable statement and asserts it has data.
|
java.sql.Array |
getArray(int parameterIndex) |
java.sql.Array |
getArray(java.lang.String colName) |
java.math.BigDecimal |
getBigDecimal(int parameterIndex) |
java.math.BigDecimal |
getBigDecimal(int parameterIndex,
int scale)
Deprecated.
|
java.math.BigDecimal |
getBigDecimal(java.lang.String colName) |
java.sql.Blob |
getBlob(int parameterIndex) |
java.sql.Blob |
getBlob(java.lang.String colName) |
boolean |
getBoolean(int parameterIndex) |
boolean |
getBoolean(java.lang.String colName) |
byte |
getByte(int parameterIndex) |
byte |
getByte(java.lang.String colName) |
byte[] |
getBytes(int parameterIndex) |
byte[] |
getBytes(java.lang.String colName) |
java.io.Reader |
getCharacterStream(int parameterIndex) |
java.io.Reader |
getCharacterStream(java.lang.String parameterName) |
java.sql.Clob |
getClob(int parameterIndex) |
java.sql.Clob |
getClob(java.lang.String colName) |
java.sql.ResultSet |
getCurrentResultSet()
Get current result set.
|
java.sql.Date |
getDate(int parameterIndex) |
java.sql.Date |
getDate(int parameterIndex,
java.util.Calendar cal) |
java.sql.Date |
getDate(java.lang.String colName) |
java.sql.Date |
getDate(java.lang.String colName,
java.util.Calendar cal) |
double |
getDouble(int parameterIndex) |
double |
getDouble(java.lang.String colName) |
float |
getFloat(int parameterIndex) |
float |
getFloat(java.lang.String colName) |
java.sql.ResultSet |
getGeneratedKeys() |
int |
getInt(int parameterIndex) |
int |
getInt(java.lang.String colName) |
long |
getLong(int parameterIndex) |
long |
getLong(java.lang.String colName) |
java.sql.ResultSetMetaData |
getMetaData() |
java.io.Reader |
getNCharacterStream(int parameterIndex) |
java.io.Reader |
getNCharacterStream(java.lang.String parameterName) |
java.sql.NClob |
getNClob(int parameterIndex) |
java.sql.NClob |
getNClob(java.lang.String parameterName) |
java.lang.String |
getNString(int parameterIndex) |
java.lang.String |
getNString(java.lang.String parameterName) |
java.lang.Object |
getObject(int parameterIndex) |
<T> T |
getObject(int parameterIndex,
java.lang.Class<T> type) |
java.lang.Object |
getObject(int parameterIndex,
java.util.Map<java.lang.String,java.lang.Class<?>> map) |
java.lang.Object |
getObject(java.lang.String colName) |
<T> T |
getObject(java.lang.String parameterName,
java.lang.Class<T> type) |
java.lang.Object |
getObject(java.lang.String colName,
java.util.Map<java.lang.String,java.lang.Class<?>> map) |
java.sql.ParameterMetaData |
getParameterMetaData() |
java.sql.Ref |
getRef(int parameterIndex) |
java.sql.Ref |
getRef(java.lang.String colName) |
java.sql.ResultSet |
getResultSet() |
java.sql.RowId |
getRowId(int parameterIndex) |
java.sql.RowId |
getRowId(java.lang.String parameterName) |
short |
getShort(int parameterIndex) |
short |
getShort(java.lang.String colName) |
java.sql.SQLXML |
getSQLXML(int parameterIndex) |
java.sql.SQLXML |
getSQLXML(java.lang.String parameterName) |
java.lang.String |
getString(int parameterIndex) |
java.lang.String |
getString(java.lang.String colName) |
java.sql.Time |
getTime(int parameterIndex) |
java.sql.Time |
getTime(int parameterIndex,
java.util.Calendar cal) |
java.sql.Time |
getTime(java.lang.String colName) |
java.sql.Time |
getTime(java.lang.String colName,
java.util.Calendar cal) |
java.sql.Timestamp |
getTimestamp(int parameterIndex) |
java.sql.Timestamp |
getTimestamp(int parameterIndex,
java.util.Calendar cal) |
java.sql.Timestamp |
getTimestamp(java.lang.String colName) |
java.sql.Timestamp |
getTimestamp(java.lang.String colName,
java.util.Calendar cal) |
java.net.URL |
getURL(int parameterIndex) |
java.net.URL |
getURL(java.lang.String colName) |
protected boolean |
internalExecute(boolean sendOutParams)
Execute this statement.
|
boolean |
isSelectableProcedure()
Retrieve if this callable statement has been marked as selectable.
|
protected void |
prepareFixedStatement(java.lang.String sql)
We allow multiple calls to this method without re-preparing the statement.
|
void |
registerOutParameter(int parameterIndex,
int sqlType) |
void |
registerOutParameter(int parameterIndex,
int sqlType,
int scale) |
void |
registerOutParameter(int parameterIndex,
int sqlType,
java.lang.String typeName) |
void |
registerOutParameter(int parameterIndex,
java.sql.SQLType sqlType) |
void |
registerOutParameter(int parameterIndex,
java.sql.SQLType sqlType,
int scale) |
void |
registerOutParameter(int parameterIndex,
java.sql.SQLType sqlType,
java.lang.String typeName) |
void |
registerOutParameter(java.lang.String param1,
int param2) |
void |
registerOutParameter(java.lang.String param1,
int param2,
int param3) |
void |
registerOutParameter(java.lang.String param1,
int param2,
java.lang.String param3) |
void |
registerOutParameter(java.lang.String parameterName,
java.sql.SQLType sqlType) |
void |
registerOutParameter(java.lang.String parameterName,
java.sql.SQLType sqlType,
int scale) |
void |
registerOutParameter(java.lang.String parameterName,
java.sql.SQLType sqlType,
java.lang.String typeName) |
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream x) |
void |
setAsciiStream(java.lang.String param1,
java.io.InputStream param2,
int param3) |
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream x,
long length) |
void |
setBigDecimal(int parameterIndex,
java.math.BigDecimal x) |
void |
setBigDecimal(java.lang.String param1,
java.math.BigDecimal param2) |
void |
setBinaryStream(int parameterIndex,
java.io.InputStream inputStream) |
void |
setBinaryStream(int parameterIndex,
java.io.InputStream inputStream,
int length) |
void |
setBinaryStream(int parameterIndex,
java.io.InputStream inputStream,
long length) |
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream x) |
void |
setBinaryStream(java.lang.String param1,
java.io.InputStream param2,
int param3) |
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream x,
long length) |
void |
setBlob(int parameterIndex,
java.sql.Blob blob) |
void |
setBlob(int parameterIndex,
java.io.InputStream inputStream) |
void |
setBlob(int parameterIndex,
java.io.InputStream inputStream,
long length) |
void |
setBlob(java.lang.String parameterName,
java.sql.Blob x) |
void |
setBlob(java.lang.String parameterName,
java.io.InputStream inputStream) |
void |
setBlob(java.lang.String parameterName,
java.io.InputStream inputStream,
long length) |
void |
setBoolean(int parameterIndex,
boolean x) |
void |
setBoolean(java.lang.String param1,
boolean param2) |
void |
setByte(int parameterIndex,
byte x) |
void |
setByte(java.lang.String param1,
byte param2) |
void |
setBytes(int parameterIndex,
byte[] x) |
void |
setBytes(java.lang.String param1,
byte[] param2) |
void |
setCharacterStream(int parameterIndex,
java.io.Reader reader) |
void |
setCharacterStream(int parameterIndex,
java.io.Reader reader,
int length) |
void |
setCharacterStream(int parameterIndex,
java.io.Reader reader,
long length) |
void |
setCharacterStream(java.lang.String parameterName,
java.io.Reader reader) |
void |
setCharacterStream(java.lang.String param1,
java.io.Reader param2,
int param3) |
void |
setCharacterStream(java.lang.String parameterName,
java.io.Reader reader,
long length) |
void |
setClob(int parameterIndex,
java.sql.Clob x) |
void |
setClob(int parameterIndex,
java.io.Reader reader) |
void |
setClob(int parameterIndex,
java.io.Reader reader,
long length) |
void |
setClob(java.lang.String parameterName,
java.sql.Clob x) |
void |
setClob(java.lang.String parameterName,
java.io.Reader reader) |
void |
setClob(java.lang.String parameterName,
java.io.Reader reader,
long length) |
void |
setDate(int parameterIndex,
java.sql.Date x) |
void |
setDate(int parameterIndex,
java.sql.Date x,
java.util.Calendar cal) |
void |
setDate(java.lang.String param1,
java.sql.Date param2) |
void |
setDate(java.lang.String param1,
java.sql.Date param2,
java.util.Calendar param3) |
void |
setDouble(int parameterIndex,
double x) |
void |
setDouble(java.lang.String param1,
double param2) |
void |
setFloat(int parameterIndex,
float x) |
void |
setFloat(java.lang.String param1,
float param2) |
void |
setInt(int parameterIndex,
int x) |
void |
setInt(java.lang.String param1,
int param2) |
void |
setLong(int parameterIndex,
long x) |
void |
setLong(java.lang.String param1,
long param2) |
void |
setNCharacterStream(java.lang.String parameterName,
java.io.Reader value) |
void |
setNCharacterStream(java.lang.String parameterName,
java.io.Reader value,
long length) |
void |
setNClob(java.lang.String parameterName,
java.sql.NClob value) |
void |
setNClob(java.lang.String parameterName,
java.io.Reader reader) |
void |
setNClob(java.lang.String parameterName,
java.io.Reader reader,
long length) |
void |
setNString(java.lang.String parameterName,
java.lang.String value) |
void |
setNull(int parameterIndex,
int sqlType) |
void |
setNull(int parameterIndex,
int sqlType,
java.lang.String typeName) |
void |
setNull(java.lang.String param1,
int param2) |
void |
setNull(java.lang.String param1,
int param2,
java.lang.String param3) |
void |
setObject(int parameterIndex,
java.lang.Object x) |
void |
setObject(int parameterIndex,
java.lang.Object x,
int targetSqlType) |
void |
setObject(int parameterIndex,
java.lang.Object x,
int targetSqlType,
int scale) |
void |
setObject(java.lang.String param1,
java.lang.Object param2) |
void |
setObject(java.lang.String param1,
java.lang.Object param2,
int param3) |
void |
setObject(java.lang.String param1,
java.lang.Object param2,
int param3,
int param4) |
protected void |
setRequiredTypes()
Set required types for output parameters.
|
void |
setRowId(java.lang.String parameterName,
java.sql.RowId x) |
void |
setSelectableProcedure(boolean selectableProcedure)
Mark this callable statement as a call of the selectable procedure.
|
void |
setShort(int parameterIndex,
short x) |
void |
setShort(java.lang.String param1,
short param2) |
void |
setSQLXML(java.lang.String parameterName,
java.sql.SQLXML xmlObject) |
void |
setString(int parameterIndex,
java.lang.String x) |
void |
setString(java.lang.String param1,
java.lang.String param2) |
void |
setTime(int parameterIndex,
java.sql.Time x) |
void |
setTime(int parameterIndex,
java.sql.Time x,
java.util.Calendar cal) |
void |
setTime(java.lang.String param1,
java.sql.Time param2) |
void |
setTime(java.lang.String param1,
java.sql.Time param2,
java.util.Calendar param3) |
void |
setTimestamp(int parameterIndex,
java.sql.Timestamp x) |
void |
setTimestamp(int parameterIndex,
java.sql.Timestamp x,
java.util.Calendar cal) |
void |
setTimestamp(java.lang.String param1,
java.sql.Timestamp param2) |
void |
setTimestamp(java.lang.String param1,
java.sql.Timestamp param2,
java.util.Calendar param3) |
void |
setURL(java.lang.String param1,
java.net.URL param2) |
boolean |
wasNull() |
addBatch, clearParameters, completeStatement, execute, execute, execute, execute, executeLargeUpdate, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getExecutionPlan, getExplainedExecutionPlan, getField, getFirebirdParameterMetaData, getParameterDescriptor, getStatementType, isGeneratedKeyQuery, needsScrollableCursorEnabled, notifyStatementCompleted, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setObject, setObject, setRef, setRowId, setSQLXML, setUnicodeStream, setURLaddWarning, cancel, checkValidity, clearWarnings, close, closeOnCompletion, completeStatement, createBatchUpdateException, createStatementListener, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, equals, executeBatch, executeImpl, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, getConnection, getDeletedRowsCount, getFetchDirection, getFetchSize, getInsertedRowsCount, getLargeMaxRows, getLargeUpdateCount, getLargeUpdateCountMinZero, getLastExecutionPlan, getLastExplainedExecutionPlan, getLocalStatementId, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getUpdateCountMinZero, getUpdatedRowsCount, getWarnings, hashCode, hasOpenResultSet, internalExecute, internalExecute, isClosed, isCloseOnCompletion, isPoolable, isSimpleIdentifier, isValid, isWrapperFor, nativeSQL, notifyStatementCompleted, notifyStatementStarted, notifyStatementStarted, requireStatement, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, unwrap, withLockclone, finalize, getClass, notify, notifyAll, toString, wait, wait, waitgetExecutionPlan, getExplainedExecutionPlan, getStatementTypegetDeletedRowsCount, getInsertedRowsCount, getLastExecutionPlan, getLastExplainedExecutionPlan, getLocalStatementId, getUpdatedRowsCount, hasOpenResultSet, isValidclearParameters, executeLargeUpdate, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setObject, setObject, setRef, setRowId, setSQLXML, setUnicodeStream, setURLaddBatch, cancel, clearWarnings, close, closeOnCompletion, 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, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeoutprotected boolean selectableProcedure
protected FBProcedureCall procedureCall
protected FBCallableStatement(GDSHelper c, java.lang.String sql, int rsType, int rsConcurrency, int rsHoldability, StoredProcedureMetaData storedProcMetaData, FBObjectListener.StatementListener statementListener, FBObjectListener.BlobListener blobListener) throws java.sql.SQLException
java.sql.SQLExceptionpublic java.sql.ParameterMetaData getParameterMetaData()
throws java.sql.SQLException
getParameterMetaData in interface java.sql.PreparedStatementgetParameterMetaData in class FBPreparedStatementjava.sql.SQLExceptionpublic void addBatch()
throws java.sql.SQLException
addBatch in interface java.sql.PreparedStatementaddBatch in class FBPreparedStatementjava.sql.SQLExceptionpublic void clearBatch()
throws java.sql.SQLException
clearBatch in interface java.sql.StatementclearBatch in class FBPreparedStatementjava.sql.SQLExceptionprotected java.util.List<java.lang.Long> executeBatchInternal()
throws java.sql.SQLException
executeBatchInternal in class FBPreparedStatementjava.sql.SQLExceptionpublic void setSelectableProcedure(boolean selectableProcedure)
FirebirdCallableStatementsetSelectableProcedure in interface FirebirdCallableStatementselectableProcedure - true if the called procedure is selectable.FirebirdCallableStatement.isSelectableProcedure()public boolean isSelectableProcedure()
FirebirdCallableStatementStarting 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.
isSelectableProcedure in interface FirebirdCallableStatementtrue if the called procedure is selectable, false otherwiseFirebirdCallableStatement.setSelectableProcedure(boolean)protected void setRequiredTypes()
throws java.sql.SQLException
java.sql.SQLException - if something went wrong.protected void prepareFixedStatement(java.lang.String sql)
throws java.sql.SQLException
prepareFixedStatement in class FBPreparedStatementjava.sql.SQLExceptionpublic java.sql.ResultSetMetaData getMetaData()
throws java.sql.SQLException
Since 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.
getMetaData in interface java.sql.PreparedStatementgetMetaData in class FBPreparedStatementjava.sql.SQLExceptionpublic boolean execute()
throws java.sql.SQLException
execute in interface java.sql.PreparedStatementexecute in class FBPreparedStatementjava.sql.SQLExceptionpublic java.sql.ResultSet executeQuery()
throws java.sql.SQLException
executeQuery in interface java.sql.PreparedStatementexecuteQuery in class FBPreparedStatementjava.sql.SQLExceptionpublic int executeUpdate()
throws java.sql.SQLException
executeUpdate in interface java.sql.PreparedStatementexecuteUpdate in class FBPreparedStatementjava.sql.SQLExceptionprotected boolean internalExecute(boolean sendOutParams)
throws java.sql.SQLException
FBPreparedStatementinternalExecute in class FBPreparedStatementsendOutParams - Determines if the XSQLDA structure should be sent to the
databasetrue if the statement has more result sets.java.sql.SQLExceptionprotected FBResultSet createSpecialResultSet(FBObjectListener.ResultSetListener resultSetListener) throws java.sql.SQLException
FBStatementspecialResult.
Should only be called from FBStatement.getResultSet(boolean). This exists because FBCallableStatement needs
to create the result set in a slightly different way to account for the fact that the blobs were already cached
earlier.
createSpecialResultSet in class FBStatementresultSetListener - result set listener (can be null)specialResultjava.sql.SQLExceptionpublic void registerOutParameter(int parameterIndex,
int sqlType)
throws java.sql.SQLException
registerOutParameter in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void registerOutParameter(int parameterIndex,
int sqlType,
int scale)
throws java.sql.SQLException
Implementation note: This method will behave the same as calling registerOutParameter(int, int).
registerOutParameter in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void registerOutParameter(int parameterIndex,
java.sql.SQLType sqlType)
throws java.sql.SQLException
Implementation note: behaves as registerOutParameter(int, int) called with
SQLType.getVendorTypeNumber().
registerOutParameter in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void registerOutParameter(int parameterIndex,
java.sql.SQLType sqlType,
int scale)
throws java.sql.SQLException
Implementation note: behaves as registerOutParameter(int, int, int) called with
SQLType.getVendorTypeNumber().
registerOutParameter in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void registerOutParameter(int parameterIndex,
java.sql.SQLType sqlType,
java.lang.String typeName)
throws java.sql.SQLException
Implementation note: behaves as registerOutParameter(int, int, String) called with
SQLType.getVendorTypeNumber().
registerOutParameter in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic boolean wasNull()
throws java.sql.SQLException
wasNull in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.lang.String getString(int parameterIndex)
throws java.sql.SQLException
getString in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic boolean getBoolean(int parameterIndex)
throws java.sql.SQLException
getBoolean in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic byte getByte(int parameterIndex)
throws java.sql.SQLException
getByte in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic short getShort(int parameterIndex)
throws java.sql.SQLException
getShort in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic int getInt(int parameterIndex)
throws java.sql.SQLException
getInt in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic long getLong(int parameterIndex)
throws java.sql.SQLException
getLong in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic float getFloat(int parameterIndex)
throws java.sql.SQLException
getFloat in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic double getDouble(int parameterIndex)
throws java.sql.SQLException
getDouble in interface java.sql.CallableStatementjava.sql.SQLException@Deprecated
public java.math.BigDecimal getBigDecimal(int parameterIndex,
int scale)
throws java.sql.SQLException
getBigDecimal in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic byte[] getBytes(int parameterIndex)
throws java.sql.SQLException
getBytes in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Date getDate(int parameterIndex)
throws java.sql.SQLException
getDate in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Time getTime(int parameterIndex)
throws java.sql.SQLException
getTime in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Timestamp getTimestamp(int parameterIndex)
throws java.sql.SQLException
getTimestamp in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.lang.Object getObject(int parameterIndex)
throws java.sql.SQLException
Implementation note: the registered type is ignored, and the type derived from the actual datatype will be used.
getObject in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.lang.Object getObject(java.lang.String colName)
throws java.sql.SQLException
Implementation note: the registered type is ignored, and the type derived from the actual datatype will be used.
getObject in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.lang.Object getObject(int parameterIndex,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
throws java.sql.SQLException
Implementation note: the registered type is ignored, and the type derived from the actual datatype will be used.
getObject in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.lang.Object getObject(java.lang.String colName,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
throws java.sql.SQLException
Implementation note: the registered type is ignored, and the type derived from the actual datatype will be used.
getObject in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic <T> T getObject(int parameterIndex,
java.lang.Class<T> type)
throws java.sql.SQLException
getObject in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic <T> T getObject(java.lang.String parameterName,
java.lang.Class<T> type)
throws java.sql.SQLException
getObject in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.math.BigDecimal getBigDecimal(int parameterIndex)
throws java.sql.SQLException
getBigDecimal in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Ref getRef(int parameterIndex)
throws java.sql.SQLException
getRef in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Blob getBlob(int parameterIndex)
throws java.sql.SQLException
getBlob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Clob getClob(int parameterIndex)
throws java.sql.SQLException
getClob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Array getArray(int parameterIndex)
throws java.sql.SQLException
getArray in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Date getDate(int parameterIndex,
java.util.Calendar cal)
throws java.sql.SQLException
getDate in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Time getTime(int parameterIndex,
java.util.Calendar cal)
throws java.sql.SQLException
getTime in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Timestamp getTimestamp(int parameterIndex,
java.util.Calendar cal)
throws java.sql.SQLException
getTimestamp in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.net.URL getURL(int parameterIndex)
throws java.sql.SQLException
getURL in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.lang.String getString(java.lang.String colName)
throws java.sql.SQLException
getString in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic boolean getBoolean(java.lang.String colName)
throws java.sql.SQLException
getBoolean in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic byte getByte(java.lang.String colName)
throws java.sql.SQLException
getByte in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic short getShort(java.lang.String colName)
throws java.sql.SQLException
getShort in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic int getInt(java.lang.String colName)
throws java.sql.SQLException
getInt in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic long getLong(java.lang.String colName)
throws java.sql.SQLException
getLong in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic float getFloat(java.lang.String colName)
throws java.sql.SQLException
getFloat in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic double getDouble(java.lang.String colName)
throws java.sql.SQLException
getDouble in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic byte[] getBytes(java.lang.String colName)
throws java.sql.SQLException
getBytes in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Date getDate(java.lang.String colName)
throws java.sql.SQLException
getDate in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Time getTime(java.lang.String colName)
throws java.sql.SQLException
getTime in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Timestamp getTimestamp(java.lang.String colName)
throws java.sql.SQLException
getTimestamp in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.math.BigDecimal getBigDecimal(java.lang.String colName)
throws java.sql.SQLException
getBigDecimal in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Ref getRef(java.lang.String colName)
throws java.sql.SQLException
getRef in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Blob getBlob(java.lang.String colName)
throws java.sql.SQLException
getBlob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Clob getClob(java.lang.String colName)
throws java.sql.SQLException
getClob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Array getArray(java.lang.String colName)
throws java.sql.SQLException
getArray in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Date getDate(java.lang.String colName,
java.util.Calendar cal)
throws java.sql.SQLException
getDate in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Time getTime(java.lang.String colName,
java.util.Calendar cal)
throws java.sql.SQLException
getTime in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.Timestamp getTimestamp(java.lang.String colName,
java.util.Calendar cal)
throws java.sql.SQLException
getTimestamp in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.net.URL getURL(java.lang.String colName)
throws java.sql.SQLException
getURL in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.io.Reader getCharacterStream(int parameterIndex)
throws java.sql.SQLException
getCharacterStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.io.Reader getCharacterStream(java.lang.String parameterName)
throws java.sql.SQLException
getCharacterStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.io.Reader getNCharacterStream(int parameterIndex)
throws java.sql.SQLException
Implementation note: This method behaves exactly the same as getCharacterStream(int).
getNCharacterStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.io.Reader getNCharacterStream(java.lang.String parameterName)
throws java.sql.SQLException
Implementation note: This method behaves exactly the same as getCharacterStream(String) .
getNCharacterStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.lang.String getNString(int parameterIndex)
throws java.sql.SQLException
Implementation note: This method behaves exactly the same as getString(int).
getNString in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.lang.String getNString(java.lang.String parameterName)
throws java.sql.SQLException
Implementation note: This method behaves exactly the same as getString(String).
getNString in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setAsciiStream(java.lang.String parameterName,
java.io.InputStream x,
long length)
throws java.sql.SQLException
setAsciiStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setAsciiStream(java.lang.String parameterName,
java.io.InputStream x)
throws java.sql.SQLException
setAsciiStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setBinaryStream(java.lang.String parameterName,
java.io.InputStream x,
long length)
throws java.sql.SQLException
setBinaryStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setBinaryStream(java.lang.String parameterName,
java.io.InputStream x)
throws java.sql.SQLException
setBinaryStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setBlob(java.lang.String parameterName,
java.sql.Blob x)
throws java.sql.SQLException
setBlob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setBlob(java.lang.String parameterName,
java.io.InputStream inputStream,
long length)
throws java.sql.SQLException
setBlob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setBlob(java.lang.String parameterName,
java.io.InputStream inputStream)
throws java.sql.SQLException
setBlob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setCharacterStream(java.lang.String parameterName,
java.io.Reader reader,
long length)
throws java.sql.SQLException
setCharacterStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setCharacterStream(java.lang.String parameterName,
java.io.Reader reader)
throws java.sql.SQLException
setCharacterStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setClob(java.lang.String parameterName,
java.sql.Clob x)
throws java.sql.SQLException
setClob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setClob(java.lang.String parameterName,
java.io.Reader reader,
long length)
throws java.sql.SQLException
setClob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setClob(java.lang.String parameterName,
java.io.Reader reader)
throws java.sql.SQLException
setClob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setNCharacterStream(java.lang.String parameterName,
java.io.Reader value,
long length)
throws java.sql.SQLException
Implementation note: This method behaves exactly the same as setCharacterStream(String, Reader, long).
setNCharacterStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setNCharacterStream(java.lang.String parameterName,
java.io.Reader value)
throws java.sql.SQLException
Implementation note: This method behaves exactly the same as setCharacterStream(String, Reader).
setNCharacterStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setNClob(java.lang.String parameterName,
java.io.Reader reader,
long length)
throws java.sql.SQLException
Implementation note: This method behaves exactly the same as setClob(String, Reader, long).
setNClob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setNClob(java.lang.String parameterName,
java.io.Reader reader)
throws java.sql.SQLException
Implementation note: This method behaves exactly the same as setClob(String, Reader).
setNClob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setNString(java.lang.String parameterName,
java.lang.String value)
throws java.sql.SQLException
Implementation note: This method behaves exactly the same as setString(String, String).
setNString in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void registerOutParameter(java.lang.String param1,
int param2)
throws java.sql.SQLException
registerOutParameter in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void registerOutParameter(java.lang.String param1,
int param2,
int param3)
throws java.sql.SQLException
registerOutParameter in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void registerOutParameter(java.lang.String param1,
int param2,
java.lang.String param3)
throws java.sql.SQLException
registerOutParameter in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void registerOutParameter(java.lang.String parameterName,
java.sql.SQLType sqlType)
throws java.sql.SQLException
Implementation note: behaves as registerOutParameter(String, int) called with
SQLType.getVendorTypeNumber().
registerOutParameter in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void registerOutParameter(java.lang.String parameterName,
java.sql.SQLType sqlType,
int scale)
throws java.sql.SQLException
Implementation note: behaves as registerOutParameter(String, int, int) called with
SQLType.getVendorTypeNumber().
registerOutParameter in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void registerOutParameter(java.lang.String parameterName,
java.sql.SQLType sqlType,
java.lang.String typeName)
throws java.sql.SQLException
Implementation note: behaves as registerOutParameter(String, int, String) called with
SQLType.getVendorTypeNumber().
registerOutParameter in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setURL(java.lang.String param1,
java.net.URL param2)
throws java.sql.SQLException
setURL in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setNull(java.lang.String param1,
int param2)
throws java.sql.SQLException
setNull in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setBoolean(java.lang.String param1,
boolean param2)
throws java.sql.SQLException
setBoolean in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setByte(java.lang.String param1,
byte param2)
throws java.sql.SQLException
setByte in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setShort(java.lang.String param1,
short param2)
throws java.sql.SQLException
setShort in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setInt(java.lang.String param1,
int param2)
throws java.sql.SQLException
setInt in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setLong(java.lang.String param1,
long param2)
throws java.sql.SQLException
setLong in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setFloat(java.lang.String param1,
float param2)
throws java.sql.SQLException
setFloat in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setDouble(java.lang.String param1,
double param2)
throws java.sql.SQLException
setDouble in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setBigDecimal(java.lang.String param1,
java.math.BigDecimal param2)
throws java.sql.SQLException
setBigDecimal in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setString(java.lang.String param1,
java.lang.String param2)
throws java.sql.SQLException
setString in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setBytes(java.lang.String param1,
byte[] param2)
throws java.sql.SQLException
setBytes in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setDate(java.lang.String param1,
java.sql.Date param2)
throws java.sql.SQLException
setDate in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setTime(java.lang.String param1,
java.sql.Time param2)
throws java.sql.SQLException
setTime in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setTimestamp(java.lang.String param1,
java.sql.Timestamp param2)
throws java.sql.SQLException
setTimestamp in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setAsciiStream(java.lang.String param1,
java.io.InputStream param2,
int param3)
throws java.sql.SQLException
setAsciiStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setBinaryStream(java.lang.String param1,
java.io.InputStream param2,
int param3)
throws java.sql.SQLException
setBinaryStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setObject(java.lang.String param1,
java.lang.Object param2,
int param3,
int param4)
throws java.sql.SQLException
setObject in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setObject(java.lang.String param1,
java.lang.Object param2,
int param3)
throws java.sql.SQLException
setObject in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setObject(java.lang.String param1,
java.lang.Object param2)
throws java.sql.SQLException
setObject in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setCharacterStream(java.lang.String param1,
java.io.Reader param2,
int param3)
throws java.sql.SQLException
setCharacterStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setDate(java.lang.String param1,
java.sql.Date param2,
java.util.Calendar param3)
throws java.sql.SQLException
setDate in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setTime(java.lang.String param1,
java.sql.Time param2,
java.util.Calendar param3)
throws java.sql.SQLException
setTime in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setTimestamp(java.lang.String param1,
java.sql.Timestamp param2,
java.util.Calendar param3)
throws java.sql.SQLException
setTimestamp in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setNull(java.lang.String param1,
int param2,
java.lang.String param3)
throws java.sql.SQLException
setNull in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void registerOutParameter(int parameterIndex,
int sqlType,
java.lang.String typeName)
throws java.sql.SQLException
registerOutParameter in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.ResultSet getGeneratedKeys()
throws java.sql.SQLException
getGeneratedKeys in interface java.sql.StatementgetGeneratedKeys in class FBStatementjava.sql.SQLExceptionprotected void assertHasData(java.sql.ResultSet rs)
throws java.sql.SQLException
rs - result set to testjava.sql.SQLException - when the result set has no data.public java.sql.ResultSet getCurrentResultSet()
throws java.sql.SQLException
FirebirdStatementStatement.getResultSet(), except that this method
can be called as much as you like.getCurrentResultSet in interface FirebirdStatementgetCurrentResultSet in class FBStatementResultSet representing current result set
or null if it is not available.java.sql.SQLException - if database access error happened.protected java.sql.ResultSet getAndAssertSingletonResultSet()
throws java.sql.SQLException
This should fix the problem described in JDBC-350 in most circumstances.
java.sql.SQLException - For database access errorspublic java.sql.ResultSet getResultSet()
throws java.sql.SQLException
Calling this method twice with autocommit on and used will probably throw an inappropriate or uninformative exception.
getResultSet in interface java.sql.StatementgetResultSet in class FBStatementjava.sql.SQLExceptionpublic void setBigDecimal(int parameterIndex,
java.math.BigDecimal x)
throws java.sql.SQLException
setBigDecimal in interface java.sql.PreparedStatementsetBigDecimal in class FBPreparedStatementjava.sql.SQLExceptionpublic void setBinaryStream(int parameterIndex,
java.io.InputStream inputStream,
int length)
throws java.sql.SQLException
setBinaryStream in interface java.sql.PreparedStatementsetBinaryStream in class FBPreparedStatementjava.sql.SQLExceptionpublic void setBinaryStream(int parameterIndex,
java.io.InputStream inputStream,
long length)
throws java.sql.SQLException
setBinaryStream in interface java.sql.PreparedStatementsetBinaryStream in class FBPreparedStatementjava.sql.SQLExceptionpublic void setBinaryStream(int parameterIndex,
java.io.InputStream inputStream)
throws java.sql.SQLException
setBinaryStream in interface java.sql.PreparedStatementsetBinaryStream in class FBPreparedStatementjava.sql.SQLExceptionpublic void setBlob(int parameterIndex,
java.sql.Blob blob)
throws java.sql.SQLException
setBlob in interface java.sql.PreparedStatementsetBlob in class FBPreparedStatementjava.sql.SQLExceptionpublic void setBlob(int parameterIndex,
java.io.InputStream inputStream,
long length)
throws java.sql.SQLException
setBlob in interface java.sql.PreparedStatementsetBlob in class FBPreparedStatementjava.sql.SQLExceptionpublic void setBlob(int parameterIndex,
java.io.InputStream inputStream)
throws java.sql.SQLException
setBlob in interface java.sql.PreparedStatementsetBlob in class FBPreparedStatementjava.sql.SQLExceptionpublic void setBoolean(int parameterIndex,
boolean x)
throws java.sql.SQLException
setBoolean in interface java.sql.PreparedStatementsetBoolean in class FBPreparedStatementjava.sql.SQLExceptionpublic void setByte(int parameterIndex,
byte x)
throws java.sql.SQLException
setByte in interface java.sql.PreparedStatementsetByte in class FBPreparedStatementjava.sql.SQLExceptionpublic void setBytes(int parameterIndex,
byte[] x)
throws java.sql.SQLException
setBytes in interface java.sql.PreparedStatementsetBytes in class FBPreparedStatementjava.sql.SQLExceptionpublic void setCharacterStream(int parameterIndex,
java.io.Reader reader,
int length)
throws java.sql.SQLException
setCharacterStream in interface java.sql.PreparedStatementsetCharacterStream in class FBPreparedStatementjava.sql.SQLExceptionpublic void setCharacterStream(int parameterIndex,
java.io.Reader reader,
long length)
throws java.sql.SQLException
setCharacterStream in interface java.sql.PreparedStatementsetCharacterStream in class FBPreparedStatementjava.sql.SQLExceptionpublic void setCharacterStream(int parameterIndex,
java.io.Reader reader)
throws java.sql.SQLException
setCharacterStream in interface java.sql.PreparedStatementsetCharacterStream in class FBPreparedStatementjava.sql.SQLExceptionpublic void setClob(int parameterIndex,
java.sql.Clob x)
throws java.sql.SQLException
setClob in interface java.sql.PreparedStatementsetClob in class FBPreparedStatementjava.sql.SQLExceptionpublic void setClob(int parameterIndex,
java.io.Reader reader,
long length)
throws java.sql.SQLException
setClob in interface java.sql.PreparedStatementsetClob in class FBPreparedStatementjava.sql.SQLExceptionpublic void setClob(int parameterIndex,
java.io.Reader reader)
throws java.sql.SQLException
setClob in interface java.sql.PreparedStatementsetClob in class FBPreparedStatementjava.sql.SQLExceptionpublic void setDate(int parameterIndex,
java.sql.Date x,
java.util.Calendar cal)
throws java.sql.SQLException
setDate in interface java.sql.PreparedStatementsetDate in class FBPreparedStatementjava.sql.SQLExceptionpublic void setDate(int parameterIndex,
java.sql.Date x)
throws java.sql.SQLException
setDate in interface java.sql.PreparedStatementsetDate in class FBPreparedStatementjava.sql.SQLExceptionpublic void setDouble(int parameterIndex,
double x)
throws java.sql.SQLException
setDouble in interface java.sql.PreparedStatementsetDouble in class FBPreparedStatementjava.sql.SQLExceptionpublic void setFloat(int parameterIndex,
float x)
throws java.sql.SQLException
setFloat in interface java.sql.PreparedStatementsetFloat in class FBPreparedStatementjava.sql.SQLExceptionpublic void setInt(int parameterIndex,
int x)
throws java.sql.SQLException
setInt in interface java.sql.PreparedStatementsetInt in class FBPreparedStatementjava.sql.SQLExceptionpublic void setLong(int parameterIndex,
long x)
throws java.sql.SQLException
setLong in interface java.sql.PreparedStatementsetLong in class FBPreparedStatementjava.sql.SQLExceptionpublic void setNull(int parameterIndex,
int sqlType,
java.lang.String typeName)
throws java.sql.SQLException
setNull in interface java.sql.PreparedStatementsetNull in class FBPreparedStatementjava.sql.SQLExceptionpublic void setNull(int parameterIndex,
int sqlType)
throws java.sql.SQLException
setNull in interface java.sql.PreparedStatementsetNull in class FBPreparedStatementjava.sql.SQLExceptionpublic void setObject(int parameterIndex,
java.lang.Object x,
int targetSqlType,
int scale)
throws java.sql.SQLException
FBPreparedStatement
Implementation note: ignores scale and targetSqlType and works as
FBPreparedStatement.setObject(int, Object).
setObject in interface java.sql.PreparedStatementsetObject in class FBPreparedStatementjava.sql.SQLExceptionpublic void setObject(int parameterIndex,
java.lang.Object x,
int targetSqlType)
throws java.sql.SQLException
FBPreparedStatement
Implementation note: ignores targetSqlType and works as FBPreparedStatement.setObject(int, Object).
setObject in interface java.sql.PreparedStatementsetObject in class FBPreparedStatementjava.sql.SQLExceptionpublic void setObject(int parameterIndex,
java.lang.Object x)
throws java.sql.SQLException
setObject in interface java.sql.PreparedStatementsetObject in class FBPreparedStatementjava.sql.SQLExceptionpublic void setShort(int parameterIndex,
short x)
throws java.sql.SQLException
setShort in interface java.sql.PreparedStatementsetShort in class FBPreparedStatementjava.sql.SQLExceptionpublic void setString(int parameterIndex,
java.lang.String x)
throws java.sql.SQLException
setString in interface java.sql.PreparedStatementsetString in class FBPreparedStatementjava.sql.SQLExceptionpublic void setTime(int parameterIndex,
java.sql.Time x,
java.util.Calendar cal)
throws java.sql.SQLException
setTime in interface java.sql.PreparedStatementsetTime in class FBPreparedStatementjava.sql.SQLExceptionpublic void setTime(int parameterIndex,
java.sql.Time x)
throws java.sql.SQLException
setTime in interface java.sql.PreparedStatementsetTime in class FBPreparedStatementjava.sql.SQLExceptionpublic void setTimestamp(int parameterIndex,
java.sql.Timestamp x,
java.util.Calendar cal)
throws java.sql.SQLException
setTimestamp in interface java.sql.PreparedStatementsetTimestamp in class FBPreparedStatementjava.sql.SQLExceptionpublic void setTimestamp(int parameterIndex,
java.sql.Timestamp x)
throws java.sql.SQLException
setTimestamp in interface java.sql.PreparedStatementsetTimestamp in class FBPreparedStatementjava.sql.SQLExceptionprotected int findOutParameter(java.lang.String paramName)
throws java.sql.SQLException
paramName - Name of the OUT parameterjava.sql.SQLExceptionpublic java.sql.NClob getNClob(int parameterIndex)
throws java.sql.SQLException
Implementation note: This method behaves exactly the same as getClob(int).
getNClob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.NClob getNClob(java.lang.String parameterName)
throws java.sql.SQLException
Implementation note: This method behaves exactly the same as getClob(String).
getNClob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.RowId getRowId(int parameterIndex)
throws java.sql.SQLException
getRowId in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.RowId getRowId(java.lang.String parameterName)
throws java.sql.SQLException
getRowId in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.SQLXML getSQLXML(int parameterIndex)
throws java.sql.SQLException
getSQLXML in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic java.sql.SQLXML getSQLXML(java.lang.String parameterName)
throws java.sql.SQLException
getSQLXML in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setNClob(java.lang.String parameterName,
java.sql.NClob value)
throws java.sql.SQLException
Implementation note: This method behaves exactly the same as setClob(String, Clob).
setNClob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setRowId(java.lang.String parameterName,
java.sql.RowId x)
throws java.sql.SQLException
setRowId in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setSQLXML(java.lang.String parameterName,
java.sql.SQLXML xmlObject)
throws java.sql.SQLException
setSQLXML in interface java.sql.CallableStatementjava.sql.SQLExceptionCopyright © 2001-2023 Jaybird (Firebird JDBC) team. All rights reserved.