• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

DB crashes when it's used simultaneous

Ranch Hand
Posts: 904
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Im making a "back end" for an app. We have to save information about a
person(id,name,value). It should be possible to insert and update a persons
record, and return the 10 most valuable persons in the DB. Please note, that
im using .asp (yes yes, I know ) and the DB is Access. Im
posting here, because 1) im a Java dev., 2) because this might be of general interest and ummm, 3) because I don't know any asp boards.

Anyways.. A typical run is like this: you contact the server, and depending
on the request the server calls eighter, the MakeRecord, UpdateRecord or PrintTop10 function.

Atm. im making a "stress test" (a simple Java program), and when run from one computer there's no
problems, but when I turn on several computers, the DB crashes. When I use two computers
it seems to work "ok", even though one of the computers cast an exception
with HTTP response code: 500, and after a while I get a HTTP response code: 4403
I guess that's because the server crashes, since the same thing happends (code 500 -> code 403 | ok run).
when e.g. three computers are beeing used. As a side note, after a "stress thread"
is beeing invoked the main prog. sleeps for 150 - 1000 ms.

When im updating or inserting, im setting a lock on the DB, and therefor
it makes sence, that I get an exception when several tries to get access
to the DB, but it also crashes when I simply "print the 10 best persons"
(that is, "SELECT TOP 10 * FROM player ORDER BY player.score DESC;").

Pointers, ect. ?

Thanks in advance,

/Svend Rost
[ May 10, 2005: Message edited by: Svend Rost ]
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm afraid to say that the simple answer is change Databases. Access is not a very good DB, and suffers "issues" with concurrent access.

(BTW - you might try MSDN for your Microsoft questions. Not that people here will probably mind answering them, just you are far more likely to get a better response. )
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
    Bookmark Topic Watch Topic
  • New Topic