Hi Robin,

This sounds bang-on.

Many thanks.

regards,
Martin

On Mon, 2003-06-09 at 13:34, Robin Keech wrote:
> You could try forking before making a connection to the database.
> 
> A forked program will share the same resources (I think), and the DBI could be 
> getting the child signal and closing connection. However, any resources you create 
> after the fork will be your own.
> 
> Hope it helps (bit of a guess really),
> 
> Robin Keech
> Java Developer
> Synectics Ltd
> 
> 
> -----Original Message-----
> From: Martin Waite [mailto:[EMAIL PROTECTED] 
> Sent: 09 June 2003 12:10
> To: MySQL List
> Subject: problem with DBI connection interaction with sub-process
> 
> 
> <snip>
> 
> What seems to happen is that when the child exits, the
> DBI connection to the database is lost and automatically
> reconnected (how?).   Obviously this blows away my temporary
> tables.
> 
> Does anyone know how to avoid this ?
> 
> <snip>
> 
> regards,
> Martin
> 
> 
>  
> 
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.474 / Virus Database: 272 - Release Date: 18/04/2003
>  
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]
> 



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to