nz.co.gregs.dbvolution.databases

Class DBTransactionStatement

java.lang.Object

nz.co.gregs.dbvolution.databases.DBStatement

nz.co.gregs.dbvolution.databases.DBTransactionStatement

All Implemented Interfaces:

AutoCloseable, Statement, Wrapper

public class DBTransactionStatement
extends DBStatement

Extends DBStatement to add support for database transactions.

Use DBScript to easily create a transaction.

You should not need to create on of these as statements and transactions are managed by DBDatabase automatically.

Transactions are a collection of database actions that have a coherent collective nature. This implies that even though they are separate java statements that they should be handled collectively by the database.

Support DBvolution at Patreon

Author:

Gregory Graham

Field Summary

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
DBTransactionStatement(DBDatabase database, DBStatement statement) Creates a DBTransactionStatement for the given DBDatabase and DBStatement.

Method Summary

Methods

Modifier and Type	Method and Description
void	cancel() Cancels this Statement object if both the DBMS and driver support aborting an SQL statement.
void	close() Closes the internal statement and creates a new statement for the next operation.
void	transactionFinished() Performs actions required following the completion of a transaction.

Methods inherited from class nz.co.gregs.dbvolution.databases.DBStatement

addBatch, clearBatch, clearWarnings, closeOnCompletion, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getBatchHasEntries, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getInternalStatement, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isWrapperFor, replaceBrokenConnection, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setInternalStatement, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, unwrap

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DBTransactionStatement

public DBTransactionStatement(DBDatabase database,
                      DBStatement statement)
                       throws SQLException

Creates a DBTransactionStatement for the given DBDatabase and DBStatement.

Used within DBDatabase.doTransaction(nz.co.gregs.dbvolution.transactions.DBTransaction) to create a transaction. 1 Database exceptions may be thrown

Parameters:

database - database

statement - statement

Throws:

SQLException - java.sql.SQLException

Method Detail

close

public void close()
           throws SQLException

Closes the internal statement and creates a new statement for the next operation.

To close a transaction call the transactionFinished() method.

Specified by:

close in interface AutoCloseable

Specified by:

close in interface Statement

Overrides:

close in class DBStatement

Throws:

SQLException - SQLException

cancel

public void cancel()
            throws SQLException

Description copied from class: DBStatement

Cancels this Statement object if both the DBMS and driver support aborting an SQL statement. This method can be used by one thread to cancel a statement that is being executed by another thread. 1 Database exceptions may be thrown

Specified by:

cancel in interface Statement

Overrides:

cancel in class DBStatement

Throws:

SQLException

transactionFinished

public void transactionFinished()
                         throws SQLException

Performs actions required following the completion of a transaction.

Transactions last longer than the standard DBStatement so a new method is required to close their resources. 1 Database exceptions may be thrown

Throws:

SQLException - java.sql.SQLException