Topic: Commit Transaction and post
|
|
LeovanTour
User
Junior Boarder
| Posts: 10 |   |
Karma: 0
|
|
Commit Transaction and post
|
|
Posted: 2007/09/22 07:23 |
|
|
|
|
Hello,
I have a question about post.
You can only post a record and not commit.
When you post a record is the record directly written to the database
table ?
It is not possible to commit a transaction.
I have somtimes the idea that the data is not written directly to disk
when I post. Sometime I lost data at the serverside.
Best Regards.
Leo
|
|
Diman
Admin
Admin
| Posts: 1461 | |
Karma: 18
|
|
Re:Commit Transaction and post
|
|
Posted: 2007/09/24 09:08 |
|
|
|
|
Hello
1) What DBMS do you use at server side ?
2) What ThinDAC server do you use ?
3) Do you set TTDClientDataSet.CachedUpdates to True ?
Regards,
Dmitry
|
|
LeovanTour
User
Junior Boarder
| Posts: 10 | |
Karma: 0
|
|
Re:Commit Transaction and post
|
|
Posted: 2007/09/24 12:04 |
|
|
|
|
hello,
interbase 6.01
thindac 1.31
thindacserver ibx
cachedupdates = false
I have also firebird 1.5 and 2.0 on different PC's available,
also nexusdb.
So if that can solve the problem.
|
|
LeovanTour
User
Junior Boarder
| Posts: 10 | |
Karma: 0
|
|
Re:Commit Transaction and post
|
|
Posted: 2007/09/24 12:23 |
|
|
|
|
Dmitry
I noticed that the databasefile will be changed when I stop the
thindac server and close the program.
Then the updates are saved to file.
I can not force that the updates are written to disk.
best Regards
|
|
Diman
Admin
Admin
| Posts: 1461 | |
Karma: 18
|
|
Re:Commit Transaction and post
|
|
Posted: 2007/09/25 01:20 |
|
|
|
|
Hello
To fix issue, please open daTDServer.pas. Find there method TTDSQLProcessor.DoFinishUpdates. And replace lines:
if not AInfo.FInTransaction and (AInfo.FProv <> nil) then
AInfo.FProv.PSEndTransaction(AInfo.Success);
|
with:
if AInfo.FInTransaction and (AInfo.FProv <> nil) then
AInfo.FProv.PSEndTransaction(AInfo.Success);
|
This issue will be permanently fixed in v 2.0.
Regards,
Dmitry
|
|
LeovanTour
User
Junior Boarder
| Posts: 10 | |
Karma: 0
|
|
Re:Commit Transaction and post
|
|
Posted: 2007/09/25 13:50 |
|
|
|
|
Dmitry,
It works now with Firebird 2 and IBO server.
I am not sure it works with IBX server and interbase 6.01
I only use TDClientdataset1.post
Is that enough ? I believe it works.
I do not use TDclientdataset1.applyupdates or .commitupdates
Best Regards
|
|
Diman
Admin
Admin
| Posts: 1461 | |
Karma: 18
|
|
Re:Commit Transaction and post
|
|
Posted: 2007/09/25 22:19 |
|
|
|
|
Hello
This suggested fix, ThinDAC servers will work, but with some potential limitations.
Regards,
Dmitry
|
|
|
