File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply 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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to handle concurrent write/read to a db
 
Similar Threads
How to handle concurrent write/read to a db from a servlet
B&S how important is the lockCookie for the update/delete operation?
Database security
pooled connection object vs non pooled connection object
Question about shared DB connection