Class FBPreparedStatement
- java.lang.Object
- 
- org.firebirdsql.jdbc.FBStatement
- 
- org.firebirdsql.jdbc.FBPreparedStatement
 
 
- 
- All Implemented Interfaces:
- java.lang.AutoCloseable,- java.sql.PreparedStatement,- java.sql.Statement,- java.sql.Wrapper,- FirebirdPreparedStatement,- FirebirdStatement
 - Direct Known Subclasses:
- FBCallableStatement
 
 public class FBPreparedStatement extends FBStatement implements FirebirdPreparedStatement Implementation ofPreparedStatement.- Author:
- David Jencks, Roman Rokytskyy, Mark Rotteveel
 
- 
- 
Nested Class Summary- 
Nested classes/interfaces inherited from class org.firebirdsql.jdbc.FBStatementFBStatement.StatementResult
 
- 
 - 
Field SummaryFields Modifier and Type Field Description static java.lang.StringMETHOD_NOT_SUPPORTED- 
Fields inherited from class org.firebirdsql.jdbc.FBStatementconnection, currentStatementResult, fbStatement, fetchSize, firstWarning, gdsHelper, isSingletonResult, maxRows, specialResult, statementListener
 - 
Fields inherited from interface org.firebirdsql.jdbc.FirebirdPreparedStatementTYPE_COMMIT, TYPE_DDL, TYPE_DELETE, TYPE_EXEC_PROCEDURE, TYPE_GET_SEGMENT, TYPE_INSERT, TYPE_PUT_SEGMENT, TYPE_ROLLBACK, TYPE_SELECT, TYPE_SELECT_FOR_UPDATE, TYPE_SET_GENERATOR, TYPE_START_TRANS, TYPE_UPDATE
 
- 
 - 
Constructor SummaryConstructors Modifier Constructor Description protectedFBPreparedStatement(GDSHelper c, int rsType, int rsConcurrency, int rsHoldability, FBObjectListener.StatementListener statementListener, FBObjectListener.BlobListener blobListener)Create instance of this class for the specified result set type and concurrency.protectedFBPreparedStatement(GDSHelper c, java.lang.String sql, int rsType, int rsConcurrency, int rsHoldability, FBObjectListener.StatementListener statementListener, FBObjectListener.BlobListener blobListener, boolean metaDataQuery, boolean standaloneStatement, boolean generatedKeys)Create instance of this class and prepare SQL statement.
 - 
