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). Could you please tell me where 3.2.6rc1 could be found?
- In the latest dtd available from http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_3_2.dtd, there is not such 'lazy-resultset-loading' element for a query parent. <!ELEMENT query (description?, query-method, (jboss-ql | dynamic-ql | declared-sql)?, read-ahead?, ql-compiler?)> May be the new dtd release will come together with JBoss 3.2.6rc1 MySQL syntax comment According to the mysql documentation, syntax is : SELECT ... [LIMIT {[offset,] row_count | row_count OFFSET offset}] ... MySQL allows both of the following syntaxes : SELECT * FROM table LIMIT my_offset, my_lim ; or SELECT * FROM table LIMIT my_lim OFFSET my_offset; Using JBoss3.2.4 and JBoss3.2.5, what works is, for example : <query-method> <method-name>findAll</method-name> <method-params /> </query-method> <jboss-ql>SELECT DISTINCT OBJECT(a) FROM App a OFFSET 0 LIMIT 2 </jboss-ql> But it's not really a lazy mode yet, just a page size limitation. Thanks for your help. Chris View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3842279#3842279 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3842279 ------------------------------------------------------- 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
