Re: Check the DB-handle status.

2008-10-13 Thread Jenda Krynicky
From: Deviloper <[EMAIL PROTECTED]> > > If you use RaiseErrors, DBI dies in case of error. In a daemonlike > script, that is properly the last thing you want to happen. Not really. die() doesn't mean "exit the script with this message". It means "throw this exception and in case no one catches

Re: Check the DB-handle status.

2008-10-13 Thread Deviloper
If you use RaiseErrors, DBI dies in case of error. In a daemonlike script, that is properly the last thing you want to happen. the perldoc on finish() might has missed out, that if autocommit is deactivated, it is not guaranteed that the commit to db is done at the moment the instruction is ex

Re: Check the DB-handle status.

2008-10-13 Thread Jenda Krynicky
From: Deviloper <[EMAIL PROTECTED]> > in the early days of the dbi-modul there was a function $dbh->ping(). > nearly no driver ever implemented it. > > I want to check the status of my db, in my daemon on a regular base. > I could not find any standard solution. Today I´m just doing a query > and c

Re: Check the DB-handle status.

2008-10-13 Thread Rob Coops
On Mon, Oct 13, 2008 at 10:29 AM, Deviloper <[EMAIL PROTECTED]> wrote: > Hi there, > > in the early days of the dbi-modul there was a function $dbh->ping(). > nearly no driver ever implemented it. > > I want to check the status of my db, in my daemon on a regular base. > I could not find any stand

Check the DB-handle status.

2008-10-13 Thread Deviloper
Hi there, in the early days of the dbi-modul there was a function $dbh->ping(). nearly no driver ever implemented it. I want to check the status of my db, in my daemon on a regular base. I could not find any standard solution. Today I´m just doing a query and check then if there where errors.