org.firebirdsql.jdbc

Class FBCallableStatement

java.lang.Object

org.firebirdsql.jdbc.AbstractStatement

org.firebirdsql.jdbc.AbstractPreparedStatement

org.firebirdsql.jdbc.FBPreparedStatement

org.firebirdsql.jdbc.AbstractCallableStatement

org.firebirdsql.jdbc.FBCallableStatement

All Implemented Interfaces:

java.lang.AutoCloseable, java.sql.CallableStatement, java.sql.PreparedStatement, java.sql.Statement, java.sql.Wrapper, FirebirdCallableStatement, FirebirdPreparedStatement, FirebirdStatement, Synchronizable

public class FBCallableStatement
extends AbstractCallableStatement

JDBC 4.2 compliant implementation of CallableStatement.

Nested Class Summary

Nested classes/interfaces inherited from class org.firebirdsql.jdbc.AbstractStatement

AbstractStatement.StatementResult

Field Summary

Fields inherited from class org.firebirdsql.jdbc.AbstractCallableStatement

procedureCall, selectableProcedure

Fields inherited from class org.firebirdsql.jdbc.AbstractPreparedStatement

batchList, isParamSet

Fields inherited from class org.firebirdsql.jdbc.AbstractStatement

completed, connection, currentStatementResult, fetchSize, firstWarning, fixedStmt, gdsHelper, maxRows, statementListener

Fields inherited from interface org.firebirdsql.jdbc.FirebirdPreparedStatement

TYPE_COMMIT, TYPE_DDL, TYPE_DELETE, TYPE_EXEC_PROCEDURE, TYPE_GET_SEGMENT, TYPE_INSERT, TYPE_PUT_SEGMENT, TYPE_ROLLBACK, TYPE_SELECT, TYPE_SELECT_FOR_UPDATE, TYPE_SET_GENERATOR, TYPE_START_TRANS, TYPE_UPDATE

Fields inherited from interface java.sql.Statement

CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO

Constructor Summary

Constructors

Constructor and Description
FBCallableStatement(org.firebirdsql.gds.impl.GDSHelper c, java.lang.String sql, int rsType, int rsConcurrency, int rsHoldability, StoredProcedureMetaData storedProcedureMetaData, FBObjectListener.StatementListener statementListener, FBObjectListener.BlobListener blobListener) Create instance of this class.

Method Summary

Modifier and Type	Method and Description
java.sql.NClob	getNClob(int parameterIndex)
java.sql.NClob	getNClob(java.lang.String parameterName)
java.sql.RowId	getRowId(int parameterIndex)
java.sql.RowId	getRowId(java.lang.String parameterName)
java.sql.SQLXML	getSQLXML(int parameterIndex)
java.sql.SQLXML	getSQLXML(java.lang.String parameterName)
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 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	setNClob(java.lang.String parameterName, java.sql.NClob value)
void	setRowId(java.lang.String parameterName, java.sql.RowId x)
void	setSQLXML(java.lang.String parameterName, java.sql.SQLXML xmlObject)

Methods inherited from class org.firebirdsql.jdbc.AbstractCallableStatement

addBatch, equals, execute, executeBatch, executeQuery, executeUpdate, findOutParameter, getAndAssertSingletonResultSet, getArray, getArray, getBigDecimal, getBigDecimal, getBigDecimal, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getCurrentResultSet, getDate, getDate, getDate, getDate, getDouble, getDouble, getFloat, getFloat, getGeneratedKeys, getInt, getInt, getLong, getLong, getMetaData, getNCharacterStream, getNCharacterStream, getNString, getNString, getObject, getObject, getObject, getObject, getObject, getObject, getParameterMetaData, getRef, getRef, getResultSet, getShort, getShort, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getURL, getURL, internalExecute, isSelectableProcedure, prepareFixedStatement, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBlob, setBoolean, setBoolean, setByte, setByte, setBytes, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setClob, setDate, setDate, setDate, setDate, setDouble, setDouble, setFloat, setFloat, setInt, setInt, setLong, setLong, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNString, setNull, setNull, setNull, setNull, setObject, setObject, setObject, setObject, setObject, setObject, setRef, setRequiredTypes, setSelectableProcedure, setShort, setShort, setString, setString, setTime, setTime, setTime, setTime, setTimestamp, setTimestamp, setTimestamp, setTimestamp, setUnicodeStream, setURL, setURL, wasNull

Methods inherited from class org.firebirdsql.jdbc.FBPreparedStatement

executeLargeUpdate, setNClob, setObject, setObject, setRowId, setSQLXML

Methods inherited from class org.firebirdsql.jdbc.AbstractPreparedStatement

