geronimo-user mailing list archives

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

Hello, Gianny

sad to hear :/ I always thought that it is a standard clause.

Well, you may implement it (the OFFSET clause is also not spec
compliant?) but you don't need to. I'll try to create workaround in that
case :)

Best regards

Dirk

Gianny Damour schrieb:
> 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?
> 
> 

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

iD8DBQFFP1vNbiSTaBU+G6oRA8DTAJ9+CCyEwLk4GkWEFvb8UXxn5pZrLwCgifDx
Gp/uHeGEc2yv6+gIox6BNUc=
=1fbY
-----END PGP SIGNATURE-----

	

	
		
___________________________________________________________ 
Der frühe Vogel fängt den Wurm. Hier gelangen Sie zum neuen Yahoo! Mail: http://mail.yahoo.de

Mime
View raw message