Skip to Content
avatar image
Former Member

DB (Oracle or MaxDB) Locking using JDBC Connection

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 13, 2007 at 06:10 AM

    Hi

    Check this Optimistic Locking pattern for EJBs

    http://www.javaworld.com/javaworld/jw-07-2001/jw-0713-optimism.html

    Regards

    Ayyapparaj

    Add comment
    10|10000 characters needed characters exceeded