geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gianny Damour <>
Subject Re: ejbSelect with LIMIT
Date Wed, 25 Oct 2006 12:30:13 GMT

The LIMIT clause is not an EJBQL standard compliant clause and TranQL  
does not support it. Thought, I should be able to add it rather easily.


On 25/10/2006, at 10:20 PM, Kaeto23 wrote:

> 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
> 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?

View raw message