How to use

DbTransactionMode

in

jodd.db

  /**
   * Converter JTX transaction mode to DB transaction mode.
   */
  public static DbTransactionMode convertToDbMode(final JtxTransactionMode txMode) {
    final int isolation;
    switch (txMode.getIsolationLevel()) {
      case ISOLATION_DEFAULT: isolation = DbTransactionMode.ISOLATION_DEFAULT; break;
      case ISOLATION_NONE: isolation = DbTransactionMode.ISOLATION_NONE; break;
      case ISOLATION_READ_COMMITTED: isolation = DbTransactionMode.ISOLATION_READ_COMMITTED; break;
      case ISOLATION_READ_UNCOMMITTED: isolation = DbTransactionMode.ISOLATION_READ_UNCOMMITTED; break;
      case ISOLATION_REPEATABLE_READ: isolation = DbTransactionMode.ISOLATION_REPEATABLE_READ; break;
      case ISOLATION_SERIALIZABLE: isolation = DbTransactionMode.ISOLATION_SERIALIZABLE; break;
      default:
        throw new IllegalArgumentException();
    }
    return new DbTransactionMode(isolation, txMode.isReadOnly());
  }
}

@Override
public boolean equals(final Object object) {
  if (this == object) {
    return true;
  }
  if (this.getClass() != object.getClass()) {
    return false;
  }
  DbTransactionMode mode = (DbTransactionMode) object;
  return  (mode.getIsolation() == this.isolation) &&
      (mode.isReadOnly() == this.readOnlyMode);
}

  /**
   * Convert JTX transaction mode to DB transaction mode.
   */
  public static DbTransactionMode convertToDbMode(JtxTransactionMode txMode) {
    int isolation = -1;
    switch (txMode.getIsolationLevel()) {
      case ISOLATION_DEFAULT: isolation = DbTransactionMode.ISOLATION_DEFAULT; break;
      case ISOLATION_NONE: isolation = DbTransactionMode.ISOLATION_NONE; break;
      case ISOLATION_READ_COMMITTED: isolation = DbTransactionMode.ISOLATION_READ_COMMITTED; break;
      case ISOLATION_READ_UNCOMMITTED: isolation = DbTransactionMode.ISOLATION_READ_UNCOMMITTED; break;
      case ISOLATION_REPEATABLE_READ: isolation = DbTransactionMode.ISOLATION_REPEATABLE_READ; break;
      case ISOLATION_SERIALIZABLE: isolation = DbTransactionMode.ISOLATION_SERIALIZABLE; break;
    }
    DbTransactionMode result = new DbTransactionMode();
    result.setIsolation(isolation);
    result.setReadOnly(txMode.isReadOnly());
    return result;
  }
}

@ParameterizedTest
@MethodSource(value = "testData_testConvertToDbMode")
void testConvertToDbMode(final DbTransactionMode expected, final JtxTransactionMode input) {
  final DbTransactionMode actual = JtxDbUtil.convertToDbMode(input);
  // asserts
  assertNotNull(actual);
  assertTrue(expected.equals(actual));
}

/**
 * Opens a transaction.
 */
protected void openTx() {
  if (connection == null) {
    connection = connectionProvider.getConnection();
  }
  txActive = true;
  try {
    connection.setAutoCommit(false);
    if (txMode.getIsolation() != DbTransactionMode.ISOLATION_DEFAULT) {
      connection.setTransactionIsolation(txMode.getIsolation());
    }
    connection.setReadOnly(txMode.isReadOnly());
  } catch (SQLException sex) {
    throw new DbSqlException("Open TX failed", sex);
  }
}

  JtxTransactionMode.DEFAULT_TIMEOUT);
DbTransactionMode dbTransactionMode = new DbTransactionMode(DbTransactionMode.ISOLATION_DEFAULT, readonly);
  JtxTransactionMode.DEFAULT_TIMEOUT);
