aspose file tools*
The moose likes JDBC and the fly likes How to handle concurrent write/read to a db Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to handle concurrent write/read to a db" Watch "How to handle concurrent write/read to a db" New topic
Author

How to handle concurrent write/read to a db

Subbu Aswathanarayan
Ranch Hand

Joined: Jun 22, 2001
Posts: 73
Hi all,
in my application i have two databases. lets call them a & b.from database a i will be just reading data and displaying it to the user.no writing has to be done.but on database b i have to perform writing as well as reading operations.since multiple users will be accessing this database i have a few questions
i) how do i take care of the cuncurrency issue?
ii)will the cuncurrency issue come in only when two users try to write something to the database at the same time or is it a problem even when multiple users try to read at the same time?
iii) should i implement connection pooling?i dont expect a lot of cuncurrent users(around 50 or so).is there any threshold value for the no. of concurrent users beyond which it is advisable to implement connection pooling.
Thanks in advance.
Subbu


Subbu
 
jQuery in Action, 2nd edition
 
subject: How to handle concurrent write/read to a db