KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I am storing images in MYSQL. I have table as CREATE TABLE myTable (id INT, myImage BLOB); When I am trying to insert 4.7MB file, I am getting exception as com.mysql.jdbc.PacketTooBigException: Packet for query is too large (4996552 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable. I believe this is related to image size only. Is there any other variable type that I can use? Update 1 As per older SO question, I also tried with MEDIUMBLOB but still I am getting same error. Adding Image to a database in Java Update 2 At the start of the project, I execute below query and everything is working now SET GLOBAL max_allowed_packet = 1024*1024*14;
Tags (comma-separated)
Save Edits
Cancel