geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gianny Damour <gianny.dam...@optusnet.com.au>
Subject Re: ejbSelect with LIMIT
Date Wed, 25 Oct 2006 12:30:13 GMT
Hello,

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.

Thanks,
Gianny

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

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


Mime
View raw message