Setting
er.extensions.ERXAdaptorChannelDelegate.enabled=true
er.extensions.ERXAdaptorChannelDelegate.trace.milliSeconds.info=1
er.extensions.ERXAdaptorChannelDelegate.trace.entityMatchPattern
= .*
Should give you a stack trace of where the second update originates.
Based on the delay, I'd guess a refresh of some sort from the
browser. Check your Ajax usage. Also override dispatchRequest()
in Application and log out the request.uri() so that you can see
the traffic coming in.
Ah yes, the SQL Server calls does happen in a WOLongResponsePage.
So I will check that out.
The two updates runs in the same request (eg, the URI didn't
change) :-/ In fact, they are running in the same transaction.
So, it's part of the same transaction, and it's timed only one time :
2010-04-22 15:36:37,811 [ERXNSLogLog4jBridge.java:46] DEBUG - ===
Begin Internal Transaction
2010-04-22 15:36:37,812 [ERXNSLogLog4jBridge.java:46] DEBUG -
evaluateExpression:
<com.webobjects.jdbcadaptor.MicrosoftSQLServerPlugIn
$MicrosoftSQLServerExpression: "UPDATE dbo.CommandesEcom SET
CommandeComplet = ? WHERE NoCommandeOracle = ?" withBindings:
1:true(commandeComplet), 2:6091(noCommandeOracle)>
2010-04-22 15:36:38,319 [ERXNSLogLog4jBridge.java:46] DEBUG -
evaluateExpression:
<com.webobjects.jdbcadaptor.MicrosoftSQLServerPlugIn
$MicrosoftSQLServerExpression: "UPDATE dbo.CommandesEcom SET
CommandeComplet = ? WHERE NoCommandeOracle = ?" withBindings:
1:true(commandeComplet), 2:6091(noCommandeOracle)>
2010-04-22 15:36:38,324 [ERXEOAccessUtilities.java:1213] INFO -
"CommandesEcom"@8796244 expression took 5 ms: UPDATE dbo.CommandesEcom
SET CommandeComplet = ? WHERE NoCommandeOracle = ? withBindings:
1:NULL[commandeComplet], 2:6091[noCommandeOracle]
2010-04-22 15:36:38,335 [ERXNSLogLog4jBridge.java:46] DEBUG - ===
Commit Internal Transaction
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to arch...@mail-archive.com
