james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eric Charles (JIRA)" <server-...@james.apache.org>
Subject [jira] Updated: (IMAP-181) Implement database schema and data incremental migration for 3.0 release
Date Thu, 29 Jul 2010 14:36:19 GMT

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

Eric Charles updated IMAP-181:
------------------------------

    Attachment: jpa-migrator-2.zip

jpa-migrator-2.zip for review as candidate for new mvn project "jpa-migrator" under current
imap directory (in // to jpa mvn project).
Functional as such (tested on real data) for 5 jiras.
Uses much native SQL (don't see any other solution)
Enhancements will be needed:
- Extract the SQL in JAVA classes to XML file.
- Log with log4j.

Waiting for a "go" to commit in trunk.

> Implement database schema and data incremental migration for 3.0 release
> ------------------------------------------------------------------------
>
>                 Key: IMAP-181
>                 URL: https://issues.apache.org/jira/browse/IMAP-181
>             Project: JAMES Imap
>          Issue Type: New Feature
>          Components: JPA Mailbox
>         Environment: all
>            Reporter: Eric Charles
>            Assignee: Eric Charles
>         Attachments: jpa-migrator-2.zip, jpa-migrator.zip
>
>
> We need a way to upgrade the database (for JPA store) whenever it is needed.
> In general, a database upgrade is needed further a JIRA that impacts the database.
> This can be:
> 1. On a db schema level (table, columns, fk, index,...)
> 2. On data level (update some data, feed a column with relation keys,...).
> Plain SQL would be enough for the first point (not for the second one). PLSQL (or similar)
would be needed for the second point.
> To ease things, a java "software" process will developed based on the existing JPA layer.
> The tool should be invoked with JIRA numbers as parameters.
> Each provided JIRA number would invoke a DB Change Command.
> As POC (Proof of Concept), we will first develop a tool that takes into account.
> - https://issues.apache.org/jira/browse/IMAP-176
> - https://issues.apache.org/jira/browse/IMAP-172
> - https://issues.apache.org/jira/browse/IMAP-168
> - https://issues.apache.org/jira/browse/IMAP-165

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


---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org


Mime
View raw message