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]