Saving blob files in mysql database

Question

I am saving blob files in the mysql database in my springmvc with hibernate project.But after several blob files has uploaded i got an error in my project as out of memmory error java heap space.Can any one help me to resolve this

Why do you save files directly in the form of blob? Is it absolutely necessary? You should avoid it and store them in a directory instead, if there is no need to store them in blob. — Lion
– Lion, Commented Apr 17, 2012 at 2:36
Can you design your project to not store blobs in your MySQL database? Blobs are incredibly inefficient and cursorily sounds like the blobs are using up all your cache. — Yzmir Ramirez
– Yzmir Ramirez, Commented Apr 17, 2012 at 2:37
Sure, let me just haul out my magic crystal ball and examine your code via remote telepathic viewing... ummm. ... it's that extra semicolon on line 3562463235423523 of your code. — Marc B
– Marc B, Commented Apr 17, 2012 at 2:37
@MarcB Why don't you save comments like those for reddit. They help nobody. — arkon
– arkon, Commented Apr 8, 2014 at 4:46

ccleve · Accepted Answer · 2012-04-17 02:38:46Z

1

The contents of your files aren't getting released by your application. Somehow a reference to them remains in memory. You can use a profiler to track down where this reference exists.

answered Apr 17, 2012 at 2:38

ccleve

15.9k30 gold badges102 silver badges173 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Saving blob files in mysql database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related