[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