Re: Pass a DBI Object?

[prev] [thread] [next] [Date index for 2004/08/18]

Brian E. Lozier wrote:
> Is there a way to pass an already-existing DBH to Class::DBI instead of  
> using its connection() method?
> 
> Thanks,
> Brian
> 

... try this

package My::Class::DBI::Project;

our $dbh;

sub db_Main { $dbh; }

...

package main;

$My::Class::DBI::Project::dbh = $my_dbh;

----------

Explanation:
   connection method calls Ima::DBI's method set_db with first parameter 
'Main'. It creates method db_Main, witch should return some db handler.

So, if you provides your own db_Main method, you can use your own dbh.
(this is neccessary e.g. if you want handle broken db connection without 
restarting your application)

In my opinion, this is great disadvantage of Class::DBI.

By,

Barney