Re: Cannot commit when autoCommit is enabled error

Gurkan Ozfidan <gurkan(at)timeforgedev(dot)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