Re: JDBC parse error with preparedStatement!

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
>

I can't see anything that's going wrong here either. The best way to
debug this problem is to enable statement loggin on the server so we can
see the exact query the server tries to run. To do this enable
log_statement in postgresql.conf and restart the server.

Kris Jurka