| Author |
OutOfMemory just in Mysql, not in Oracle or SqlServer
|
Luis Felipe Bacca Arango
Greenhorn
Joined: May 26, 2003
Posts: 27
|
|
Hi everyone, i developing an application that downloads information of different databases and create plain text with that information. Each 200,000 records, i going to the text plain and write the contents of a StringBuffer, and create a new one to continue record information in it. In Oracle, my code work fine, with a table of 5,600,000 records, but in mysql, i get java.lang.OutOfMemoryError, even with much less records than in oracle. My query in mysql is SELECT * FROM afiliados limit 500000, i try to record in the file each 50,000 records, but the results are the same. My code is the following : Please help me in this situation, Thanks and Regards, [edited to add code tags] [ March 05, 2005: Message edited by: Jeanne Boyarsky ]
|
Luis Felipe.<br /> <br />SCJP, SCWCD.
|
 |
Jeanne Boyarsky
internet detective
Marshal
Joined: May 26, 2003
Posts: 26173
|
|
Luis, Do you know where the out of memory error is coming from? Maybe the driver?
|
[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
|
 |
 |
|
|
subject: OutOfMemory just in Mysql, not in Oracle or SqlServer
|
|
|