addBatch, clearBatch, clearParameters, completeStatement, execute, execute, execute, execute, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getExecutionPlan, getField, getFirebirdParameterMetaData, getStatementType, getXsqlvar, notifyStatementCompleted, setAsciiStream, setAsciiStream, setAsciiStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setCharacterStream, setCharacterStream, setClob, setClob, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNString, setStringForced

Methods inherited from class org.firebirdsql.jdbc.AbstractStatement

addWarning, cancel, checkValidity, clearWarnings, close, closeOnCompletion, completeStatement, finalize, forgetResultSet, getConnection, getDeletedRowsCount, getFetchDirection, getFetchSize, getInsertedRowsCount, getLastExecutionPlan, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getSynchronizationObject, getUpdateCount, getUpdateCountInternal, getUpdatedRowsCount, getWarnings, hashCode, hasOpenResultSet, internalExecute, isClosed, isCloseOnCompletion, isExecuteProcedureStatement, isPoolable, isValid, isWrapperFor, nativeSQL, notifyStatementCompleted, notifyStatementStarted, notifyStatementStarted, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, toArray, unwrap

Methods inherited from class java.lang.Object

clone, getClass, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface org.firebirdsql.jdbc.FirebirdPreparedStatement

getExecutionPlan, getStatementType

Methods inherited from interface org.firebirdsql.jdbc.FirebirdStatement

getDeletedRowsCount, getInsertedRowsCount, getLastExecutionPlan, getUpdatedRowsCount, hasOpenResultSet, isClosed, isValid

Methods inherited from interface java.sql.CallableStatement

setObject, setObject

Methods inherited from interface java.sql.PreparedStatement

clearParameters, executeLargeUpdate, setAsciiStream, setAsciiStream, setAsciiStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setCharacterStream, setCharacterStream, setClob, setClob, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setObject, setObject, setRowId, setSQLXML

Methods inherited from interface java.sql.Statement

addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, execute, execute, execute, execute, 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, isCloseOnCompletion, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout

Methods inherited from interface java.sql.Wrapper

isWrapperFor, unwrap

Constructor Detail

FBCallableStatement

public FBCallableStatement(org.firebirdsql.gds.impl.GDSHelper c,
                           java.lang.String sql,
                           int rsType,
                           int rsConcurrency,
                           int rsHoldability,
                           StoredProcedureMetaData storedProcedureMetaData,
                           FBObjectListener.StatementListener statementListener,
                           FBObjectListener.BlobListener blobListener)
                    throws java.sql.SQLException

Create instance of this class.

Parameters:

c - instance of AbstractConnection

sql - SQL statement containing procedure call.

Throws:

java.sql.SQLException - if SQL error occured.

Method Detail

getNClob

public java.sql.NClob getNClob(int parameterIndex)
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

getNClob

public java.sql.NClob getNClob(java.lang.String parameterName)
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

getRowId

public java.sql.RowId getRowId(int parameterIndex)
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

getRowId

public java.sql.RowId getRowId(java.lang.String parameterName)
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

getSQLXML

public java.sql.SQLXML getSQLXML(int parameterIndex)
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

getSQLXML

public java.sql.SQLXML getSQLXML(java.lang.String parameterName)
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

setNClob

public void setNClob(java.lang.String parameterName,
                     java.sql.NClob value)
              throws java.sql.SQLException

Throws:

java.sql.SQLException

setRowId

public void setRowId(java.lang.String parameterName,
                     java.sql.RowId x)
              throws java.sql.SQLException

Throws:

java.sql.SQLException

setSQLXML

public void setSQLXML(java.lang.String parameterName,
                      java.sql.SQLXML xmlObject)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

registerOutParameter

public void registerOutParameter(int parameterIndex,
                                 java.sql.SQLType sqlType)
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

registerOutParameter

public void registerOutParameter(int parameterIndex,
                                 java.sql.SQLType sqlType,
                                 int scale)
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

registerOutParameter

public void registerOutParameter(int parameterIndex,
                                 java.sql.SQLType sqlType,
                                 java.lang.String typeName)
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

registerOutParameter

public void registerOutParameter(java.lang.String parameterName,
                                 java.sql.SQLType sqlType)
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

registerOutParameter

public void registerOutParameter(java.lang.String parameterName,
                                 java.sql.SQLType sqlType,
                                 int scale)
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

registerOutParameter

public void registerOutParameter(java.lang.String parameterName,
                                 java.sql.SQLType sqlType,
                                 java.lang.String typeName)
                          throws java.sql.SQLException

Throws:

java.sql.SQLException