private void dropTriggers() throws SQLException {
  String sql="select trigger_name from user_triggers order by trigger_name";
  ResultSet rs=stmtdb1.executeQuery(sql);
  while (rs.next()) {
    m_dropTriggerStatements.add("DROP " + rs.getString("TRIGGER_NAME") + ";");
  }
  rs.close();
}

private void dropTriggers ( ) throws SQLException { String sql = "select trigger_name from user_triggers order by trigger_name" ; ResultSet rs = stmtdb1 . executeQuery ( sql ) ; while ( rs . next ( ) ) { m_dropTriggerStatements . add ( "DROP " + rs . getString ( "TRIGGER_NAME" ) + ";" ) ; } rs . close ( ) ; }
newer compiere dbs don ' t use triggers . so just create drop statements .
