Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

OutOfMemory just in Mysql, not in Oracle or SqlServer

 
Luis Felipe Bacca Arango
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 35977
422
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Luis,
Do you know where the out of memory error is coming from? Maybe the driver?
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!