A result was returned by the statement, when none was expected

From: Eric Scroger <escroger(at)carl(dot)org>
To: pgsql hackers <pgsql-hackers(at)postgresql(dot)org>, pgsql-jdbc(at)postgresql(dot)org
Cc: ed(at)carl(dot)org
Subject: A result was returned by the statement, when none was expected
Date: 2002-03-05 22:27:59
Message-ID: 3C85466F.9010606@carl.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

JDBC-ers,

We are doing an INSERT and occasionally Postgres throws a SQLException
because there are unexpected results (see stacktrace below), maybe 10%
of the time,
Any idea why this would happen when it works over 90% of the time?
However, it appears the insert is completed successfully.

We have looked at the source code for ResultSet.java and noticed
the method reallyResultSet() returns true if any of the fields are non-null.
I hope that helps in debugging.

Also, we are running Postgres 7.1 with JDK1.2.1.

Regards,

Eric

--------------------------------------------------------------------------

IINSERT INTO bad_urls(ID,DATA,ATTEMPTS,REASON) VALUES
(3375,'http://www.oit.itd.umich.edu/projects/adw2k/chordata/aves.html',0,'Unknown
Host')

A result was returned by the statement, when none was expected.
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code)
at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Compiled Code)
at java.sql.SQLException.<init>(SQLException.java:98)
at org.postgresql.util.PSQLException.<init>(PSQLException.java:23)
at org.postgresql.jdbc2.Statement.executeUpdate(Statement.java:80)
at
org.postgresql.jdbc2.PreparedStatement.executeUpdate(PreparedStatement.java:122)
at InsertError.record(InsertError.java:98)
at InsertError.record(InsertError.java:69)
at wbCheckUrl$CheckThread.run(wbCheckUrl.java:307)

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Cramer 2002-03-05 22:56:52 Re: A result was returned by the statement, when none was expected
Previous Message mlw 2002-03-05 21:56:24 Re: Postgresql backend to perform vacuum automatically

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2002-03-05 22:56:52 Re: A result was returned by the statement, when none was expected
Previous Message Nick Fankhauser 2002-03-05 22:01:42 Re: Problem to connect from host via JDBC ...