aspose file tools*
The moose likes JDBC and the fly likes multiple access to same data in database by multiple requests? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "multiple access to same data in database by multiple requests?" Watch "multiple access to same data in database by multiple requests?" New topic
Author

multiple access to same data in database by multiple requests?

sandy sean
Ranch Hand

Joined: Dec 30, 2010
Posts: 69
Hi!

I am using struts2 and jdbc in my web application. please hint me how i can prevent multiple access to same data in database by multiple requests?

thanks..
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42634
    
  65
Are you asking about read access or write access? And more importantly, why do you want to do this? There are multiple approaches, and some are more suited to certain scenarios than others.


Ping & DNS - my free Android networking tools app
sandy sean
Ranch Hand

Joined: Dec 30, 2010
Posts: 69
actually what i meant was that suppose multiple users accessing same part in database(for write access),then will jdbc transaction support (autoCommit(),comit(),rollback().) will manage all that or i have to do other things also?

In simple i want to ask that there are various reads, locks, isolation levels etc.in database to prevent shared access.will all these get managed by using jdbc transaction support (autoCommit(),commit(),rollback()) in java program?
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: multiple access to same data in database by multiple requests?