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] Created: (IMAP-181) Implement database schema and data incremental migration for 3.0 release
Date Fri, 23 Jul 2010 13:12:50 GMT
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

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

View raw message