Re: transaction Apache::DBI

2003-11-19 Thread Perrin Harkins
On Wed, 2003-11-19 at 02:34, Christophe Musielak wrote: > hum but connect_cached is quite a recent feature (my production servers > are DBI 0.92) Actually, connect_cached is more than 4 years old. The 0.92 release came out in February 1998! You really need to upgrade. > The last solution is to

Re: transaction Apache::DBI

2003-11-19 Thread Christophe Musielak
Le lun 17/11/2003 à 18:16, Perrin Harkins a écrit : > On Mon, 2003-11-17 at 09:30, Jamie Le Tual wrote: > > An interesting test would be to put a sleep(20) adter the delcaration of > > the second database handle, then open a mysql shell and do a : > > show processlist; > > There's no need to go

Re: transaction Apache::DBI

2003-11-17 Thread Perrin Harkins
On Mon, 2003-11-17 at 09:30, Jamie Le Tual wrote: > An interesting test would be to put a sleep(20) adter the delcaration of > the second database handle, then open a mysql shell and do a : > show processlist; There's no need to go to all that trouble. Turning on debugging for Apache::DBI will

Re: transaction Apache::DBI

2003-11-17 Thread Jamie Le Tual
An interesting test would be to put a sleep(20) adter the delcaration of the second database handle, then open a mysql shell and do a : show processlist; to see how many connections you have to your database server. My guess is that you will see one. If thats the case, then whats happening is p

Re: transaction Apache::DBI

2003-11-14 Thread Perrin Harkins
On Fri, 2003-11-14 at 02:50, Christophe Musielak wrote: > my $db = DBI->connect($dsn,$user, $password, { AutoCommit => 1, > RaiseError => 1 } )|| > die "ERROR NO_CONNECTION_TO_POSTMASTER\n"; > > print "$db"."\n"; > > print "".$db->{AutoCommit}."\n"; > > $db->{AutoCommit} = 0; > > print "".$db->

Re: transaction Apache::DBI

2003-11-14 Thread Christophe Musielak
Le jeu 13/11/2003 à 20:08, Perrin Harkins a écrit : > On Thu, 2003-11-13 at 10:32, Christophe Musielak wrote: > > My question is : is it safe to use transactions of multiple objects, > > doing a commit or rollback at the end as i'm sure i will stay in the > > same interpreter space and that no othe

Re: transaction Apache::DBI

2003-11-13 Thread Perrin Harkins
On Thu, 2003-11-13 at 10:32, Christophe Musielak wrote: > My question is : is it safe to use transactions of multiple objects, > doing a commit or rollback at the end as i'm sure i will stay in the > same interpreter space and that no other user can ask for the same > database handle to do some stu

transaction Apache::DBI

2003-11-13 Thread Christophe Musielak
Hi, its been some times i'm reading, first time i'm writing :) first let me present myself : Christophe, 33, working on a e-crm application web based that deals with emails. This is app is written mostly in Perl with some C++. We're using mp1, Apache 1.3, Embperl and Postgres. The Perl libs are f