Hello,
> When I execute a query with the following OQL statement:
>
> select count(t.id) from model.Test t where (status = $1) and (showDate
> <= $2)
>
> 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"
This is just a wild guess - I don't have a MySQL DB available currently.
But does it work if you remove the parenthesis and change your OQL to the
following query?
select count(t.id) from model.Test t where status = $1 and showDate <= $2
Regards,
Martin
--
Martin Fuchs
[EMAIL PROTECTED]
+++ GMX DSL Premiumtarife 3 Monate gratis* + WLAN-Router 0,- EUR* +++
Clevere DSL-Nutzer wechseln jetzt zu GMX: http://www.gmx.net/de/go/dsl
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-user
