Page 1 of 1

Timeout when uploading large BLOB field

Posted: Mon 08 Nov 2004 14:32
by rfish
When uploading a large blob field to the database, I get the Exception [the database has gone away]. This limits the max upload size of the BLOB field to about 12MBytes. I need to be able to upload larger fields.

Is there somewhere to set this timeout?

Re: Timeout when uploading large BLOB field

Posted: Mon 08 Nov 2004 16:08
by Ikar
Probably, the problem isn't in timeout but in a value of max_allowed_packet at the server.
Try to change a value of this variable. You can read details about it in MySQL Reference Manual.
rfish wrote:When uploading a large blob field to the database, I get the Exception [the database has gone away]. This limits the max upload size of the BLOB field to about 12MBytes. I need to be able to upload larger fields.

Is there somewhere to set this timeout?

Posted: Mon 08 Nov 2004 22:04
by rfish
Max allowed packet at the server is set to 500M (500 Mbytes).

I can use the mysql client to upload larger blob files than I can with the dbexpress component.

Posted: Tue 09 Nov 2004 10:52
by Ikar
Try to do it not in Direct mode. Do you have the same error?