我的mysql版本是3.23.55-nt。
参照一些例子(conn.setAuotCommit(false);conn.commit();conn.rollback();conn.setAutoCommit(true);)写了一个处理事务的方法:
java.sql.SQLException: General error: Warning: Some non-transactional changed t
ables couldnt be rolled back
at org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown Source)
at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown Source)
at org.gjt.mm.mysql.MysqlIO.sqlQuery(Unknown Source)
at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
at org.gjt.mm.mysql.Connection.rollback(Unknown Source)
at com.javabean.QueryTool.execTransaction(QueryTool.java:119)
at com.javabean.QueryTool.main(QueryTool.java:167)
mysql 3.x好象不支持事务
mysql的表类型MyISAM不支持事务,必须将表类型改为innodb才行