File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

OutOfMemory just in Mysql, not in Oracle or SqlServer

 
Luis Felipe Bacca Arango
Greenhorn
Posts: 27
  • 0
  • 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
Marshal
Posts: 33691
316
Eclipse IDE Java VI Editor
  • 0
  • 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?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic