How to use

jodd.db.jtx.DbJtxTransactionManager

constructor

/**
 * Creates JTX transaction manager.
 */
protected JtxTransactionManager createJtxTransactionManager(final ConnectionProvider connectionProvider) {
  return new DbJtxTransactionManager(connectionProvider);
}

@BeforeEach
protected void setUp() throws Exception {
  final DbPropsQueryMap queryMap = new DbPropsQueryMap();
  if (SystemUtil.info().isJavaVersion(9)) {
    queryMap.props().load(this.getClass().getClassLoader().getResourceAsStream("queries.sql.props"));
  }
  LoggerFactory.setLoggerProvider(new TestLoggerProvider());
  if (dbtxm != null) {
    return;
  }
  // create connection pool if not created
  if (cp == null) {
    cp = new CoreConnectionPool();
    setupPool(cp);
    cp.init();
  }
  dbtxm = new DbJtxTransactionManager(cp);
  dbOom = DbOom
    .create()
    .withConnectionProvider(cp)
    .withQueryMap(queryMap)
    .get()
    .connect();
  // initial data
  final DbSession session = new DbSession(cp);
  initDb(session);
  session.closeSession();
}

@BeforeEach
void setUp() {
  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();
}

/**
 * Creates JTX transaction manager.
 */
protected JtxTransactionManager createJtxTransactionManager(final ConnectionProvider connectionProvider) {
  return new DbJtxTransactionManager(connectionProvider);
}

super.setupPool(cp);
JtxTransactionManager jtxManager = new DbJtxTransactionManager(cp);
DbJtxSessionProvider sessionProvider = new DbJtxSessionProvider(jtxManager);