Re: SQL Logging in wonder.
Re: SQL Logging in wonder.
- Subject: Re: SQL Logging in wonder.
- From: Q <email@hidden>
- Date: Fri, 8 Jun 2007 01:10:51 +1000
Thanks. I needed to bump the log4j.logger.er log level up to get the
extra detail.
On 07/06/2007, at 11:59 PM, Guido Neitzer wrote:
On 07.06.2007, at 05:06, Q wrote:
In wonder how does one enable logging of the number of rows being
returned from an sql query?
By activating SQL logging with:
er.extensions.ERXAdaptorChannelDelegate.enabled=true
er.extensions.ERXAdaptorChannelDelegate.maxMilliSeconds=1000
er.extensions.ERXAdaptorChannelDelegate.trace.milliSeconds.debug=0
er.extensions.ERXAdaptorChannelDelegate.trace.milliSeconds.info=100
er.extensions.ERXAdaptorChannelDelegate.trace.milliSeconds.warn=1000
er.extensions.ERXAdaptorChannelDelegate.trace.milliSeconds.error=5000
log4j.category.er.extensions.ERXAdaptorChannelDelegate.sqlLogging=Debu
g
I get the following output:
07:56:14 ERXNSLogLog4jBridge:44 DEBUG - evaluateExpression:
<com.webobjects.jdbcadaptor.PostgresqlExpression: "SELECT
t0.contact_id FROM contacts t0 WHERE (t0.inheritance_type =
'EventsUser' AND t0.client_id = 2) ORDER BY t0.lastname ASC LIMIT 2
OFFSET 0">
07:56:14 ERXNSLogLog4jBridge:44 DEBUG - 2 row(s) processed
The number of rows is shown after the SQL output.
cug
--
Seeya...Q
Quinton Dolan - email@hidden
Gold Coast, QLD, Australia
Ph: +61 419 729 806
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden