JDBC and commit problems

From: "Robert M(dot) Zigweid" <rzigweid(at)securesoftware(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: JDBC and commit problems
Date: 2002-10-04 04:31:21
Message-ID: 1033705881.398.14.camel@ilyria
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I'm trying to roll a JDBC intensive application utilizing PostgreSQL and
I came across a very difficult (and annoying) problem.

The long and the short of it comes down to it appears that doing manual
transactions do not appear to work presently under postgres. Switching
the application to use autoCommit() cleared up the problem.

I'm utilizing 7.2.2 for the database and grabbed devpgjdbc2.jar a couple
days ago to test against, though I had similar issues with other
versions of the jdbc driver.

I've searched quite a bit and can't find any mention of others having
this problem. Does everyone normally autocommit? Regardless, I have
reasons where wanting full control over my transactions would be highly
desirable and would like to either know what it is I'm doing wrong, or
if this is indeed a flaw in the jdbc driver.

Regards,

Robert M. Zigweid

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Thomas O'Dowd 2002-10-04 04:37:43 Re: JDBC and commit problems
Previous Message Tom Lane 2002-10-03 22:18:36 Re: Programmatically dropping and creating table