Simultaneous access to database from different program instances not possible
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
BibCite |
In Progress
|
Wishlist
|
Prunus dulcis |
Bug Description
Accessing the database file simultaneously throws a DataBaseFileLocked exception for all but the first program instances. This makes working in multi-user teams on the same database very tedious. A database controller class could be used to open and close connections to the database implementing
1) a memory copy of the database content the user has access to (with possibility to update this copy when needed - via a changedFlag or similar in the db4o.java class)
2) implementing threading for database access with waiting for possible database access and graceful failure when access not possible for prolonged duration of time.
Needs implementation of user defined database path including pointing to a web-ressource.
Separated all database access as first step - all database access now runs through dbModel.java methods. This should enable something like web access and multiple accesses from different program instances on the same database in the future.