Using TableLocking API in Stateless Session Bean through WD application

[Former Member]

Hi All,

We have develpoed a webDynpro application which involved Jav Dictionary Table.

We have given UI for Creation, Updation and Deletion of the table.For database connection we have used Stateless Session Bean.

we have the requirement of Locking the Table record when one user is either editing or deleting the record of Table from UI, so any other user cannot update or delete the same record.

To implement the above functionality, we have used TableLocking API with lifetime as userSession in the Stateless Session Bean to acquire a Lock for particular record.

With lifetime as usersession the record should get unLocked automatically, if the session of application is expired and record is not unLocked Explicitly.

We are calling the Session Bean from Webdynpro application to acquire a lock, When the Dynpro application expires the locked record should get unlocked automatically as the lifetime is defined as usersession,But the record remains unlocked only even after expiration of the application sessionand deadlock occurs for that record.

So if anyone can suggest the solution for the above problem.

Or some other method to Lock Particular Record from application.

Thanks in advance.

Regards,

Shruti.

[Former Member]

HI,

Can you resolve this issue?

I have the same scenary, could you give me some tips?

Thanks,

Freddy F