Win a copy of GANs in ActionE this week in the AI forum
or WebAssembly in Action in the JavaScript forum!
  • 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 ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Paul Clapham
  • Jeanne Boyarsky
  • Knute Snortum
Sheriffs:
  • Liutauras Vilda
  • Tim Cooke
  • Junilu Lacar
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Joe Ess
  • salvin francis
  • fred rosenberger

DB crashes when it's used simultaneous

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

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 ]
 
Bartender
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. )
 
Don't MAKE me come back there with this tiny ad:
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!