Method SummaryAll Methods Instance Methods Concrete Methods Deprecated Methods Modifier and Type Method Description voidaddBatch()voidaddBatch(java.lang.String sql)voidclearBatch()voidclearParameters()voidcompleteStatement(CompletionReason reason)booleanexecute()booleanexecute(java.lang.String sql)booleanexecute(java.lang.String sql, int autoGeneratedKeys)booleanexecute(java.lang.String sql, int[] columnIndexes)booleanexecute(java.lang.String sql, java.lang.String[] columnNames)protected java.util.List<java.lang.Long>executeBatchInternal()longexecuteLargeUpdate()java.sql.ResultSetexecuteQuery()java.sql.ResultSetexecuteQuery(java.lang.String sql)intexecuteUpdate()intexecuteUpdate(java.lang.String sql)intexecuteUpdate(java.lang.String sql, int autoGeneratedKeys)intexecuteUpdate(java.lang.String sql, int[] columnIndex)intexecuteUpdate(java.lang.String sql, java.lang.String[] columnNames)java.lang.StringgetExecutionPlan()Get the execution plan of this PreparedStatementjava.lang.StringgetExplainedExecutionPlan()Get the detailed execution plan of this PreparedStatementprotected FBFieldgetField(int columnIndex)Factory method for the field access objectsFirebirdParameterMetaDatagetFirebirdParameterMetaData()java.sql.ResultSetMetaDatagetMetaData()protected FieldDescriptorgetParameterDescriptor(int columnIndex)Returns theFieldDescriptorof the specified parameter.java.sql.ParameterMetaDatagetParameterMetaData()intgetStatementType()Get the statement type of this PreparedStatement.protected booleaninternalExecute(boolean sendOutParams)Execute this statement.protected booleanisGeneratedKeyQuery()protected booleanneedsScrollableCursorEnabled()protected voidnotifyStatementCompleted(boolean success)Notifies statement completion.protected voidprepareFixedStatement(java.lang.String sql)Prepare fixed statement and initialize parameters.voidsetArray(int i, java.sql.Array x)voidsetAsciiStream(int parameterIndex, java.io.InputStream x)voidsetAsciiStream(int parameterIndex, java.io.InputStream x, int length)voidsetAsciiStream(int parameterIndex, java.io.InputStream x, long length)voidsetBigDecimal(int parameterIndex, java.math.BigDecimal x)voidsetBinaryStream(int parameterIndex, java.io.InputStream inputStream)voidsetBinaryStream(int parameterIndex, java.io.InputStream inputStream, int length)voidsetBinaryStream(int parameterIndex, java.io.InputStream inputStream, long length)voidsetBlob(int parameterIndex, java.io.InputStream inputStream)voidsetBlob(int parameterIndex, java.io.InputStream inputStream, long length)voidsetBlob(int parameterIndex, java.sql.Blob blob)voidsetBoolean(int parameterIndex, boolean x)voidsetByte(int parameterIndex, byte x)voidsetBytes(int parameterIndex, byte[] x)voidsetCharacterStream(int parameterIndex, java.io.Reader reader)voidsetCharacterStream(int parameterIndex, java.io.Reader reader, int length)voidsetCharacterStream(int parameterIndex, java.io.Reader reader, long length)voidsetClob(int parameterIndex, java.io.Reader reader)voidsetClob(int parameterIndex, java.io.Reader reader, long length)voidsetClob(int parameterIndex, java.sql.Clob clob)voidsetDate(int parameterIndex, java.sql.Date x)voidsetDate(int parameterIndex, java.sql.Date x, java.util.Calendar cal)voidsetDouble(int parameterIndex, double x)voidsetFloat(int parameterIndex, float x)voidsetInt(int parameterIndex, int x)voidsetLong(int parameterIndex, long x)voidsetNCharacterStream(int parameterIndex, java.io.Reader value)voidsetNCharacterStream(int parameterIndex, java.io.Reader value, long length)voidsetNClob(int parameterIndex, java.io.Reader reader)voidsetNClob(int parameterIndex, java.io.Reader reader, long length)voidsetNClob(int parameterIndex, java.sql.NClob value)voidsetNString(int parameterIndex, java.lang.String value)voidsetNull(int parameterIndex, int sqlType)voidsetNull(int parameterIndex, int sqlType, java.lang.String typeName)voidsetObject(int parameterIndex, java.lang.Object x)voidsetObject(int parameterIndex, java.lang.Object x, int targetSqlType)voidsetObject(int parameterIndex, java.lang.Object x, int targetSqlType, int scale)voidsetObject(int parameterIndex, java.lang.Object x, java.sql.SQLType targetSqlType)voidsetObject(int parameterIndex, java.lang.Object x, java.sql.SQLType targetSqlType, int scaleOrLength)voidsetRef(int i, java.sql.Ref x)voidsetRowId(int parameterIndex, java.sql.RowId x)voidsetShort(int parameterIndex, short x)voidsetSQLXML(int parameterIndex, java.sql.SQLXML xmlObject)voidsetString(int parameterIndex, java.lang.String x)voidsetTime(int parameterIndex, java.sql.Time x)voidsetTime(int parameterIndex, java.sql.Time x, java.util.Calendar cal)voidsetTimestamp(int parameterIndex, java.sql.Timestamp x)voidsetTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar cal)voidsetUnicodeStream(int parameterIndex, java.io.InputStream x, int length)Deprecated.voidsetURL(int parameterIndex, java.net.URL url)- 
Methods inherited from class org.firebirdsql.jdbc.FBStatementaddWarning, cancel, checkValidity, clearWarnings, close, closeOnCompletion, completeStatement, createBatchUpdateException, createBatchUpdateException, createSpecialResultSet, createStatementListener, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, equals, executeBatch, executeImpl, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, getConnection, getCurrentResultSet, getDeletedRowsCount, getFetchDirection, getFetchSize, getGeneratedKeys, getInsertedRowsCount, getLargeMaxRows, getLargeUpdateCount, getLargeUpdateCountMinZero, getLastExecutionPlan, getLastExplainedExecutionPlan, getLocalStatementId, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, 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
 - 
