Using sql2o-1.6-RC3 and microsoft JDBC 4.2
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot invoke a rollback operation when the AutoCommit mode is set to "true".
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:191)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.rollback(SQLServerConnection.java:2696)
at com.zaxxer.hikari.pool.ProxyConnection.rollback(ProxyConnection.java:361)
at com.zaxxer.hikari.pool.HikariProxyConnection.rollback(HikariProxyConnection.java)
at org.sql2o.Connection.rollback(Connection.java:124)
at org.sql2o.Connection.onException(Connection.java:68)
at org.sql2o.Query.executeUpdate(Query.java:661)
this problem goes away when i set:
connection.setRollbackOnException(false);
But shouln't rollback be set to false by default when using autoCommit?