Search in sources :

Example 11 with JtxTransaction

use of jodd.jtx.JtxTransaction in project jodd by oblac.

the class DbPropagationTest method testRequiredToNever.

@Test
public void testRequiredToNever() {
    LeanJtxWorker worker = new LeanJtxWorker(dbtxm);
    DbJtxSessionProvider sessionProvider = new DbJtxSessionProvider(worker.getTransactionManager());
    // session #1: required
    JtxTransaction jtx = worker.maybeRequestTransaction(required(), CTX_1);
    assertNotNull(jtx);
    DbSession session1 = sessionProvider.getDbSession();
    executeUpdate(session1, "insert into GIRL values(1, 'Sophia', null)");
    assertTrue(jtx.isActive());
    assertFalse(jtx.isCommitted());
    assertFalse(jtx.isNoTransaction());
    // session #2: inner, never
    try {
        worker.maybeRequestTransaction(never(), CTX_2);
        fail();
    } catch (JtxException ignore) {
    }
}
Also used : LeanJtxWorker(jodd.jtx.worker.LeanJtxWorker) DbJtxSessionProvider(jodd.db.jtx.DbJtxSessionProvider) JtxException(jodd.jtx.JtxException) JtxTransaction(jodd.jtx.JtxTransaction) Test(org.junit.Test)

Example 12 with JtxTransaction

use of jodd.jtx.JtxTransaction in project jodd by oblac.

the class DbPropagationTest method testSupportsNone.

@Test
public void testSupportsNone() {
    LeanJtxWorker worker = new LeanJtxWorker(dbtxm);
    DbJtxSessionProvider sessionProvider = new DbJtxSessionProvider(worker.getTransactionManager());
    // session #1: supports - commit
    JtxTransaction jtx = worker.maybeRequestTransaction(supports(), CTX_1);
    assertNotNull(jtx);
    DbSession session = sessionProvider.getDbSession();
    executeUpdate(session, "insert into GIRL values(1, 'Sophia', null)");
    assertFalse(jtx.isActive());
    assertFalse(jtx.isCommitted());
    assertTrue(jtx.isNoTransaction());
    assertTrue(worker.maybeCommitTransaction(jtx));
    assertFalse(jtx.isActive());
    assertTrue(jtx.isCommitted());
    // session #2: required - rollback
    jtx = worker.maybeRequestTransaction(supports(), CTX_2);
    assertNotNull(jtx);
    session = sessionProvider.getDbSession();
    executeUpdate(session, "insert into GIRL values(2, 'Gloria', null)");
    assertTrue(worker.markOrRollbackTransaction(jtx, null));
    // test
    session = new DbSession(cp);
    assertEquals(1, executeCount(session, "select count(*) from GIRL where id = 1"));
    assertEquals(1, executeCount(session, "select count(*) from GIRL where id = 2"));
    session.closeSession();
}
Also used : LeanJtxWorker(jodd.jtx.worker.LeanJtxWorker) DbJtxSessionProvider(jodd.db.jtx.DbJtxSessionProvider) JtxTransaction(jodd.jtx.JtxTransaction) Test(org.junit.Test)

Example 13 with JtxTransaction

use of jodd.jtx.JtxTransaction in project jodd by oblac.

the class DbPropagationTest method testSupportsToRequiresNewCommit.

