Skip site navigation (1) Skip section navigation (2)

"No results" exception on insert

From: Brian_Williams(at)i2(dot)com
To: pgsql-jdbc(at)postgresql(dot)org
Subject: "No results" exception on insert
Date: 2001-05-08 18:50:17
Message-ID: OFEEA0FFB3.58799563-ON88256A46.0065CD14@i2.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hello,

I have some code which is essentially doing the following:

Statement stmt;
ResultSet rs = stmt.executeQuery("insert into users values ( 'joe', 'blow'
)");

The values are inserted into the table correctly.  I verified this using
psql:
"select * from users".

The problem is that the executeQuery throws an Exception.  The message
is "No results were returned by the query":

No results were returned by the query.
        at org.postgresql.jdbc2.Statement.executeQuery(Statement.java,
Compiled
Code)

My driver is "org.postgresql.Driver" from the jar file jdbc7.0-1.2.jar.  I
think
the port version is 7.1  The platform is FreeBSD 4.2-RELEASE.
I am using linux jdk 1.2.2.

Can anyone give me any ideas?

Thanks,
Brian



Responses

pgsql-jdbc by date

Next:From: Bruce MomjianDate: 2001-05-08 19:32:19
Subject: Re: Why?? executeQuery() & exception: "No results were returned by the query."
Previous:From: Bruce MomjianDate: 2001-05-08 17:29:52
Subject: Re: [JDBC] Re: Trouble with JDBC2 ResultSet.getDate()

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group