Re: PoolingDataSource executeUpdate - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: PoolingDataSource executeUpdate
Date
Msg-id 40DA3EB8.4080700@opencloud.com
Whole thread Raw
In response to PoolingDataSource executeUpdate  (ALBERDI Ion <alberdi@enseirb.fr>)
Responses Re: PoolingDataSource executeUpdate
List pgsql-jdbc
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.

If your application is expecting connections obtained from the
datasource to have autocommit on by default, this could be the problem.

-O

pgsql-jdbc by date:

Previous
From: ALBERDI Ion
Date:
Subject: PoolingDataSource executeUpdate
Next
From: Kris Jurka
Date:
Subject: Re: PoolingDataSource executeUpdate