Fabien COELHO schrieb:
328 [main] DEBUG com.mosaicag.rwa.dbutil.standard.DefaultCsvExport - executing SQL-Stmt: SELECT * FROM transaction WHERE transaction_date >= to_timestamp('01.01.2002', 'DD.MM.YYYY') AND transaction_date < to_timestamp('01.01.2003', 'DD.MM.YYYY') java.lang.OutOfMemoryError Exception in thread "main"
Maybe the JDBC drivier tries to allocate the whole result of the query? If so, it is not a memory leak, it's a big memory need;-)
You might try using a cursor manually (well, if it is the problem, then it just shows that jdbc should do it by default).
Using a cursor avoids the out of memory error. I used:
stmt.setFetchSize(1000);
after creation of the statement now.
Thanks, that helped. But for me this behaviour is still a bug.
-- Roland Walter MOSAIC SOFTWARE AG Telefon: 02225/882-411 Fax: 02225/882-201 http://www.mosaic-ag.com
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
