[error report of Sean Liang]
When I execute a query with the following OQL statement:
select count(t.id) from model.Test t where (status = $1) and (showDate <=
An exception occurs:
org.exolab.castor.jdo.QueryException: java.sql.SQLException: Syntax error
or access violation message from server: "You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the right
syntax to use near '2 ))' at line 1"
I didn't change anything of my code or database, so I guess it is not my
The final sql is something like this:
SELECT COUNT(test.id) FROM test WHERE (( test.status = ?1 ) and (
test.showDate <= ?2 ))
I could reproduce this problem. It is related to the usage of COUNT() or
similar functions. It's been caused by the recent changes to implement
I will create and attach a patch to solve this issue.
Sean - could you please apply this patch to your source tree and test, if it
solves your problems?