StrataFrame Forum
Back
Login
Login
Home
»
StrataFrame Application Framework - V1
»
Business Objects and Data Access (How do I?)
»
Transaction Problem
Transaction Problem
Post Reply
Like
0
1
2
Next
Jump To Page
Transaction Problem
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
Edhy Rijo
E
Edhy Rijo
posted 15 Years Ago
ANSWER
Post Details
Share Post
E
Group: StrataFrame Users
Posts: 2.4K,
Visits: 23K
Glad to heard that. Good luck!
Edhy Rijo
Reply
Like
0
Trent Taylor
Trent Taylor
posted 15 Years Ago
ANSWER
Post Details
Share Post
Group: StrataFrame Developers
Posts: 6.6K,
Visits: 6.9K
Great.
Reply
Like
0
dgsoft
dgsoft
posted 15 Years Ago
ANSWER
Post Details
Share Post
Group: StrataFrame Users
Posts: 93,
Visits: 236
Yes.. the problem was - I use only 2 parameters in the TransactionBegin DataSourceKey and IsolationLevel.. now when I use another method overload - it works perfect!
Problem is solved!
Thank you!
Reply
Like
0
dgsoft
dgsoft
posted 15 Years Ago
ANSWER
Post Details
Share Post
Group: StrataFrame Users
Posts: 93,
Visits: 236
You are right!
The problem was in TransactionBegin() method. When I send 3 parameters DataSourceKey, TransactionKey and IsolationLevel - now all works perfect!
Thank you for Help!
Denis
Reply
Like
0
Trent Taylor
Trent Taylor
posted 15 Years Ago
ANSWER
Post Details
Share Post
Group: StrataFrame Developers
Posts: 6.6K,
Visits: 6.9K
Try Edhy's sample...that should work.
Reply
Like
0
Edhy Rijo
E
Edhy Rijo
posted 15 Years Ago
ANSWER
Post Details
Share Post
E
Group: StrataFrame Users
Posts: 2.4K,
Visits: 23K
dgsoft (06/01/2009)
Hi, in my case its DataSourceKey.. I will try to check it with another constructur..
Try this:
Try
BusinessLayer.TransactionBegin("PENSOLUTIONOFFICE","MyTransationKey", Data.IsolationLevel.ReadCommitted)
mmks_UpdateSFSUsers(loSFSUserBO)
lSaveResult = loSFSUserBO.Save(True, MyTransationKey")
Edhy Rijo
Reply
Like
0
dgsoft
dgsoft
posted 15 Years Ago
ANSWER
Post Details
Share Post
Group: StrataFrame Users
Posts: 93,
Visits: 236
Hi, in my case its DataSourceKey.. I will try to check it with another constructur..
Reply
Like
0
dgsoft
dgsoft
posted 15 Years Ago
ANSWER
Post Details
Share Post
Group: StrataFrame Users
Posts: 93,
Visits: 236
Hmm. but when I add second parameter.. I not able to save the data because an error happen
"An error occurred while saving the data to the server."
[code]
Dim loSFSUserBO As MicroFour.StrataFrame.Security.BusinessObjects.SFSUsersBO = New MicroFour.StrataFrame.Security.BusinessObjects.SFSUsersBO()
If llNewUser Then
loSFSUserBO.Add()
Else
loSFSUserBO.FillByPrimaryKey(pmks_SFSUserId)
End If
Try
BusinessLayer.TransactionBegin("PENSOLUTIONOFFICE", Data.IsolationLevel.ReadCommitted)
mmks_UpdateSFSUsers(loSFSUserBO)
lSaveResult = loSFSUserBO.Save(True, "PENSOLUTIONOFFICE")
[code]
IsDirty = true here.. and on Save line I have an exception..
Reply
Like
0
Edhy Rijo
E
Edhy Rijo
posted 15 Years Ago
ANSWER
Post Details
Share Post
E
Group: StrataFrame Users
Posts: 2.4K,
Visits: 23K
Hi Denis,
The BO.TransactionBegin() has 2 constructors, I use the 2nd one with 3 parameters, DataSourKey, TransactionKey and IsoLevel, the main one for me is the TransactionKey which I also used as the 2nd parameter of my Save(True, TransactionKey). In your case I don't know if "PENSOLUTIONOFFICE" is the DataSourceKey or the TransactionKey, so pass the TransactionKey to the Save() and you should be fine.
Edhy Rijo
Reply
Like
0
Trent Taylor
Trent Taylor
posted 15 Years Ago
ANSWER
Post Details
Share Post
Group: StrataFrame Developers
Posts: 6.6K,
Visits: 6.9K
You did not tell the BO to save on the transaction that you created. You can start more than one transaction session and save each BO in a different transaction if you had that need. But in your case, you created the transaction then did not tell the BO to save on that transaction.
loPSOClients.Save(True, "PENSOLUTIONOFFICE")
Reply
Like
0
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Post Reply
Like
0
1
2
Next
Jump To Page
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search