Hackers,

I get the following error (see below) when I attempt to insert a row into
one of our tables.  I'm using postgres 6.4 with java/jdbc 1.2.1.

Any ideas on what it means? I can't seem to find documentation
on this particular exception anywhere?  

Thanks,

Eric

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

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

java.sql.SQLException: results returned
    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:82)
    at postgresql.Statement.executeUpdate(Compiled Code)
    at postgresql.PreparedStatement.executeUpdate(Compiled Code)
    at InsertError.record(Compiled Code)
    at InsertError.record(Compiled Code)
    at wbCheckUrl$CheckThread.run(Compiled Code)


Mon, 04 Mar 2002 13:28:57 -0700
Eric Scroger <escroger@carl.org>
JDBC: java.sql.SQLException: results returned
Eric Scroger <escroger@carl.org> writes:

> Hackers,
> 
> I get the following error (see below) when I attempt to insert a row into
> one of our tables.  I'm using postgres 6.4 with java/jdbc 1.2.1.

6.4!!!!!!  Jeez, upgrade already.  

> Any ideas on what it means? I can't seem to find documentation
> on this particular exception anywhere?  Thanks,

Run a version of PG that isn't 5 years old and maybe someone will help
you out.  ;)

-Doug
-- 
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863

04 Mar 2002 19:04:45 -0500
Doug McNaught <doug@wireboard.com>
Re: JDBC: java.sql.SQLException: results returned
UPDATE:

So now I've got postgres 7.1 running.  I upgraded the postgres JDBC jar
file as well, yet I'm still getting the exception, 
java.sql.SQLException: results returned.

Any ideas?

Eric


Eric Scroger wrote:

> Hackers,
>
> I get the following error (see below) when I attempt to insert a row into
> one of our tables.  I'm using postgres 6.4 with java/jdbc 1.2.1.
>
> Any ideas on what it means? I can't seem to find documentation
> on this particular exception anywhere? 
> Thanks,
>
> Eric
>
> ----------------------------------------------
>
> INSERT INTO bad_urls(ID,DATA,ATTEMPTS,REASON) VALUES 
> (3376,'http://www.oit.itd.umich.edu/projects/adw2k/chordata/aves.html',0,'Unknown 
> Host')
>
> java.sql.SQLException: results returned
>    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:82)
>    at postgresql.Statement.executeUpdate(Compiled Code)
>    at postgresql.PreparedStatement.executeUpdate(Compiled Code)
>    at InsertError.record(Compiled Code)
>    at InsertError.record(Compiled Code)
>    at wbCheckUrl$CheckThread.run(Compiled Code)
>



Mon, 04 Mar 2002 18:18:00 -0700
Eric Scroger <escroger@carl.org>
Re: JDBC: java.sql.SQLException: results returned
Eric,

Can you send the new stack trace, and the lines of code that are causing
it?

Dave

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Eric Scroger
Sent: Monday, March 04, 2002 8:18 PM
To: pgsql-jdbc@postgresql.org
Cc: pgsql hackers
Subject: Re: [JDBC] JDBC: java.sql.SQLException: results returned


UPDATE:

So now I've got postgres 7.1 running.  I upgraded the postgres JDBC jar
file as well, yet I'm still getting the exception, 
java.sql.SQLException: results returned.

Any ideas?

Eric


Eric Scroger wrote:

> Hackers,
>
> I get the following error (see below) when I attempt to insert a row 
> into one of our tables.  I'm using postgres 6.4 with java/jdbc 1.2.1.
>
> Any ideas on what it means? I can't seem to find documentation on this

> particular exception anywhere? Thanks,
>
> Eric
>
> ----------------------------------------------
>
> INSERT INTO bad_urls(ID,DATA,ATTEMPTS,REASON) VALUES
>
(3376,'http://www.oit.itd.umich.edu/projects/adw2k/chordata/aves.html',0
,'Unknown 
> Host')
>
> java.sql.SQLException: results returned
>    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:82)
>    at postgresql.Statement.executeUpdate(Compiled Code)
>    at postgresql.PreparedStatement.executeUpdate(Compiled Code)
>    at InsertError.record(Compiled Code)
>    at InsertError.record(Compiled Code)
>    at wbCheckUrl$CheckThread.run(Compiled Code)
>



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



Mon, 4 Mar 2002 20:27:24 -0500
"Dave Cramer" <Dave@micro-automation.net>
Re: JDBC: java.sql.SQLException: results returned
Are there any rules or triggers on this particular table?

--Barry

Eric Scroger wrote:
> UPDATE:
> 
> So now I've got postgres 7.1 running.  I upgraded the postgres JDBC jar
> file as well, yet I'm still getting the exception, 
> java.sql.SQLException: results returned.
> 
> Any ideas?
> 
> Eric
> 
> 
> Eric Scroger wrote:
> 
>> Hackers,
>>
>> I get the following error (see below) when I attempt to insert a row into
>> one of our tables.  I'm using postgres 6.4 with java/jdbc 1.2.1.
>>
>> Any ideas on what it means? I can't seem to find documentation
>> on this particular exception anywhere? Thanks,
>>
>> Eric
>>
>> ----------------------------------------------
>>
>> INSERT INTO bad_urls(ID,DATA,ATTEMPTS,REASON) VALUES 
>> (3376,'http://www.oit.itd.umich.edu/projects/adw2k/chordata/aves.html',0,'Unknown 
>> Host')
>>
>> java.sql.SQLException: results returned
>>    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:82)
>>    at postgresql.Statement.executeUpdate(Compiled Code)
>>    at postgresql.PreparedStatement.executeUpdate(Compiled Code)
>>    at InsertError.record(Compiled Code)
>>    at InsertError.record(Compiled Code)
>>    at wbCheckUrl$CheckThread.run(Compiled Code)
>>
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org
> 



Mon, 04 Mar 2002 17:32:46 -0800
Barry Lind <barry@xythos.com>
Re: [HACKERS] JDBC: java.sql.SQLException: results returned