> Hi, my answer is a little late for you : Hi, > For count with a query, you have > broker.getCount(query) > It will make select count(*) from ... without using > an iterator
I know the existence of broker.getCount(query), but i have to count the rows grouped by the user_id; in other words i need to retrieve something like this: count | user_id 3 | 1 6 | 2 ... the broker.getReportQuery... function seemed to me to match my needs. Am i wrong? > Second thing for using iterator (you can have this > problem later) : I was not aware of this problem with Iterator. I'll check my code. Thanx u very much for the advices :) Marco > There is a big problem with Iterators, when you > don't take all the lines of > the iterator (you have 50 lines to get with your > select but you stop at 30th > line), you will have a problem with cursors in your > database (in a moment, > you'll have all yours cursors used and can't open a > new cursor). > For resolve this problem, you can use OJBIterator > instead of Iterator (You > cast the Iterator in OJBIterator), in the end of the > method, you use > releaseDbResources(), it will close the cursor from > the database. > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
