hi,
i am using castor 0.9.3.9 in the newest cvs-version with mysql.
now i am wondering, if there is a way to use the LIMIT claus in oql.
i tried the following:
SELECT o FROM com.mycompany.lg.People o WHERE id > $1 LIMIT $2,$3
an i get this exception:
java.lang.ArrayIndexOutOfBoundsException
at org.gjt.mm.mysql.PreparedStatement.set(PreparedStatement.java:1192)
at org.gjt.mm.mysql.PreparedStatement.setInt(PreparedStatement.java:484)
at org.gjt.mm.mysql.PreparedStatement.setObject(PreparedStatement.java:952)
at
org.exolab.castor.jdo.engine.SQLEngine$SQLQuery.execute(SQLEngine.java:1581)
at
org.exolab.castor.persist.TransactionContext.query(TransactionContext.java:
644)
at org.exolab.castor.jdo.engine.OQLQueryImpl.execute(OQLQueryImpl.java:458)
at org.exolab.castor.jdo.engine.OQLQueryImpl.execute(OQLQueryImpl.java:405)
greetings
jan
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
