1 message in com.mysql.lists.javamax allowed packet size
FromSent OnAttachments
Michael Yuan22 Nov 2000 09:13 
Subject:max allowed packet size
From:Michael Yuan (jun@astro.as.utexas.edu)
Date:11/22/2000 09:13:47 AM
List:com.mysql.lists.java

Hi,

I am using mm.mysql-2.0.2 on my solaris machine with Tomcat 3.1 and JDk1.2.2. I have a BLOB field in my table to store big chunks of binary data. But my servlet keeps giving exceptions complaining "Packet too large" when I do "insert" with big data. That happens even after I start safe_mysqld with "--set-variable=max_allowed_packet=16M" option. Does anyone know what I need to do to fix this? Thanks a lot!

When I use my old mm.mysql-1.2c, it can handle big data "insert" with no problem but when I tried to read out the data the server/JDBC driver truncated it at 64KB. I tried to do "stmt.setMaxFieldSize(0)", but this does not change the 64KB limit. If I try to do "stmt.setMaxFieldSize(100000)", the JDBC driver will generate an exception ...

Any help would be greatly appreciated! Michael