Re: TIPool / multiple database connections

2002-08-01 Thread Gerald Richter
- - Original Message - From: Elizabeth Mattijsen [EMAIL PROTECTED] To: Stas Bekman [EMAIL PROTECTED]; Perrin Harkins [EMAIL PROTECTED] Cc: Tim Keefer [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, July 16, 2002 11:17 AM Subject: Re: TIPool / multiple database connections At 02:57 PM 7/16

Re: TIPool / multiple database connections

2002-07-16 Thread Stas Bekman
Perrin Harkins wrote: Elizabeth Mattijsen wrote: Hmm... but you won't be able to fetch the $dbh from the thread. It can only live in _that_ thread. You cannot pass objects between threads. But you _can_ send queries to that thread, fetch a jobid for that job and then obtain whatever

Re: TIPool / multiple database connections

2002-07-16 Thread Elizabeth Mattijsen
At 02:57 PM 7/16/02 +, Stas Bekman wrote: Perrin Harkins wrote: Hmmm... That could really throw a wrench in things. If you have an object based on a hash, and you share that hash, and you re-bless the object in each thread, does that work? What if the hash contains references to other

Re: TIPool / multiple database connections

2002-07-16 Thread Stas Bekman
Liz, should we move this thread to the perl-ithreads list so we can get some answers from the threads gurus? or p5p? I doubt Arthur is listening on this list. __ Stas BekmanJAm_pH -- Just Another mod_perl Hacker

TIPool / multiple database connections

2002-07-15 Thread Tim Keefer
I need to have several database connections within one modperl application (sharing the connections across all modules would ideal). Could anyone suggest a way to cache these connection with Apache2/modperl2 on win32? The modperl2 docs talk about a TIPool module along with a DBIPool module.

Re: TIPool / multiple database connections

2002-07-15 Thread Stas Bekman
Tim Keefer wrote: I need to have several database connections within one modperl application (sharing the connections across all modules would ideal). Could anyone suggest a way to cache these connection with Apache2/modperl2 on win32? The modperl2 docs talk about a TIPool module along

Re: TIPool / multiple database connections

2002-07-15 Thread Elizabeth Mattijsen
At 12:18 AM 7/16/02 +, Stas Bekman wrote: ...A few folks at p5p are creating a bunch of new modules around threads:: and threads::shared::, just yesterday a new module: Thread::Pool was released by Elizabeth Mattijsen. Which seems to be what's needed for Apache::DBITPool. Hmmm... I guess

Re: TIPool / multiple database connections

2002-07-15 Thread Stas Bekman
Elizabeth Mattijsen wrote: At 12:18 AM 7/16/02 +, Stas Bekman wrote: ...A few folks at p5p are creating a bunch of new modules around threads:: and threads::shared::, just yesterday a new module: Thread::Pool was released by Elizabeth Mattijsen. Which seems to be what's needed for

Re: TIPool / multiple database connections

2002-07-15 Thread Elizabeth Mattijsen
At 01:14 AM 7/16/02 +, Stas Bekman wrote: Hmmm... I guess you're right. I hadn't thought of applying Thread::Pool in this situation, but it sure makes sense. This would however imply that jobs would be submitted from different threads. That _should_ work, but I just realised that I

Re: TIPool / multiple database connections

2002-07-15 Thread Perrin Harkins
Elizabeth Mattijsen wrote: Hmm... but you won't be able to fetch the $dbh from the thread. It can only live in _that_ thread. You cannot pass objects between threads. But you _can_ send queries to that thread, fetch a jobid for that job and then obtain whatever was returned as a Perl