Java Savepoint類代碼示例

import java.sql.Savepoint; //導入依賴的package包/類
/**
 * @see Connection#setSavepoint(String)
 */
public java.sql.Savepoint setSavepoint(String arg0) throws SQLException {
    checkClosed();

    if (isInGlobalTx()) {
        throw SQLError.createSQLException("Can't set autocommit to 'true' on an XAConnection", SQLError.SQL_STATE_INVALID_TRANSACTION_TERMINATION,
                MysqlErrorNumbers.ER_XA_RMERR, this.exceptionInterceptor);
    }

    try {
        return this.mc.setSavepoint(arg0);
    } catch (SQLException sqlException) {
        checkAndFireConnectionError(sqlException);
    }

    return null; // we don't reach this code, compiler can't tell
}
 

import java.sql.Savepoint; //導入依賴的package包/類
/**
 * Stores the Savepoint in static for username + connectionId
 * 
 * @param savepoint
 *            the Savepoint to store
 */
public void put(Savepoint savepoint) {

	debug("Creating a Savepoint for user: " + connectionKey);
	if (savepoint == null) {
		throw new IllegalArgumentException("savepoint is null!");
	}

	Set<Savepoint> savepointSet = savepointMap.get(connectionKey);
	if (savepointSet == null) {
		savepointSet = new LinkedHashSet<Savepoint>();
	}

	savepointSet.add(savepoint);
	savepointMap.put(connectionKey, savepointSet);
}
 

import java.sql.Savepoint; //導入依賴的package包/類
/**
 * Begins a transaction on the current database;
 * 
 * @return
 * @throws SQLException
 */
public synchronized Savepoint beginTransaction() throws SQLException {
	if (this.transaction_connection != null)
		throw new RuntimeException("Another transaction is already running: " + transaction_savepoint);

	this.transaction_connection = popConnection();
	this.transaction_connection.setAutoCommit(false);
	this.transaction_savepoint = this.transaction_connection.setSavepoint();
	return this.transaction_savepoint;
}
 

import java.sql.Savepoint; //導入依賴的package包/類
@Test
public void testRollback() throws Exception
{
	thrown.expect(SQLFeatureNotSupportedException.class);
	AbstractCloudSpannerConnection testSubject;
	Savepoint savepoint = null;

	// default test
	testSubject = createTestSubject();
	testSubject.rollback(savepoint);
}
 

import java.sql.Savepoint; //導入依賴的package包/類
/**
 * See {@link DatabaseConnection#commit(Savepoint)}
 */
public void commit(Class<?> type, Savepoint savepoint) {
    try {
        String tableName = getDao(type).getTableName();
        getConnectionSource().getReadWriteConnection(tableName).commit(savepoint);
    } catch (SQLException e) {
        throw new Panic(e);
    }
}
 

import java.sql.Savepoint; //導入依賴的package包/類
/**
 * @see Connection#setSavepoint()
 */
public java.sql.Savepoint setSavepoint() throws SQLException {
    MysqlSavepoint savepoint = new MysqlSavepoint(getExceptionInterceptor());

    setSavepoint(savepoint);

    return savepoint;
}
 

import java.sql.Savepoint; //導入依賴的package包/類
public Savepoint setSavepoint(String name) throws SQLException
{
	try
	{
		return realConnection.setSavepoint(name);
	}
	catch(SQLException s)
	{
		String methodCall = "setSavepoint(" + name + ")";
		reportException(methodCall, s, null);
		throw s;
	}
}
 

import java.sql.Savepoint; //導入依賴的package包/類
/**
 * 用於在事務中設置一個保存點，屬於線程安全的
 */
public static void setSavePoint() {
    Connection connection = tl_conn.get();
    if (connection == null) {
        throw new RuntimeException("You do not start a Transaction so you can not set a savepoint!");
    }
    try {
        Stack<Savepoint> stack_sp = tl_sp.get();
        Savepoint sp = connection.setSavepoint();
        stack_sp.push(sp);
    } catch (SQLException e) {
        throw new RuntimeException(e);
    }
}
 

