log.debug("deleted " + rows);
   protected void deleteAllData() throws Exception   {      try      {         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_CHANNEL_MAPPING";         PreparedStatement ps = conn.prepareStatement(sql);                  int rows = ps.executeUpdate();                     ps.close();                  sql = "DELETE FROM JMS_MESSAGE_REFERENCE";         ps = conn.prepareStatement(sql);                  rows = ps.executeUpdate();                  ps.close();                  sql = "DELETE FROM JMS_MESSAGE";         ps = conn.prepareStatement(sql);                  rows = ps.executeUpdate();                     ps.close();                  sql = "DELETE FROM JMS_TRANSACTION";         ps = conn.prepareStatement(sql);                  rows = ps.executeUpdate();                         ps.close();                  sql = "DELETE FROM JMS_COUNTER";         ps = conn.prepareStatement(sql);                  rows = ps.executeUpdate();                  ps.close();                  sql = "DELETE FROM JMS_USER";         ps = conn.prepareStatement(sql);                  rows = ps.executeUpdate();                  ps.close();         conn.close();            mgr.commit();            if (txOld != null)         {            mgr.resume(txOld);         }      }      catch (SQLException e)      {         //Ignore - tables might not exist            }   }