Re: Cannot commit when autoCommit is enabled error

The code you showed looks fine. Are you sure this is where it is happening

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca

On Wed, Sep 18, 2013 at 9:39 AM, Gurkan Ozfidan <gurkan(at)resolution(dot)com>wrote:

> Dear group,
> We have been using postgresql-jdbc-8.3-604, and recently we started using
> postgresql-jdbc-9.2, everything seems working fine, except we are getting
> this error and could not find the solution yet. This related to our
> reporting and I could say that it is not happening every report we run. If
> you could help, I really appreciated.
> Below is the part of the code and error that we are getting. Thanks.
>
> ERROR:
> ERROR in createReportTable(): Cannot commit when autoCommit is enabled.
> org.postgresql.util.PSQLException: Cannot commit when autoCommit is
> enabled.
> at
> org.postgresql.jdbc2.AbstractJdbc2Connection.commit(AbstractJdbc2Connection.java:703)
> at sun.reflect.GeneratedMethodAccessor65.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126)
> at
> org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
> at
> org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:80)
> at $Proxy0.commit(Unknown Source)
> at sun.reflect.GeneratedMethodAccessor65.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:40)
> at $Proxy125.commit(Unknown Source)
> at
> com.resolution.scheduler.dao.hibernate.SalesPAFNewDaoHibernate.runStorageSQLQuery(SalesPAFNewDaoHibernate.java:219)
> at
> com.resolution.scheduler.service.impl.SalesPAFNewManagerImpl.runStorageSQLQuery(SalesPAFNewManagerImpl.java:151)
>
>
> PART OF THE CODE:
>
> public Integer runStorageSQLQuery(String sqlQuery) throws Exception {
> int results=0;
> try {
> java.sql.Connection conn = getSession().connection();
> boolean acs = conn.getAutoCommit();
> //System.out.println("........
> ...........AutoCommit status: "+acs);
> conn.setAutoCommit(false);
> java.sql.PreparedStatement st =
> conn.prepareStatement(sqlQuery);
> results = st.executeUpdate();
> conn.commit();
> conn.setAutoCommit(acs);
> st.close();
> } catch (Exception e) {
> System.err.println("ERROR in runStorageSQLQuery(): " +
> e.getMessage() + " sqlQuery: "+sqlQuery);
> e.printStackTrace();
> }
> return new Integer(results);
> }
>