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-name>findAll</method-name>
<method-params />
</query-method>
<jboss-ql><![CDATA[SELECT OBJECT(a) FROM Applica a]]></jboss-ql>
<lazy-resultset-loading>true</lazy-resultset-loading>
I get the following exception when I try to parse the first element retrieved using a
Collection Iterator :
javax.ejb.FinderException: Find failed: java.sql.SQLException: Syntax error
or access violation, message from server:
"You have an error in your SQL syntax. Check the manual that corresponds to your
MySQL server version for the right syntax to use near 'SELECT count(t0_a.IDAPPLICA)
FROM applica t0_a), t0_a.IDAPP".
Thanks for helping me solving this issue.
Chris
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3842507#3842507
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3842507
-------------------------------------------------------
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
