<div>
DBI can generate debugging information itself:<br />
<br />
set <br />
&nbsp; &nbsp; DBI-&gt;trace(2 =&gt; &quot;/tmp/logfile&quot;);<br />
somewhere near the top of your script.<br />
Or set the environment variable<br />
&nbsp; &nbsp; DBI_PROFILE=2<br />
<br />
See manuals for DBI::Profile and DBI::Trace.<br />
<br />
(Found this at <a href="http://www.class-dbi.com/cgi-bin/wiki/index.cgi?SeeAllSQL" rel="ugc">http://www.class-dbi.com/cgi-bin/wiki/index.cgi?SeeAllSQL</a>)
</div>


DBI can generate debugging information itself:

set
    DBI->trace(2 => "/tmp/logfile");
somewhere near the top of your script.
Or set the environment variable
    DBI_PROFILE=2

See manuals for DBI::Profile and DBI::Trace.

(Found this at http://www.class-dbi.com/cgi-bin/wiki/index.cgi?SeeAllSQL [http://www.class-dbi.com/cgi-bin/wiki/index.cgi?SeeAllSQL])

<div>
<div class="content wysiwyg-content">
I have a large code base (which runs under mod_perl) to which I would like to add some debugging code.<br />
<br />
I would like to be able to run a bit of code everytime DBI is used to connect, prepare or execute. How can I add this debugging code _without_ editing every call to those methods and _without_ editing the DBI module itself. 
</div>
</div>


I have a large code base (which runs under mod_perl) to which I would like to add some debugging code.

I would like to be able to run a bit of code everytime DBI is used to connect, prepare or execute. How can I add this debugging code _without_ editing every call to those methods and _without_ editing the DBI module itself. 

Transparent wrapper around DBI for debugging purposes

Perl is a high-level, general-purpose, interpreted, dynamic programming languages with over 25 years of development. Perl 5 runs on over 100 platforms from portables to mainframes and is suitable for both rapid prototyping and large-scale development projects.  Perl gained widespread popularity as a Common Gateway Interface (CGI) scripting language, in part due to its regular expression and string parsing abilities. In addition to CGI, Perl is used for graphics programming, system administration, network programming, finance, bioinformatics, and other applications.