Methods inherited from class java.lang.Objectclone, finalize, getClass, notify, notifyAll, toString, wait, wait, wait
 - 
Methods inherited from interface org.firebirdsql.jdbc.FirebirdStatementgetCurrentResultSet, getDeletedRowsCount, getInsertedRowsCount, getLastExecutionPlan, getLastExplainedExecutionPlan, getLocalStatementId, getUpdatedRowsCount, hasOpenResultSet, isValid
 - 
Methods inherited from interface java.sql.Statementcancel, clearWarnings, close, closeOnCompletion, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, executeBatch, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isSimpleIdentifier, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout
 
- 
 
- 
- 
- 
Field Detail- 
METHOD_NOT_SUPPORTEDpublic static final java.lang.String METHOD_NOT_SUPPORTED - See Also:
- Constant Field Values
 
 
- 
 - 
Constructor Detail- 
FBPreparedStatementprotected FBPreparedStatement(GDSHelper c, int rsType, int rsConcurrency, int rsHoldability, FBObjectListener.StatementListener statementListener, FBObjectListener.BlobListener blobListener) throws java.sql.SQLException Create instance of this class for the specified result set type and concurrency. This constructor is used only inFBCallableStatementsince the statement is prepared right before the execution.- Parameters:
- c- instance of- GDSHelperthat will be used to perform all database activities.
- rsType- desired result set type.
- rsConcurrency- desired result set concurrency.
- statementListener- statement listener that will be notified about the statement start, close and completion.
- Throws:
- java.sql.SQLException- if something went wrong.
 
 - 
