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 <[EMAIL PROTECTED]>
Subject: Re: [Catalyst] How to show SQL in apache
To: The elegant MVC web framework <[email protected]>
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset=us-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/
_______________________________________________
List: [email protected]
Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/[email protected]/
Dev site: http://dev.catalyst.perl.org/

Reply via email to