Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Firedac and pessimistic locking on advantagedatabase server



Permlink Replies: 3 - Last Post: Oct 19, 2015 6:35 AM Last Post By: Dmitry Arefiev
Yusuf Zorlu

Posts: 2
Registered: 4/26/00
Firedac and pessimistic locking on advantagedatabase server
Click to report abuse...   Click to reply to this thread Reply
  Posted: May 29, 2015 12:46 AM
Hello Dmitry,

as i know in past you had different tries to get that pessimistic locking work with advantagedatabase server. Is there anything we can use / try? We want to switch from ADS native components to firedac but the problem is that locking. All of our applications do need locking on record level. That means one user is editing a record, all other users should not be able to edit same record.

If firedac can't, can we do something with onAfterEdit i.e. save the primary index of current record into a db-table and check this in onBeforeEdit?

Can you help us a little bit?
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: Firedac and pessimistic locking on advantagedatabase server
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jun 2, 2015 7:42 AM   in response to: Yusuf Zorlu in response to: Yusuf Zorlu
Sorry, there are no news on this topic. OnBeforeEdit / OnAfterEdit will not
help, because the locks will be released differently than you will expect.

I will suggest to create QC entry and vote for it. This will help to properly
manage the customer requests.

--
With best regards,
Dmitry Arefiev / FireDAC Architect
Flavius Fernandes

Posts: 9
Registered: 2/14/13
Re: Firedac and pessimistic locking on advantagedatabase server
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 19, 2015 2:09 AM   in response to: Yusuf Zorlu in response to: Yusuf Zorlu
Yusuf Zorlu wrote:
Hello Dmitry,

as i know in past you had different tries to get that pessimistic locking work with advantagedatabase server. Is there anything we can use / try? We want to switch from ADS native components to firedac but the problem is that locking. All of our applications do need locking on record level. That means one user is editing a record, all other users should not be able to edit same record.

If firedac can't, can we do something with onAfterEdit i.e. save the primary index of current record into a db-table and check this in onBeforeEdit?

Can you help us a little bit?

Hi Yusuf,

I am also looking at FireDac to replace ADS native components. Have you managed to get a resolution.

FFernandes
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: Firedac and pessimistic locking on advantagedatabase server
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 19, 2015 6:35 AM   in response to: Flavius Fernandes in response to: Flavius Fernandes
I am also looking at FireDac to replace ADS native components. Have you managed to get a resolution.

At moment there is no changes in this area. I am planning to check this area
in next 1-2 months.

--
With best regards,
Dmitry Arefiev / FireDAC Architect
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02