RE: "No results" exception on executeQuery()

Chris,

executeQuery will not return a resultset from an insert query. If you
use execute instead it will work ok

Dave

-----Original Message-----
From: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of chris markiewicz
Sent: August 16, 2001 12:47 PM
To: pgsql-jdbc(at)postgresql(dot)org
Subject: [JDBC] "No results" exception on executeQuery()

Hello. I just update my driver to the latest version (7.1-1.3). I am
seeing MANY of the following exception:

No results were returned by the query.
at
org.postgresql.jdbc2.Statement.executeQuery(Statement.java:63)
at
com.commnav.sbh.framework.persist.JDBCEngine.executeQuery(JDBCEngine.jav
a:22
1)
at
com.commnav.sbh.framework.persist.PersistenceObject.query(PersistenceObj
ect.
java:1046)
...

I checked the history of this listserv and found some related but not
quite relevant stuff (part of the thread is below - it talks about using
executeUpdate for update/insert/delete)...

I am sometimes getting this exception even when there should be results
returned...

I appreciate any help.
chris

-----Original Message-----
From: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org]On Behalf Of
Brian_Williams(at)i2(dot)com
Sent: Tuesday, May 08, 2001 2:50 PM
To: pgsql-jdbc(at)postgresql(dot)org
Subject: [JDBC] "No results" exception on insert

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

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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html