Dale Amon
and 1 contributors


 Fault::Dbh - Database Handle abstraction.


 use Fault::Dbh;
 $db  = Fault::Dbh->open ($db, $usr, $pass);
 $dbh = $db->dbh;


The Fault::Dbh Database handle abstraction centralizes the creation and destruction of a database handle for a connection to the database server. I do this to minimize the number of active socket connections to the database server. I have observed situations in which all available processes have been utilized, causing further access attempts to fail.

This is currently only coded to function on a single local MySQL database. If multiple databases are required, I will have to get fancier, perhaps a local hash of database names with handles attached.

The init method is supplied for use in forked environments. Since only a single database connection is created by open, no matter how many times you call it, you will get into very deep trouble if you open then fork and access the database from both processes. If you fork, use the init method as one of the first things you do in your child process. If you do not do this, do not come crying to me about the really weird random error messages and connection closures you are getting from your database.

If I wanted to, I could subclass the DBI::db handle itself, but I did not study enough of it to make sure I did not step on anything,

Error handling is currently minimal; virtually anything that goes wrong will cause the return of a pointer with a value of undef.


 use Fault::Dbh;
 $db  = Fault::Dbh->open ("mydatabase","me","apassword");
 $dbh = $db->dbh;

Class Variables (Internal)

 DBH            the database handle or undef
 DBHCNT         number of opens on this handle, zero if closed.

Instance Variables


Class Methods


Initialize the local database handles. This discards any handle which was previously opened. We need this because if we fork a process the old handle gets shared among parent and child processes and if any two attempt to communicate with the db at the same time...

If you are only working with a single process, you only need to use open and close. If you fork, you should init as one of the very first things you do in the new process.

$dbh = Fault::Dbh->open ($db, $usr, $pass)

Class method to create a new object to handle a connection to the local database server for $db as user $usr with password $pass. It only supports one localhost database at present. A new connection is opened only if the count of open connections is zero; otherwise it re-uses the currently open one.

It returns undef if it fails to make the requested connection.

Instance Methods

$dbh = $db->dbh

Return the database handle.


Close this connection to the database server. It decrements the count of open connections and does the real disconnect if the count reaches zero.

Private Class Methods


Private Instance Methods


Errors and Warnings



 See TODO.




Dale Amon <amon@vnl.com>

2 POD Errors

The following errors were encountered while parsing the POD:

Around line 160:

=back doesn't take any parameters, but you said =back 4

Around line 175:

=back doesn't take any parameters, but you said =back 4