org.firebirdsql.jdbc

Class FBPreparedStatement

java.lang.Object

org.firebirdsql.jdbc.AbstractStatement

org.firebirdsql.jdbc.AbstractPreparedStatement

org.firebirdsql.jdbc.FBPreparedStatement

All Implemented Interfaces:

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

Direct Known Subclasses:

AbstractCallableStatement

public class FBPreparedStatement
extends AbstractPreparedStatement

JDBC-4.2 implementation of PreparedStatement.

Author:

Roman Rokytskyy

Nested Class Summary

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

AbstractStatement.StatementResult

Field Summary

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
FBPreparedStatement(org.firebirdsql.gds.impl.GDSHelper c, int rsType, int rsConcurrency, int rsHoldability, FBObjectListener.StatementListener statementListener, FBObjectListener.BlobListener blobListener)
FBPreparedStatement(org.firebirdsql.gds.impl.GDSHelper gdsHelper, java.lang.String sql, int rsType, int rsConcurrency, int rsHoldability, FBObjectListener.StatementListener statementListener, FBObjectListener.BlobListener blobListener, boolean metaDataQuery, boolean standaloneStatement, boolean generatedKeys)

Method Summary

Modifier and Type	Method and Description
long	executeLargeUpdate()
void	setNClob(int parameterIndex, java.sql.NClob value)
void	setObject(int parameterIndex, java.lang.Object x, java.sql.SQLType targetSqlType)
void	setObject(int parameterIndex, java.lang.Object x, java.sql.SQLType targetSqlType, int scaleOrLength)
void	setRowId(int parameterIndex, java.sql.RowId x)
void	setSQLXML(int parameterIndex, java.sql.SQLXML xmlObject)

Methods inherited from class org.firebirdsql.jdbc.AbstractPreparedStatement

addBatch, addBatch, clearBatch, clearParameters, completeStatement, equals, execute, execute, execute, execute, execute, executeBatch, executeQuery, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getExecutionPlan, getField, getFirebirdParameterMetaData, getMetaData, getParameterMetaData, getStatementType, getXsqlvar, internalExecute, notifyStatementCompleted, prepareFixedStatement, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNString, setNull, setNull, setObject, setObject, setObject, setRef, setShort, setString, setStringForced, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL

Methods inherited from class org.firebirdsql.jdbc.AbstractStatement

addWarning, cancel, checkValidity, clearWarnings, close, closeOnCompletion, completeStatement, finalize, forgetResultSet, getConnection, getCurrentResultSet, getDeletedRowsCount, getFetchDirection, getFetchSize, getGeneratedKeys, getInsertedRowsCount, getLastExecutionPlan, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, 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.FirebirdStatement

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

Methods inherited from interface java.sql.Statement

cancel, clearWarnings, close, closeOnCompletion, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, 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

FBPreparedStatement

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

Throws:

java.sql.SQLException

FBPreparedStatement

public FBPreparedStatement(org.firebirdsql.gds.impl.GDSHelper gdsHelper,
                           java.lang.String sql,
                           int rsType,
                           int rsConcurrency,
                           int rsHoldability,
                           FBObjectListener.StatementListener statementListener,
                           FBObjectListener.BlobListener blobListener,
                           boolean metaDataQuery,
                           boolean standaloneStatement,
                           boolean generatedKeys)
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

Method Detail

setNClob

public void setNClob(int parameterIndex,
                     java.sql.NClob value)
              throws java.sql.SQLException

Throws:

java.sql.SQLException

setRowId

public void setRowId(int parameterIndex,
                     java.sql.RowId x)
              throws java.sql.SQLException

Throws:

java.sql.SQLException

setSQLXML

public void setSQLXML(int parameterIndex,
                      java.sql.SQLXML xmlObject)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

setObject

public void setObject(int parameterIndex,
                      java.lang.Object x,
                      java.sql.SQLType targetSqlType,
                      int scaleOrLength)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

setObject

public void setObject(int parameterIndex,
                      java.lang.Object x,
                      java.sql.SQLType targetSqlType)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

executeLargeUpdate

public long executeLargeUpdate()
                        throws java.sql.SQLException

Jaybird does not support update counts exceeding Integer.MAX_VALUE, this method calls AbstractPreparedStatement.executeUpdate().

Throws:

java.sql.SQLException