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
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 |