Hi! I'm using a large database to make some reporting. The problem is when I need to show a report with about 100000 records. This just freeze my machinery, and after 10 minutes, I get OutOfMemoryException...
Yes, I know that I should use java -Xmx 128M -Xms 64M and so on, so I'll get things working. But one developer at my side show me that is possible to get same 100000 records shown in about 2 minutes just with default values for Xmx and Xms. Well, I needed to put my mind to work, and adapted my ReportBuilder to accept a Collection returned by OJB or a ResultSet, and now I need to obtain: 1) A Connection from OJB, and the formed query (the SELECT that OJB is generating to execute), so I can execute and pass the ResultSet to the report builder; OR 2) A ResultSet obtained after execution by OJB, and before OJB build the objects (to me, it's the ideal because I don't need to worry about statements and so on). Some one has tips on how to do this? Thanks, Edson Richter --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.507 / Virus Database: 304 - Release Date: 4/8/2003