Subject: Re: [Catalyst] How to show SQL in apache

[Cookie]

If the sql print out to the STDERR,I think the apache server should be
caught.
I follow the Storage::DBI,open a new filehandle,and tried to write the
log,but it seems still useless.
I am so puzzled about this,Please help me.Thanks.

Message: 6
Date: Wed, 13 Jun 2007 06:55:05 +0100
From: Matt S Trout <dbix-class at trout.me.uk>
Subject: Re: [Catalyst] How to show SQL in apache
To: The elegant MVC web framework <catalyst at lists.rawmode.org>
Message-ID: <20070613055505.GN8493 at jules.scsys.co.uk>
Content-Type: text/plain; charset=3Dus-ascii

On Wed, Jun 13, 2007 at 12:27:26PM +0800, Cookie wrote:
> Thanks for your answer.But I think it already can not work although I add
> $schema->storage->debug(1);
> in my code.I agree with you the output of sql is in the STDOUT.I will find
> some way of configurating the apache to record the STDOUT.

No it isn't.

STDERR is the default.

> BTW,If I want to know,if I used log4perl,Can I log the sql in my log
> file?Thanks.

Read the Storage::DBI docs and follow the references to provide a custom
debug object.

--
     Matt S Trout       Need help with your Catalyst or DBIx::Class project?
  Technical Director    Want a managed development or deployment platform?
 Shadowcat Systems Ltd.  Contact mst (at) shadowcatsystems.co.uk for a quote
http://chainsawblues.vox.com/             http://www.shadowcatsystems.co.uk/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20070619/14398=
ff4/attachment.htm