geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kaeto23 <kaet...@yahoo.de>
Subject ejbSelect with LIMIT
Date Wed, 25 Oct 2006 12:20:54 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160

Hello,

the main ejbSelect problems are resolved. Now there's another problem
which may not be related to a bug but to a missunderstanding.

Have this ejbSelect:

@XD5EjbSelectMethode(descr="returns the latest post from the forum",
ejbQL="select distinct object(p) from Post as p where
p.thread.forum.id=?1 order by p.erstellt desc limit 1")
public abstract Post ejbSelectLatestPost(long forumId) throws
FinderException;

which should return the latest post entry from a forum. Unfortunately
the TranQL parser thinks that this ejbQL is wrong. Does anyone have the
correct syntax for this?

Stacktrace at deploy time:

aused by: org.tranql.ql.QueryException: Select [Select
method=[ejbSelectLatestPost]; EJB-QL=[select distinct object(p) from
Post as p where p.thread.forum.id=?1 order by p.erstellt desc limit 1]]
	at
org.tranql.sql.EJBQLToPhysicalQuery.buildSelect(EJBQLToPhysicalQuery.java:173)
	at
org.tranql.sql.EJBQLToPhysicalQuery.buildSelects(EJBQLToPhysicalQuery.java:109)
	... 37 more
Caused by: org.tranql.ql.QueryException: Parser, lexer or Tree-walker
exception
	at
org.tranql.sql.EJBQLToPhysicalQuery.getEJBQLQuery(EJBQLToPhysicalQuery.java:235)
	at
org.tranql.sql.EJBQLToPhysicalQuery.buildSelect(EJBQLToPhysicalQuery.java:152)
	... 38 more
Caused by: org.tranql.ql.QueryException: Tokens left on the stream.
	at
org.tranql.sql.EJBQLToPhysicalQuery.getEJBQLQuery(EJBQLToPhysicalQuery.java:227)
	... 39 more

Best regards

Dirk

- --
Kaeto23

HTTP: http://kaeto23.dnsalias.com (german!)
Jabber: jabber://kaeto23@jabber.ds2/DS2

Reclaim Your Inbox!
http://www.mozilla.org/products/thunderbird/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFFP1ambiSTaBU+G6oRA/eWAJ4p8YmkVBWVlOOaW+3nDw3QgO6SnwCfVF0G
ZijW675K1JD/WS2ihWIJBHk=
=3pHa
-----END PGP SIGNATURE-----

		
___________________________________________________________ 
Telefonate ohne weitere Kosten vom PC zum PC: http://messenger.yahoo.de

Mime
View raw message