Re^3: how to test a connection with mysql db

You shouldn't have to worry that much about the connection; simply test the return value of each DBI statement, if it fails, then it MAY be because the connection's lost.
$dbh->something() or .... # put your error management code here

Comment on Re^3: how to test a connection with mysql db Download Code

Replies are listed 'Best First'.
Re^4: how to test a connection with mysql db by Anonymous Monk on Jul 22, 2005 at 07:42 UTC
What if the sql statement is wrong, than it also fails! Is there a difference between both ? Luca	[reply]
Re^5: how to test a connection with mysql db by wazoox (Prior) on Jul 22, 2005 at 09:34 UTC
The error message is different, yes. But it will also vary from a sgbd to another, or from a version to another. You can't really help there.	[reply]
Re^6: how to test a connection with mysql db by jeanluca (Deacon) on Jul 25, 2005 at 12:29 UTC
What is exactly the consequence of connecting a perl object to a mysql database, while it is already connected ? Luca	[reply]
Re^7: how to test a connection with mysql db by wazoox (Prior) on Jul 25, 2005 at 13:09 UTC