Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Implementing strict two phase lock

843859May 3 2010 — edited May 3 2010

Hi,

We have a requirement to implement strict two phase lock in one of our project's module.

The project is related to banking account and its transactions.

I could not find any method to lock any record in the database table to avoid concurrent access.I expect this is by default implemented in the database.We are using Oracle 10g.We have methods to modify autocommit mode ON or OFF.

Please suggest me, how this kind of banking account transactions in distributed environment will be implemented in Java program.

Regards
Vamshi

Locked Post

New comments cannot be posted to this locked post.

Locked on May 31 2010

Added on May 3 2010

#java-database-connectivity-jdbc

7 comments

943 views