Problem saving Text file in database using Hibernate

Question

I'm having a problem saving large text files to MySQL database. If the text file size is around 5KB it successfully saves. If file is 148KB then I get this error from Hibernate:

org.hibernate.exception.DataException: Could not execute JDBC batch update

These is the SQL shows by Hibernate:

Hibernate: insert into file_table (ID,FILE) values (?, ?)

And in my hibernate file I'm using java.sql.Blob to store the file.

Anyone knows why it fails to save a file size of 148KB but if I open that same file, cut it down to around 5KB, it will successfully save it?

I thought the default limit was I think 2GB? This is weird.

Thanks.

gcores · Accepted Answer · 2010-05-20 19:37:24Z

1

Here is an explanation of the maximum length for different string columns in mysql:

http://dev.mysql.com/doc/refman/5.1/en/string-type-overview.html

A standard TEXT column only allows 65,535 characters max, you probably want a LONGTEXT column which allows around 4Gb per column.

answered May 20, 2010 at 19:37

gcores

12.7k2 gold badges52 silver badges45 bronze badges

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

1 Comment

Marquinio Over a year ago

Thank you. I previously had BLOB in database. I changed in database to LONGBLOB and it work!!!

Collectives™ on Stack Overflow

Problem saving Text file in database using Hibernate

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related