| 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: | Whole Thread | Raw Message | 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
| 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 |
| 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) |