success &= dropTable(stmt, "TXN_COMPONENTS", retryCount); success &= dropTable(stmt, "COMPLETED_TXN_COMPONENTS", retryCount); success &= dropTable(stmt, "TXNS", retryCount); success &= dropTable(stmt, "NEXT_TXN_ID", retryCount); success &= dropTable(stmt, "TXN_TO_WRITE_ID", retryCount); success &= dropTable(stmt, "NEXT_WRITE_ID", retryCount); success &= dropTable(stmt, "MIN_HISTORY_LEVEL", retryCount); success &= dropTable(stmt, "HIVE_LOCKS", retryCount); success &= dropTable(stmt, "NEXT_LOCK_ID", retryCount); success &= dropTable(stmt, "COMPACTION_QUEUE", retryCount); success &= dropTable(stmt, "NEXT_COMPACTION_QUEUE_ID", retryCount); success &= dropTable(stmt, "COMPLETED_COMPACTIONS", retryCount); success &= dropTable(stmt, "AUX_TABLE", retryCount); success &= dropTable(stmt, "WRITE_SET", retryCount); success &= dropTable(stmt, "REPL_TXN_MAP", retryCount); success &= dropTable(stmt, "MATERIALIZATION_REBUILD_LOCKS", retryCount);
public static void cleanDb() throws Exception { Connection conn = null; Statement stmt = null; try { conn = getConnection(); stmt = conn.createStatement(); // We want to try these, whether they succeed or fail. try { stmt.execute("DROP INDEX HL_TXNID_INDEX"); } catch (Exception e) { System.err.println("Unable to drop index HL_TXNID_INDEX " + e.getMessage()); } dropTable(stmt, "TXN_COMPONENTS"); dropTable(stmt, "COMPLETED_TXN_COMPONENTS"); dropTable(stmt, "TXNS"); dropTable(stmt, "NEXT_TXN_ID"); dropTable(stmt, "HIVE_LOCKS"); dropTable(stmt, "NEXT_LOCK_ID"); dropTable(stmt, "COMPACTION_QUEUE"); dropTable(stmt, "NEXT_COMPACTION_QUEUE_ID"); conn.commit(); } finally { closeResources(conn, stmt, null); } }
public static void cleanDb() throws Exception { Connection conn = null; Statement stmt = null; try { conn = getConnection(); stmt = conn.createStatement(); // We want to try these, whether they succeed or fail. try { stmt.execute("DROP INDEX HL_TXNID_INDEX"); } catch (Exception e) { System.err.println("Unable to drop index HL_TXNID_INDEX " + e.getMessage()); } dropTable(stmt, "TXN_COMPONENTS"); dropTable(stmt, "COMPLETED_TXN_COMPONENTS"); dropTable(stmt, "TXNS"); dropTable(stmt, "NEXT_TXN_ID"); dropTable(stmt, "HIVE_LOCKS"); dropTable(stmt, "NEXT_LOCK_ID"); dropTable(stmt, "COMPACTION_QUEUE"); dropTable(stmt, "NEXT_COMPACTION_QUEUE_ID"); conn.commit(); } finally { closeResources(conn, stmt, null); } }
success &= dropTable(stmt, "TXN_COMPONENTS", retryCount); success &= dropTable(stmt, "COMPLETED_TXN_COMPONENTS", retryCount); success &= dropTable(stmt, "TXNS", retryCount); success &= dropTable(stmt, "NEXT_TXN_ID", retryCount); success &= dropTable(stmt, "TXN_TO_WRITE_ID", retryCount); success &= dropTable(stmt, "NEXT_WRITE_ID", retryCount); success &= dropTable(stmt, "MIN_HISTORY_LEVEL", retryCount); success &= dropTable(stmt, "HIVE_LOCKS", retryCount); success &= dropTable(stmt, "NEXT_LOCK_ID", retryCount); success &= dropTable(stmt, "COMPACTION_QUEUE", retryCount); success &= dropTable(stmt, "NEXT_COMPACTION_QUEUE_ID", retryCount); success &= dropTable(stmt, "COMPLETED_COMPACTIONS", retryCount); success &= dropTable(stmt, "AUX_TABLE", retryCount); success &= dropTable(stmt, "WRITE_SET", retryCount); success &= dropTable(stmt, "REPL_TXN_MAP", retryCount);