• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

OutOfMemory just in Mysql, not in Oracle or SqlServer

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 ]
author & internet detective
Posts: 40211
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Do you know where the out of memory error is coming from? Maybe the driver?
Did you miss me? Did you miss this tiny ad?
the value of filler advertising in 2020
    Bookmark Topic Watch Topic
  • New Topic