java.sql.SQLException:无法在上设置了自动提交的情况下提交(PhysicalConnection.j

Question

我的web应用程序启动没有出现错误，但当我运行它时，我会出现这个错误。。。

我的同事都帮不了我，你们中的一些人？

我在eclipserational和java1.6.0上使用websphere7

E com.ibm.ws.webcontainer.webapp.WebApp logServletError SRVE0293E: [Errore servlet]-[action]: it.xxx.navigator.exception.NavigatorException: java.sql.SQLException: Could not commit with auto-commit set on
at it.xxx.navigator.Navigator.throwException(Navigator.java:53)
at it.xxx.navigator.Navigator.initialize(Navigator.java:217)
at it.xxx.pensionis7.action.IndexAction.index(IndexAction.java:499)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)

Caused by: java.sql.SQLException: Could not commit with auto-commit set on
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:2356)
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:2403)
at oracle.jdbc.OracleConnectionWrapper.commit(OracleConnectionWrapper.java:139)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.commit(WSJdbcConnection.java:1112)
at it.xxx.navigator.dao.NavigatorConnection.commit(NavigatorConnection.java:46)
at it.xxx.navigator.delegate.NavigatorBD.getDefinedApplications(NavigatorBD.java:78)
at it.xxx.navigator.delegate.NavigatorDelegate.getDefinedApplications(NavigatorDelegate.java:33)
at it.xxx.navigator.Navigator.initialize(Navigator.java:190)
... 35 more

Answer 1

Oracle的JDBC驱动程序在尝试使用getAutoCommit() == true提交时抛出异常。

所以你要么：使用自动提交，根本不调用commit()(它将被自动调用(

或

仅当getAutoCommit() == false:时调用commit()

if (!connection.getAutoCommit()) {
connection.commit();
}