Hi, 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. thanks, Graham.
posted 13 years ago
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.
Bosun (SCJP, SCWCD)
So much trouble in the world -- Bob Marley