Re: SQL Logging in wonder.
Re: SQL Logging in wonder.
- Subject: Re: SQL Logging in wonder.
- From: Guido Neitzer <email@hidden>
- Date: Thu, 7 Jun 2007 07:59:41 -0600
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=Debug
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
_______________________________________________
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