JTA事务无效
userTransaction = (UserTransaction) ctx.lookup("java:comp/env/UserTransaction");
userTransaction.begin();
//取得连接
Connection conn = per.getConnection();
Statement sta = conn.createStatement();
String sql1 = "insert into t_nb_yhxx (c_yhbh,c_dwbm) values ('447778','4778')";
String sql2 = "insert into t_nb_yhxx (c_yhbh,c_dwbm) values ('55','55')";
sta.executeUpdate(sql1);
sta.executeUpdate(sql2);
userTransaction.commit();
tomcat的设置是
<Resource name="UserTransaction" auth="Container" type="javax.transaction.UserTransaction" factory="org.objectweb.jotm.UserTransactionFactory" jotm.timeout="60"/>
jta事务无效,例如两语句,一语句是违反唯一约束的,可是另一条还是会插入数据库,因为可能涉及到两数据库,所以没有用jdbc的事务