Datbase Concurrency

I want to ask that i have made a project for Problem Logging System using Java Servlets . The system will be run on LAN & hence many users can simultaneously perform the same event .
I am using Microsoft Access as my Backend & there is a field called "ProblemId" which is generated as the maximum of ProblemID (so far) plus 1 that is if the maximum ProblemID so far is 0 then 1 will be assigned to next ProblemId which is stored in the Database .
I wanted to ask is what problems will arise when 10 users simultaneouly click on the event which generates this ProblemID . will the database or the servlet take care of it by itself or will it cause any problem .
      PLZ HELP ,its Urgent
yatin_k26Asked:
Who is Participating?
 
jean4GetItCommented:
Acces takes care of this.

You can look into the environment settings.
He automaticly locks the record for the first user. You can set this off.
0
 
BelugaCommented:
Just wondering if there's a reason that you can't set the ProblemID field to type "Counter" in the Access table design? This would generate the ProblemID number automatically as soon as a new record is created. The database engine will automatically take care of multiple requests.

Doing this in a seperate program may be a problem. After the program has read the maximum value, and before it writes a new record, the database will be unlocked. So someone else could come along and get the same maximum value and the same new value. You'd end up with either two records with the same ProblemID, or a database integrity error. So yes, if you haven't found a way around this, it could be a problem!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.