Postgres Pro
Downloads
Home   >   mailing lists

Bug: Transaction still open after error when autocommit=true - Mailing list pgsql-jdbc

From Daniel Migowski
Subject Bug: Transaction still open after error when autocommit=true
Date
Msg-id 41ED3F5450C90F4D8381BC4D8DF6BBDC60CCBB02@EXCHANGESERVER.ikoffice.de
Whole thread Raw
Responses Re: Bug: Transaction still open after error when autocommit=true
Re: Bug: Transaction still open after error when autocommit=true
List pgsql-jdbc
Tree view

Hi,

 

There is a problem with the JDBC 3 driver for PostgreSQL 9.1 (and maybe others, but the 8.3 drivers don’t show this bug):

 

If I send a statement with a BEGIN token and something that fails, the database connection stays in “transaction error” mode, even if autocommit is on! This should not be if I read the specs, especially because in autocommit mode doing a rollback() throws an exception!

 

A small demo for the bug is attached.

 

Thanks for your great work btw.!

 

Regards,

Daniel Migowski

 

Attachment

pgsql-jdbc by date:

Previous
From: Maciek Sakrejda
Date:
Subject: Re: test git conversion
Next
From: "Kevin Grittner"
Date:
Subject: Re: Bug: Transaction still open after error when autocommit=true