StrataFrame Forum
Back
Login
Login
Home
»
StrataFrame Application Framework - V1
»
Business Objects and Data Access (How do I?)
»
Transaction processing strange behavior
Transaction processing strange behavior
Post Reply
Like
1
Transaction processing strange behavior
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
Marcel Heitlager
Marcel Heitlager
posted 12 Years Ago
ANSWER
Topic Details
Share Topic
Group: StrataFrame Users
Posts: 84,
Visits: 835
Hi,
For some reason when I try to save data to two tables during a transaction save, sometimes the transaction only commits one of the tables. This is on a website. It happens when a person might put a payment through and the entire transaction fails, and rolls back for some reason. Then the person will try it again within a couple of minutes, and the transaction only commits the data to the 2nd save. See below:
'-- first generate a unique transaction key
Dim lcTransactionKey As String = AES.BOL.Base.Utils.NewSeqGuid().ToString
Try
TransactionBegin(Me.OPPaymentDetail.DataSourceKey, lcTransactionKey, IsolationLevel.ReadCommitted)
'-- First save data to the contact information table - This save Fails
Me.OPPaymentDetail.Save(True, lcTransactionKey)
'-- next get the primary key value and save to ACH detail table - This save Succeeds
Me.OPACHInfoBO.ah_op_Key = Me.OPPaymentDetail.GetPostSavePrimaryKeyValue(-1).ToString
Me.OPACHInfoBO.Save(True, lcTransactionKey)
TransactionCommit(Me.OPPaymentDetail.DataSourceKey, lcTransactionKey)
Return True
Catch ex As Exception
TransactionRollback(Me.OPPaymentDetail.DataSourceKey, lcTransactionKey)
Me.SendTransactionReportError()
Return False
End Try
It seems the 2nd transaction always commits, but the first doesn't.
It's running on SQL Server Express 2005, Windows Server 2003. Could it be some memory cache issue?
Thanks,
Marcel
Tags
Transaction Save
Transactions
Reply
Like
1
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Threaded View
Threaded View
Transaction processing strange behavior
Marcel Heitlager
-
12 Years Ago
Hi Marcel, Your transaction looks just fine, except that I would put...
Edhy Rijo
-
12 Years Ago
Thanks for you reply Edhy! The thought didn't occur to me that I need...
Marcel Heitlager
-
12 Years Ago
Hi Marcel, You are welcome!!! [quote][b]Marcel Heitlager...
Edhy Rijo
-
12 Years Ago
Post Reply
Like
1
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search