org.firebirdsql.jdbc
Interface FirebirdConnection

All Superinterfaces:
java.sql.Connection, java.sql.Wrapper
All Known Implementing Classes:
AbstractConnection, FBConnection

public interface FirebirdConnection
extends java.sql.Connection

Extension of Connection interface providing access to Firebird specific features.

Author:
Roman Rokytskyy

Field Summary
static int TPB_CONCURRENCY
           
static int TPB_CONSISTENCY
           
static int TPB_NO_REC_VERSION
           
static int TPB_NOWAIT
           
static int TPB_READ
           
static int TPB_READ_COMMITTED
           
static int TPB_REC_VERSION
           
static int TPB_WAIT
           
static int TPB_WRITE
           
 
Fields inherited from interface java.sql.Connection
TRANSACTION_NONE, TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE
 
Method Summary
 java.sql.Blob createBlob()
          Create Blob object.
 TransactionParameterBuffer createTransactionParameterBuffer()
          Create new instance of TransactionParameterBuffer.
 java.lang.String getIscEncoding()
          Get current ISC encoding.
 TransactionParameterBuffer getTransactionParameters(int isolationLevel)
          Get transaction parameters for the specified transaction isolation level.
 boolean isUseFirebirdAutoCommit()
           
 void releaseSavepoint(FirebirdSavepoint savepoint)
          Deprecated. This method will be removed in Jaybird 2.3, use Connection.releaseSavepoint(java.sql.Savepoint)
 void rollback(FirebirdSavepoint savepoint)
          Deprecated. This method will be removed in Jaybird 2.3, use Connection.rollback(java.sql.Savepoint)
 FirebirdSavepoint setFirebirdSavepoint()
          Deprecated. This method will be removed in Jaybird 2.3, use Connection.setSavepoint()
 FirebirdSavepoint setFirebirdSavepoint(java.lang.String name)
          Deprecated. This method will be removed in Jaybird 2.3, use Connection.setSavepoint(String)
 void setTransactionParameters(int isolationLevel, int[] parameters)
          Deprecated. use setTransactionParameters(int, TransactionParameterBuffer) instead.
 void setTransactionParameters(int isolationLevel, TransactionParameterBuffer tpb)
          Set transaction parameters for the specified transaction isolation level.
 void setTransactionParameters(TransactionParameterBuffer tpb)
          Set transaction parameters for the next transactions.
 
Methods inherited from interface java.sql.Connection
clearWarnings, close, commit, createArrayOf, createClob, createNClob, createSQLXML, createStatement, createStatement, createStatement, createStruct, getAutoCommit, getCatalog, getClientInfo, getClientInfo, getHoldability, getMetaData, getTransactionIsolation, getTypeMap, getWarnings, isClosed, isReadOnly, isValid, nativeSQL, prepareCall, prepareCall, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, releaseSavepoint, rollback, rollback, setAutoCommit, setCatalog, setClientInfo, setClientInfo, setHoldability, setReadOnly, setSavepoint, setSavepoint, setTransactionIsolation, setTypeMap
 
Methods inherited from interface java.sql.Wrapper
isWrapperFor, unwrap
 

Field Detail

TPB_READ_COMMITTED

static final int TPB_READ_COMMITTED
See Also:
Constant Field Values

TPB_CONCURRENCY

static final int TPB_CONCURRENCY
See Also:
Constant Field Values

TPB_CONSISTENCY

static final int TPB_CONSISTENCY
See Also:
Constant Field Values

TPB_READ

static final int TPB_READ
See Also:
Constant Field Values

TPB_WRITE

static final int TPB_WRITE
See Also:
Constant Field Values

TPB_WAIT

static final int TPB_WAIT
See Also:
Constant Field Values

TPB_NOWAIT

static final int TPB_NOWAIT
See Also:
Constant Field Values

TPB_REC_VERSION

static final int TPB_REC_VERSION
See Also:
Constant Field Values

TPB_NO_REC_VERSION

static final int TPB_NO_REC_VERSION
See Also:
Constant Field Values
Method Detail

createBlob

java.sql.Blob createBlob()
                         throws java.sql.SQLException
Create Blob object.

Specified by:
createBlob in interface java.sql.Connection
Returns:
instance of FirebirdBlob.
Throws:
java.sql.SQLException - if something went wrong.

getIscEncoding

java.lang.String getIscEncoding()
                                throws java.sql.SQLException
Get current ISC encoding.

Returns:
current ISC encoding.
Throws:
java.sql.SQLException

setTransactionParameters

void setTransactionParameters(int isolationLevel,
                              int[] parameters)
                              throws java.sql.SQLException