FBPreparedStatementprotected FBPreparedStatement(GDSHelper c, 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 Create instance of this class and prepare SQL statement.- Parameters:
- c- connection to be used.
- sql- SQL statement to prepare.
- rsType- type of result set to create.
- rsConcurrency- result set concurrency.
- Throws:
- java.sql.SQLException- if something went wrong.
 
 
- 
 - 
Method Detail- 
completeStatementpublic void completeStatement(CompletionReason reason) throws java.sql.SQLException - Overrides:
- completeStatementin class- FBStatement
- Throws:
- java.sql.SQLException
 
 - 
notifyStatementCompletedprotected void notifyStatementCompleted(boolean success) throws java.sql.SQLExceptionDescription copied from class:FBStatementNotifies statement completion.Use of success = falseshould not be generally used for failing execution. The only difference betweentrueandfalseis whether completion triggers commit or rollback in auto-commit mode, and in general, even for failed execution, a commit should be triggered. The only exception is for batch execution in auto-commit, where we rollback if one statement failed (and this behaviour is specified by JDBC as implementation-specific), and ending a transaction if statement preparation failed inFBPreparedStatement.- Overrides:
- notifyStatementCompletedin class- FBStatement
- Parameters:
- success-- truenotify successful completion,- falsefor unsuccessful completion
- Throws:
- java.sql.SQLException- exception from handling statement completion (e.g. commit or rollback in auto-commit)
 
 - 
needsScrollableCursorEnabledprotected boolean needsScrollableCursorEnabled() - Overrides:
- needsScrollableCursorEnabledin class- FBStatement
 
 - 
executeQuerypublic java.sql.ResultSet executeQuery() throws java.sql.SQLException- Specified by:
- executeQueryin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
executeUpdatepublic int executeUpdate() throws java.sql.SQLException- Specified by:
- executeUpdatein interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
getFirebirdParameterMetaDatapublic FirebirdParameterMetaData getFirebirdParameterMetaData() throws java.sql.SQLException - Throws:
- java.sql.SQLException
 
 - 
setNullpublic void setNull(int parameterIndex, int sqlType) throws java.sql.SQLException- Specified by:
- setNullin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setBinaryStreampublic void setBinaryStream(int parameterIndex, java.io.InputStream inputStream, int length) throws java.sql.SQLException- Specified by:
- setBinaryStreamin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setBinaryStreampublic void setBinaryStream(int parameterIndex, java.io.InputStream inputStream, long length) throws java.sql.SQLException- Specified by:
- setBinaryStreamin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setBinaryStreampublic void setBinaryStream(int parameterIndex, java.io.InputStream inputStream) throws java.sql.SQLException- Specified by:
- setBinaryStreamin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setBytespublic void setBytes(int parameterIndex, byte[] x) throws java.sql.SQLException- Specified by:
- setBytesin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setBooleanpublic void setBoolean(int parameterIndex, boolean x) throws java.sql.SQLException- Specified by:
- setBooleanin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setBytepublic void setByte(int parameterIndex, byte x) throws java.sql.SQLException- Specified by:
- setBytein interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setDatepublic void setDate(int parameterIndex, java.sql.Date x) throws java.sql.SQLException- Specified by:
- setDatein interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setDoublepublic void setDouble(int parameterIndex, double x) throws java.sql.SQLException- Specified by:
- setDoublein interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setFloatpublic void setFloat(int parameterIndex, float x) throws java.sql.SQLException- Specified by:
- setFloatin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setIntpublic void setInt(int parameterIndex, int x) throws java.sql.SQLException- Specified by:
- setIntin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setLongpublic void setLong(int parameterIndex, long x) throws java.sql.SQLException- Specified by:
- setLongin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setObjectpublic void setObject(int parameterIndex, java.lang.Object x) throws java.sql.SQLException- Specified by:
- setObjectin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setObjectpublic void setObject(int parameterIndex, java.lang.Object x, java.sql.SQLType targetSqlType, int scaleOrLength) throws java.sql.SQLExceptionImplementation note: behaves as setObject(int, Object, int, int)called withSQLType.getVendorTypeNumber().- Specified by:
- setObjectin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setObjectpublic void setObject(int parameterIndex, java.lang.Object x, java.sql.SQLType targetSqlType) throws java.sql.SQLExceptionImplementation note: behaves as setObject(int, Object, int)called withSQLType.getVendorTypeNumber().- Specified by:
- setObjectin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setShortpublic void setShort(int parameterIndex, short x) throws java.sql.SQLException- Specified by:
- setShortin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setStringpublic void setString(int parameterIndex, java.lang.String x) throws java.sql.SQLException- Specified by:
- setStringin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setTimepublic void setTime(int parameterIndex, java.sql.Time x) throws java.sql.SQLException- Specified by:
- setTimein interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setTimestamppublic void setTimestamp(int parameterIndex, java.sql.Timestamp x) throws java.sql.SQLException- Specified by:
- setTimestampin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setBigDecimalpublic void setBigDecimal(int parameterIndex, java.math.BigDecimal x) throws java.sql.SQLException- Specified by:
- setBigDecimalin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
getParameterDescriptorprotected FieldDescriptor getParameterDescriptor(int columnIndex) Returns theFieldDescriptorof the specified parameter.- Parameters:
- columnIndex- 1-based index of the parameter
- Returns:
- Field descriptor
 
 - 
getFieldprotected FBField getField(int columnIndex) throws java.sql.SQLException Factory method for the field access objects- Throws:
- java.sql.SQLException
 
 - 
setAsciiStreampublic final void setAsciiStream(int parameterIndex, java.io.InputStream x, int length) throws java.sql.SQLExceptionImplementation note: works identical to setBinaryStream(int, InputStream, int).- Specified by:
- setAsciiStreamin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setAsciiStreampublic final void setAsciiStream(int parameterIndex, java.io.InputStream x, long length) throws java.sql.SQLExceptionImplementation note: works identical to setBinaryStream(int, InputStream, long).- Specified by:
- setAsciiStreamin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setAsciiStreampublic final void setAsciiStream(int parameterIndex, java.io.InputStream x) throws java.sql.SQLExceptionImplementation note: works identical to setBinaryStream(int, InputStream).- Specified by:
- setAsciiStreamin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setUnicodeStream@Deprecated public void setUnicodeStream(int parameterIndex, java.io.InputStream x, int length) throws java.sql.SQLExceptionDeprecated.Method is no longer supported since Jaybird 3.0.For old behavior use setBinaryStream(int, InputStream, int). For JDBC suggested behavior, usesetCharacterStream(int, Reader, int).- Specified by:
- setUnicodeStreamin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLFeatureNotSupportedException- Always
- java.sql.SQLException
 
 - 
setURLpublic void setURL(int parameterIndex, java.net.URL url) throws java.sql.SQLExceptionJaybird does not support array types. - Specified by:
- setURLin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setNCharacterStreampublic void setNCharacterStream(int parameterIndex, java.io.Reader value, long length) throws java.sql.SQLExceptionImplementation note: This method behaves exactly the same as setCharacterStream(int, Reader, long).- Specified by:
- setNCharacterStreamin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setNCharacterStreampublic void setNCharacterStream(int parameterIndex, java.io.Reader value) throws java.sql.SQLExceptionImplementation note: This method behaves exactly the same as setCharacterStream(int, Reader).- Specified by:
- setNCharacterStreamin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setNClobpublic void setNClob(int parameterIndex, java.io.Reader reader, long length) throws java.sql.SQLExceptionImplementation note: This method behaves exactly the same as setClob(int, Reader, long).- Specified by:
- setNClobin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setNClobpublic void setNClob(int parameterIndex, java.io.Reader reader) throws java.sql.SQLExceptionImplementation note: This method behaves exactly the same as setClob(int, Reader).- Specified by:
- setNClobin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setNStringpublic void setNString(int parameterIndex, java.lang.String value) throws java.sql.SQLExceptionImplementation note: This method behaves exactly the same as setString(int, String).- Specified by:
- setNStringin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
clearParameterspublic void clearParameters() throws java.sql.SQLException- Specified by:
- clearParametersin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setObjectpublic void setObject(int parameterIndex, java.lang.Object x, int targetSqlType, int scale) throws java.sql.SQLExceptionImplementation note: ignores scaleandtargetSqlTypeand works assetObject(int, Object).- Specified by:
- setObjectin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setObjectpublic void setObject(int parameterIndex, java.lang.Object x, int targetSqlType) throws java.sql.SQLExceptionImplementation note: ignores targetSqlTypeand works assetObject(int, Object).- Specified by:
- setObjectin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
executepublic boolean execute() throws java.sql.SQLException- Specified by:
- executein interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
internalExecuteprotected boolean internalExecute(boolean sendOutParams) throws java.sql.SQLExceptionExecute this statement. Method checks whether all parameters are set, flushes all "flushable" fields that might contain cached data and executes the statement.- Parameters:
- sendOutParams- Determines if the XSQLDA structure should be sent to the database
- Returns:
- trueif the statement has more result sets.
- Throws:
- java.sql.SQLException
 
 - 
isGeneratedKeyQueryprotected boolean isGeneratedKeyQuery() - Overrides:
- isGeneratedKeyQueryin class- FBStatement
- Returns:
- truewhen the current statement is expected to return generated keys,- falseotherwise.
 
 - 
addBatchpublic void addBatch() throws java.sql.SQLException- Specified by:
- addBatchin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
clearBatchpublic void clearBatch() throws java.sql.SQLException- Specified by:
- clearBatchin interface- java.sql.Statement
- Overrides:
- clearBatchin class- FBStatement
- Throws:
- java.sql.SQLException
 
 - 
executeBatchInternalprotected java.util.List<java.lang.Long> executeBatchInternal() throws java.sql.SQLException- Overrides:
- executeBatchInternalin class- FBStatement
- Throws:
- java.sql.SQLException
 
 - 
setCharacterStreampublic void setCharacterStream(int parameterIndex, java.io.Reader reader, int length) throws java.sql.SQLException- Specified by:
- setCharacterStreamin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setCharacterStreampublic void setCharacterStream(int parameterIndex, java.io.Reader reader, long length) throws java.sql.SQLException- Specified by:
- setCharacterStreamin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setCharacterStreampublic void setCharacterStream(int parameterIndex, java.io.Reader reader) throws java.sql.SQLException- Specified by:
- setCharacterStreamin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setRefpublic void setRef(int i, java.sql.Ref x) throws java.sql.SQLExceptionJaybird does not support ref types. - Specified by:
- setRefin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setBlobpublic void setBlob(int parameterIndex, java.sql.Blob blob) throws java.sql.SQLException- Specified by:
- setBlobin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setBlobpublic void setBlob(int parameterIndex, java.io.InputStream inputStream, long length) throws java.sql.SQLException- Specified by:
- setBlobin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setBlobpublic void setBlob(int parameterIndex, java.io.InputStream inputStream) throws java.sql.SQLException- Specified by:
- setBlobin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setClobpublic void setClob(int parameterIndex, java.sql.Clob clob) throws java.sql.SQLException- Specified by:
- setClobin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setClobpublic void setClob(int parameterIndex, java.io.Reader reader, long length) throws java.sql.SQLException- Specified by:
- setClobin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setClobpublic void setClob(int parameterIndex, java.io.Reader reader) throws java.sql.SQLException- Specified by:
- setClobin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setArraypublic void setArray(int i, java.sql.Array x) throws java.sql.SQLExceptionJaybird does not support array types. - Specified by:
- setArrayin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
getMetaDatapublic java.sql.ResultSetMetaData getMetaData() throws java.sql.SQLException- Specified by:
- getMetaDatain interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setDatepublic void setDate(int parameterIndex, java.sql.Date x, java.util.Calendar cal) throws java.sql.SQLException- Specified by:
- setDatein interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setTimepublic void setTime(int parameterIndex, java.sql.Time x, java.util.Calendar cal) throws java.sql.SQLException- Specified by:
- setTimein interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setTimestamppublic void setTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar cal) throws java.sql.SQLException- Specified by:
- setTimestampin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setNullpublic void setNull(int parameterIndex, int sqlType, java.lang.String typeName) throws java.sql.SQLException- Specified by:
- setNullin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
prepareFixedStatementprotected void prepareFixedStatement(java.lang.String sql) throws java.sql.SQLExceptionPrepare fixed statement and initialize parameters.- Overrides:
- prepareFixedStatementin class- FBStatement
- Throws:
- java.sql.SQLException
 
 - 
