Re: [RDBO] Too Many connections

2008-01-25 Thread John Siracusa
your common base class up-front, as described above) or just pass in a "db" parameter to every Manager call. -John >> -Original Message- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On >> Behalf Of John Siracusa >> Sent: Thursday, January

Re: [RDBO] Too Many connections

2008-01-25 Thread maxim
PROTECTED] > [mailto:[EMAIL PROTECTED] On > Behalf Of John Siracusa > Sent: Thursday, January 10, 2008 7:25 PM > To: Rose-DB-Object > Subject: Re: [RDBO] Too Many connections > > On 1/10/08 5:30 PM, James Masters wrote: > > Looking into this, I seem to simply be doing t

Re: [RDBO] Too Many connections

2008-01-11 Thread Ted Zlatanov
On Fri, 11 Jan 2008 13:29:43 -0500 "John Siracusa" <[EMAIL PROTECTED]> wrote: JS> On Jan 11, 2008 1:10 PM, Ted Zlatanov <[EMAIL PROTECTED]> wrote: >> I think the automatic class builder should have a required option to set >> the default explicitly (it didn't, last time I looked). That would >>

Re: [RDBO] Too Many connections

2008-01-11 Thread John Siracusa
On Jan 11, 2008 1:10 PM, Ted Zlatanov <[EMAIL PROTECTED]> wrote: > I think the automatic class builder should have a required option to set > the default explicitly (it didn't, last time I looked). That would > ensure the developer thought about it even in the path of least > resistance. Wat woul

Re: [RDBO] Too Many connections

2008-01-11 Thread Ted Zlatanov
On Fri, 11 Jan 2008 07:43:23 -0500 "John Siracusa" <[EMAIL PROTECTED]> wrote: JS> That's why I think the default unshared behavior is the "safest" in JS> that sharing now requires some action (and therefore some thought) on JS> the part of the developer. The required action is simple (usually a J

Re: [RDBO] Too Many connections

2008-01-11 Thread John Siracusa
On Jan 11, 2008 4:43 AM, James Masters <[EMAIL PROTECTED]> wrote: > In my naivety, it seems to me that conceptually a script would normally have > a single shared connection for all it's calls. Both from a tidiness point > of view and also because I guess it would be better performing not to keep

Re: [RDBO] Too Many connections

2008-01-11 Thread James Masters
John Siracusa Sent: 11 January 2008 01:25 To: Rose-DB-Object Subject: Re: [RDBO] Too Many connections On 1/10/08 5:30 PM, James Masters wrote: > Looking into this, I seem to simply be doing the following in a "for" loop > more than 100 times: > > my $shipobj = MGORD::Shipment-&g

Re: [RDBO] Too Many connections

2008-01-10 Thread John Siracusa
On 1/10/08 5:30 PM, James Masters wrote: > Looking into this, I seem to simply be doing the following in a "for" loop > more than 100 times: > > my $shipobj = MGORD::Shipment->new(shipid => $shipid)->load(with =>['items', > 'costs', 'problems', 'predictedcosts', 'toaddress', 'fromaddress']); > >

[RDBO] Too Many connections

2008-01-10 Thread James Masters
Another new odd thing happened today. Have a program that has worked fine for sometime but today it had to suck in more data than ever before and produced: Too many connections at C:/Perl/site/lib/Rose/DB.pm line 828 This seems to be a common error and simply means I've broken the default restric