Re: multiple database users

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

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

On 7 Jun 2005, at 04:58, Perrin Harkins wrote:

> 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.

there are also shared-namespace problems with this particular  
solution. The connection key that Alexander is using to select a  
database handle is stored as class data, so in most respects it is  
exactly the same as calling connection().

will







>
>
>> 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