getExecutionPlanpublic java.lang.String getExecutionPlan() throws java.sql.SQLExceptionDescription copied from interface:FirebirdPreparedStatementGet the execution plan of this PreparedStatement- Specified by:
- getExecutionPlanin interface- FirebirdPreparedStatement
- Returns:
- The execution plan of the statement
- Throws:
- java.sql.SQLException
 
 - 
getExplainedExecutionPlanpublic java.lang.String getExplainedExecutionPlan() throws java.sql.SQLExceptionDescription copied from interface:FirebirdPreparedStatementGet the detailed execution plan of this PreparedStatement- Specified by:
- getExplainedExecutionPlanin interface- FirebirdPreparedStatement
- Returns:
- The detailed execution plan of the statement
- Throws:
- java.sql.SQLException
 
 - 
getStatementTypepublic int getStatementType() throws java.sql.SQLExceptionDescription copied from interface:FirebirdPreparedStatementGet the statement type of this PreparedStatement. The returned value will be one of theTYPE_*constant values.- Specified by:
- getStatementTypein interface- FirebirdPreparedStatement
- Returns:
- The identifier for the given statement's type
- Throws:
- java.sql.SQLException
 
 - 
getParameterMetaDatapublic java.sql.ParameterMetaData getParameterMetaData() throws java.sql.SQLException- Specified by:
- getParameterMetaDatain interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setNClobpublic void setNClob(int parameterIndex, java.sql.NClob value) throws java.sql.SQLExceptionImplementation note: This method behaves exactly the same as setClob(int, Clob).- Specified by:
- setNClobin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setRowIdpublic void setRowId(int parameterIndex, java.sql.RowId x) throws java.sql.SQLException- Specified by:
- setRowIdin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
setSQLXMLpublic void setSQLXML(int parameterIndex, java.sql.SQLXML xmlObject) throws java.sql.SQLExceptionJaybird does not support SQLXML. - Specified by:
- setSQLXMLin interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 - 
executeQuerypublic java.sql.ResultSet executeQuery(java.lang.String sql) throws java.sql.SQLException- Specified by:
- executeQueryin interface- java.sql.Statement
- Overrides:
- executeQueryin class- FBStatement
- Throws:
- java.sql.SQLException
 
 - 
