log.debug("deleted " + rows);
log.debug("JMS_MESSAGE_REFERENCE: deleted " + rows);
   protected void deleteAllData() throws Exception   {      try      {         log.info("DELETING ALL DATA FROM DATABASE!");         InitialContext ctx = new InitialContext();         TransactionManager mgr = (TransactionManager)ctx.lookup(TransactionManagerService.JNDI_NAME);         DataSource ds = (DataSource)ctx.lookup("java:/DefaultDS");         javax.transaction.Transaction txOld = mgr.suspend();         mgr.begin();         Connection conn = ds.getConnection();         String sql = "DELETE FROM JMS_POSTOFFICE";         PreparedStatement ps = conn.prepareStatement(sql);         int rows = ps.executeUpdate();         ps.close();         sql = "DELETE FROM JMS_MESSAGE_REFERENCE";         ps = conn.prepareStatement(sql);         rows = ps.executeUpdate();         log.debug("deleted " + rows);         ps.close();         sql = "DELETE FROM JMS_MESSAGE";         ps = conn.prepareStatement(sql);         rows = ps.executeUpdate();         log.debug("deleted " + rows);         ps.close();         sql = "DELETE FROM JMS_TRANSACTION";         ps = conn.prepareStatement(sql);         rows = ps.executeUpdate();         log.debug("deleted " + rows);         ps.close();         sql = "DELETE FROM JMS_COUNTER";         ps = conn.prepareStatement(sql);         rows = ps.executeUpdate();         log.debug("deleted " + rows);         ps.close();         sql = "DELETE FROM JMS_USER";         ps = conn.prepareStatement(sql);         rows = ps.executeUpdate();         log.debug("deleted " + rows);         ps.close();         conn.close();         mgr.commit();         if (txOld != null)         {            mgr.resume(txOld);         }      }      catch (SQLException e)      {         //Ignore - tables might not exist      }   }