[JBoss-user] [Persistence & CMP/JBoss] - Re: Using LIMIT in findermethod

2004-12-16 Thread dijkstra
I am wondering whats the problem with my previous post (see above). Nobody has an answer till now. How come? - Is my English that bad, so nobody understands my problem? - Is my question too difficult and really nobody knows the answer? - No experienced jboss users are visiting this forum? How ab

[JBoss-user] [Persistence & CMP/JBoss] - Re: Using LIMIT in findermethod

2004-12-14 Thread triathlon98
Strange, I seem to remember actually answering a post like this. There are a couple of things you can do. 1. LIMIT is handled by JBoss, so it will work, even though the SQL qurey will not show it (but a larger resultset may come back from the DB). 2. Actually traversing the resultset is slower