PostgreSQL JDBC - Problems after upgrading from 7.4.6 driver to 8.0.2 driver

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Problems after upgrading from 7.4.6 driver to 8.0.2 driver

Mark Lewis

2005-04-25, 8:25 pm

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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Sponsored Links