[jboss-user] [EJB 3.0] - Transactions Question: Subsequent calls the method fail due

I have a stateless bean method that calls em.createNativeQuery(sql).executeUpdate(); I call it from another method in the same SLSB in a loop. If, for example the first call fails, then all subsequent calls fail with this error: javax.persistence.TransactionRequiredException: Executing an update/delete query Am I required to do something to "clean-up" the first error? I thought the REQUIRES_NEW transaction annotation would start over with a clean slate so to speak. Please advise. @TransactionAttribute(TransactionAttributeType.REQUIRES_NEW) public int runStatement(String sql) throws Exception { try { return em.createNativeQuery(sql).executeUpdate(); } catch (Exception ex) { log.error(....); throw(ex); } } also: The calling method catches the re-thrown exception. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4157702#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...