[OS-JIRA] Created: (CAY-466) Improving Modeler preferences DB concurrency and consistency

From: jira-norepl..bjectstyle.org
Date: Sun Feb 26 2006 - 17:34:16 EST

  • Next message: jira-norepl..bjectstyle.org: "[OS-JIRA] Created: (CAY-467) Prefetched Query Refresh Bug for refreshing entities of query table only one time"

    Message:

      A new issue has been created in JIRA.

    ---------------------------------------------------------------------
    View the issue:

      http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-466

    Here is an overview of the issue:
    ---------------------------------------------------------------------
            Key: CAY-466
        Summary: Improving Modeler preferences DB concurrency and consistency
           Type: Improvement

         Status: Assigned
       Priority: Major

        Project: Cayenne
     Components:
                 CayenneModeler GUI
       Fix Fors:
                 1.2 [DEV]
       Versions:
                 1.2 [DEV]

       Assignee: Andrus Adamchik
       Reporter: Andrus Adamchik

        Created: Sun, 26 Feb 2006 5:33 PM
        Updated: Sun, 26 Feb 2006 5:33 PM

    Description:
    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.

    ---------------------------------------------------------------------
    JIRA INFORMATION:
    This message is automatically generated by JIRA.

    If you think it was sent incorrectly contact one of the administrators:
       http://objectstyle.org/jira/secure/Administrators.jspa

    If you want more information on JIRA, or have a bug to report see:
       http://www.atlassian.com/software/jira



    This archive was generated by hypermail 2.0.0 : Sun Feb 26 2006 - 17:34:19 EST