|Problems? Is your data what you think it is?|
Confirm persistent db connection?
Contributed by Athalia
on Sep 21, 2000 at 03:01 UTC
Q&A > database programming
Description:I have a web resource served by Apache with a Perl interface to a MySQL database. In order to speed things up, I am using mod_perl/Apache::DBI to create a persistent database connection in a script that is run when Apache is started.
I want to make sure that I actually have a persistent connection. The scripts that query the db were not originally written with mod_perl in mind and each one contains a db connection statement. The mod_perl guide says these will be ignored if a persistent connection exists.
The obvious way to test would be to remove these statements and see if the queries fail but I'm sure there must be a more elegant and explicit test.
Does anyone know how to do this? Is there a connection id or environment variable that I can get?
Thanks in advance...
[formatted by editor]
Please (register and) log in if you wish to add an answer