This week's book giveaway is in the General Computing forum. We're giving away four copies of Arduino in Action and have Martin Evans, Joshua Noble, and Jordan Hochenbaum on-line! See this thread for details.
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).