executeUpdatepublic int executeUpdate(java.lang.String sql) throws java.sql.SQLException- Specified by:
- executeUpdatein interface- java.sql.Statement
- Overrides:
- executeUpdatein class- FBStatement
- Throws:
- java.sql.SQLException
 
 - 
executepublic boolean execute(java.lang.String sql) throws java.sql.SQLException- Specified by:
- executein interface- java.sql.Statement
- Overrides:
- executein class- FBStatement
- Throws:
- java.sql.SQLException
 
 - 
addBatchpublic void addBatch(java.lang.String sql) throws java.sql.SQLException- Specified by:
- addBatchin interface- java.sql.Statement
- Overrides:
- addBatchin class- FBStatement
- Throws:
- java.sql.SQLException
 
 - 
executeUpdatepublic int executeUpdate(java.lang.String sql, int autoGeneratedKeys) throws java.sql.SQLException- Specified by:
- executeUpdatein interface- java.sql.Statement
- Overrides:
- executeUpdatein class- FBStatement
- Throws:
- java.sql.SQLException
 
 - 
executeUpdatepublic int executeUpdate(java.lang.String sql, int[] columnIndex) throws java.sql.SQLException- Specified by:
- executeUpdatein interface- java.sql.Statement
- Overrides:
- executeUpdatein class- FBStatement
- Throws:
- java.sql.SQLException
 
 - 
