wood burning stoves 2.0*
The moose likes JDBC and the fly likes PreparedStatement fails to execute Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "PreparedStatement fails to execute " Watch "PreparedStatement fails to execute " New topic
Author

PreparedStatement fails to execute

olze oli
Ranch Hand

Joined: Jun 20, 2009
Posts: 148
hi,

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
Position: 52
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)


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.
Ed Ward
Ranch Hand

Joined: Jan 30, 2006
Posts: 147
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.
olze oli
Ranch Hand

Joined: Jun 20, 2009
Posts: 148
You have been right... thanks
I had a normal Statement (stmt) and a PreparedStatement (prepStmt).
 
 
subject: PreparedStatement fails to execute
 
Similar Threads
[RESOLVED] jasper & iReport multi-reports
onetoone unidirectional relationship problem
How to Escape single quotes with PreparedStatment while using PostGresql?
Weired error comes while using stored procedure with hibernate
Error Calling stored procedure from my java codes.