Search:

You have an error in your syntax. Please read my first post. To reiterate: using System.out.println before calling the query that works, and compare that to the query that doesn't work. You will see...

This does not directly address my points...what is the exception? Post the full stack trace.

1) Sometimes when debugging things such as this, it helps to place the full query into a string and use a println statement to see what the query actually contains.
2) you mention it one works and...