当前位置: 首页>>代码示例>>Java>>正文

Java MysqlXADataSource.setRollbackOnPooledClose方法代码示例

本文整理汇总了Java中com.mysql.jdbc.jdbc2.optional.MysqlXADataSource.setRollbackOnPooledClose方法的典型用法代码示例。如果您正苦于以下问题：Java MysqlXADataSource.setRollbackOnPooledClose方法的具体用法？Java MysqlXADataSource.setRollbackOnPooledClose怎么用？Java MysqlXADataSource.setRollbackOnPooledClose使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类com.mysql.jdbc.jdbc2.optional.MysqlXADataSource的用法示例。


在下文中一共展示了MysqlXADataSource.setRollbackOnPooledClose方法的3个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Java代码示例。

示例1: testSuspendableTx

import com.mysql.jdbc.jdbc2.optional.MysqlXADataSource; //导入方法依赖的package包/类
public void testSuspendableTx() throws Exception {
    if (!versionMeetsMinimum(5, 0)) {
        return;
    }

    Connection conn1 = null;

    MysqlXADataSource suspXaDs = new MysqlXADataSource();
    suspXaDs.setUrl(BaseTestCase.dbUrl);
    suspXaDs.setPinGlobalTxToPhysicalConnection(true);
    suspXaDs.setRollbackOnPooledClose(true);

    XAConnection xaConn1 = null;

    Xid xid = createXid();

    try {
        /*
         * -- works using RESUME
         * xa start 0x123,0x456;
         * select * from foo;
         * xa end 0x123,0x456;
         * xa start 0x123,0x456 resume;
         * select * from foo;
         * xa end 0x123,0x456;
         * xa commit 0x123,0x456 one phase;
         */

        xaConn1 = suspXaDs.getXAConnection();
        XAResource xaRes1 = xaConn1.getXAResource();
        conn1 = xaConn1.getConnection();
        xaRes1.start(xid, XAResource.TMNOFLAGS);
        conn1.createStatement().execute("SELECT 1");
        xaRes1.end(xid, XAResource.TMSUCCESS);
        xaRes1.start(xid, XAResource.TMRESUME);
        conn1.createStatement().execute("SELECT 1");
        xaRes1.end(xid, XAResource.TMSUCCESS);
        xaRes1.commit(xid, true);

        xaConn1.close();

        /*
         * 
         * -- fails using JOIN
         * xa start 0x123,0x456;
         * select * from foo;
         * xa end 0x123,0x456;
         * xa start 0x123,0x456 join;
         * select * from foo;
         * xa end 0x123,0x456;
         * xa commit 0x123,0x456 one phase;
         */

        xaConn1 = suspXaDs.getXAConnection();
        xaRes1 = xaConn1.getXAResource();
        conn1 = xaConn1.getConnection();
        xaRes1.start(xid, XAResource.TMNOFLAGS);
        conn1.createStatement().execute("SELECT 1");
        xaRes1.end(xid, XAResource.TMSUCCESS);
        xaRes1.start(xid, XAResource.TMJOIN);
        conn1.createStatement().execute("SELECT 1");
        xaRes1.end(xid, XAResource.TMSUCCESS);
        xaRes1.commit(xid, true);
    } finally {
        if (xaConn1 != null) {
            xaConn1.close();
        }
    }
}
开发者ID:bragex，项目名称:the-vigilantes，代码行数:70，代码来源:XATest.java

示例2: testSuspendableTx

