No results were returned by the query.

From: Don Park <donald(dot)g(dot)park(at)iname(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: No results were returned by the query.
Date: 2003-04-19 20:41:30
Message-ID: Pine.LNX.4.51.0304191339060.24359@amidala.klickitat.st
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Patrik Lundgren 2003-04-19 20:48:30 Re: No results were returned by the query.
Previous Message malik ashfaq 2003-04-18 01:43:05 cancel my member ship