-----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://[EMAIL PROTECTED]/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