import com.mysql.jdbc.jdbc2.optional.MysqlXADataSource; //导入方法依赖的package包/类
public void testSuspendableTx() throws Exception {
    if (!versionMeetsMinimum(5, 0) || isRunningOnJdk131()) {
        return;
    }

    Connection conn1 = null;

    MysqlXADataSource suspXaDs = new MysqlXADataSource();
    suspXaDs.setUrl(BaseTestCase.dbUrl);
    suspXaDs.setPinGlobalTxToPhysicalConnection(true);
    suspXaDs.setRollbackOnPooledClose(true);

    XAConnection xaConn1 = null;

    Xid xid = createXid();

    try {
        /*
         * -- works using RESUME
         * xa start 0x123,0x456;
         * select * from foo;
         * xa end 0x123,0x456;
         * xa start 0x123,0x456 resume;
         * select * from foo;
         * xa end 0x123,0x456;
         * xa commit 0x123,0x456 one phase;
         */

        xaConn1 = suspXaDs.getXAConnection();
        XAResource xaRes1 = xaConn1.getXAResource();
        conn1 = xaConn1.getConnection();
        xaRes1.start(xid, XAResource.TMNOFLAGS);
        conn1.createStatement().executeQuery("SELECT 1");
        xaRes1.end(xid, XAResource.TMSUCCESS);
        xaRes1.start(xid, XAResource.TMRESUME);
        conn1.createStatement().executeQuery("SELECT 1");
        xaRes1.end(xid, XAResource.TMSUCCESS);
        xaRes1.commit(xid, true);

        xaConn1.close();

        /*
         * 
         * -- fails using JOIN
         * xa start 0x123,0x456;
         * select * from foo;
         * xa end 0x123,0x456;
         * xa start 0x123,0x456 join;
         * select * from foo;
         * xa end 0x123,0x456;
         * xa commit 0x123,0x456 one phase;
         */

        xaConn1 = suspXaDs.getXAConnection();
        xaRes1 = xaConn1.getXAResource();
        conn1 = xaConn1.getConnection();
        xaRes1.start(xid, XAResource.TMNOFLAGS);
        conn1.createStatement().executeQuery("SELECT 1");
        xaRes1.end(xid, XAResource.TMSUCCESS);
        xaRes1.start(xid, XAResource.TMJOIN);
        conn1.createStatement().executeQuery("SELECT 1");
        xaRes1.end(xid, XAResource.TMSUCCESS);
        xaRes1.commit(xid, true);
    } finally {
        if (xaConn1 != null) {
            xaConn1.close();
        }
    }
}
开发者ID:mniepert，项目名称:TPKB，代码行数:70，代码来源:XATest.java

示例3: testSuspendableTx

import com.mysql.jdbc.jdbc2.optional.MysqlXADataSource; //导入方法依赖的package包/类
public void testSuspendableTx() throws Exception {
	if (!versionMeetsMinimum(5, 0) || isRunningOnJdk131()) {
		return;
	}
	
	Connection conn1 = null;

	MysqlXADataSource suspXaDs = new MysqlXADataSource();
	suspXaDs.setUrl(BaseTestCase.dbUrl);
	suspXaDs.setPinGlobalTxToPhysicalConnection(true);
	suspXaDs.setRollbackOnPooledClose(true);
	
	XAConnection xaConn1 = null;
	
	Xid xid = createXid();
	
	try {
		/*
		  	-- works using RESUME
			xa start 0x123,0x456;
			select * from foo;
			xa end 0x123,0x456;
			xa start 0x123,0x456 resume;
			select * from foo;
			xa end 0x123,0x456;
			xa commit 0x123,0x456 one phase;
		 */
		
		xaConn1 = suspXaDs.getXAConnection();
		XAResource xaRes1 = xaConn1.getXAResource();
		conn1 = xaConn1.getConnection();
		xaRes1.start(xid, XAResource.TMNOFLAGS);
		conn1.createStatement().executeQuery("SELECT 1");
		xaRes1.end(xid, XAResource.TMSUCCESS);
		xaRes1.start(xid, XAResource.TMRESUME);
		conn1.createStatement().executeQuery("SELECT 1");
		xaRes1.end(xid, XAResource.TMSUCCESS);
		xaRes1.commit(xid, true);
		
		xaConn1.close();
		
		/*

			-- fails using JOIN
			xa start 0x123,0x456;
			select * from foo;
			xa end 0x123,0x456;
			xa start 0x123,0x456 join;
			select * from foo;
			xa end 0x123,0x456;
			xa commit 0x123,0x456 one phase;
			*/
	
		xaConn1 = suspXaDs.getXAConnection();
		xaRes1 = xaConn1.getXAResource();
		conn1 = xaConn1.getConnection();
		xaRes1.start(xid, XAResource.TMNOFLAGS);
		conn1.createStatement().executeQuery("SELECT 1");
		xaRes1.end(xid, XAResource.TMSUCCESS);
		xaRes1.start(xid, XAResource.TMJOIN);
		conn1.createStatement().executeQuery("SELECT 1");
		xaRes1.end(xid, XAResource.TMSUCCESS);
		xaRes1.commit(xid, true);
	} finally {
		if (xaConn1 != null) {
			xaConn1.close();
		}
	}
}
开发者ID:hinsenchan，项目名称:fil_project_mgmt_app_v2，代码行数:70，代码来源:XATest.java


注：本文中的com.mysql.jdbc.jdbc2.optional.MysqlXADataSource.setRollbackOnPooledClose方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。