Re: PoolingDataSource executeUpdate

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