aspose file tools*
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


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "java  oracle simultaneous transaction problem" Watch "java  oracle simultaneous transaction problem" New topic
Author

java oracle simultaneous transaction problem

ashok mane
Greenhorn

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

Suppose
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




Thanks
Ashok Mane



Rahul Bhattacharjee
Ranch Hand

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


Rahul Bhattacharjee
LinkedIn - Blog
fred rosenberger
lowercase baba
Bartender

Joined: Oct 02, 2003
Posts: 11402
    
  16

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: http://aspose.com/file-tools
 
subject: java oracle simultaneous transaction problem