import java.sql.Savepoint; //導入依賴的package包/類
/**
 * @see Connection#releaseSavepoint(Savepoint)
 */
public void releaseSavepoint(Savepoint arg0) throws SQLException {
    checkClosed();

    try {
        this.mc.releaseSavepoint(arg0);
    } catch (SQLException sqlException) {
        checkAndFireConnectionError(sqlException);
    }
}
 

import java.sql.Savepoint; //導入依賴的package包/類
public void releaseSavepoint(Savepoint savepoint) throws SQLException
{
	try
	{
		realConnection.releaseSavepoint(savepoint);
	}
	catch(SQLException s)
	{
		String methodCall = "releaseSavepoint(" + savepoint + ")";
		reportException(methodCall, s, null);
		throw s;
	}
}
 

import java.sql.Savepoint; //導入依賴的package包/類
protected Long newNodeImplInsert(NodeEntity node)
{
    Long id = null;
    Savepoint savepoint = controlDAO.createSavepoint("newNodeImpl");
    try
    {
        // First try a straight insert and risk the constraint violation if the node exists
        id = insertNode(node);
        controlDAO.releaseSavepoint(savepoint);
    }
    catch (Throwable e)
    {
        controlDAO.rollbackToSavepoint(savepoint);
        // This is probably because there is an existing node.  We can handle existing deleted nodes.
        NodeRef targetNodeRef = node.getNodeRef();
        Node dbTargetNode = selectNodeByNodeRef(targetNodeRef);
        if (dbTargetNode == null)
        {
            // There does not appear to be any row that could prevent an insert
            throw new AlfrescoRuntimeException("Failed to insert new node: " + node, e);
        }
        else if (dbTargetNode.getDeleted(qnameDAO))
        {
            Long dbTargetNodeId = dbTargetNode.getId();
            // This is OK.  It happens when we create a node that existed in the past.
            // Remove the row completely
            deleteNodeProperties(dbTargetNodeId, (Set<Long>) null);
            deleteNodeById(dbTargetNodeId);
            // Now repeat the insert but let any further problems just be thrown out
            id = insertNode(node);
        }
        else
        {
            // A live node exists.
            throw new NodeExistsException(dbTargetNode.getNodePair(), e);
        }
    }
    
    return id;
}
 

import java.sql.Savepoint; //導入依賴的package包/類
/**
 * See {@link DatabaseConnection#rollback(Savepoint)}
 */
public void rollback(Class<?> type, Savepoint savepoint) {
    try {
        String tableName = getDao(type).getTableName();
        getConnectionSource().getReadWriteConnection(tableName).rollback(savepoint);
    } catch (SQLException e) {
        throw new Panic(e);
    }
}
 

import java.sql.Savepoint; //導入依賴的package包/類
/**
 * @see Connection#rollback(Savepoint)
 */
public void rollback(Savepoint arg0) throws SQLException {
    checkClosed();

    if (isInGlobalTx()) {
        throw SQLError.createSQLException("Can't call rollback() on an XAConnection associated with a global transaction",
                SQLError.SQL_STATE_INVALID_TRANSACTION_TERMINATION, MysqlErrorNumbers.ER_XA_RMERR, this.exceptionInterceptor);
    }

    try {
        this.mc.rollback(arg0);
    } catch (SQLException sqlException) {
        checkAndFireConnectionError(sqlException);
    }
}
 

import java.sql.Savepoint; //導入依賴的package包/類
/**
 * @see Connection#setSavepoint(String)
 */
public java.sql.Savepoint setSavepoint(String name) throws SQLException {
    synchronized (getConnectionMutex()) {
        MysqlSavepoint savepoint = new MysqlSavepoint(name, getExceptionInterceptor());

        setSavepoint(savepoint);

        return savepoint;
    }
}
 

import java.sql.Savepoint; //導入依賴的package包/類
@Override
public void rollback(Savepoint savepoint) throws SQLException
{
	inner.rollback(savepoint);
}