Class AbstractPreparedStatement
- java.lang.Object
- 
- org.firebirdsql.jdbc.FBStatement
- 
- org.firebirdsql.jdbc.AbstractPreparedStatement
 
 
- 
- All Implemented Interfaces:
- java.lang.AutoCloseable,- java.sql.PreparedStatement,- java.sql.Statement,- java.sql.Wrapper,- FirebirdPreparedStatement,- FirebirdStatement,- Synchronizable
 - Direct Known Subclasses:
- FBPreparedStatement
 
 public abstract class AbstractPreparedStatement extends FBStatement implements FirebirdPreparedStatement Abstract 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 protected java.util.List<java.lang.Object>batchListstatic java.lang.StringMETHOD_NOT_SUPPORTED- 
Fields inherited from class org.firebirdsql.jdbc.FBStatementcompleted, connection, currentStatementResult, fbStatement, fetchSize, firstWarning, gdsHelper, isSingletonResult, jdbcVersionSupport, 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 protectedAbstractPreparedStatement(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.protectedAbstractPreparedStatement(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 voidnotifyStatementCompleted(boolean success)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)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)voidsetStringForced(int parameterIndex, java.lang.String x)Sets the designated parameter to the given String value.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, createStatementListener, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, equals, executeBatch, executeImpl, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, finalize, forgetResultSet, getConnection, getCurrentResultSet, getDeletedRowsCount, getFetchDirection, getFetchSize, getGeneratedKeys, getInsertedRowsCount, getLargeMaxRows, getLargeUpdateCount, getLastExecutionPlan, getLastExplainedExecutionPlan, getLocalStatementId, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getSynchronizationObject, getUpdateCount, getUpdatedRowsCount, getWarnings, hashCode, hasOpenResultSet, internalExecute, isClosed, isCloseOnCompletion, isExecuteProcedureStatement, isPoolable, isSimpleIdentifier, isValid, isWrapperFor, nativeSQL, notifyStatementCompleted, notifyStatementStarted, notifyStatementStarted, requireStatement, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, toArray, toLargeArray, unwrap
 - 
Methods inherited from class java.lang.Objectclone, 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
 
 - 
batchListprotected final java.util.List<java.lang.Object> batchList 
 
- 
 - 
Constructor Detail- 
AbstractPreparedStatementprotected AbstractPreparedStatement(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.
 
 - 
AbstractPreparedStatementprotected AbstractPreparedStatement(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.SQLException- Overrides:
- notifyStatementCompletedin class- FBStatement
- Throws:
- java.sql.SQLException
 
 - 
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
 
 - 
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
 
 - 
setStringForcedpublic void setStringForced(int parameterIndex, java.lang.String x) throws java.sql.SQLExceptionSets the designated parameter to the given String value. This is a workaround for the ambiguous "operation was cancelled" response from the server for when an oversized string is set for a limited-size field. This method sets the string parameter without checking size constraints.- Parameters:
- parameterIndex- the first parameter is 1, the second is 2, ...
- x- The String value to be set
- Throws:
- java.sql.SQLException- if a database access occurs
 
 - 
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
 
 
- 
 
-