Re: Cannot commit when autoCommit is enabled error - Mailing list pgsql-general

From Kevin Grittner
Subject Re: Cannot commit when autoCommit is enabled error
Date
Msg-id 1379496313.51692.YahooMailNeo@web162904.mail.bf1.yahoo.com
Whole thread Raw
In response to Cannot commit when autoCommit is enabled error  (Gurkan Ozfidan <gurkan@timeforgedev.com>)
List pgsql-general
Gurkan Ozfidan <gurkan@timeforgedev.com> wrote:

>ERROR in createReportTable(): Cannot commit when autoCommit is enabled.

>PART OF THE CODE:

>        } catch (Exception e) {
>            System.err.println("ERROR in runStorageSQLQuery(): " + e.getMessage() + " sqlQuery: "+sqlQuery);
>            e.printStackTrace();

It may be part of the code, but it's not the part that is throwing
the exception.

FWIW, the JDBC API requires that the driver throw an exception if
you try to invoke Connection.commit() on a connection which is in
autoCommit mode.  Older versions of the PostgreSQL JDBC driver
failed to do that; newer ones comply with that requirement.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-general by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: upgrade from 9.2.x to 9.3 causes significant performance degradation
Next
From: Jayadevan M
Date:
Subject: Moving from 9.2 to 9.3