Re: "No results" exception on insert

Brian_Williams(at)i2(dot)com wrote:

> 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)

Hi,

When you're using INSERT, UPDATE, or DELETE, you should use the
executeUpdate() method of JDBC. executeQuery expects results because it
assumes a query is being sent. :)

HTH,
Jeremy