/*
	public void testRequiredToRequiredNewCommit() {
		LeanJtxWorker worker = new LeanJtxWorker(dbtxm);
		DbJtxSessionProvider sessionProvider = new DbJtxSessionProvider(worker.getTransactionManager());

		// session #1: required
		JtxTransaction jtx = worker.maybeRequestTransaction(required(), CTX_1);
		assertNotNull(jtx);
		DbSession session1 = sessionProvider.getDbSession();

		executeUpdate(session1, "insert into GIRL values(1, 'Sophia', null)");
		assertTrue(jtx.isActive());
		assertFalse(jtx.isCommitted());
		assertFalse(jtx.isNoTransaction());


		// session #2: inner, required new
		// important - have to be in different context!
		JtxTransaction jtx2 = worker.maybeRequestTransaction(requiredNew(), CTX_2);
		assertNotNull(jtx2);
		DbSession session2 = sessionProvider.getDbSession();
		assertNotSame(session1, session2);
		executeUpdate(session2, "insert into GIRL values(2, 'Gloria', null)");
		assertTrue(worker.maybeCommitTransaction(jtx2));
		assertFalse(jtx2.isActive());
		assertTrue(jtx2.isCommitted());

		// session #1: commit
		assertTrue(worker.maybeCommitTransaction(jtx));
		assertFalse(jtx.isActive());
		assertTrue(jtx.isCommitted());

		// test
		session1 = new DbSession(cp);
		assertEquals(1, executeCount(session1, "select count(*) from GIRL where id = 1"));
		assertEquals(1, executeCount(session1, "select count(*) from GIRL where id = 2"));
		session1.closeSession();
	}
*/
/*
	public void testRequiredToRequiredNewRollback() {
		LeanJtxWorker worker = new LeanJtxWorker(dbtxm);
		DbJtxSessionProvider sessionProvider = new DbJtxSessionProvider(worker.getTransactionManager());

		// session #1: required
		JtxTransaction jtx = worker.maybeRequestTransaction(required(), CTX_1);
		assertNotNull(jtx);
		DbSession session1 = sessionProvider.getDbSession();

		executeUpdate(session1, "insert into GIRL values(1, 'Sophia', null)");
		assertTrue(jtx.isActive());
		assertFalse(jtx.isCommitted());
		assertFalse(jtx.isNoTransaction());


		// session #2: inner, required new
		// important - have to be in different context!
		JtxTransaction jtx2 = worker.maybeRequestTransaction(requiredNew(), CTX_2);
		assertFalse(worker.getTransactionManager().isIgnoreScope());
		assertNotNull(jtx2);
		DbSession session2 = sessionProvider.getDbSession();
		assertNotSame(session1, session2);
		executeUpdate(session2, "insert into GIRL values(2, 'Gloria', null)");
		assertTrue(worker.markOrRollbackTransaction(jtx2, null));
		assertFalse(jtx2.isActive());
		assertFalse(jtx2.isCommitted());
		assertTrue(jtx2.isRolledback());

		// session #1: commit
		assertTrue(worker.maybeCommitTransaction(jtx));
		assertFalse(jtx.isActive());
		assertTrue(jtx.isCommitted());

		// test
		session1 = new DbSession(cp);
		assertEquals(1, executeCount(session1, "select count(*) from GIRL where id = 1"));
		assertEquals(0, executeCount(session1, "select count(*) from GIRL where id = 2"));
		session1.closeSession();
	}
*/
@Test
public void testSupportsToRequiresNewCommit() {
    LeanJtxWorker worker = new LeanJtxWorker(dbtxm);
    DbJtxSessionProvider sessionProvider = new DbJtxSessionProvider(worker.getTransactionManager());
    // session #1: supports
    JtxTransaction jtx = worker.maybeRequestTransaction(supports(), CTX_1);
    assertNotNull(jtx);
    assertFalse(jtx.isActive());
    DbSession session1 = sessionProvider.getDbSession();
    executeUpdate(session1, "insert into GIRL values(1, 'Sophia', null)");
    assertFalse(jtx.isActive());
    assertFalse(jtx.isCommitted());
    assertTrue(jtx.isNoTransaction());
    // session #2: inner, required
    JtxTransaction jtx2 = worker.maybeRequestTransaction(requiredNew(), CTX_2);
    assertNotNull(jtx2);
    DbSession session2 = sessionProvider.getDbSession();
    assertNotSame(session1, session2);
    executeUpdate(session2, "insert into GIRL values(2, 'Gloria', null)");
    assertTrue(worker.maybeCommitTransaction(jtx2));
    assertFalse(jtx2.isActive());
    // session #1: rollback
    assertTrue(worker.markOrRollbackTransaction(jtx, null));
    assertFalse(jtx.isActive());
    assertFalse(jtx.isCommitted());
    // test
    session1 = new DbSession(cp);
    assertEquals(1, executeCount(session1, "select count(*) from GIRL where id = 1"));
    assertEquals(1, executeCount(session1, "select count(*) from GIRL where id = 2"));
    session1.closeSession();
}
Also used : LeanJtxWorker(jodd.jtx.worker.LeanJtxWorker) DbJtxSessionProvider(jodd.db.jtx.DbJtxSessionProvider) JtxTransaction(jodd.jtx.JtxTransaction) Test(org.junit.Test)

Example 14 with JtxTransaction

use of jodd.jtx.JtxTransaction in project jodd by oblac.

the class DbPropagationTest method testRequiredToSupportsCommit.

