On Sat, Feb 11, 2012 at 17:22, Andreas Berglund <email.list...@gmail.com> wrote:
> Hi!
>
> I have the following piece of jdbc code
>
> String query = "UPDATE books SET title = ? WHERE book_id=?";
> pstmt =conn.prepareStatement(query);
> pstmt.setInt(1, new_book_id);
> pstmt.setString(2, getStringPrompt("new title"));
> pstmt.executeUpdate();
>
> getStringPrompt returns a string and new_book_id is an int.Aren't you passing your parameters in the wrong order? Your query wants title first and book_id second, but you send in new_book_id first and the new title second? -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
