Does the transaction actually roll back?
Or is it that the error is thrown before the roll back and the cfcatch catches it and reports the line as being the last in the cfcatch block?
From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Dan Vega
Sent: Wednesday, October 11, 2006 11:31 AM
To: [email protected]
Subject: Re: [Reactor for CF] Connection reset by peer.
This line > <cftransaction action="" />
But again, this application has been working outside of the 3 errors in the last month that I have seen.
On 10/11/06, Doug Hughes <[EMAIL PROTECTED]> wrote:
Which line is it erroring on?
From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Dan Vega
Sent: Wednesday, October 11, 2006 11:24 AM
To: [email protected]
Subject: Re: [Reactor for CF] Connection reset by peer.
I am looking through my logs though and it happens in the exact same place 3 different times in a month. Maybe I am doing something wrong here in my transcation, does this look ok to everyone? Most the information for these objects are loaded somewhere else.
<cftransaction action=""
<cftry>
<cfset session.client.user.save(false)>
<cfset session.client.address.setUserId(session.client.user.getUserId ())>
<cfset session.client.address.save(false)>
<cfset session.client.creditcard.setUserId(session.client.user.getUserId())>
<cfset session.client.creditcard.save (false)>
<cfset session.client.customer.setUserId(session.client.user.getUserId())>
<cfset session.client.customer.setCCID(session.client.creditcard.getCCID())>
<cfset session.client.customer.setAddressId(session.client.address.getAddressId())>
<cfset session.client.customer.setInitial(form.initial)>
<cfset session.client.customer.setMonthly(form.monthly )>
<cfset session.client.customer.setBonus(form.bonus)>
<cfset session.client.customer.save(false)>
<cfif session.client.mode EQ "add">
<cfset groupID = application.reactor.createGateway("groups").getGroupByName("client")>
<cfset ug = application.reactor.createRecord("users_groups")>
<cfset ug.setUsersGroupsId (0)>
<cfset ug.setUserId(session.client.user.getUserId())>
<cfset ug.setGroupId(groupId)>
<cfset ug.save(false)>
</cfif>
<cfcatch type="any">
<cflog file="scfsinc" type="error" text="Error during client submission. #cfcatch.Message# #cfcatch.detail#">
<cftransaction action="" />
</cfcatch>
</cftry>
<cftransaction action="" />
</cftransaction>On 10/11/06, Doug Hughes <[EMAIL PROTECTED]> wrote:
Agreed
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Beth Bowden
Sent: Wednesday, October 11, 2006 11:11 AM
To: [email protected]
Subject: Re: [Reactor for CF] Connection reset by peer.
I would think that those two things would look the same to ColdFusion.
On 10/11/06, Dan Vega <[EMAIL PROTECTED] > wrote:
When you say the database connection has dropped do you mean the dbms itself or the connection between cf and mssql. I do not see this problem in any other applications. It's not to say its not happening of course...i just have not seen it.
Dan
On 10/11/06, Dan Vega < [EMAIL PROTECTED]> wrote:
That is so strange though, I have never seen this error before. This code works fine but this is the 2nd occasion this has come up.
On 10/11/06, Tom Chiverton <[EMAIL PROTECTED] > wrote:
On Wednesday 11 October 2006 15:54, Dan Vega wrote:
> happen? This is not reactor specfic right?
No, it's not.
Maybe your DB is closing the connection because it has been open/running to
long ?
--
Tom Chiverton
Helping to vitalistically improve visionary networks
****************************************************
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 Law Society.
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 8008.
For more information about Halliwells LLP visit www.halliwells.com.
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
--
Dan Vega
[EMAIL PROTECTED]
--
Dan Vega
[EMAIL PROTECTED]
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
--
Dan Vega
[EMAIL PROTECTED]
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
--
Dan Vega
[EMAIL PROTECTED]
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
--
Dan Vega
[EMAIL PROTECTED]
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
