Hi,
you can do this by using Jboss specific sql.
in your jbosscmp-jdbc.xml file, you can add something like :
<query-method>
<method-name>findAllLtd</method-name>
<method-params>
<method-param>int</method-param>
</method-params>
</query-method>
<jboss-ql><![CDATA[SELECT OBJECT(a) FROM table as a LIMIT
?1]]></jboss-ql>
This is nicely documented in the free online documentation.
Be aware that this overrides a method in your ejb-jar.xml ! So you must also have a
query in your ejb-jar.xml file, but this one will be overriden by the query in your
jbosscmp-jdbc.xml file.
Henk
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3842726#3842726
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3842726
-------------------------------------------------------
This SF.Net email is sponsored by BEA Weblogic Workshop
FREE Java Enterprise J2EE developer tools!
Get your free copy of BEA WebLogic Workshop 8.1 today.
http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
