Examples with XAConnection javax.sql.XAConnection used on opensource projects

Example 71 with XAConnection

use of javax.sql.XAConnection in project aries by apache.

the class TransactionLogTest method testRequired2PCNoRecovery.

@Test
public void testRequired2PCNoRecovery() throws Exception {
    XAConnection xaConn = dataSource.getXAConnection();
    XAConnection xaConn2 = dataSource.getXAConnection();
    try {
        txControl.required(() -> {
            txControl.getCurrentContext().registerXAResource(xaConn.getXAResource(), null);
            txControl.getCurrentContext().registerXAResource(xaConn2.getXAResource(), null);
            Connection conn = xaConn.getConnection();
            // conn.setAutoCommit(false);
            Connection conn2 = xaConn2.getConnection();
            conn2.setAutoCommit(false);
            conn.createStatement().execute("Insert into TEST_TABLE values ( 'Hello World!' )");
            return conn2.createStatement().execute("Insert into TEST_TABLE values ( 'Hello World 2!' )");
        });
    } finally {
        xaConn.close();
    }
    try (Connection conn = dataSource.getConnection()) {
        ResultSet rs = conn.createStatement().executeQuery("Select * from TEST_TABLE order by message DESC");
        rs.next();
        assertEquals("Hello World!", rs.getString(1));
        rs.next();
        assertEquals("Hello World 2!", rs.getString(1));
        assertFalse(rs.next());
    }
}

Example 72 with XAConnection

use of javax.sql.XAConnection in project warn-report by saaavsaaa.

the class DistributeTransaction method getDatabaseConnection.

Connection getDatabaseConnection(XAConnection xacon) {
    Connection con = null;
    try {
        System.out.print("Establish database connection: ");
        con = xacon.getConnection();
        con.setAutoCommit(false);
        System.out.println("Okay.");
    } catch (SQLException e) {
        sqlerr(e);
    }
    return con;
}

Example 73 with XAConnection

use of javax.sql.XAConnection in project jaybird by FirebirdSQL.

the class TestFBXADataSource method testInDistributed_setAutoCommit_true_inAutoCommit.

/**
 * Tests if setting autoCommit(true) when autoCommit is true throws an exception when participating in a distributed transaction (JDBC 4.0 section 12.4).
 */
@Test
public void testInDistributed_setAutoCommit_true_inAutoCommit() throws Exception {
    XAConnection pc = getXAConnection();
    XAResource xa = pc.getXAResource();
    Xid xid = new XidImpl();
    try (Connection con = pc.getConnection()) {
        con.setAutoCommit(true);
        xa.start(xid, XAResource.TMNOFLAGS);
        expectedException.expect(SQLException.class);
        expectedException.expect(sqlStateEquals(SQLStateConstants.SQL_STATE_INVALID_TX_STATE));
        con.setAutoCommit(true);
    } finally {
        xa.end(xid, XAResource.TMSUCCESS);
        xa.rollback(xid);
    }
}

Example 74 with XAConnection

use of javax.sql.XAConnection in project jaybird by FirebirdSQL.

the class TestFBXADataSource method testInDistributed_setSavepoint.

/**
 * Test if calling setSavePoint (no param) throws an exception when participating in a distributed transaction (JDBC 4.0 section 12.4).
 */
@Test
public void testInDistributed_setSavepoint() throws Exception {
    XAConnection pc = getXAConnection();
    XAResource xa = pc.getXAResource();
    Xid xid = new XidImpl();
    try (Connection con = pc.getConnection()) {
        con.setAutoCommit(false);
        xa.start(xid, XAResource.TMNOFLAGS);
        expectedException.expect(SQLException.class);
        expectedException.expect(sqlStateEquals(SQLStateConstants.SQL_STATE_INVALID_TX_STATE));
        con.setSavepoint();
    } finally {
        xa.end(xid, XAResource.TMSUCCESS);
        xa.rollback(xid);
    }
}

Example 75 with XAConnection

use of javax.sql.XAConnection in project jaybird by FirebirdSQL.

the class TestFBXADataSource method testInDistributed_commit.

/**
 * Test if calling commit throws an exception when participating in a distributed transaction (JDBC 4.0 section 12.4).
 */
@Test
public void testInDistributed_commit() throws Exception {
    XAConnection pc = getXAConnection();
    XAResource xa = pc.getXAResource();
    Xid xid = new XidImpl();
    try (Connection con = pc.getConnection()) {
        con.setAutoCommit(false);
        xa.start(xid, XAResource.TMNOFLAGS);
        expectedException.expect(SQLException.class);
        expectedException.expect(sqlStateEquals(SQLStateConstants.SQL_STATE_INVALID_TX_STATE));
        con.commit();
    } finally {
        xa.end(xid, XAResource.TMSUCCESS);
        xa.rollback(xid);
    }
}