Deprecated. use setTransactionParameters(int, TransactionParameterBuffer) instead.

Set transaction parameters for the specified isolation level. They will take effect only on the newly started transaction.

Parameters:
isolationLevel - JDBC isolation level.
parameters - array of TPB parameters, see all TPB_* constants.
Throws:
java.sql.SQLException - if specified transaction parameters cannot be set.

getTransactionParameters

TransactionParameterBuffer getTransactionParameters(int isolationLevel)
                                                    throws java.sql.SQLException
Get transaction parameters for the specified transaction isolation level.

Parameters:
isolationLevel - isolation level defined in the Connection interface.
Returns:
instance of TransactionParameterBuffer containing current transaction parameters.
Throws:
java.sql.SQLException - if error occured obtaining transaction parameters.

createTransactionParameterBuffer

TransactionParameterBuffer createTransactionParameterBuffer()
                                                            throws java.sql.SQLException
Create new instance of TransactionParameterBuffer.

Returns:
empty instance of TransactionParameterBuffer.
Throws:
java.sql.SQLException - if error occured during this operation.

setTransactionParameters

void setTransactionParameters(int isolationLevel,
                              TransactionParameterBuffer tpb)
                              throws java.sql.SQLException
Set transaction parameters for the specified transaction isolation level. This method replaces the default TPB mapping with the specified one, changes will be effective from the next transaction start.

Parameters:
isolationLevel - isolation level defined in the Connection interface.
tpb - instance of TransactionParameterBuffer with parameters to set.
Throws:
java.sql.SQLException - if error occured during this operation.

setTransactionParameters

void setTransactionParameters(TransactionParameterBuffer tpb)
                              throws java.sql.SQLException
Set transaction parameters for the next transactions. This method does not change the TPB mapping, but replaces the mapping for the current transaction isolation until Connection.setTransactionIsolation(int) is called.

Method cannot be called when transaction has already started.

Parameters:
tpb - instance of TransactionParameterBuffer with new transaction parameters.
Throws:
java.sql.SQLException - if method is called within a transaction.

isUseFirebirdAutoCommit

boolean isUseFirebirdAutoCommit()
Returns:
true if this connection is configured to use isc_tpb_autocommit when in auto commit.

setFirebirdSavepoint

@Deprecated
FirebirdSavepoint setFirebirdSavepoint()
                                       throws java.sql.SQLException
Deprecated. This method will be removed in Jaybird 2.3, use Connection.setSavepoint()

Creates an unnamed savepoint in the current transaction and returns the new FirebirdSavepoint object that represents it.

This method corresponds to the Connection.setSavepoint() method in JDBC 3.0.

Returns:
instance of FirebirdSavepoint
Throws:
java.sql.SQLException - if a an error occured.

setFirebirdSavepoint

@Deprecated
FirebirdSavepoint setFirebirdSavepoint(java.lang.String name)
                                       throws java.sql.SQLException
Deprecated. This method will be removed in Jaybird 2.3, use Connection.setSavepoint(String)

Creates a named savepoint in the current transaction and returns the new FirebirdSavepoint object that represents it.

This method corresponds to the Connection.setSavepoint(String) method in JDBC 3.0.

Parameters:
name - a String containing the name of the savepoint
Returns:
instance of FirebirdSavepoint
Throws:
java.sql.SQLException - if a an error occured.

rollback

@Deprecated
void rollback(FirebirdSavepoint savepoint)
              throws java.sql.SQLException
Deprecated. This method will be removed in Jaybird 2.3, use Connection.rollback(java.sql.Savepoint)

Undoes all changes made after the given FirebirdSavepoint object was set.

This method corresponds to the Connection.rollback(Savepoint) method in JDBC 3.0.

Parameters:
savepoint - the FirebirdSavepoint object to roll back to
Throws:
java.sql.SQLException - if a database access error occurs.

releaseSavepoint

@Deprecated
void releaseSavepoint(FirebirdSavepoint savepoint)
                      throws java.sql.SQLException
Deprecated. This method will be removed in Jaybird 2.3, use Connection.releaseSavepoint(java.sql.Savepoint)

Removes the given FirebirdSavepoint object from the current transaction. Any reference to the savepoint after it have been removed will cause an SQLException to be thrown.

This method corresponds to the Connection.releaseSavepoint(Savepoint) method in JDBC 3.0.

Parameters:
savepoint - the FirebirdSavepoint object to be removed
Throws:
java.sql.SQLException - if a database access error occurs


Copyright © 2001-2019 Jaybird (Firebird JDBC/JCA) team. All rights reserved.