on 05-15-2005 6:12 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.