FYI, just configure PW SQL logging with this in Properties file,
adjusting values for your needs
########################################################################
#
# ERXAdaptorChannelDelegate
########################################################################
#
## Enable delegate to emit SQL debugging info. The Logger used is
## log4j.category.er.extensions.ERXAdaptorChannelDelegate.sqlLogging
er.extensions.ERXAdaptorChannelDelegate.enabled=true
## How long a statement must run to cause a log message. Messages
with longer than
## error also emit a stack-trace
er.extensions.ERXAdaptorChannelDelegate.trace.milliSeconds.debug=10
er.extensions.ERXAdaptorChannelDelegate.trace.milliSeconds.info=100
er.extensions.ERXAdaptorChannelDelegate.trace.milliSeconds.warn=700
er.extensions.ERXAdaptorChannelDelegate.trace.milliSeconds.error=3000
## MaxLength of the message
er.extensions.ERXAdaptorChannelDelegate.trace.maxLength = 3000
## What entities to watch
er.extensions.ERXAdaptorChannelDelegate.trace.entityMatchPattern = .*
On Feb 21, 2007, at 3:31 PM, Kieran Kelleher wrote:
put a try/catch around the ec.saveChanges(), and catch the
EOGeneralAdaptorException. Then log out the contents of the
exception.userInfo() ...... somewhere in there is the SQL error
that the database gave you back.
Alternatively, turn on MySQL statement logging for all statements
to see what the database sees....... by putting sth like this in
your my.cnf:
log=/var/log/mysql.log
and then tail -f on that file.
HTH, Kieran
On Feb 21, 2007, at 12:34 PM, James Cicenia wrote:
I get this error:
[2007-02-21 11:32:49 CST] <WorkerThread2>
com.webobjects.foundation.NSForwardException for
com.webobjects.eoaccess.EOGeneralAdaptorException:
updateValuesInRowDescribedByQualifier --
com.webobjects.jdbcadaptor.JDBCChannel method failed to update row
in database
It seems like no matter how many enabled debugging, wo arguments,
etc., I can't get it to show me my sql?!
What is the trick?
Thanks
James Cicenia
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/kieran_lists%
40mac.com
This email sent to [EMAIL PROTECTED]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/kieran_lists%
40mac.com
This email sent to [EMAIL PROTECTED]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
