[JBos 4.0.4.GA EJB2.1, using xdoclet, MySQL] I have a dyniamic query...
"SELECT * FROM table WHERE (.....) LIMIT 100" and I build the WHERE clause at run time - I'm happy But the (JBoss) generated SQL does not include LIMIT on the query. With large record sets it takes a long time. So, I should use Declared-SQL. But this appears to be completely static. Does anybody know how I can do both? have I missed something here? Many Thanks Ian Hunter View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3954786#3954786 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3954786 Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
