Timeout when uploading large BLOB field

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for MySQL in Delphi and C++Builder
Post Reply
rfish
Posts: 7
Joined: Mon 08 Nov 2004 14:28
Location: Fredericksburg, VA

Timeout when uploading large BLOB field

Post by rfish » Mon 08 Nov 2004 14:32

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?

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Re: Timeout when uploading large BLOB field

Post by Ikar » Mon 08 Nov 2004 16:08

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?

rfish
Posts: 7
Joined: Mon 08 Nov 2004 14:28
Location: Fredericksburg, VA

Post by rfish » Mon 08 Nov 2004 22:04

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.

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Tue 09 Nov 2004 10:52

Try to do it not in Direct mode. Do you have the same error?

Post Reply