Re: JDBC parse error with preparedStatement! - Mailing list pgsql-jdbc

On Sun, 11 Jan 2004, Ramin Rad wrote:
> > > I am getting a very annoying parse error message on a simple delete
> > statement:
> > >
> > >   String sqlStmt = "DELETE FROM ft_member WHERE username = ?";
> > >   PreparedStatement stmt = connection.prepareStatement( sqlStmt );
> > >   stmt.setString( 1, "test");
> > >   stmt.executeUpdate( sqlStmt );
> > >
> > > Here is the error message:
> > >
> > > Exception in thread "main" java.sql.SQLException: ERROR:  parser: parse
> > error
> > > at end of input
> > >

Re-reading your original message made the problem apparent. You should
just do stmt.executeUpdate(), not pass in the sqlStat which is overriding
the prepared query.

Kris Jurka