Re: Logging SQL statements
Re: Logging SQL statements
- Subject: Re: Logging SQL statements
- From: Mike Schrag <email@hidden>
- Date: Sun, 18 Dec 2005 14:53:51 -0500
By the way, every time I've had that "failed to update row", it was
caused by optimistic locking failing because of precision problems in
either a float/double/decimal type or a timestamp type that was
mapping to a date (without time) type in the database.
ms
On Dec 18, 2005, at 2:04 PM, Stirling Olson wrote:
Still no luck. Is there any way to set this programmatically? At
least that way it will have to compile.
Any known problems with XCode 2.1 or WO 5.3 on this front?
Thanks everyone. I'm trying to get this logging working so I can
solve a REAL problem where I mysteriously get the following:
com.webobjects.eoaccess.EOGeneralAdaptorException:
updateValuesInRowDescribedByQualifier --
com.webobjects.jdbcadaptor.JDBCChannel method failed to update row
in database
So, I'm trying to look at the darn SQL to see what is going on.
I'm doing a VERY simple update on existing data to an app that
worked just fine before my machine recently crashed. I had to re-
install everything and I suspect that a version of one of my Wonder
frameworks or Postgres plugins is out-of-whack but no success
figuring it out yet. Argh.
Thanks again.
-S
On Dec 18, 2005, at 9:01 AM, Alex Finkel wrote:
The correct syntax to use in the active executable is:
-EOAdaptorDebugEnabled true
You can also try a command line by into your <AppName.woa> and
launching as:
./<AppName> -EOAdaptorDebugEnabled true
On 12/17/05, Stirling Olson <email@hidden> wrote:
Hmm. I've tried all the combinations and still no success. Thanks
for trying.
-Stirling
On Dec 17, 2005, at 3:57 PM, Jerry W. Walker wrote:
Hi, Stirling,
Try "EOAdaptorDebugEnabled YES" in your properties file, and/or "-
EOAdaptorDebugEnabled YES" as an Xcode argument to the application.
I think the confusion is resulting from the combined syntaxes of
Java Properties and WO Defaults syntax.
Regards,
Jerry
On Dec 17, 2005, at 5:43 PM, Stirling Olson wrote:
I think I'm going crazy...
I'm trying to turn SQL logging on in my application and can't seem
to do it for the life of me. I'm running on:
Mac OS 10.4
XCode 2.1
I have:
EOAdaptorDebugEnabled=true
in my Properties file.
I have:
-DEOAdaptorDebugEnabled=true
set as an argument in XCode -> Projects -> Edit Active
Executable -
Arguments
but still no SQL statements. I've restarted, rebooted and
sacrificed a chicken to no avail.
Hoping that someone with more sleep, more caffeine or just more
smarts can help me out.
Many thanks,
Stirling
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
jerrywwalker%
40gmail.com
This email sent to email@hidden
--
__ Jerry W. Walker,
WebObjects Developer/Instructor for High Performance Industrial
Strength Internet Enabled Systems
email@hidden
203 278-4085 office
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40gmail.com
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40mdimension.com
This email sent to email@hidden
_______________________________________________
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