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?
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
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]
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
--
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
--
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
--
--
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
|
