I might have a couple of ideas that will hopefully help.
1. From reading the POD for
DBD::mysql, it notes the following:
This attribute is ignored when AutoCommit is turned off, and when AutoCommit is turned off, DBD::mysql will not automatically reconnect to the server.
Although, after
DBD::mysql version
2.0416, this
should default to 'on', you might want to try
$handle->{'AutoCommit'} = 1; just in case.
2. You might want to verify that the version of
DBD::mysql is recent. I know more and more functionality has been built into this module with later releases of MySQL
3. I haven't found this to be true for this specific attribute, however you might want to look into verifying that auto_reconnect is supported in MySQL 3.x; it
might be a database-dependent type of attribute. I don't imagine so, especially since the CPAN POD doesn't hint towards this, however I have noticed fishy things with earlier releases of MySQL in very specific curcumstances, and it may be worth looking into if nothing else.
Good Luck!!
---hA||ta----
print map{$_.' '}grep{/\w+/}@{[reverse(qw{Perl Code})]} or die while ( 'trying' );