permaculture playing cards
The moose likes Oracle/OAS and the fly likes java  oracle simultaneous transaction problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "java  oracle simultaneous transaction problem" Watch "java  oracle simultaneous transaction problem" New topic

java oracle simultaneous transaction problem

ashok mane

Joined: Jun 12, 2007
Posts: 1
Hi friends,

Actually i m using stuts,oracle(stored procedure),jsp in my application.
i have done all thing like writing stored procedure ,inserting data,validating data etc and finally data goes inside database.
But friends my problem is that when i do two simultanious transaction in aplication then both trasaction are inserted into databases without giving me any exception which i expect from second transaction.

for example

I m login on two diffrent computers with same user id and doing following transactions simulteneously
Txn A giving payemnt 2000
Txn B also giving payemnt 2000

Now due to some business logic i m expecting only one transaction should be insert into DB & other should raise me my exception

My client not excepting Lock from start to end on data inserting stored procedure

Now my databses stored procedure not contain any lock contain only commits

how can i manage two independant transaction my application

Ashok Mane

Rahul Bhattacharjee
Ranch Hand

Joined: Nov 29, 2005
Posts: 2308
Wrong forum.

Rahul Bhattacharjee
LinkedIn - Blog
fred rosenberger
lowercase baba

Joined: Oct 02, 2003
Posts: 11955

Originally posted by Rahul Bhattacharjee:
Wrong forum.

indeed. moving now...

There are only two hard things in computer science: cache invalidation, naming things, and off-by-one errors
I agree. Here's the link:
subject: java oracle simultaneous transaction problem
It's not a secret anymore!