Re: ColdFusion 7 MX - Oracle Stored Proc Calls
On Monday 26 Nov 2007, Mike Garner wrote: > we are seeing that ColdFusion is issuing the stored proc call twice for a > single transaction and have verified it is not due to multiple clicks How ? > Just curious if there are any known threading issues with CF and Oracle > stored proc calls in Oracle that anyone has come across. We are using the Could it be as simple as an un-var'ed method-local variable in a CFC ? -- Tom Chiverton Helping to confidentially repurpose leading-edge synergies on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293862 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
ColdFusion 7 MX - Oracle Stored Proc Calls
We've been experiencing this issue for some time and I thought I'd throw it out there to see if anyone else has had this problem. When a user logs into our site, we call an Oracle stored proc, which validates the login, and if success inserts an audit record. Occasionally we are seeing that ColdFusion is issuing the stored proc call twice for a single transaction and have verified it is not due to multiple clicks on the login button. We have noticed similar behavior in submitting a registation type form where a user is created. The issue goes away if we remove the stored proc call and use cfquery's instead to do the insert. Just curious if there are any known threading issues with CF and Oracle stored proc calls in Oracle that anyone has come across. We are using the 3.5 jdbc driver. We allow up to 5 connections, and CF holds the connection. If there's any additional information I can provide that would be helpful, let me know. thanks, Mike ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293819 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
