Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re: How to report call stack for DBI queries

by arturo (Vicar)
on Apr 17, 2003 at 18:09 UTC ( #251278=note: print w/ replies, xml ) Need Help??


in reply to How to report call stack for DBI queries

update: whoops, read the note way too quickly. Thought you wanted a trace of what's going on in the prepare calls; the advice stands for that usage, but not for the poster's question!

Check out the DBI's trace method, which is simple to set up:

my $db = DBI->connect(#blah blah blah"); # trace level (1-9), and output (STDERR if not specified) $db->trace(2, '/tmp/trace.log');

I find level 2 to be of general use while debugging harder problems, 3 when 2 doesn't reveal enough, but I've never needed to go any higher. As the docs used to say, 6 really is too high to be useful, but I suppose it's there for a reason =)

If not P, what? Q maybe?
"Sidney Morgenbesser"


Comment on Re: How to report call stack for DBI queries
Select or Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://251278]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (8)
As of 2015-07-04 14:22 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (60 votes), past polls