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


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


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

Reply via email to