on 11-12-2007 5:29 PM
Hi All,
I have the following scenario --
A JavaDictionaryTable Project has been created with a Database Table e.g. "MainTable". Using EJB Project and Stateless Sesionbeans and JD BC Connectivity, the various operations like Search,Insert,Update,Delete etc are performed on "MainTable".
This EJB Project has been used in a WebDynpro Project where a UI has been designed to provide the UPDATE AND DELETE Operations on "MainTable". All the projects are deployed on WAS 04s and developed on NWDS 04s, SP07.
This scenario has been implemented in a Multi-user environment.
My requirement is that -
When a particular record/row in the MainTable is being accessed by 'One User' for either UPDATE OR DELETE operation, that particular record should get locked for all other users. Although Simultaneously if any User performs a SEARCH Operation, then the record should be visible.
Is this possible with (EJB) JDBC in WebDynpro ??
Thanks in advance
Arpita H
Hi
Check this Optimistic Locking pattern for EJBs
http://www.javaworld.com/javaworld/jw-07-2001/jw-0713-optimism.html
Regards
Ayyapparaj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
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.