Warning on transaction commit

From: Jeremy Buchmann <jeremy(at)wellsgaming(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Warning on transaction commit
Date: 2003-01-13 19:35:41
Message-ID: 3383060E-272E-11D7-BA14-000502E740BA@wellsgaming.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

Hi all,

I'm getting a warning message in my logs that looks like this:

WARNING: COMMIT: no transaction in progress

when I run this code:

dbh.setAutoCommit(false);
Statement doEvents = dbh.createStatement();
doEvents.executeUpdate("DELETE FROM ...");
doEvents.executeUpdate("INSERT INTO ...");
dbh.commit();
dbh.setAutoCommit(true);

The statements do what they're supposed to do, but I don't understand
why I'm getting that warning message. Anyone know why?

I'm running PostgreSQL 7.3.1 and using the PostgreSQL 7.3 JDBC 2 driver
that I just downloaded a couple days ago from jdbc.postgresql.org.

Thanks,
--Jeremy

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Treat 2003-01-13 20:50:32 Re: \d type queries - why not views in system catalog?!?
Previous Message Joe Conway 2003-01-13 19:19:20 Re: targetlist functions part 1 (was [HACKERS] targetlist

Browse pgsql-jdbc by date

  From Date Subject
Next Message Felipe Schnack 2003-01-13 20:07:27 binary data
Previous Message Carlos Correia 2003-01-13 19:18:05 Errors compiling Postgres (bison -maximum table size excceeded)