topic Re: work process for database updation in Application Development and Automation Discussions

work process for database updation

Former Member — Tue, 29 Sep 2015 10:58:51 GMT

hi ,

how to make queue for database update based on priority,

for example, program 1 and program 2 are updating same database table at same time,

i want to update db table based on queue request thats after completing update from program 1,program 2 has to update,

how to achieve the same.

Former Member — Tue, 29 Sep 2015 11:26:58 GMT

Hi,

I suggest you to do table lock while doing updating the DB table.

This will prevent another program or another transaction to modify the same table.

Please check the below link for more details.

You may check in your second program whether your table is locked or not. According to that you

may write the logic.

nishantbansal91 — Tue, 29 Sep 2015 11:32:33 GMT

Hi,

Prog A.

Lock the table before updating and unlock the table after updating.

PROG B.

Check If the table is locked wait for 2 second or as per your requirement and check the same,

Thanks
Nishant

Former Member — Wed, 30 Sep 2015 06:59:32 GMT

thanks for ur reply.