why do some failure spoils the jdbc connection ?

From: Maxime Lévesque <maxime(dot)levesque(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: why do some failure spoils the jdbc connection ?
Date: 2010-05-01 15:11:53
Message-ID: y2n554f5f781005010811p573b5e6ejac0282dbb0a79699@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi everyone,

When I execute some statements, for example droping a constraint and the
constraint
doesn't exist, an exception gets thrown as expected. If I issue another
statelemt
via the same connection, I get another exception saying the transaction is
canceled,
in other words, the connection is no longer useable.

Is the re a way that I can concinue using the connection ?

Thanks

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2010-05-01 15:31:44 Re: why do some failure spoils the jdbc connection ?
Previous Message Kris Jurka 2010-05-01 14:41:50 Re: Very Dangerous bug in XA connection pooling and SL EJBs with jboss-4.2.3 & latest postgresql-8.4-701.jdbc3.jar