[jira] Closed: (CAY-466) Improving Modeler preferences DB concurrency and consistency

["Andrus Adamchik (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CAY-466?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andrus Adamchik closed CAY-466.
-------------------------------

    Resolution: Won't Fix

This is no longer relevant. Preferences are being switched to java.util.prefs per CAY-1327.

> Improving Modeler preferences DB concurrency and consistency
> ------------------------------------------------------------
>
>                 Key: CAY-466
>                 URL: https://issues.apache.org/jira/browse/CAY-466
>             Project: Cayenne
>          Issue Type: Improvement
>          Components: CayenneModeler GUI
>    Affects Versions: 1.2 branch
>            Reporter: Andrus Adamchik
>            Assignee: Andrus Adamchik
>             Fix For: Undefined future
>
>
> Embedded HSQLDB creates a number of concurrency problems - two or more instances of the Modeler can't use the same DB; when a Modeler is killed via kill -9, the DB lock is not cleaned; fresh preferences updates are not picked up by the local apps using cayenne "JNDI emulation" mode, etc.
> Suggested improvements:
> * Issue SHUTDOWN periodically (most likely by closing the connection pool and using "shutdown=true" URL property, so it will be transparent to Cayenne)
> * When a DB is locked we create a copy of it so that the Modeler can still run. But then if the preferences are saved to this copy, they never make it to the master instance. Improve that by presenting "unlock preferences" dialog when a user attempts to edit preferences on the copy. If a users selects "yes, unlock", an attempt will be made to delete the lock on the master DB and take it over.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.