What is the correct syntax? I tried the following
SELECT p FROM org.usiis.struts.PatientSearchForm p LIMIT $1 ORDER BY
p.lastName
but got
org.exolab.castor.jdo.oql.OQLSyntaxException: An incorrect token type
was found
near ORDER (found KEYWORD_ORDER, but expected END_OF_QUERY)
at org.exolab.castor.jdo.oql.Parser.match(Parser.java:222)
at
org.exolab.castor.jdo.oql.Parser.getParseTree(Parser.java:184)
at
org.exolab.castor.jdo.engine.OQLQueryImpl.create(OQLQueryImpl.java:23
)
at
org.exolab.castor.jdo.engine.DatabaseImpl.getOQLQuery(DatabaseImpl.ja
a:465)
at
org.usiis.struts.PersistenceManager.getPatientSearchQuery(Persistence
anager.java:1828)
at
org.usiis.struts.PersistenceManager.patientSearch(PersistenceManager.
>>> [EMAIL PROTECTED] 05/11/05 4:35 PM >>>
On 5/11/05, Eric Anderson <[EMAIL PROTECTED]> wrote:
>
> I have tried LIMT $1 and rownum < $1 and can't seem to get it to
work?
> Am I doing it wrong?
> oql.bind(100);
>
> http://castor.org/oql.html#Limit-Clause doesn't show it as
different?
Take a look here:
http://castor.codehaus.org/release-notes.html
and search for the word limit.
Also, by looking at the code, it appears that the ORDER BY clause is
required for Oracle.
It looks like the docs need to be updated to reflect the current
functionality.
> Also is there a way to search the mailing list of archives? I don't
see
> it here?
>
> http://archive.codehaus.org/castor/user/
There are searchable archives available from the following locations:
http://www.mail-archive.com/[email protected]/
http://www.mail-archive.com/[email protected]/
http://marc.theaimsgroup.com/?l=castor-user&r=1&w=2
http://marc.theaimsgroup.com/?l=castor-dev&r=1&w=2
http://news.gmane.org/gmane.comp.java.castor.user
http://news.gmane.org/gmane.comp.java.castor.devel
I have no idea why this page only lists the Codehaus archive now:
http://castor.codehaus.org/lists.html
It looks like we've got some updating to do WRT the docs. Thanks for
pointing out this stuff Eric.
Bruce
--
perl -e 'print
unpack("u30","D0G)[EMAIL PROTECTED]&5R\"F)R=6-E+G-N>61E<D\!G;6%I;\"YC;VT*"
);'
The Castor Project
http://www.castor.org/
Apache Geronimo
http://geronimo.apache.org/
