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_SUPPORTED
completed, connection, currentStatementResult, fbStatement, fetchSize, firstWarning, gdsHelper, isSingletonResult, maxRows, specialResult, statementListener
TYPE_COMMIT, TYPE_DDL, TYPE_DELETE, TYPE_EXEC_PROCEDURE, TYPE_GET_SEGMENT, TYPE_INSERT, TYPE_PUT_SEGMENT, TYPE_ROLLBACK, TYPE_SELECT, TYPE_SELECT_FOR_UPDATE, TYPE_SET_GENERATOR, TYPE_START_TRANS, TYPE_UPDATE
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)
Deprecated.
use
getAndAssertSingletonResultSet().findColumn(paramName) (but verify if that is the right
thing to do); method will be removed in Jaybird 6 |
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, setURL
addWarning, 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, withLock
clone, finalize, getClass, notify, notifyAll, toString, wait, wait, wait
getExecutionPlan, getExplainedExecutionPlan, getStatementType
getDeletedRowsCount, getInsertedRowsCount, getLastExecutionPlan, getLastExplainedExecutionPlan, getLocalStatementId, getUpdatedRowsCount, hasOpenResultSet, isValid
clearParameters, executeLargeUpdate, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setObject, setObject, setRef, setRowId, setSQLXML, setUnicodeStream, setURL
addBatch, 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, setQueryTimeout
protected 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.SQLException
public java.sql.ParameterMetaData getParameterMetaData() throws java.sql.SQLException
getParameterMetaData
in interface java.sql.PreparedStatement
getParameterMetaData
in class FBPreparedStatement
java.sql.SQLException
public void addBatch() throws java.sql.SQLException
addBatch
in interface java.sql.PreparedStatement
addBatch
in class FBPreparedStatement
java.sql.SQLException
public void clearBatch() throws java.sql.SQLException
clearBatch
in interface java.sql.Statement
clearBatch
in class FBPreparedStatement
java.sql.SQLException
protected java.util.List<java.lang.Long> executeBatchInternal() throws java.sql.SQLException
executeBatchInternal
in class FBPreparedStatement
java.sql.SQLException
public void setSelectableProcedure(boolean selectableProcedure)
FirebirdCallableStatement
setSelectableProcedure
in interface FirebirdCallableStatement
selectableProcedure
- true
if the called procedure is selectable.FirebirdCallableStatement.isSelectableProcedure()
public boolean isSelectableProcedure()
FirebirdCallableStatement
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.
isSelectableProcedure
in interface FirebirdCallableStatement
true
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 FBPreparedStatement
java.sql.SQLException
public 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.PreparedStatement
getMetaData
in class FBPreparedStatement
java.sql.SQLException
public boolean execute() throws java.sql.SQLException
execute
in interface java.sql.PreparedStatement
execute
in class FBPreparedStatement
java.sql.SQLException
public java.sql.ResultSet executeQuery() throws java.sql.SQLException
executeQuery
in interface java.sql.PreparedStatement
executeQuery
in class FBPreparedStatement
java.sql.SQLException
public int executeUpdate() throws java.sql.SQLException
executeUpdate
in interface java.sql.PreparedStatement
executeUpdate
in class FBPreparedStatement
java.sql.SQLException
protected boolean internalExecute(boolean sendOutParams) throws java.sql.SQLException
FBPreparedStatement
internalExecute
in class FBPreparedStatement
sendOutParams
- Determines if the XSQLDA structure should be sent to the
databasetrue
if the statement has more result sets.java.sql.SQLException
protected FBResultSet createSpecialResultSet(FBObjectListener.ResultSetListener resultSetListener) throws java.sql.SQLException
FBStatement
specialResult
.
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 FBStatement
resultSetListener
- result set listener (can be null
)specialResult
java.sql.SQLException
public void registerOutParameter(int parameterIndex, int sqlType) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
public 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.CallableStatement
java.sql.SQLException
public 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.CallableStatement
java.sql.SQLException
public 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.CallableStatement
java.sql.SQLException
public 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.CallableStatement
java.sql.SQLException
public boolean wasNull() throws java.sql.SQLException
wasNull
in interface java.sql.CallableStatement
java.sql.SQLException
public java.lang.String getString(int parameterIndex) throws java.sql.SQLException
getString
in interface java.sql.CallableStatement
java.sql.SQLException
public boolean getBoolean(int parameterIndex) throws java.sql.SQLException
getBoolean
in interface java.sql.CallableStatement
java.sql.SQLException
public byte getByte(int parameterIndex) throws java.sql.SQLException
getByte
in interface java.sql.CallableStatement
java.sql.SQLException
public short getShort(int parameterIndex) throws java.sql.SQLException
getShort
in interface java.sql.CallableStatement
java.sql.SQLException
public int getInt(int parameterIndex) throws java.sql.SQLException
getInt
in interface java.sql.CallableStatement
java.sql.SQLException
public long getLong(int parameterIndex) throws java.sql.SQLException
getLong
in interface java.sql.CallableStatement
java.sql.SQLException
public float getFloat(int parameterIndex) throws java.sql.SQLException
getFloat
in interface java.sql.CallableStatement
java.sql.SQLException
public double getDouble(int parameterIndex) throws java.sql.SQLException
getDouble
in interface java.sql.CallableStatement
java.sql.SQLException
@Deprecated public java.math.BigDecimal getBigDecimal(int parameterIndex, int scale) throws java.sql.SQLException
getBigDecimal
in interface java.sql.CallableStatement
java.sql.SQLException
public byte[] getBytes(int parameterIndex) throws java.sql.SQLException
getBytes
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Date getDate(int parameterIndex) throws java.sql.SQLException
getDate
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Time getTime(int parameterIndex) throws java.sql.SQLException
getTime
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Timestamp getTimestamp(int parameterIndex) throws java.sql.SQLException
getTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
public 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.CallableStatement
java.sql.SQLException
public 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.CallableStatement
java.sql.SQLException
public 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.CallableStatement
java.sql.SQLException
public 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.CallableStatement
java.sql.SQLException
public <T> T getObject(int parameterIndex, java.lang.Class<T> type) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
java.sql.SQLException
public <T> T getObject(java.lang.String parameterName, java.lang.Class<T> type) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
java.sql.SQLException
public java.math.BigDecimal getBigDecimal(int parameterIndex) throws java.sql.SQLException
getBigDecimal
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Ref getRef(int parameterIndex) throws java.sql.SQLException
getRef
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Blob getBlob(int parameterIndex) throws java.sql.SQLException
getBlob
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Clob getClob(int parameterIndex) throws java.sql.SQLException
getClob
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Array getArray(int parameterIndex) throws java.sql.SQLException
getArray
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Date getDate(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
getDate
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Time getTime(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
getTime
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Timestamp getTimestamp(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
getTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
public java.net.URL getURL(int parameterIndex) throws java.sql.SQLException
getURL
in interface java.sql.CallableStatement
java.sql.SQLException
public java.lang.String getString(java.lang.String colName) throws java.sql.SQLException
getString
in interface java.sql.CallableStatement
java.sql.SQLException
public boolean getBoolean(java.lang.String colName) throws java.sql.SQLException
getBoolean
in interface java.sql.CallableStatement
java.sql.SQLException
public byte getByte(java.lang.String colName) throws java.sql.SQLException
getByte
in interface java.sql.CallableStatement
java.sql.SQLException
public short getShort(java.lang.String colName) throws java.sql.SQLException
getShort
in interface java.sql.CallableStatement
java.sql.SQLException
public int getInt(java.lang.String colName) throws java.sql.SQLException
getInt
in interface java.sql.CallableStatement
java.sql.SQLException
public long getLong(java.lang.String colName) throws java.sql.SQLException
getLong
in interface java.sql.CallableStatement
java.sql.SQLException
public float getFloat(java.lang.String colName) throws java.sql.SQLException
getFloat
in interface java.sql.CallableStatement
java.sql.SQLException
public double getDouble(java.lang.String colName) throws java.sql.SQLException
getDouble
in interface java.sql.CallableStatement
java.sql.SQLException
public byte[] getBytes(java.lang.String colName) throws java.sql.SQLException
getBytes
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Date getDate(java.lang.String colName) throws java.sql.SQLException
getDate
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Time getTime(java.lang.String colName) throws java.sql.SQLException
getTime
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Timestamp getTimestamp(java.lang.String colName) throws java.sql.SQLException
getTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
public java.math.BigDecimal getBigDecimal(java.lang.String colName) throws java.sql.SQLException
getBigDecimal
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Ref getRef(java.lang.String colName) throws java.sql.SQLException
getRef
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Blob getBlob(java.lang.String colName) throws java.sql.SQLException
getBlob
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Clob getClob(java.lang.String colName) throws java.sql.SQLException
getClob
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Array getArray(java.lang.String colName) throws java.sql.SQLException
getArray
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Date getDate(java.lang.String colName, java.util.Calendar cal) throws java.sql.SQLException
getDate
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Time getTime(java.lang.String colName, java.util.Calendar cal) throws java.sql.SQLException
getTime
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Timestamp getTimestamp(java.lang.String colName, java.util.Calendar cal) throws java.sql.SQLException
getTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
public java.net.URL getURL(java.lang.String colName) throws java.sql.SQLException
getURL
in interface java.sql.CallableStatement
java.sql.SQLException
public java.io.Reader getCharacterStream(int parameterIndex) throws java.sql.SQLException
getCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public java.io.Reader getCharacterStream(java.lang.String parameterName) throws java.sql.SQLException
getCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public 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.CallableStatement
java.sql.SQLException
public 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.CallableStatement
java.sql.SQLException
public 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.CallableStatement
java.sql.SQLException
public 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.CallableStatement
java.sql.SQLException
public void setAsciiStream(java.lang.String parameterName, java.io.InputStream x, long length) throws java.sql.SQLException
setAsciiStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setAsciiStream(java.lang.String parameterName, java.io.InputStream x) throws java.sql.SQLException
setAsciiStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBinaryStream(java.lang.String parameterName, java.io.InputStream x, long length) throws java.sql.SQLException
setBinaryStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBinaryStream(java.lang.String parameterName, java.io.InputStream x) throws java.sql.SQLException
setBinaryStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBlob(java.lang.String parameterName, java.sql.Blob x) throws java.sql.SQLException
setBlob
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBlob(java.lang.String parameterName, java.io.InputStream inputStream, long length) throws java.sql.SQLException
setBlob
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBlob(java.lang.String parameterName, java.io.InputStream inputStream) throws java.sql.SQLException
setBlob
in interface java.sql.CallableStatement
java.sql.SQLException
public void setCharacterStream(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException
setCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setCharacterStream(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
setCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setClob(java.lang.String parameterName, java.sql.Clob x) throws java.sql.SQLException
setClob
in interface java.sql.CallableStatement
java.sql.SQLException
public void setClob(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException
setClob
in interface java.sql.CallableStatement
java.sql.SQLException
public void setClob(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
setClob
in interface java.sql.CallableStatement
java.sql.SQLException
public 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.CallableStatement
java.sql.SQLException
public 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.CallableStatement
java.sql.SQLException
public 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.CallableStatement
java.sql.SQLException
public 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.CallableStatement
java.sql.SQLException
public 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.CallableStatement
java.sql.SQLException
public void registerOutParameter(java.lang.String param1, int param2) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
public void registerOutParameter(java.lang.String param1, int param2, int param3) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
public void registerOutParameter(java.lang.String param1, int param2, java.lang.String param3) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
public 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.CallableStatement
java.sql.SQLException
public 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.CallableStatement
java.sql.SQLException
public 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.CallableStatement
java.sql.SQLException
public void setURL(java.lang.String param1, java.net.URL param2) throws java.sql.SQLException
setURL
in interface java.sql.CallableStatement
java.sql.SQLException
public void setNull(java.lang.String param1, int param2) throws java.sql.SQLException
setNull
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBoolean(java.lang.String param1, boolean param2) throws java.sql.SQLException
setBoolean
in interface java.sql.CallableStatement
java.sql.SQLException
public void setByte(java.lang.String param1, byte param2) throws java.sql.SQLException
setByte
in interface java.sql.CallableStatement
java.sql.SQLException
public void setShort(java.lang.String param1, short param2) throws java.sql.SQLException
setShort
in interface java.sql.CallableStatement
java.sql.SQLException
public void setInt(java.lang.String param1, int param2) throws java.sql.SQLException
setInt
in interface java.sql.CallableStatement
java.sql.SQLException
public void setLong(java.lang.String param1, long param2) throws java.sql.SQLException
setLong
in interface java.sql.CallableStatement
java.sql.SQLException
public void setFloat(java.lang.String param1, float param2) throws java.sql.SQLException
setFloat
in interface java.sql.CallableStatement
java.sql.SQLException
public void setDouble(java.lang.String param1, double param2) throws java.sql.SQLException
setDouble
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBigDecimal(java.lang.String param1, java.math.BigDecimal param2) throws java.sql.SQLException
setBigDecimal
in interface java.sql.CallableStatement
java.sql.SQLException
public void setString(java.lang.String param1, java.lang.String param2) throws java.sql.SQLException
setString
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBytes(java.lang.String param1, byte[] param2) throws java.sql.SQLException
setBytes
in interface java.sql.CallableStatement
java.sql.SQLException
public void setDate(java.lang.String param1, java.sql.Date param2) throws java.sql.SQLException
setDate
in interface java.sql.CallableStatement
java.sql.SQLException
public void setTime(java.lang.String param1, java.sql.Time param2) throws java.sql.SQLException
setTime
in interface java.sql.CallableStatement
java.sql.SQLException
public void setTimestamp(java.lang.String param1, java.sql.Timestamp param2) throws java.sql.SQLException
setTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
public void setAsciiStream(java.lang.String param1, java.io.InputStream param2, int param3) throws java.sql.SQLException
setAsciiStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBinaryStream(java.lang.String param1, java.io.InputStream param2, int param3) throws java.sql.SQLException
setBinaryStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setObject(java.lang.String param1, java.lang.Object param2, int param3, int param4) throws java.sql.SQLException
setObject
in interface java.sql.CallableStatement
java.sql.SQLException
public void setObject(java.lang.String param1, java.lang.Object param2, int param3) throws java.sql.SQLException
setObject
in interface java.sql.CallableStatement
java.sql.SQLException
public void setObject(java.lang.String param1, java.lang.Object param2) throws java.sql.SQLException
setObject
in interface java.sql.CallableStatement
java.sql.SQLException
public void setCharacterStream(java.lang.String param1, java.io.Reader param2, int param3) throws java.sql.SQLException
setCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setDate(java.lang.String param1, java.sql.Date param2, java.util.Calendar param3) throws java.sql.SQLException
setDate
in interface java.sql.CallableStatement
java.sql.SQLException
public void setTime(java.lang.String param1, java.sql.Time param2, java.util.Calendar param3) throws java.sql.SQLException
setTime
in interface java.sql.CallableStatement
java.sql.SQLException
public void setTimestamp(java.lang.String param1, java.sql.Timestamp param2, java.util.Calendar param3) throws java.sql.SQLException
setTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
public void setNull(java.lang.String param1, int param2, java.lang.String param3) throws java.sql.SQLException
setNull
in interface java.sql.CallableStatement
java.sql.SQLException
public void registerOutParameter(int parameterIndex, int sqlType, java.lang.String typeName) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.ResultSet getGeneratedKeys() throws java.sql.SQLException
getGeneratedKeys
in interface java.sql.Statement
getGeneratedKeys
in class FBStatement
java.sql.SQLException
protected 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
FirebirdStatement
Statement.getResultSet()
, except that this method
can be called as much as you like.getCurrentResultSet
in interface FirebirdStatement
getCurrentResultSet
in class FBStatement
ResultSet
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.Statement
getResultSet
in class FBStatement
java.sql.SQLException
public void setBigDecimal(int parameterIndex, java.math.BigDecimal x) throws java.sql.SQLException
setBigDecimal
in interface java.sql.PreparedStatement
setBigDecimal
in class FBPreparedStatement
java.sql.SQLException
public void setBinaryStream(int parameterIndex, java.io.InputStream inputStream, int length) throws java.sql.SQLException
setBinaryStream
in interface java.sql.PreparedStatement
setBinaryStream
in class FBPreparedStatement
java.sql.SQLException
public void setBinaryStream(int parameterIndex, java.io.InputStream inputStream, long length) throws java.sql.SQLException
setBinaryStream
in interface java.sql.PreparedStatement
setBinaryStream
in class FBPreparedStatement
java.sql.SQLException
public void setBinaryStream(int parameterIndex, java.io.InputStream inputStream) throws java.sql.SQLException
setBinaryStream
in interface java.sql.PreparedStatement
setBinaryStream
in class FBPreparedStatement
java.sql.SQLException
public void setBlob(int parameterIndex, java.sql.Blob blob) throws java.sql.SQLException
setBlob
in interface java.sql.PreparedStatement
setBlob
in class FBPreparedStatement
java.sql.SQLException
public void setBlob(int parameterIndex, java.io.InputStream inputStream, long length) throws java.sql.SQLException
setBlob
in interface java.sql.PreparedStatement
setBlob
in class FBPreparedStatement
java.sql.SQLException
public void setBlob(int parameterIndex, java.io.InputStream inputStream) throws java.sql.SQLException
setBlob
in interface java.sql.PreparedStatement
setBlob
in class FBPreparedStatement
java.sql.SQLException
public void setBoolean(int parameterIndex, boolean x) throws java.sql.SQLException
setBoolean
in interface java.sql.PreparedStatement
setBoolean
in class FBPreparedStatement
java.sql.SQLException
public void setByte(int parameterIndex, byte x) throws java.sql.SQLException
setByte
in interface java.sql.PreparedStatement
setByte
in class FBPreparedStatement
java.sql.SQLException
public void setBytes(int parameterIndex, byte[] x) throws java.sql.SQLException
setBytes
in interface java.sql.PreparedStatement
setBytes
in class FBPreparedStatement
java.sql.SQLException
public void setCharacterStream(int parameterIndex, java.io.Reader reader, int length) throws java.sql.SQLException
setCharacterStream
in interface java.sql.PreparedStatement
setCharacterStream
in class FBPreparedStatement
java.sql.SQLException
public void setCharacterStream(int parameterIndex, java.io.Reader reader, long length) throws java.sql.SQLException
setCharacterStream
in interface java.sql.PreparedStatement
setCharacterStream
in class FBPreparedStatement
java.sql.SQLException
public void setCharacterStream(int parameterIndex, java.io.Reader reader) throws java.sql.SQLException
setCharacterStream
in interface java.sql.PreparedStatement
setCharacterStream
in class FBPreparedStatement
java.sql.SQLException
public void setClob(int parameterIndex, java.sql.Clob x) throws java.sql.SQLException
setClob
in interface java.sql.PreparedStatement
setClob
in class FBPreparedStatement
java.sql.SQLException
public void setClob(int parameterIndex, java.io.Reader reader, long length) throws java.sql.SQLException
setClob
in interface java.sql.PreparedStatement
setClob
in class FBPreparedStatement
java.sql.SQLException
public void setClob(int parameterIndex, java.io.Reader reader) throws java.sql.SQLException
setClob
in interface java.sql.PreparedStatement
setClob
in class FBPreparedStatement
java.sql.SQLException
public void setDate(int parameterIndex, java.sql.Date x, java.util.Calendar cal) throws java.sql.SQLException
setDate
in interface java.sql.PreparedStatement
setDate
in class FBPreparedStatement
java.sql.SQLException
public void setDate(int parameterIndex, java.sql.Date x) throws java.sql.SQLException
setDate
in interface java.sql.PreparedStatement
setDate
in class FBPreparedStatement
java.sql.SQLException
public void setDouble(int parameterIndex, double x) throws java.sql.SQLException
setDouble
in interface java.sql.PreparedStatement
setDouble
in class FBPreparedStatement
java.sql.SQLException
public void setFloat(int parameterIndex, float x) throws java.sql.SQLException
setFloat
in interface java.sql.PreparedStatement
setFloat
in class FBPreparedStatement
java.sql.SQLException
public void setInt(int parameterIndex, int x) throws java.sql.SQLException
setInt
in interface java.sql.PreparedStatement
setInt
in class FBPreparedStatement
java.sql.SQLException
public void setLong(int parameterIndex, long x) throws java.sql.SQLException
setLong
in interface java.sql.PreparedStatement
setLong
in class FBPreparedStatement
java.sql.SQLException
public void setNull(int parameterIndex, int sqlType, java.lang.String typeName) throws java.sql.SQLException
setNull
in interface java.sql.PreparedStatement
setNull
in class FBPreparedStatement
java.sql.SQLException
public void setNull(int parameterIndex, int sqlType) throws java.sql.SQLException
setNull
in interface java.sql.PreparedStatement
setNull
in class FBPreparedStatement
java.sql.SQLException
public 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.PreparedStatement
setObject
in class FBPreparedStatement
java.sql.SQLException
public 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.PreparedStatement
setObject
in class FBPreparedStatement
java.sql.SQLException
public void setObject(int parameterIndex, java.lang.Object x) throws java.sql.SQLException
setObject
in interface java.sql.PreparedStatement
setObject
in class FBPreparedStatement
java.sql.SQLException
public void setShort(int parameterIndex, short x) throws java.sql.SQLException
setShort
in interface java.sql.PreparedStatement
setShort
in class FBPreparedStatement
java.sql.SQLException
public void setString(int parameterIndex, java.lang.String x) throws java.sql.SQLException
setString
in interface java.sql.PreparedStatement
setString
in class FBPreparedStatement
java.sql.SQLException
public void setTime(int parameterIndex, java.sql.Time x, java.util.Calendar cal) throws java.sql.SQLException
setTime
in interface java.sql.PreparedStatement
setTime
in class FBPreparedStatement
java.sql.SQLException
public void setTime(int parameterIndex, java.sql.Time x) throws java.sql.SQLException
setTime
in interface java.sql.PreparedStatement
setTime
in class FBPreparedStatement
java.sql.SQLException
public void setTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar cal) throws java.sql.SQLException
setTimestamp
in interface java.sql.PreparedStatement
setTimestamp
in class FBPreparedStatement
java.sql.SQLException
public void setTimestamp(int parameterIndex, java.sql.Timestamp x) throws java.sql.SQLException
setTimestamp
in interface java.sql.PreparedStatement
setTimestamp
in class FBPreparedStatement
java.sql.SQLException
@Deprecated protected int findOutParameter(java.lang.String paramName) throws java.sql.SQLException
getAndAssertSingletonResultSet().findColumn(paramName)
(but verify if that is the right
thing to do); method will be removed in Jaybird 6paramName
- name of the OUT parameterjava.sql.SQLException
public 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.CallableStatement
java.sql.SQLException
public 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.CallableStatement
java.sql.SQLException
public java.sql.RowId getRowId(int parameterIndex) throws java.sql.SQLException
getRowId
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.RowId getRowId(java.lang.String parameterName) throws java.sql.SQLException
getRowId
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.SQLXML getSQLXML(int parameterIndex) throws java.sql.SQLException
getSQLXML
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.SQLXML getSQLXML(java.lang.String parameterName) throws java.sql.SQLException
getSQLXML
in interface java.sql.CallableStatement
java.sql.SQLException
public 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.CallableStatement
java.sql.SQLException
public void setRowId(java.lang.String parameterName, java.sql.RowId x) throws java.sql.SQLException
setRowId
in interface java.sql.CallableStatement
java.sql.SQLException
public void setSQLXML(java.lang.String parameterName, java.sql.SQLXML xmlObject) throws java.sql.SQLException
setSQLXML
in interface java.sql.CallableStatement
java.sql.SQLException
Copyright © 2001-2023 Jaybird (Firebird JDBC) team. All rights reserved.