This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
The moose likes JDBC and the fly likes OutOfMemory just in Mysql, not in Oracle or SqlServer Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "OutOfMemory just in Mysql, not in Oracle or SqlServer" Watch "OutOfMemory just in Mysql, not in Oracle or SqlServer" New topic
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: 30384
    
150

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: OutOfMemory just in Mysql, not in Oracle or SqlServer