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

Example 1 with DbJtxTransactionManager

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

the class DbH2TestCase method setUp.

@Before
public void setUp() throws Exception {
    LoggerFactory.setLoggerFactory(new TestLoggerFactory());
    if (dbtxm != null) {
        return;
    }
    cp = new CoreConnectionPool();
    cp.setDriver("org.h2.Driver");
    cp.setUrl("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1");
    cp.setUser("sa");
    cp.setPassword("");
    cp.init();
    dbtxm = new DbJtxTransactionManager(cp);
}

Example 2 with DbJtxTransactionManager

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

the class DbHsqldbTestCase method setUp.

@Before
public void setUp() throws Exception {
    DbManager.getInstance().setQueryMap(new DbPropsQueryMap());
    LoggerFactory.setLoggerFactory(new TestLoggerFactory());
    cp = new CoreConnectionPool();
    cp.setDriver("org.hsqldb.jdbcDriver");
    cp.setUrl("jdbc:hsqldb:mem:test");
    cp.setUser("sa");
    cp.setPassword("");
    cp.init();
    dbtxm = new DbJtxTransactionManager(cp);
    // initial data
    DbSession session = new DbSession(cp);
    createTables(session);
    session.closeSession();
}

Example 3 with DbJtxTransactionManager

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

the class DbJtxTransactionManagerTest method testSessionProvider.

@Test
public void testSessionProvider() {
    // prepare
    JtxTransactionManager jtxManager = new DbJtxTransactionManager(cp);
    DbJtxSessionProvider sessionProvider = new DbJtxSessionProvider(jtxManager);
    DbManager.getInstance().setSessionProvider(sessionProvider);
    for (int i = 0; i < 2; i++) {
        // start, 0 transactions, no session
        assertEquals(0, jtxManager.totalTransactions());
        // start transaction
        jtxManager.requestTransaction(new JtxTransactionMode());
        // get session from provider!
        DbSession dbSession = sessionProvider.getDbSession();
        assertNotNull(dbSession);
        // transaction started, but connection not yet fetched as it is not used yet
        assertEquals(1, jtxManager.totalTransactions());
        assertEquals(0, cp.getConnectionsCount().getBusyCount());
        // same session as it is the same transaction
        DbSession dbSession2 = sessionProvider.getDbSession();
        assertNotNull(dbSession2);
        assertSame(dbSession, dbSession2);
        // create query, session is get from provider, the very same one
        DbQuery dbQuery = new DbQuery("SELECT 173 FROM (VALUES(0))");
        long value = dbQuery.executeCount();
        assertEquals(173, value);
        assertSame(dbSession, dbQuery.getSession());
        // transaction still active, connection still in use
        assertEquals(1, jtxManager.totalTransactions());
        assertEquals(1, cp.getConnectionsCount().getBusyCount());
        // close query
        dbQuery.close();
        // transaction still active, connection still in use (!)
        // since session is still active
        assertEquals(1, jtxManager.totalTransactions());
        assertEquals(1, cp.getConnectionsCount().getBusyCount());
        assertTrue(!dbQuery.getSession().isSessionClosed());
        // commit transaction...
        jtxManager.getTransaction().commit();
        // no transaction
        assertEquals(0, jtxManager.totalTransactions());
        // session is closed
        assertTrue(dbSession.isSessionClosed());
        // connection is returned
        assertEquals(0, cp.getConnectionsCount().getBusyCount());
    }
}

Example 4 with DbJtxTransactionManager

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

the class DbHsqldbTestCase method setUp.

@Before
public void setUp() throws Exception {
    cp = new CoreConnectionPool();
    cp.setDriver("org.hsqldb.jdbcDriver");
    cp.setUrl("jdbc:hsqldb:mem:test");
    cp.setUser("sa");
    cp.setPassword("");
    cp.init();
    dbtxm = new DbJtxTransactionManager(cp);
    // initial data
    DbSession session = new DbSession(cp);
    executeUpdate(session, "drop table BOY if exists");
    executeUpdate(session, "drop table GIRL if exists");
    String sql = "create table GIRL (" + "ID			integer		not null," + "NAME		varchar(20)	not null," + "SPECIALITY	varchar(20)	null," + "primary key (ID)" + ')';
    executeUpdate(session, sql);
    sql = "create table BOY (" + "ID			integer	not null," + "GIRL_ID	integer	null," + "NAME	varchar(20)	null," + "primary key (ID)," + "FOREIGN KEY (GIRL_ID) REFERENCES GIRL (ID)" + ')';
    executeUpdate(session, sql);
    session.closeSession();
}