upgrading from pg74.216.jdbc3.jar to 8.1-407 JDBC 3 Shoud I?

From: David Gagnon <dgagnon(at)siunik(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: upgrading from pg74.216.jdbc3.jar to 8.1-407 JDBC 3 Shoud I?
Date: 2006-08-14 13:09:45
Message-ID: 44E07619.9090204@siunik.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi all,

I'm running 8.4 and to make a short story I'm doing some test with my
Tomcat/postgresql application. I shutdown the service and restart it
and notice that sometime just get ConnectionResetByPeerException (If I
remember well). So I tried the latest JDBC driver to see if I will get
this problem and run into this, I suppose really common problem:

BUG [main] (MappedStatement.java:908) 2006-08-14 07:46:43,062 : Error
executing 'role.getList' in '[Reader passed to buildSqlMap()]'. Check
the SQL statement. Cause: org.postgresql.util.PSQLException: L'opération
nécessite un scrollable ResultSet, mais ce ResultSet est FORWARD_ONLY.
org.postgresql.util.PSQLException: L'opération nécessite un scrollable
ResultSet, mais ce ResultSet est FORWARD_ONLY.

Is there a way to default the JDBC driver so it behave like pg74.216 ?
The code come from a library so I cannot modify it? Is there a work around?

On the other side is it worth upgrading to 8.1 driver. Can he solve my
reliability problem. (stability, reliability, etc.).. should I upgrade?

Thanks for your help !

Best Regards
/David

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Emi Lu 2006-08-14 13:51:20 SQLMAP IBATIS insert values from web forms to a money type column
Previous Message Oliver Jowett 2006-08-13 10:56:29 Re: SQL query never ends