Security and Concurrent use of local database

User 7b0ee04e66

04-08-2009 11:24:39


We intend to set up the security on a local database with one editor account and several read-only accounts.

Can we safely have several users searching the data at the same time when the editor is logged on and may be editing data as well ?



ChemAxon 3b366b17e5

04-08-2009 15:41:04

If editor doesn't change database structure and schema it will be working fine for multiple editors and readers. Reader can also explicitely reload data by using Data->Reload data action from main menu.


User 7b0ee04e66

04-08-2009 15:43:03



ChemAxon fa971619eb

04-08-2009 16:26:05

I think this needs clarification. Catherine mentions ue of a local database. Applying security to a local database is fully supported, using just the same approach as a remote database. But concurrent access to a local database is not supported, The Derby database used for the local database only allows access from one Java virtual machine at a time, so multiple users will not be able to access the database at the same time, even if the database is lcoated on a file server where multiple users can see the files at the same time.

Even if only one user accesses the database at the same time this is still not a recomended approach. Using a shared MySQL or Oracle database is the recommended approach.