Re: Finding why two UPDATES are send
Re: Finding why two UPDATES are send
- Subject: Re: Finding why two UPDATES are send
- From: Chuck Hill <email@hidden>
- Date: Thu, 22 Apr 2010 17:37:47 -0700
On Apr 22, 2010, at 5:26 PM, Pascal Robert wrote:
Le 10-04-22 à 16:31, Pascal Robert a écrit :
Le 10-04-22 à 16:02, Chuck Hill a écrit :
Now that I read the comments in Properties...
Try with
er.extensions.ERXAdaptorChannelDelegate.trace.milliSeconds.error=1
That should get you stack traces (assuming the comments are
correct). That _may_ shed some light on things.
No luck, I have put a 100 ms limit, and it doesn't say that it's
taking too long (but it's a damn cool feature!).
Chuck have sent me his SQLLoggingAdaptorChannelDelegate class, and
I'm going to the exact stack trace! So I did the same calls in
Oracle SQL Developer (yes, it can talk to MS SQL Server too) and
when I do the UPDATE call, SQL Dev told me that executeUpdate can't
return a resultset! But if I do the UPDATE a second time, it's ok.
So it's a mix of the vendor DB who is sending something back + EOF
that think the database was down, hence doing the UPDATE
automatically a second time. This is with WO 5.3.3.
Many thanks to Chuck! I guess I own him a couple of Unibroue
bottles, or he can call me Robert for a month.
I will settle for some Le Cheval Blanc and calling you Bobby for two
weeks. :-P
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
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