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