jQuery in Action, 2nd edition*
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: How to handle concurrent write/read to a db
 
Similar Threads
How to handle concurrent write/read to a db from a servlet
pooled connection object vs non pooled connection object
B&S how important is the lockCookie for the update/delete operation?
Question about shared DB connection
Database security