DbTransactionMode dbTransactionMode = new DbTransactionMode(DbTransactionMode.ISOLATION_NONE, readonly);
  JtxTransactionMode.DEFAULT_TIMEOUT);
DbTransactionMode dbTransactionMode = new DbTransactionMode(DbTransactionMode.ISOLATION_READ_COMMITTED, readonly);
  JtxTransactionMode.DEFAULT_TIMEOUT);
DbTransactionMode dbTransactionMode = new DbTransactionMode(DbTransactionMode.ISOLATION_READ_UNCOMMITTED,readonly);
  JtxTransactionMode.DEFAULT_TIMEOUT);
DbTransactionMode dbTransactionMode = new DbTransactionMode(DbTransactionMode.ISOLATION_REPEATABLE_READ, readonly);
  JtxTransactionMode.DEFAULT_TIMEOUT);
DbTransactionMode dbTransactionMode = new DbTransactionMode(DbTransactionMode.ISOLATION_SERIALIZABLE, readonly);

@Override
public boolean equals(Object object) {
  if (this == object) {
    return true;
  }
  if (!(object instanceof DbTransactionMode)) {
    return false;
  }
  DbTransactionMode mode = (DbTransactionMode) object;
  return  (mode.getIsolation() == this.isolation) &&
      (mode.isReadOnly() == this.readOnlyMode);
}

  /**
   * Converter JTX transaction mode to DB transaction mode.
   */
  public static DbTransactionMode convertToDbMode(final JtxTransactionMode txMode) {
    final int isolation;
    switch (txMode.getIsolationLevel()) {
      case ISOLATION_DEFAULT: isolation = DbTransactionMode.ISOLATION_DEFAULT; break;
      case ISOLATION_NONE: isolation = DbTransactionMode.ISOLATION_NONE; break;
      case ISOLATION_READ_COMMITTED: isolation = DbTransactionMode.ISOLATION_READ_COMMITTED; break;
      case ISOLATION_READ_UNCOMMITTED: isolation = DbTransactionMode.ISOLATION_READ_UNCOMMITTED; break;
      case ISOLATION_REPEATABLE_READ: isolation = DbTransactionMode.ISOLATION_REPEATABLE_READ; break;
      case ISOLATION_SERIALIZABLE: isolation = DbTransactionMode.ISOLATION_SERIALIZABLE; break;
      default:
        throw new IllegalArgumentException();
    }
    return new DbTransactionMode(isolation, txMode.isReadOnly());
  }
}

@Override
public boolean equals(final Object object) {
  if (this == object) {
    return true;
  }
  if (this.getClass() != object.getClass()) {
    return false;
  }
  DbTransactionMode mode = (DbTransactionMode) object;
  return  (mode.getIsolation() == this.isolation) &&
      (mode.isReadOnly() == this.readOnlyMode);
}

/**
 * Opens a transaction.
 */
protected void openTx() {
  if (connection == null) {
    connection = connectionProvider.getConnection();
  }
  txActive = true;
  try {
    connection.setAutoCommit(false);
    if (txMode.getIsolation() != DbTransactionMode.ISOLATION_DEFAULT) {
      connection.setTransactionIsolation(txMode.getIsolation());
    }
    connection.setReadOnly(txMode.isReadOnly());
  } catch (SQLException sex) {
    throw new DbSqlException("Unable to open and prepare transaction.", sex);
  }
}

/**
 * Opens a transaction.
 */
protected void openTx() {
  if (connection == null) {
    connection = connectionProvider.getConnection();
  }
  txActive = true;
  try {
    connection.setAutoCommit(false);
    if (txMode.getIsolation() != DbTransactionMode.ISOLATION_DEFAULT) {
      connection.setTransactionIsolation(txMode.getIsolation());
    }
    connection.setReadOnly(txMode.isReadOnly());
  } catch (SQLException sex) {
    throw new DbSqlException("Open TX failed", sex);
  }
}