executeUpdatepublic int executeUpdate(java.lang.String sql, java.lang.String[] columnNames) throws java.sql.SQLException- Specified by:
- executeUpdatein interface- java.sql.Statement
- Overrides:
- executeUpdatein class- FBStatement
- Throws:
- java.sql.SQLException
 
 - 
executepublic boolean execute(java.lang.String sql, int autoGeneratedKeys) throws java.sql.SQLException- Specified by:
- executein interface- java.sql.Statement
- Overrides:
- executein class- FBStatement
- Throws:
- java.sql.SQLException
 
 - 
executepublic boolean execute(java.lang.String sql, int[] columnIndexes) throws java.sql.SQLException- Specified by:
- executein interface- java.sql.Statement
- Overrides:
- executein class- FBStatement
- Throws:
- java.sql.SQLException
 
 - 
executepublic boolean execute(java.lang.String sql, java.lang.String[] columnNames) throws java.sql.SQLException- Specified by:
- executein interface- java.sql.Statement
- Overrides:
- executein class- FBStatement
- Throws:
- java.sql.SQLException
 
 - 
executeLargeUpdatepublic long executeLargeUpdate() throws java.sql.SQLException- Specified by:
- executeLargeUpdatein interface- java.sql.PreparedStatement
- Throws:
- java.sql.SQLException
 
 
- 
 
-