Thread: No results were returned by the query.

No results were returned by the query.

From
Don Park
Date:
I have some postgresql calls in a jsp file. I can do select calls with no
problem. When i do an update call I get

javax.servlet.ServletException: No results were returned by the query

the code snipit is:
        PreparedStatement ps = conn.prepareStatement(
           "update users set firstname = ? where userid = ?");
        ps.setString(1, firstname);
        ps.setString(2, userid);
        ps.executeQuery();

I dont except any 'results' from an update statment, so im really confused
by the exception. The statement does get executed - i can see the change
in the database. Im just trying to avoid the exception.

Don


Re: No results were returned by the query.

From
"Patrik Lundgren"
Date:
Call executeUpdate instead of executeQuery in PreparedStatement.

Regards,
Patrik Lundgren

-----Ursprungligt meddelande-----
Från: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] För Don Park
Skickat: Saturday, April 19, 2003 10:42 PM
Till: pgsql-jdbc@postgresql.org
Ämne: [JDBC] No results were returned by the query.



I have some postgresql calls in a jsp file. I can do select calls with
no problem. When i do an update call I get

javax.servlet.ServletException: No results were returned by the query

the code snipit is:
        PreparedStatement ps = conn.prepareStatement(
           "update users set firstname = ? where userid = ?");
        ps.setString(1, firstname);
        ps.setString(2, userid);
        ps.executeQuery();

I dont except any 'results' from an update statment, so im really
confused by the exception. The statement does get executed - i can see
the change in the database. Im just trying to avoid the exception.

Don


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