Re: PoolingDataSource executeUpdate

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: ALBERDI Ion <alberdi(at)enseirb(dot)fr>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: PoolingDataSource executeUpdate
Date: 2004-06-24 02:38:48
Message-ID: 40DA3EB8.4080700@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2004-06-24 06:35:18 Re: PoolingDataSource executeUpdate
Previous Message Pete Lewin-Harris 2004-06-23 15:28:05 Blob getBinaryStream issue.