1 message in com.mysql.lists.javaProblems with large attachments
FromSent OnAttachments
Zsolt Koppany17 Dec 2006 01:43 
Subject:Problems with large attachments
From:Zsolt Koppany (zkop@intland.com)
Date:12/17/2006 01:43:01 AM
List:com.mysql.lists.java

Hi,

if I select attachments (BLOB) larger than 80MB I get:

java.sql.SQLException: Already closed

I have tried to increase max_allowed_packet=60M to max_allowed_packet=250M but that didn't help either.

Actually I don't understand how it was even possible to store attachments

60M into the database because I thought that max_allowed_packet controls

(limits) the largest data.

I use connector-java-5.0.4 and mysql-4.1.19 Windows XP and jre-1.5.0_09.

Any ideas what I need to configure?

Zsolt