Re: mp2 and Class:DBI

2005-01-05 Thread Stas Bekman
Randy Kobes wrote: On Wed, 5 Jan 2005, Stas Bekman wrote: Mike Carlton wrote: [...] But isn't there a problem with making db connections from startup.pl? When the processes later fork, you potentially wind up with database connection problems (I saw lots of problems under MP1 when I was doing this

Re: mp2 and Class:DBI

2005-01-05 Thread Perrin Harkins
On Wed, 2005-01-05 at 14:58 -0600, Randy Kobes wrote: > It's probably just me, but just to clarify the wording - > are you saying the use of PerlChildInitHandler, as in > Apache::DBI, *is* a safe way to to initiate database > connections within a startup.pl? It is, since it doesn't actually open a

Re: mp2 and Class:DBI

2005-01-05 Thread Randy Kobes
On Wed, 5 Jan 2005, Stas Bekman wrote: > Mike Carlton wrote: > [...] > > But isn't there a problem with making db connections from startup.pl? > > When the processes later fork, you potentially wind up with database > > connection problems (I saw lots of problems under MP1 when I was doing > > thi

Re: mp2 and Class:DBI

2005-01-04 Thread Perrin Harkins
On Tue, 2005-01-04 at 21:42 -0800, Mike Carlton wrote: > But isn't there a problem with making db connections from startup.pl? Only if you don't close them before forking. > Particularly with Class::DBI::mysql, just loading a class makes a > database connection. Right, but Class::DBI doesn't do

Re: mp2 and Class:DBI

2005-01-04 Thread Stas Bekman
Mike Carlton wrote: [...] But isn't there a problem with making db connections from startup.pl? When the processes later fork, you potentially wind up with database connection problems (I saw lots of problems under MP1 when I was doing this). Particularly with Class::DBI::mysql, just loading a cl

Re: mp2 and Class:DBI

2005-01-04 Thread Mike Carlton
On Tue, 04 Jan 2005 15:47:50 -0500, Perrin Harkins <[EMAIL PROTECTED]> wrote: > On Tue, 2005-01-04 at 14:18 -0500, Sean T Allen wrote: > > I looked to see and couldnt find any reports of issues with > > using Class::DBI w/ mod-perl 2 but wanted to check here to > > see if there are any I should be

Re: mp2 and Class:DBI

2005-01-04 Thread Perrin Harkins
On Tue, 2005-01-04 at 14:18 -0500, Sean T Allen wrote: > I looked to see and couldnt find any reports of issues with > using Class::DBI w/ mod-perl 2 but wanted to check here to > see if there are any I should be aware of... Class::DBI currently breaks the transaction-safety feature of Apache::DBI