Search Postgresql Archives

Re: Cannot commit when autoCommit is enabled error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Gurkan Ozfidan <gurkan@xxxxxxxxxxxxxxxx> 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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux