Examples with DbJtxSessionProvider jodd.db.jtx.DbJtxSessionProvider used on opensource projects

Example 11 with DbJtxSessionProvider

use of jodd.db.jtx.DbJtxSessionProvider 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();
}

Example 12 with DbJtxSessionProvider

use of jodd.db.jtx.DbJtxSessionProvider in project jodd by oblac.

the class DbPropagationTest method testRequired.

@Test
public void testRequired() {
    LeanJtxWorker worker = new LeanJtxWorker(dbtxm);
    DbJtxSessionProvider sessionProvider = new DbJtxSessionProvider(worker.getTransactionManager());
    // session #1: required - commit
    JtxTransaction jtx = worker.maybeRequestTransaction(required(), CTX_1);
    assertTrue(jtx.isActive());
    assertNotNull(jtx);
    DbSession session = sessionProvider.getDbSession();
    executeUpdate(session, "insert into GIRL values(1, 'Sophia', null)");
    assertTrue(jtx.isActive());
    assertFalse(jtx.isCommitted());
    assertFalse(jtx.isNoTransaction());
    assertTrue(worker.maybeCommitTransaction(jtx));
    assertFalse(jtx.isActive());
    assertTrue(jtx.isCommitted());
    assertFalse(jtx.isNoTransaction());
    // session #2: required - rollback
    jtx = worker.maybeRequestTransaction(required(), CTX_1);
    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(0, executeCount(session, "select count(*) from GIRL where id = 2"));
    session.closeSession();
}

Example 13 with DbJtxSessionProvider

use of jodd.db.jtx.DbJtxSessionProvider in project jodd by oblac.

the class DbPropagationTest method testSupportsToSupportsCommit.

@Test
public void testSupportsToSupportsCommit() {
    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, 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));
    assertFalse(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();
}

Example 14 with DbJtxSessionProvider

use of jodd.db.jtx.DbJtxSessionProvider in project jodd by oblac.

the class DbPropagationTest method testRequiredToMandatoryCommit.

@Test
public void testRequiredToMandatoryCommit() {
    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, mandatory
    JtxTransaction jtx2 = worker.maybeRequestTransaction(mandatory(), 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();
}

Example 15 with DbJtxSessionProvider

use of jodd.db.jtx.DbJtxSessionProvider in project jodd by oblac.

the class DefaultAppCore method startDb.

/**
	 * Initializes database. First, creates connection pool.
	 * and transaction manager. Then, Jodds DbOomManager is
	 * configured. It is also configured automagically, by scanning
	 * the class path for entities.
	 */
@SuppressWarnings("unchecked")
protected void startDb() {
    if (!useDatabase) {
        log.info("database is not used");
        return;
    }
    log.info("database initialization");
    // connection pool
    connectionProvider = createConnectionProvider();
    petite.addBean(PETITE_DBPOOL, connectionProvider);
    connectionProvider.init();
    checkConnectionProvider();
    // transactions manager
    jtxManager = createJtxTransactionManager(connectionProvider);
    jtxManager.setValidateExistingTransaction(true);
    AnnotationTxAdviceManager annTxAdviceManager = new AnnotationTxAdviceManager(jtxManager, jtxScopePattern);
    annTxAdviceManager.registerAnnotations(jtxAnnotations);
    AnnotationTxAdviceSupport.manager = annTxAdviceManager;
    DbSessionProvider sessionProvider = new DbJtxSessionProvider(jtxManager);
    // global settings
    DbManager dbManager = DbManager.getInstance();
    dbManager.setConnectionProvider(connectionProvider);
    dbManager.setSessionProvider(sessionProvider);
    petite.addBean(PETITE_DB, dbManager);
    DbOomManager dbOomManager = DbOomManager.getInstance();
    petite.addBean(PETITE_DBOOM, dbOomManager);
    // automatic configuration
    registerDbEntities(dbOomManager);
}