@Test
public void testRequiredToSupportsCommit() {
    LeanJtxWorker worker = new LeanJtxWorker(dbtxm);
    DbJtxSessionProvider sessionProvider = new DbJtxSessionProvider(worker.getTransactionManager());
    // session #1: required
    JtxTransaction jtx = worker.maybeRequestTransaction(required(), CTX_1);
    assertNotNull(jtx);
    DbSession session1 = sessionProvider.getDbSession();
    executeUpdate(session1, "insert into GIRL values(1, 'Sophia', null)");
    assertTrue(jtx.isActive());
    assertFalse(jtx.isCommitted());
    assertFalse(jtx.isNoTransaction());
    // session #2: inner, supports
    JtxTransaction jtx2 = worker.maybeRequestTransaction(supports(), CTX_2);
    assertNull(jtx2);
    DbSession session2 = sessionProvider.getDbSession();
    assertSame(session1, session2);
    executeUpdate(session2, "insert into GIRL values(2, 'Gloria', null)");
    assertFalse(worker.maybeCommitTransaction(jtx2));
    assertTrue(jtx.isActive());
    // session #1: commit
    assertTrue(worker.maybeCommitTransaction(jtx));
    assertFalse(jtx.isActive());
    assertTrue(jtx.isCommitted());
    // test
    session1 = new DbSession(cp);
    assertEquals(1, executeCount(session1, "select count(*) from GIRL where id = 1"));
    assertEquals(1, executeCount(session1, "select count(*) from GIRL where id = 2"));
    session1.closeSession();
}
Also used : LeanJtxWorker(jodd.jtx.worker.LeanJtxWorker) DbJtxSessionProvider(jodd.db.jtx.DbJtxSessionProvider) JtxTransaction(jodd.jtx.JtxTransaction) Test(org.junit.Test)

Example 15 with JtxTransaction

use of jodd.jtx.JtxTransaction in project jodd by oblac.

the class DbPropagationTest method testRequiredToRequiredCommit.

@Test
public void testRequiredToRequiredCommit() {
    LeanJtxWorker worker = new LeanJtxWorker(dbtxm);
    DbJtxSessionProvider sessionProvider = new DbJtxSessionProvider(worker.getTransactionManager());
    // session #1: required
    JtxTransaction jtx = worker.maybeRequestTransaction(required(), CTX_1);
    assertNotNull(jtx);
    DbSession session1 = sessionProvider.getDbSession();
    executeUpdate(session1, "insert into GIRL values(1, 'Sophia', null)");
    assertTrue(jtx.isActive());
    assertFalse(jtx.isCommitted());
    assertFalse(jtx.isNoTransaction());
    // session #2: inner, required
    JtxTransaction jtx2 = worker.maybeRequestTransaction(required(), CTX_2);
    assertNull(jtx2);
    DbSession session2 = sessionProvider.getDbSession();
    assertSame(session1, session2);
    executeUpdate(session2, "insert into GIRL values(2, 'Gloria', null)");
    assertFalse(worker.maybeCommitTransaction(jtx2));
    assertTrue(jtx.isActive());
    // session #1: commit
    assertTrue(worker.maybeCommitTransaction(jtx));
    assertFalse(jtx.isActive());
    assertTrue(jtx.isCommitted());
    // test
    session1 = new DbSession(cp);
    assertEquals(1, executeCount(session1, "select count(*) from GIRL where id = 1"));
    assertEquals(1, executeCount(session1, "select count(*) from GIRL where id = 2"));
    session1.closeSession();
}
Also used : LeanJtxWorker(jodd.jtx.worker.LeanJtxWorker) DbJtxSessionProvider(jodd.db.jtx.DbJtxSessionProvider) JtxTransaction(jodd.jtx.JtxTransaction) Test(org.junit.Test)

Aggregations

JtxTransaction (jodd.jtx.JtxTransaction)21 Test (org.junit.Test)18 DbJtxSessionProvider (jodd.db.jtx.DbJtxSessionProvider)13 LeanJtxWorker (jodd.jtx.worker.LeanJtxWorker)13 DbJtxTransaction (jodd.db.jtx.DbJtxTransaction)5 JtxTransactionMode (jodd.jtx.JtxTransactionMode)5 DbJtxResourceManager (jodd.db.jtx.DbJtxResourceManager)4 JtxException (jodd.jtx.JtxException)4 JtxTransactionManager (jodd.jtx.JtxTransactionManager)4 SQLException (java.sql.SQLException)1 AppDao (jodd.joy.db.AppDao)1 Madvoc (jodd.madvoc.Madvoc)1 ProxyTarget.targetClass (jodd.proxetta.ProxyTarget.targetClass)1