Re: using Apache::DBI for regular perl scripts?

2007-01-04 Thread Lev Lvovsky
On Jan 4, 2007, at 4:36 PM, Perrin Harkins wrote: On Thu, 2007-01-04 at 16:28 -0800, Lev Lvovsky wrote: Is there anything that would keep me from instituting the connection maintenance of Apache::DBI into a daemonized perl script? Don't do that. Use DBI->connect_cached instead. didn't eve

Re: using Apache::DBI for regular perl scripts?

2007-01-04 Thread Perrin Harkins
On Thu, 2007-01-04 at 16:28 -0800, Lev Lvovsky wrote: > Is there anything that would keep me from instituting the connection > maintenance of Apache::DBI into a daemonized perl script? Don't do that. Use DBI->connect_cached instead. - Perrin

Re: Using Apache::DBI

2006-09-07 Thread Jonathan Vanasco
On Sep 7, 2006, at 4:40 PM, Jay Buffington wrote: This solves a problem I was having some time ago while implementing ecommerce (verisign): 1. insert customer's info 2. authorize credit card 3. log authorization response to database 4. if auth fails roll back #1, but keep #3 Nested transact

Re: Using Apache::DBI

2006-09-07 Thread Jay Buffington
This solves a problem I was having some time ago while implementing ecommerce (verisign): 1. insert customer's info 2. authorize credit card 3. log authorization response to database 4. if auth fails roll back #1, but keep #3 I was planning on solving this problem using Oracle's AUTONOMOUS_TRAN

Re: Using Apache::DBI

2006-09-07 Thread Jonathan Vanasco
take a look at: http://search.cpan.org/~crakrjack/DBIx-Transaction-0.008/ which allows for nested transactions in a DBI handle. I use something homegrown and similar (but not stable enough for cpan), that intercepts calls to connect/disconnect and treats them as begin/end commands

Re: Using Apache::DBI

2006-09-07 Thread Perrin Harkins
On Thu, 2006-09-07 at 12:29 -0700, Jay Buffington wrote: > But, that handle might have expired, so it is possible to get a > different handle. It's not likely, but it is possible. You'd need to have some transient error that caused the connection to die between DBI calls. (Not during a call, sin

Re: Using Apache::DBI

2006-09-07 Thread Jay Buffington
Reviving a thread 4 months later... On 5/10/06, Perrin Harkins <[EMAIL PROTECTED]> wrote: On Wed, 2006-05-10 at 10:26 -0700, Jay Buffington wrote: > At first I was caching the database handle myself when running outside > of mod_perl. In mod_perl I was relying on Apache::DBI returning the > sam

Re: Using Apache::DBI

2006-05-10 Thread Perrin Harkins
On Wed, 2006-05-10 at 10:26 -0700, Jay Buffington wrote: > At first I was caching the database handle myself when running outside > of mod_perl. In mod_perl I was relying on Apache::DBI returning the > same handle every time I called connect(). That didn't work. What didn't work about it? If yo

Re: Using Apache::DBI

2006-05-10 Thread Jonathan Vanasco
On May 10, 2006, at 1:26 PM, Jay Buffington wrote: I want my modules to be able to get a the same database handle anywhere they need it during a single request (if under mod_perl) or the life time of the script they're in. At first I was caching the database handle myself when running outside

Re: Using Apache::DBI

2006-05-10 Thread Jay Buffington
I want my modules to be able to get a the same database handle anywhere they need it during a single request (if under mod_perl) or the life time of the script they're in. At first I was caching the database handle myself when running outside of mod_perl. In mod_perl I was relying on Apache::DBI

Re: Using Apache::DBI

2006-05-08 Thread Perrin Harkins
On Mon, 2006-05-08 at 17:23 +0200, Lionel MARTIN wrote: > I'm not sure this is right. Acording to what I read, and to my test, the > PerlInitHandler phase happens for every request, and not just when threads > are created. I called it PerlInitHandle, but it's actually called PerlChildInitHandler

Re: Using Apache::DBI

2006-05-08 Thread Lionel MARTIN
rkins" <[EMAIL PROTECTED]> To: "Lionel MARTIN" <[EMAIL PROTECTED]> Cc: "Octavian Rasnita" <[EMAIL PROTECTED]>; Sent: Monday, May 08, 2006 5:00 PM Subject: Re: Using Apache::DBI On Mon, 2006-05-08 at 16:56 +0200, Lionel MARTIN wrote: And what a

Re: Using Apache::DBI

2006-05-08 Thread Perrin Harkins
On Mon, 2006-05-08 at 16:56 +0200, Lionel MARTIN wrote: > And what about the best usage when using threaded MPMs, like Win32 MPMs, > concerning connections? It's no different. The threads are created after startup, and the init phase happens in each thread. - Perrin

Re: Using Apache::DBI

2006-05-08 Thread Lionel MARTIN
And what about the best usage when using threaded MPMs, like Win32 MPMs, concerning connections? - Original Message - From: "Perrin Harkins" <[EMAIL PROTECTED]> To: "Octavian Rasnita" <[EMAIL PROTECTED]> Cc: Sent: Monday, May 08, 2006 3:26 P

Re: Using Apache::DBI

2006-05-08 Thread Perrin Harkins
Octavian Rasnita wrote: I thought the best way of using Apache::DBI is to put the following code in the startup.pl script: use Apache::DBI (); Apache::DBI->connect_on_init('DBI:mysql:database=database_name;host=10.50.28 .37', 'user', undef, {PrintError => 1, RaiseError => 0, AutoCommit => 1}); u