Thread: java.sql.SQLException: results returned

java.sql.SQLException: results returned

From
Eric Scroger
Date:
JDBC-ers,

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?

Also, I have tried upgrading to 7.1, but I'm having problems with
system settings SEMMNI and SEMMNS as stated in postmaster.out.
I posted a message to pgsql-admin with the problem info if anyone
has any ideas.

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)



Re: java.sql.SQLException: results returned

From
"Dave Cramer"
Date:
Eric,

Unfortunately the driver doesn't work with posgtres <= 6.5 and it's
doubtful even then, I would suggest upgrading to at least 7.1

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 7:13 PM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] java.sql.SQLException: results returned


JDBC-ers,

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?

Also, I have tried upgrading to 7.1, but I'm having problems with system
settings SEMMNI and SEMMNS as stated in postmaster.out. I posted a
message to pgsql-admin with the problem info if anyone has any ideas.

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 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)



Re: java.sql.SQLException: results returned

From
"Joe Shevland"
Date:
And the other messages you've seen mean you need to increase the shared
memory segments for your OS... or reduce the maximum connections in use by
the postmaster etc. If you're on FreeBSD, you need to tweak the
SEMxxx/SHMxxx options in the kernel configuration file and
recompile/reboot (from memory; I've tweaked a lot more of those options,
but I'm not sure what the minimal set is).

The best reference is the PostgreSQL (Administrators?) manual which has OS
specific notes that deal with this issue.

Cheers,
Joe

> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Dave Cramer
> Sent: Tuesday, 5 March 2002 11:37
> To: 'Eric Scroger'; pgsql-jdbc@postgresql.org
> Subject: Re: [JDBC] java.sql.SQLException: results returned
>
>
> Eric,
>
> Unfortunately the driver doesn't work with posgtres <= 6.5 and it's
> doubtful even then, I would suggest upgrading to at least 7.1
>
> 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 7:13 PM
> To: pgsql-jdbc@postgresql.org
> Subject: [JDBC] java.sql.SQLException: results returned
>
>
> JDBC-ers,
>
> 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?
>
> Also, I have tried upgrading to 7.1, but I'm having problems with system
> settings SEMMNI and SEMMNS as stated in postmaster.out. I posted a
> message to pgsql-admin with the problem info if anyone has any ideas.
>
> 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 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

Attachment