[JBoss-user] [EJB/JBoss] - Re: findAll and Collection result optimization

2004-07-18 Thread cchris
I'm still playing tester for the CMP lazy mode using JBoss 3.2.6rc1. I used a very simple test query : query-method method-namefindAll/method-name method-params / /query-method jboss-ql![CDATA[SELECT OBJECT(a) FROM Applica a]]/jboss-ql

[JBoss-user] [EJB/JBoss] - Re: findAll and Collection result optimization

2004-07-16 Thread loubyansky
You could check it out from CVS -r Branch_3_2 View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3842349#3842349 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3842349 ---

[JBoss-user] [EJB/JBoss] - Re: findAll and Collection result optimization

2004-07-15 Thread loubyansky
The syntax is OFFSET X LIMIT Y. Also for future reference http://www.jboss.org/wiki/Wiki.jsp?page=LazyResultSetLoading View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3842160#3842160 Reply to the post :

[JBoss-user] [EJB/JBoss] - Re: findAll and Collection result optimization

2004-07-15 Thread cchris
JBoss distribution - According to your article (http://www.jboss.org/wiki/Wiki.jsp?page=LazyResultSetLoading), lazy ResultSet loading feature is available since 3.2.6rc1. The latest stable production download available from http://www.jboss.org/downloads/ is jboss-3.2.5.zip (June 25, 2004).

[JBoss-user] [EJB/JBoss] - Re: findAll and Collection result optimization

2004-07-14 Thread kabkhan
Use jboss-ql in your query def in the jbosscmp-jdbc.xml file for added functionality View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3842032#3842032 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3842032

[JBoss-user] [EJB/JBoss] - Re: findAll and Collection result optimization

2004-07-14 Thread cchris
In jbosscmp-jdbc.xml, I added the following query : jbosscmp-jdbc ... enterprise-beans ... query-method method-namefindAll/method-name method-params method-paramint/method-param method-paramint/method-param