Re: multiple database users

[prev] [thread] [next] [Date index for 2005/06/07]

From: Perrin Harkins
Subject: Re: multiple database users
Date: 03:58 on 07 Jun 2005

Jay Strauss wrote:
> What's the issue if your using mod_perl?

There are at least three problems with this code for use under mod_perl:

- Doesn't pay attention to whether the server is starting or not, so if 
you load any classes that do a set_up_table() in your startup.pl it will 
cause a connection to open before the fork and wreak havoc when your 
program tries to use it after the fork.

- Doesn't ping the connection to see if they're dead.  The connections 
in that hash could time out, and this code would keep trying to use them.

- Doesn't call connect at least once per request, so databases that use 
transactions will not get the Apache::DBI rollback handler registered, 
leaving you wide open for hanging transactions if your code dies in an 
unexpected place.

> And can you solve issue and 
> provide a single design that can be used in mod_perl and non-mod_perl 
> environments?

You can merge in the stuff from the mod_perl page on the wiki.  I also 
have a patch for Ima::DBI that I'll try to clean up and post tomorrow.

- Perrin

multiple database users
Hartmaier Alexander 17:43 on 02 Jun 2005

Re: multiple database users
Andreas Fromm 07:13 on 03 Jun 2005

Re: multiple database users
William Ross 08:42 on 03 Jun 2005

Re: multiple database users
Hartmaier Alexander 10:29 on 06 Jun 2005

Re: multiple database users
Mark Addison 11:20 on 06 Jun 2005

Re: multiple database users
William Ross 11:39 on 06 Jun 2005

Re: multiple database users
Tony Bowden 13:09 on 06 Jun 2005

Re: multiple database users
Mark Addison 13:34 on 06 Jun 2005

Re: multiple database users
Perrin Harkins 14:30 on 06 Jun 2005

Re: multiple database users
Hartmaier Alexander 11:31 on 06 Jun 2005

Re: multiple database users
Hartmaier Alexander 11:51 on 06 Jun 2005

Re: multiple database users
William Ross 13:46 on 06 Jun 2005

Re: multiple database users
Hartmaier Alexander 14:03 on 06 Jun 2005

Re: multiple database users
William Ross 15:30 on 06 Jun 2005

Re: multiple database users
Hartmaier Alexander 16:44 on 06 Jun 2005

Re: multiple database users
William Ross 18:26 on 06 Jun 2005

Re: multiple database users
Jay Strauss 02:53 on 07 Jun 2005

Re: multiple database users
Perrin Harkins 03:58 on 07 Jun 2005

Re: multiple database users
William Ross 10:23 on 07 Jun 2005

Re: multiple database users
Hartmaier Alexander 09:28 on 07 Jun 2005

Re: multiple database users
Perrin Harkins 12:49 on 07 Jun 2005

Re: multiple database users
Hartmaier Alexander 12:49 on 07 Jun 2005

Re: multiple database users
Perrin Harkins 12:54 on 07 Jun 2005

Re: multiple database users
Hartmaier Alexander 13:02 on 07 Jun 2005

Re: multiple database users
Mark Addison 13:47 on 07 Jun 2005