JDBC Extensions

Jaybird provides the following extensions to JDBC.

not 100% up to date

Interface	Method name	Description
FirebirdDriver	newConnectionProperties()	Create new instance of FirebirdConnectionProperties interface that can be used to set connection properties programmatically.
FirebirdDriver	connect( FirebirdConnectionProperties )	Connect to the Firebird database using the specified connection properties.
FirebirdConnectionProperties	-	see JDBC connection properties section for more details.
FirebirdConnection	getIscEncoding()	Get connection character encoding.
FirebirdConnection	getTransactionParameters( int isolationLevel )	Get the TPB parameters for the specified transaction isolation level.
FirebirdConnection	createTransactionParameterBuffer()	Create an empty transaction parameter buffer.
FirebirdConnection	setTransactionParameters( int isolationLevel, TransactionParameterBuffer tpb )	Set TPB parameters for the specified transaction isolation level. The newly specified mapping is valid for the whole connection lifetime.
FirebirdConnection	setTransactionParameters( TransactionParameterBuffer tpb )	Set TPB parameters for the specified transaction isolation level. The newly specified parameters are effective until the transaction isolation is changed.
FirebirdDatabaseMetaData	getProcedureSourceCode( String )	Get source code for the specified stored procedure name.
FirebirdDatabaseMetaData	getTriggerSourceCode( String )	Get source code for the specified trigger name.
FirebirdDatabaseMetaData	getViewSourceCode( String )	Get source code for the specified view name.
FirebirdStatement	getInsertedRowsCount() getUpdatedRowsCount() getDeletedRowsCount()	Extension that allows to get more precise information about outcome of some statement.
FirebirdStatement	hasOpenResultSet()	Check if this statement has open result set. Correctly works only when auto-commit is disabled. Check method documentation for details.
FirebirdStatement	getCurrentResultSet()	Get current result set. Behaviour of this method is similar to the behavior of the Statement.getResultSet(), except that this method can be called as much as you like.
FirebirdStatement	isValid()	Check if this statement is still valid. Statement might be invalidated when connection is automatically recycled between transactions due to some irrecoverable error.
FirebirdStatement	getLastExecutionPlan()	Get execution plan for the last executed statement.
FirebirdPreparedStatement	getExecutionPlan()	Get the execution plan of this prepared statement.
FirebirdPreparedStatement	getStatementType()	Get the statement type of this prepared statement. One of the ISCConstants.isc_info_sql_stmt_* values or 0 if type is unknown.
FirebirdCallableStatement	setSelectableProcedure( boolean selectable )	Mark this callable statement as a call of the selectable procedure. By default callable statement uses EXECUTE PROCEDURE SQL statement to invoke stored procedures that return single row of output parameters or a result set. In former case it retrieves only the first row of the result set. With Firebird 2.1 or higher it is not necessary to use this method as it provides information on the stored procedure type.
FirebirdResultSet	getExecutionPlan()	Get execution plan for this result set.
FirebirdBlob	detach()	Method 'detaches' a blob object from the underlying result set. Lifetime of 'detached' blob is limited by the lifetime of the transaction.
FirebirdBlob	isSegmented()	Check if this blob is segmented. Seek operation is not defined for the segmented blobs.
FirebirdBlob.BlobInputStream	getBlob()	Get corresponding blob instance.
FirebirdBlob.BlobInputStream	seek( int position )	Change the position from which blob content will be read, works only for stream blobs.