Mysql不支持JDBC的autoCommit事务操作吗？

Question

下面是com.mysql.jdbc.ConnectionImpl类的setAutoCommit(boolean flag)方法的注释 最后一句，Note: MySQL does not support transactions, so this method is ano-op. /** * If a connection is in auto-commit mode, than all its SQL statements will * be executed and committed as individual transactions. Otherwise, its SQL * statements are grouped into transactions that are terminated by either * commit() or rollback(). By default, new connections are in auto- commit * mode. The commit occurs when the statement completes or the next execute * occurs, whichever comes first. In the case of statements returning a * ResultSet, the statement completes when the last row of the ResultSet has * been retrieved or the ResultSet has been closed. In advanced cases, a * single statement may return multiple results as well as output parameter * values. Here the commit occurs when all results and output param values * have been retrieved. * <p> * <b>Note:</b> MySQL does not support transactions, so this method is a * no-op. * </p> * * @param autoCommitFlag - * true enables auto-commit; false disables it * @exception SQLException * if a database access error occurs */

Answer 1

你的Mysql表类型是 innodb 还时 myisam 后者是不支持事务的