Problems after upgrading from 7.4.6 driver to 8.0.2 driver - Mailing list pgsql-jdbc

From Mark Lewis
Subject Problems after upgrading from 7.4.6 driver to 8.0.2 driver
Date
Msg-id 1114472323.923.56.camel@amateljan.mirlogic.com
Whole thread Raw
Responses Re: Problems after upgrading from 7.4.6 driver to 8.0.2
List pgsql-jdbc
After upgrading from pg74.215.jdbc3.jar to postgresql-8.0-310.jdbc3.jar,
I've encountered problems getting a "This statement has been closed"
exception when using a PreparedStatement.

The application is using Jakarta's DBCP 1 connection pooling with
prepared statement caching, and is configured to execute "select 1" each
time a connection is checked out from the pool to ensure that the
connection is still alive, so I'm pretty sure the server connection is
still good.

Are there any known gotchas migrating to the new server prepared
statement implementation?  Something that could be causing statements to
close when they otherwise would not be?

Thanks,
Mark Lewis

Thanks,
Mark Lewis





pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Document translation
Next
From: Mark Lewis
Date:
Subject: Re: Problems after upgrading from 7.4.6 driver to 8.0.2