BUG #5127: AbstractJdbc2Connection#doRollback should throws Exception if connection is closed - Mailing list pgsql-bugs

From
Subject BUG #5127: AbstractJdbc2Connection#doRollback should throws Exception if connection is closed
Date
Msg-id 200910200945.n9K9jJFj086905@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #5127: AbstractJdbc2Connection#doRollback should throws Exception if connection is closed
List pgsql-bugs
The following bug has been logged online:

Bug reference:      5127
Logged by:
Email address:      taktos@gmail.com
PostgreSQL version: 8.3.7
Operating system:   CentOS 5.1
Description:        AbstractJdbc2Connection#doRollback should throws
Exception if connection is closed
Details:

If PostgreSQL server is restarted, old Connection pooled in Application
server's ConnectionPool cannot connect to DB.
That's OK.
But, I can call rollback() on old Connection and it throws no exception.
(I've set autocommit to false and ProtocolConnection#getTransactionState
returns 0)

It's fault. Rollback() should fail (throw exception) because JDBC connection
could not execute rollback.

pgsql-bugs by date:

Previous
From: Dave Page
Date:
Subject: Re: Re: BUG #5065: pg_ctl start fails as administrator, with "could not locate matching postgres executable"
Next
From: "Kevin Grittner"
Date:
Subject: Re: BUG #5127: AbstractJdbc2Connection#doRollback should throws Exception if connection is closed