Solved

Datbase Concurrency

Posted on 2004-04-26
4
183 Views
Last Modified: 2010-04-11
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
0
Comment
Question by:yatin_k26
4 Comments
 
LVL 1

Accepted Solution

by:
jean4GetIt earned 63 total points
ID: 10918595
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
 
LVL 3

Assisted Solution

by:Beluga
Beluga earned 62 total points
ID: 11030766
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

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
Data breaches are on the rise, and companies are preparing by boosting their cybersecurity budgets. According to the Cybersecurity Market Report (http://www.cybersecurityventures.com/cybersecurity-market-report), worldwide spending on cybersecurity …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question