Re: PoolingDataSource executeUpdate - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: PoolingDataSource executeUpdate
Date
Msg-id Pine.BSO.4.56.0406240134001.27120@leary.csoft.net
Whole thread Raw
In response to Re: PoolingDataSource executeUpdate  (Oliver Jowett <oliver@opencloud.com>)
Responses Re: PoolingDataSource executeUpdate  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc

On Thu, 24 Jun 2004, Oliver Jowett wrote:

> ALBERDI Ion wrote:
>
> > What happens there is that with Connection Pooling the executeUpdate method
> > always returns 0, and that the database is not upgraded.
> > I'm currently forced to use the Jdbc3SimpleDataSource class (with this class
> > the application runs perfectly) but I would like to use Connection Pools to
> > improve the application's performances.
>
> I notice that the default autocommit setting in
> org.postgresql.jdbc2.optional.ConnectionPool is false. This is the
> opposite of the required Connection default and seems like a bug to me.

True, but that doesn't explain why executeUpdate returns an affected row
count of zero.

Kris Jurka

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: PoolingDataSource executeUpdate
Next
From: Kris Jurka
Date:
Subject: Re: Blob getBinaryStream issue.