problem passing the $dbh handle between pages

[medine]

Hi folks,

I would like to be able to pass a DB handle between pages on a web site so that I will be able to use the same db connection. The connection works fine as long as I use it within the same file but when I try to pass the handle to another page I get the following error message.

Can't locate object method "prepare" via package "DBI::db=HASH(0x831cef8)" (perhaps you forgot to load "DBI::db=HASH(0x831cef8)"?) at TransactionDB.pm line 43.

I created the TransactionDB.pm file mentioned in the error message and if works fine.

I use

my $dbh = param('dbh');

to get the handle, which I then pass to a method which works fine elsewhere in the program.

I read somewhere that the DB object gets converted to a string, thats why it does not recognise the object, but I do not know how to maintain the handle as an obect when passing it to another page.

Any thoughts?

Thanks

Cal

 

[missbarbell]

The $dbh that you are getting back from DBI is a reference to an object held in memory. When the next page is requested, you are trying to access a block of memory that is no longer there, as it is released to the pool as soon as your script finished returning the previous page.

You can have persistent database connections by using mod_perl [1] and the Apache:BI [2] module.

[1]

http://perl.apache.org/

[2]

http://search.cpan.org/author/ABH/Apache-DBI-0.91/DBI.pm

Barbie
Leader of Birmingham Perl Mongers

http://birmingham.pm.org

 

[medine]

Barbie,

OK thanks for your help, I will work round the problem in the meantime and look at implimenting mod_perl eventually.

Cal