Обсуждение: JDBC: java.sql.SQLException: results returned
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(CompiledCode) at java.lang.Throwable.<init>(Compiled Code) at java.lang.Exception.<init>(CompiledCode) at java.sql.SQLException.<init>(SQLException.java:82) at postgresql.Statement.executeUpdate(CompiledCode) at postgresql.PreparedStatement.executeUpdate(Compiled Code) at InsertError.record(CompiledCode) at InsertError.record(Compiled Code) at wbCheckUrl$CheckThread.run(Compiled Code)
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
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) >
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 >