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

sql logging

2015-02-06 Thread Theodore Petrosky
I have googled, searched the wiki, and tried everything I could think of, but I can not get my sql to log. In my properties: # ERExtensions # Transaction - Switching this to debug will start the sql ouputting. log4j.logger.er.transaction.adaptor.EOAdaptorDebugEnabled=DEBUG still no SQL :-( I

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 "fals

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

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 easil

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 pas

SQL logging

2009-11-03 Thread Lon Varscsak
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? -Lon ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev ma

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

SQL Logging in wonder.

2007-06-07 Thread Q
For the wonder experts. In wonder how does one enable logging of the number of rows being returned from an sql query? -- Seeya...Q Quinton Dolan - [EMAIL PROTECTED] Gold Coast, QLD, Australia Ph: +61 419 729 806 ___ Do not post admin requests t