Re: sql logging

2015-02-06 Thread OC
Ted, if Timothy's advice does not help -- I bumped into similar problem lately (along with my weird “prepareForSaveWithCoordinator: Cannot save the object with globalID” problems /whose relatively unsurprising and rather sad results I'm about to write in a moment/), and haven't been able to log

Re: sql logging

2015-02-06 Thread Timothy Worman
Hola! With Wonder you want to do these: # Enable delegate to emit SQL debugging info. The Logger used is log4j.category.er.extensions.ERXAdaptorChannelDelegate.sqlLogging=DEBUG # put this to true if you want to log sql stuff er.extensions.ERXAdaptorChannelDelegate.enabled=true # How long a state

Re: SQL logging

2009-11-03 Thread Chuck Hill
On Nov 3, 2009, at 2:19 PM, Lon Varscsak wrote: Is there a way to get SQL logging where it's easily cut and pasted into a sql tool to analyze performance rather than the JDBC version with ?s and parameters? Not that I know of. You could make a plugin subclass to return "false" for the

Re: SQL logging

2009-11-03 Thread Lon Varscsak
Yeah, that's not a bad idea since I already am subclassing the existing Sybase plugin. I'll try that, thanks! -Lon On Tue, Nov 3, 2009 at 3:27 PM, Chuck Hill wrote: > > On Nov 3, 2009, at 2:19 PM, Lon Varscsak wrote: > > Is there a way to get SQL logging where it's easily cut and pasted into

Re: SQL logging

2009-11-03 Thread Kieran Kelleher
Does your database have a setting to log slow queries, or even all queries to a text file . I know MySQL can do this with a property in the my.cnf properties file . Regards, Kieran On Nov 3, 2009, at 5:19 PM, Lon Varscsak wrote: Is there a way to get SQL logging where it's easily cut

Re: SQL logging

2009-11-03 Thread Mike Schrag
pretty sure anjo did this somewhere maybe for the sql stats tracking stuff? i'm 99% sure this code exists in wonder. On Nov 3, 2009, at 5:27 PM, Chuck Hill wrote: On Nov 3, 2009, at 2:19 PM, Lon Varscsak wrote: Is there a way to get SQL logging where it's easily cut and pasted into a

Re: SQL Logging in wonder.

2007-06-07 Thread Q
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

Re: SQL Logging in wonder.

2007-06-07 Thread Guido Neitzer
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.ERX