cancel
Showing results for 
Search instead for 
Did you mean: 

Locking a DB record before modifying it

deshdeepak_shukla2
Participant
0 Kudos

Hi all,

We want to use the locking mechanism, i.e. lock a record before updating, inserting or deleting it. This is required to avoid concurrency issues.

How it can be done using WebDynpro technology?. Do we have to create some lock objects similar to the R/3 system or something else.

Any inputs are most welcome.

Thanks in advance.

~Deshdeepak.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

If you want to do a locking then do it in the backend. Create "Enqueue" and "Dequeue" objects in R/3 and then make use of them when trying to update, insert or delete from Webdynpro.

If you require more information on the enqueue and dequeue in R/3 let me know.

regards

ravi

deshdeepak_shukla2
Participant
0 Kudos

Hi Ravi,

We are developing tables in database of WAS. Our Web AS is currently working on Oracle 9i DB. My Question was whether WebDynpro provides a mechanism for locking a record in DB before updation deletion and insertion.

Also i wanted to know whether the mechanism is DB independent.

Thanks in advance.

Regards

~Deshdeepak.

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

There is a statement called LOCK TABLES in oracle. You can use it in executeUpdate just like we use DDL ,DML statements.

ex: LOCK TABLE <table name > WRITE.

Regards

Bharathwaj