Hi,
The following warning is shown on postgres log when you use
JDBC driver; Build 108, for PostgreSQL 7.3.x.
This is the server condition I use:
----------------------------------------
PostgreSQL 7.3.2
JDBC pg73jdbc3.jar(Build 108)
J2SE 1.4.1_01
RedHatLinux 7.2
----------------------------------------
When "auto commit" is set true, and I run Connection.setAutoCommit(false)
command in JDBC program, the following warning is shown on the PostgreSQL log;
WARNING: COMMIT: no transaction in progress
Because of the warning, I looked at
org.postgresql.jdbc1.AbstractJdbc1Connection#setAutoCommit(), and this program
was written as follows;
if (this.autoCommit == autoCommit)
return;
if (autoCommit)
{
if (haveMinimumServerVersion("7.3"))
{
//We do the select to ensure a transaction is in process
//before we do the commit to avoid warning messages
//from issuing a commit without a transaction in process
execSQL("select 1; commit; set autocommit = on;");
}
else
{
execSQL("end");
}
}
At the command line; execSQL("select 1; commit; set autocommit = on;");,
the program must finish and not record "warning" in the log even though
the program processes either during or at the end of the transaction.
As a matter of fact, the warning appears when the program runs "commit;."
The program doesn't begin a new transaction even though "select 1;"
has been executed,
I think if we change the command as follows,
execSQL("select 1;");
execSQL("commit; set autocommit = on;");
we can finish the transaction without the warning.
┛
┛ Daichi Ueura
┛
┛ Hiroshima City Univ, Department of Intelligent Systems.
┛ e-mail: (Private) daichi@lifeflow.jp
┛ : (Office) daichi@neu.co.jp
┛ : (Univ) g23010@cr.info.hiroshima-cu.ac.jp
┛
┛
