i created a prepared statement with a simple select, but it wont be executed:
The error message is:
org.postgresql.util.PSQLException: FEHLER: Syntaxfehler am Ende der Eingabe
I have no idea whats wrong with that query. Can please someone explain me what the problem is?
Syntaxfehler am Ende der Eingabe means: Syntax Error at the end of the input.
Where did "stmt" come from?
You sure you do not want to do prepStmt.executeQuery() since you went through the trouble of prepping it?
stmt.executeQuery(sql) in your code is attempting to execute the raw SQL statement, with the ? which has not yet been set.
Least, looks that way to me.
Joined: Jun 20, 2009
You have been right... thanks
I had a normal Statement (stmt) and a PreparedStatement (prepStmt).
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com