"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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-jdbc by date

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