Re: Is autocommit=true bad? - Mailing list pgsql-general

From Kris Jurka
Subject Re: Is autocommit=true bad?
Date
Msg-id Pine.LNX.4.33.0401281830220.21151-100000@leary.csoft.net
Whole thread Raw
In response to Re: Is autocommit=true bad?  (Net Llama! <netllama@linux-sxs.org>)
List pgsql-general

On Wed, 28 Jan 2004, Net Llama! wrote:

> On Wed, 28 Jan 2004, Kris Jurka wrote:
> > On Tue, 27 Jan 2004, Net Llama! wrote:
> >
> > > Greetings,
> > > I've been tasked with maintaining a postgresql-7.3.4 database that has a
> > > J2EE app on the front end.
> > >
> > > In the pgsql log I see thousands upon thousands of entries like these:
> > > WARNING:  COMMIT: no transaction in progress
> >
> > I believe this is a symptom of an old version of the jdbc driver.  Perhaps
> > upgrading that would make this go away.
>
> OK thanks.  I'm pretty ignorant of jdbc drivers.  How could I determine
> what version is the most recent, and which version is in use?  thanks.
>

The most recent version is 7.4.1 and can be downloaded from here:
http://jdbc.postgresql.org/download.html  This will work on all older
versions and should be used regardless of your database version.  To
determine what version you currently have you can use something like
this...

Connection conn = /* Get connection somehow */
DatabaseMetaData dbmd = conn.getMetaData();
System.out.println(dbmd.getDriverVersion());

Kris Jurka


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Specifying many rows in a table
Next
From: Steve Atkins
Date:
Subject: Re: Specifying many rows in a table