Cannot commit when autoCommit is enabled error

From: Gurkan Ozfidan <gurkan(at)timeforgedev(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Cannot commit when autoCommit is enabled error
Date: 2013-09-17 23:44:45
Message-ID: CAEuGAtS5y=KQV2Tfu7CGTUQm+JqidZA-A+6vz_sooyivfspKMw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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);
}

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2013-09-18 00:02:48 Re: Why does this array query fail?
Previous Message Rowan Collins 2013-09-17 23:17:02 Re: Unary Operators