[jboss-jira] [JBoss JIRA] Updated: (JBAS-5080) Need to check transaction status on SQL operations

Need to check transaction status on SQL operations -------------------------------------------------- Key: JBAS-5080 URL: http://jira.jboss.com/jira/browse/JBAS-5080 Project: JBoss Application Server Issue Type: Bug Security Level: Public(Everyone can see) Components: JCA service Affects Versions: JBossAS-4.2.2.GA Reporter: Adrian Brock Assigned To: Adrian Brock Fix For: JBossAS-4.2.3.GA In 4.2.x the transaction timeout rollsback the transaction rather than marking it rollback only. This means that for the local transaction datasource the connection has effectively moved onto the next transaction. Actual code: Connection c = datasource.getConnection(); // tx timeout here Statement s = createStatement(); s.executeUpdate(); // should not work Actual Code executed in 4.0.x Connection c = pool.getConnection(); // tx timeout here transaction.setRollbackOnly(); Statement s = createStatement(); s.executeUpdate(); tx.rollback(); // Rollsback the update Actual Code executed in 4.2.x Connection c = pool.getConnection(); // tx timeout here transaction.rollback(); Statement s = createStatement(); s.executeUpdate(); // happens "in the next local transaction"