Re: What is the trick to debug SQL?
Re: What is the trick to debug SQL?
- Subject: Re: What is the trick to debug SQL?
- From: Mark Ritchie <email@hidden>
- Date: Sat, 24 Feb 2007 10:01:25 -0500
On 21-Feb-07, at 12:34 PM, James Cicenia wrote:
It seems like no matter how many enabled debugging, wo arguments,
etc., I can't get it to show me my sql?!
On 23-Feb-07, at 1:46 PM, Christoph Zimmermann wrote:
I also have the problem to enable SQL debugging with Xcode. No
matter witch attribute i use (-DEOAdaptorDebugEnabled=true or
EOAdaptorDebugEnabled YES) I can,t see any SQL syntax. I don,t have
errors now, but I will need it. It worked a while ago.
Interestingly the same Code transferred to WoLips shows SQL Log.
On the otther hand the Code in xcode produces perfectly XSL Files
using Project Wonders ERExtensions and ExcelGenerator. This doesn:t
work in Eclipse. It also worked here a while ago.
I ran into this problem last year and while I never took the time to
fix the problem, I did discover a work around. Since I didn't track
it back to the source, YMMV.
For me, the usual -DEOAdaptorDebugEnabled=true flag stopped
working once I included ERExtensions from Wonder. I was running
Xcode on OS X with one on the nightly builds of Wonder.
My workaround was to include the ERD2WDebugFlags.wo component in my
application.
Clicking the Log4J link will open a second browser window, with Log4J
configuration settings.
On that page, click 'Show All", scroll down find a line like this:
er.transaction.adaptor.EOAdaptorDebugEnabled
On that line, click the Debug radio button and then click the update
button!
Poof, like magic, now the SQL logs show up as normal. :-)
The downside is that I had to do this for every launch of the
application.
The upside is that ERD2WDebugFlags.wo automatically turns itself off
in deployment.
Hope that helps!
Mark
__
Mark Ritchie
Cocoa and WebObjects Developer
Diamond Lake Consulting Inc.
Toronto, Ontario, Canada
_______________________________________________
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