private void deleteTransactionId(long minTxnId, long maxTxnId) throws SQLException {
    DataSourceProvider dsp = DataSourceProviderFactory.tryGetDataSourceProviderOrNull(conf);
    DataSource ds = dsp.create(conf);
    Connection dbConn = ds.getConnection();
    Statement stmt = dbConn.createStatement();
    stmt.executeUpdate("DELETE FROM TXNS WHERE TXN_ID >=" + minTxnId + " AND TXN_ID <=" + maxTxnId);
    dbConn.commit();
    stmt.close();
    dbConn.close();
  }
Tests to check the ACID properties and isolation level requirements.
ql/src/test/org/apache/hadoop/hive/ql/lockmgr/TestDbTxnManagerIsolationProperties.java