jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes locking access to tables Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "locking access to tables" Watch "locking access to tables" New topic

locking access to tables

Graham Clark

Joined: Jun 13, 2002
Posts: 17
I am using a servlet to access an Access database through JDBC. While one particular block is executing, I don't want any other instatiations of the servlet (i.e. other users) accessing a particular table in the database.
Can this be set up in the ResultSet, or do I have to write some sort of synchronization code?
Any help would be much appreciated.
Bosun Bello
Ranch Hand

Joined: Nov 06, 2000
Posts: 1510
I don't think the JDBC-ODBC driver which access uses even supports what you are trying to do (transactions). You can just synchronize the code block that contains the database access. OTOH, you can have your servlet implement the SingleThreadModel interface.

So much trouble in the world -- Bob Marley
I agree. Here's the link: http://aspose.com/file-tools
subject: locking access to tables
It's not a secret anymore!