You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@airavata.apache.org by "Chathuri Wimalasena (JIRA)" <ji...@apache.org> on 2012/09/02 01:26:07 UTC

[jira] [Created] (AIRAVATA-562) Replacing existing Jackrabbit registry with MySQL

Chathuri Wimalasena created AIRAVATA-562:
--------------------------------------------

             Summary: Replacing existing Jackrabbit registry with MySQL
                 Key: AIRAVATA-562
                 URL: https://issues.apache.org/jira/browse/AIRAVATA-562
             Project: Airavata
          Issue Type: New Feature
          Components: Registry API
    Affects Versions: 0.4-INCUBATING
            Reporter: Chathuri Wimalasena
             Fix For: 0.5-INCUBATING




--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Commented] (AIRAVATA-562) Replacing existing Jackrabbit registry with MySQL

Posted by "Raminderjeet Singh (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/AIRAVATA-562?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13447937#comment-13447937 ] 

Raminderjeet Singh commented on AIRAVATA-562:
---------------------------------------------

The sql script should be auto generated by JPA provider. It does not make sense to use JPA otherwise. We want to build REST service interface over these service and may have web interface also in future.  Why not we use Spring Framework to configure JPA and REST services?
                
> Replacing existing Jackrabbit registry with MySQL
> -------------------------------------------------
>
>                 Key: AIRAVATA-562
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-562
>             Project: Airavata
>          Issue Type: New Feature
>          Components: Registry API
>    Affects Versions: 0.4-INCUBATING
>            Reporter: Chathuri Wimalasena
>             Fix For: 0.5-INCUBATING
>
>         Attachments: AIRAVATA-562.1.patch, registry.sql
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (AIRAVATA-562) Replacing existing Jackrabbit registry with MySQL

Posted by "Chathuri Wimalasena (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/AIRAVATA-562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chathuri Wimalasena updated AIRAVATA-562:
-----------------------------------------

    Attachment: AIRAVATA-562.15.patch

Change the database script.
                
> Replacing existing Jackrabbit registry with MySQL
> -------------------------------------------------
>
>                 Key: AIRAVATA-562
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-562
>             Project: Airavata
>          Issue Type: New Feature
>          Components: Registry API
>    Affects Versions: 0.4-INCUBATING
>            Reporter: Chathuri Wimalasena
>             Fix For: 0.5-INCUBATING
>
>         Attachments: AIRAVATA-562.10.patch, AIRAVATA-562.10.patch, AIRAVATA-562.11.patch, AIRAVATA-562.12.patch, AIRAVATA-562.13.patch, AIRAVATA-562.14.patch, AIRAVATA-562.15.patch, AIRAVATA-562.1.patch, AIRAVATA-562.2.patch, AIRAVATA-562.3.patch, AIRAVATA-562.4.patch, AIRAVATA-562.5.patch, AIRAVATA-562.6.patch, AIRAVATA-562.7.patch, AIRAVATA-562.8.patch, AIRAVATA-562.9.patch, data.sql, registry.sql
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (AIRAVATA-562) Replacing existing Jackrabbit registry with MySQL

Posted by "Chathuri Wimalasena (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/AIRAVATA-562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chathuri Wimalasena updated AIRAVATA-562:
-----------------------------------------

    Attachment: AIRAVATA-562.4.patch

Attaching the updated patch. Please review. 
                
> Replacing existing Jackrabbit registry with MySQL
> -------------------------------------------------
>
>                 Key: AIRAVATA-562
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-562
>             Project: Airavata
>          Issue Type: New Feature
>          Components: Registry API
>    Affects Versions: 0.4-INCUBATING
>            Reporter: Chathuri Wimalasena
>             Fix For: 0.5-INCUBATING
>
>         Attachments: AIRAVATA-562.1.patch, AIRAVATA-562.2.patch, AIRAVATA-562.3.patch, AIRAVATA-562.4.patch, data.sql, registry.sql
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (AIRAVATA-562) Replacing existing Jackrabbit registry with MySQL

Posted by "Chathuri Wimalasena (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/AIRAVATA-562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chathuri Wimalasena updated AIRAVATA-562:
-----------------------------------------

    Attachment: AIRAVATA-562.5.patch

We need to remove auto incremented ID s from Gateway table and Users table since same gateway name and user name can be replicated in those tables if we keep auto incrementing field as the primary key. This patch includes that change and appropriate model object updates. 
                
> Replacing existing Jackrabbit registry with MySQL
> -------------------------------------------------
>
>                 Key: AIRAVATA-562
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-562
>             Project: Airavata
>          Issue Type: New Feature
>          Components: Registry API
>    Affects Versions: 0.4-INCUBATING
>            Reporter: Chathuri Wimalasena
>             Fix For: 0.5-INCUBATING
>
>         Attachments: AIRAVATA-562.1.patch, AIRAVATA-562.2.patch, AIRAVATA-562.3.patch, AIRAVATA-562.4.patch, AIRAVATA-562.5.patch, data.sql, registry.sql
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (AIRAVATA-562) Replacing existing Jackrabbit registry with MySQL

Posted by "Chathuri Wimalasena (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/AIRAVATA-562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chathuri Wimalasena updated AIRAVATA-562:
-----------------------------------------

    Attachment: AIRAVATA-562.6.patch

Attaching a patch with new database changes. 
                
> Replacing existing Jackrabbit registry with MySQL
> -------------------------------------------------
>
>                 Key: AIRAVATA-562
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-562
>             Project: Airavata
>          Issue Type: New Feature
>          Components: Registry API
>    Affects Versions: 0.4-INCUBATING
>            Reporter: Chathuri Wimalasena
>             Fix For: 0.5-INCUBATING
>
>         Attachments: AIRAVATA-562.1.patch, AIRAVATA-562.2.patch, AIRAVATA-562.3.patch, AIRAVATA-562.4.patch, AIRAVATA-562.5.patch, AIRAVATA-562.6.patch, data.sql, registry.sql
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (AIRAVATA-562) Replacing existing Jackrabbit registry with MySQL

Posted by "Chathuri Wimalasena (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/AIRAVATA-562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chathuri Wimalasena updated AIRAVATA-562:
-----------------------------------------

    Attachment: AIRAVATA-562.3.patch

Hi Saminda, 

Needed package move and some improvements are attached with the patch. Please apply patch at root level of airavata source directory.

Regards,
Chathuri
                
> Replacing existing Jackrabbit registry with MySQL
> -------------------------------------------------
>
>                 Key: AIRAVATA-562
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-562
>             Project: Airavata
>          Issue Type: New Feature
>          Components: Registry API
>    Affects Versions: 0.4-INCUBATING
>            Reporter: Chathuri Wimalasena
>             Fix For: 0.5-INCUBATING
>
>         Attachments: AIRAVATA-562.1.patch, AIRAVATA-562.2.patch, AIRAVATA-562.3.patch, data.sql, registry.sql
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Commented] (AIRAVATA-562) Replacing existing Jackrabbit registry with MySQL

Posted by "Suresh Marru (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/AIRAVATA-562?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13449775#comment-13449775 ] 

Suresh Marru commented on AIRAVATA-562:
---------------------------------------

Chathuri, Thanks for the contribution, I was just reviewing this patch, it looks good and now aligns well with modules Saminda suggested. Just one change, within src you have redundant java folders, can you get rid of one and move everything up? Its like this - src/main/java/java/org instead of src/main/java/org.

                
> Replacing existing Jackrabbit registry with MySQL
> -------------------------------------------------
>
>                 Key: AIRAVATA-562
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-562
>             Project: Airavata
>          Issue Type: New Feature
>          Components: Registry API
>    Affects Versions: 0.4-INCUBATING
>            Reporter: Chathuri Wimalasena
>             Fix For: 0.5-INCUBATING
>
>         Attachments: AIRAVATA-562.1.patch, AIRAVATA-562.2.patch, AIRAVATA-562.3.patch, data.sql, registry.sql
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (AIRAVATA-562) Replacing existing Jackrabbit registry with MySQL

Posted by "Chathuri Wimalasena (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/AIRAVATA-562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chathuri Wimalasena updated AIRAVATA-562:
-----------------------------------------

    Attachment: AIRAVATA-562.11.patch
    
> Replacing existing Jackrabbit registry with MySQL
> -------------------------------------------------
>
>                 Key: AIRAVATA-562
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-562
>             Project: Airavata
>          Issue Type: New Feature
>          Components: Registry API
>    Affects Versions: 0.4-INCUBATING
>            Reporter: Chathuri Wimalasena
>             Fix For: 0.5-INCUBATING
>
>         Attachments: AIRAVATA-562.10.patch, AIRAVATA-562.10.patch, AIRAVATA-562.11.patch, AIRAVATA-562.1.patch, AIRAVATA-562.2.patch, AIRAVATA-562.3.patch, AIRAVATA-562.4.patch, AIRAVATA-562.5.patch, AIRAVATA-562.6.patch, AIRAVATA-562.7.patch, AIRAVATA-562.8.patch, AIRAVATA-562.9.patch, data.sql, registry.sql
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (AIRAVATA-562) Replacing existing Jackrabbit registry with MySQL

Posted by "Chathuri Wimalasena (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/AIRAVATA-562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chathuri Wimalasena updated AIRAVATA-562:
-----------------------------------------

    Attachment: registry.sql

Attaching the database script file. Please review and give your feadback and suggestions. 
                
> Replacing existing Jackrabbit registry with MySQL
> -------------------------------------------------
>
>                 Key: AIRAVATA-562
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-562
>             Project: Airavata
>          Issue Type: New Feature
>          Components: Registry API
>    Affects Versions: 0.4-INCUBATING
>            Reporter: Chathuri Wimalasena
>             Fix For: 0.5-INCUBATING
>
>         Attachments: registry.sql
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Commented] (AIRAVATA-562) Replacing existing Jackrabbit registry with MySQL

Posted by "Saminda Wijeratne (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/AIRAVATA-562?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13449741#comment-13449741 ] 

Saminda Wijeratne commented on AIRAVATA-562:
--------------------------------------------

Will do Raminder... Side effects of copy pasting ;)
                
> Replacing existing Jackrabbit registry with MySQL
> -------------------------------------------------
>
>                 Key: AIRAVATA-562
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-562
>             Project: Airavata
>          Issue Type: New Feature
>          Components: Registry API
>    Affects Versions: 0.4-INCUBATING
>            Reporter: Chathuri Wimalasena
>             Fix For: 0.5-INCUBATING
>
>         Attachments: AIRAVATA-562.1.patch, AIRAVATA-562.2.patch, data.sql, registry.sql
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (AIRAVATA-562) Replacing existing Jackrabbit registry with MySQL

Posted by "Chathuri Wimalasena (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/AIRAVATA-562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chathuri Wimalasena updated AIRAVATA-562:
-----------------------------------------

    Attachment: AIRAVATA-562.1.patch

Attaching the initial data model implementation. This is just for review. Please don't apply the patch. 
                
> Replacing existing Jackrabbit registry with MySQL
> -------------------------------------------------
>
>                 Key: AIRAVATA-562
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-562
>             Project: Airavata
>          Issue Type: New Feature
>          Components: Registry API
>    Affects Versions: 0.4-INCUBATING
>            Reporter: Chathuri Wimalasena
>             Fix For: 0.5-INCUBATING
>
>         Attachments: AIRAVATA-562.1.patch, registry.sql
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Commented] (AIRAVATA-562) Replacing existing Jackrabbit registry with MySQL

Posted by "Chathuri Wimalasena (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/AIRAVATA-562?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13449796#comment-13449796 ] 

Chathuri Wimalasena commented on AIRAVATA-562:
----------------------------------------------

Yes suresh. I think there is something wrong with my svn mv command. Will update the patch. Sorry for the inconvenience. 
                
> Replacing existing Jackrabbit registry with MySQL
> -------------------------------------------------
>
>                 Key: AIRAVATA-562
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-562
>             Project: Airavata
>          Issue Type: New Feature
>          Components: Registry API
>    Affects Versions: 0.4-INCUBATING
>            Reporter: Chathuri Wimalasena
>             Fix For: 0.5-INCUBATING
>
>         Attachments: AIRAVATA-562.1.patch, AIRAVATA-562.2.patch, AIRAVATA-562.3.patch, data.sql, registry.sql
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (AIRAVATA-562) Replacing existing Jackrabbit registry with MySQL

Posted by "Chathuri Wimalasena (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/AIRAVATA-562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chathuri Wimalasena updated AIRAVATA-562:
-----------------------------------------

    Attachment: AIRAVATA-562.13.patch

Associate user should be set in implementation classes before calling the save method of database table resources.
                
> Replacing existing Jackrabbit registry with MySQL
> -------------------------------------------------
>
>                 Key: AIRAVATA-562
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-562
>             Project: Airavata
>          Issue Type: New Feature
>          Components: Registry API
>    Affects Versions: 0.4-INCUBATING
>            Reporter: Chathuri Wimalasena
>             Fix For: 0.5-INCUBATING
>
>         Attachments: AIRAVATA-562.10.patch, AIRAVATA-562.10.patch, AIRAVATA-562.11.patch, AIRAVATA-562.12.patch, AIRAVATA-562.13.patch, AIRAVATA-562.1.patch, AIRAVATA-562.2.patch, AIRAVATA-562.3.patch, AIRAVATA-562.4.patch, AIRAVATA-562.5.patch, AIRAVATA-562.6.patch, AIRAVATA-562.7.patch, AIRAVATA-562.8.patch, AIRAVATA-562.9.patch, data.sql, registry.sql
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Commented] (AIRAVATA-562) Replacing existing Jackrabbit registry with MySQL

Posted by "Saminda Wijeratne (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/AIRAVATA-562?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13449405#comment-13449405 ] 

Saminda Wijeratne commented on AIRAVATA-562:
--------------------------------------------

Sorry I didn't notice the patch much earlier. I created a new module to incorparate the new AiravataRegistry API JPA implementation @ [1]. Can you please resubmit the patch for that module? Code that goes in to [2] will become obsolete once we have the jpa implementation of the AiravataRegistry. (The [2] was created to provide a jpa provenance registry for the existing jackrabbit registry). Again, sorry for all the rework involved.

1. https://svn.apache.org/repos/asf/incubator/airavata/trunk/modules/registry/airavata-jpa-registry/
2. https://svn.apache.org/repos/asf/incubator/airavata/trunk/modules/commons/provenance-registry/

                
> Replacing existing Jackrabbit registry with MySQL
> -------------------------------------------------
>
>                 Key: AIRAVATA-562
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-562
>             Project: Airavata
>          Issue Type: New Feature
>          Components: Registry API
>    Affects Versions: 0.4-INCUBATING
>            Reporter: Chathuri Wimalasena
>             Fix For: 0.5-INCUBATING
>
>         Attachments: AIRAVATA-562.1.patch, AIRAVATA-562.2.patch, data.sql, registry.sql
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (AIRAVATA-562) Replacing existing Jackrabbit registry with MySQL

Posted by "Chathuri Wimalasena (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/AIRAVATA-562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chathuri Wimalasena updated AIRAVATA-562:
-----------------------------------------

    Attachment: AIRAVATA-562.14.patch

>From gateway resource, you can't get an application descriptor resource since you do not have all the information to retrieve an application descriptor at that level. Remove the methods of getApplicationDescriptorResource and removeApplicationDescriptor from gateway resource and add new methods to ResourceUtils. Update the registry implementer class accordingly.  
                
> Replacing existing Jackrabbit registry with MySQL
> -------------------------------------------------
>
>                 Key: AIRAVATA-562
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-562
>             Project: Airavata
>          Issue Type: New Feature
>          Components: Registry API
>    Affects Versions: 0.4-INCUBATING
>            Reporter: Chathuri Wimalasena
>             Fix For: 0.5-INCUBATING
>
>         Attachments: AIRAVATA-562.10.patch, AIRAVATA-562.10.patch, AIRAVATA-562.11.patch, AIRAVATA-562.12.patch, AIRAVATA-562.13.patch, AIRAVATA-562.14.patch, AIRAVATA-562.1.patch, AIRAVATA-562.2.patch, AIRAVATA-562.3.patch, AIRAVATA-562.4.patch, AIRAVATA-562.5.patch, AIRAVATA-562.6.patch, AIRAVATA-562.7.patch, AIRAVATA-562.8.patch, AIRAVATA-562.9.patch, data.sql, registry.sql
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (AIRAVATA-562) Replacing existing Jackrabbit registry with MySQL

Posted by "Chathuri Wimalasena (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/AIRAVATA-562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chathuri Wimalasena updated AIRAVATA-562:
-----------------------------------------

    Attachment: AIRAVATA-562.10.patch
    
> Replacing existing Jackrabbit registry with MySQL
> -------------------------------------------------
>
>                 Key: AIRAVATA-562
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-562
>             Project: Airavata
>          Issue Type: New Feature
>          Components: Registry API
>    Affects Versions: 0.4-INCUBATING
>            Reporter: Chathuri Wimalasena
>             Fix For: 0.5-INCUBATING
>
>         Attachments: AIRAVATA-562.10.patch, AIRAVATA-562.10.patch, AIRAVATA-562.1.patch, AIRAVATA-562.2.patch, AIRAVATA-562.3.patch, AIRAVATA-562.4.patch, AIRAVATA-562.5.patch, AIRAVATA-562.6.patch, AIRAVATA-562.7.patch, AIRAVATA-562.8.patch, AIRAVATA-562.9.patch, data.sql, registry.sql
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (AIRAVATA-562) Replacing existing Jackrabbit registry with MySQL

Posted by "Chathuri Wimalasena (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/AIRAVATA-562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chathuri Wimalasena updated AIRAVATA-562:
-----------------------------------------

    Attachment: AIRAVATA-562.12.patch

Fixing configurations not saving to the database.
                
> Replacing existing Jackrabbit registry with MySQL
> -------------------------------------------------
>
>                 Key: AIRAVATA-562
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-562
>             Project: Airavata
>          Issue Type: New Feature
>          Components: Registry API
>    Affects Versions: 0.4-INCUBATING
>            Reporter: Chathuri Wimalasena
>             Fix For: 0.5-INCUBATING
>
>         Attachments: AIRAVATA-562.10.patch, AIRAVATA-562.10.patch, AIRAVATA-562.11.patch, AIRAVATA-562.12.patch, AIRAVATA-562.1.patch, AIRAVATA-562.2.patch, AIRAVATA-562.3.patch, AIRAVATA-562.4.patch, AIRAVATA-562.5.patch, AIRAVATA-562.6.patch, AIRAVATA-562.7.patch, AIRAVATA-562.8.patch, AIRAVATA-562.9.patch, data.sql, registry.sql
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Commented] (AIRAVATA-562) Replacing existing Jackrabbit registry with MySQL

Posted by "Saminda Wijeratne (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/AIRAVATA-562?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13450924#comment-13450924 ] 

Saminda Wijeratne commented on AIRAVATA-562:
--------------------------------------------

Patch AIRAVATA-562.6.patch applied

Committed revision 1382136.

                
> Replacing existing Jackrabbit registry with MySQL
> -------------------------------------------------
>
>                 Key: AIRAVATA-562
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-562
>             Project: Airavata
>          Issue Type: New Feature
>          Components: Registry API
>    Affects Versions: 0.4-INCUBATING
>            Reporter: Chathuri Wimalasena
>             Fix For: 0.5-INCUBATING
>
>         Attachments: AIRAVATA-562.1.patch, AIRAVATA-562.2.patch, AIRAVATA-562.3.patch, AIRAVATA-562.4.patch, AIRAVATA-562.5.patch, AIRAVATA-562.6.patch, data.sql, registry.sql
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (AIRAVATA-562) Replacing existing Jackrabbit registry with MySQL

Posted by "Chathuri Wimalasena (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/AIRAVATA-562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chathuri Wimalasena updated AIRAVATA-562:
-----------------------------------------

    Attachment: AIRAVATA-562.10.patch

Adding initial test classes and fixing some issues
                
> Replacing existing Jackrabbit registry with MySQL
> -------------------------------------------------
>
>                 Key: AIRAVATA-562
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-562
>             Project: Airavata
>          Issue Type: New Feature
>          Components: Registry API
>    Affects Versions: 0.4-INCUBATING
>            Reporter: Chathuri Wimalasena
>             Fix For: 0.5-INCUBATING
>
>         Attachments: AIRAVATA-562.10.patch, AIRAVATA-562.1.patch, AIRAVATA-562.2.patch, AIRAVATA-562.3.patch, AIRAVATA-562.4.patch, AIRAVATA-562.5.patch, AIRAVATA-562.6.patch, AIRAVATA-562.7.patch, AIRAVATA-562.8.patch, AIRAVATA-562.9.patch, data.sql, registry.sql
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (AIRAVATA-562) Replacing existing Jackrabbit registry with MySQL

Posted by "Chathuri Wimalasena (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/AIRAVATA-562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chathuri Wimalasena updated AIRAVATA-562:
-----------------------------------------

    Attachment: AIRAVATA-562.2.patch

Hi Lahiru, 

Please apply the patch from root level of the airavata source folder. 

Regards,
Chathuri
                
> Replacing existing Jackrabbit registry with MySQL
> -------------------------------------------------
>
>                 Key: AIRAVATA-562
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-562
>             Project: Airavata
>          Issue Type: New Feature
>          Components: Registry API
>    Affects Versions: 0.4-INCUBATING
>            Reporter: Chathuri Wimalasena
>             Fix For: 0.5-INCUBATING
>
>         Attachments: AIRAVATA-562.1.patch, AIRAVATA-562.2.patch, data.sql, registry.sql
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Commented] (AIRAVATA-562) Replacing existing Jackrabbit registry with MySQL

Posted by "Saminda Wijeratne (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/AIRAVATA-562?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13447004#comment-13447004 ] 

Saminda Wijeratne commented on AIRAVATA-562:
--------------------------------------------

registry.sql
========

1. Few things that may needs changing
published workflows are for per project right?
we did not discuss this earlier, but how about adding "topic_id" as well to the experiments table? We use topic id to monitor an experiment. (right now both experiment id & the topic id is the same, but the feature does not require it to be)
thinking the pros and cons of having an integer "id" feild (primary key) for the descriptors and have a varchar name field? In that way we wont have descriptor id duplication issues among gateways.

2. A few suggestions on the names,

Projects.project_id => Projects.id (similarly for other tables as well)

publish_workflow_name => name
workflow_content => graph

host_descriptor_xml => descriptor

Publish_Workflow => Published_Workflows
Host_Descriptor => Host_Descriptors

3. Couple of things that might be useful to have but not a must (thinking aloud here)
Adding a few metadata (last saved dates, author of descriptor, user full name/contacts/photo, data expiration dates)

                
> Replacing existing Jackrabbit registry with MySQL
> -------------------------------------------------
>
>                 Key: AIRAVATA-562
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-562
>             Project: Airavata
>          Issue Type: New Feature
>          Components: Registry API
>    Affects Versions: 0.4-INCUBATING
>            Reporter: Chathuri Wimalasena
>             Fix For: 0.5-INCUBATING
>
>         Attachments: AIRAVATA-562.1.patch, registry.sql
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (AIRAVATA-562) Replacing existing Jackrabbit registry with MySQL

Posted by "Chathuri Wimalasena (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/AIRAVATA-562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chathuri Wimalasena updated AIRAVATA-562:
-----------------------------------------

    Attachment: AIRAVATA-562.8.patch
    
> Replacing existing Jackrabbit registry with MySQL
> -------------------------------------------------
>
>                 Key: AIRAVATA-562
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-562
>             Project: Airavata
>          Issue Type: New Feature
>          Components: Registry API
>    Affects Versions: 0.4-INCUBATING
>            Reporter: Chathuri Wimalasena
>             Fix For: 0.5-INCUBATING
>
>         Attachments: AIRAVATA-562.1.patch, AIRAVATA-562.2.patch, AIRAVATA-562.3.patch, AIRAVATA-562.4.patch, AIRAVATA-562.5.patch, AIRAVATA-562.6.patch, AIRAVATA-562.7.patch, AIRAVATA-562.8.patch, data.sql, registry.sql
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Commented] (AIRAVATA-562) Replacing existing Jackrabbit registry with MySQL

Posted by "Raminderjeet Singh (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/AIRAVATA-562?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13449628#comment-13449628 ] 

Raminderjeet Singh commented on AIRAVATA-562:
---------------------------------------------

Saminda,  Can you remove mysql driver dependency from the pom?
                
> Replacing existing Jackrabbit registry with MySQL
> -------------------------------------------------
>
>                 Key: AIRAVATA-562
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-562
>             Project: Airavata
>          Issue Type: New Feature
>          Components: Registry API
>    Affects Versions: 0.4-INCUBATING
>            Reporter: Chathuri Wimalasena
>             Fix For: 0.5-INCUBATING
>
>         Attachments: AIRAVATA-562.1.patch, AIRAVATA-562.2.patch, data.sql, registry.sql
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (AIRAVATA-562) Replacing existing Jackrabbit registry with MySQL

Posted by "Chathuri Wimalasena (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/AIRAVATA-562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chathuri Wimalasena updated AIRAVATA-562:
-----------------------------------------

    Attachment: data.sql

Attaching the updated SQL. Name of the sql file has changed from registry.sql -> data.sql
                
> Replacing existing Jackrabbit registry with MySQL
> -------------------------------------------------
>
>                 Key: AIRAVATA-562
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-562
>             Project: Airavata
>          Issue Type: New Feature
>          Components: Registry API
>    Affects Versions: 0.4-INCUBATING
>            Reporter: Chathuri Wimalasena
>             Fix For: 0.5-INCUBATING
>
>         Attachments: AIRAVATA-562.1.patch, data.sql, registry.sql
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (AIRAVATA-562) Replacing existing Jackrabbit registry with MySQL

Posted by "Chathuri Wimalasena (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/AIRAVATA-562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chathuri Wimalasena updated AIRAVATA-562:
-----------------------------------------

    Attachment: AIRAVATA-562.9.patch

Adding method comments.
                
> Replacing existing Jackrabbit registry with MySQL
> -------------------------------------------------
>
>                 Key: AIRAVATA-562
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-562
>             Project: Airavata
>          Issue Type: New Feature
>          Components: Registry API
>    Affects Versions: 0.4-INCUBATING
>            Reporter: Chathuri Wimalasena
>             Fix For: 0.5-INCUBATING
>
>         Attachments: AIRAVATA-562.1.patch, AIRAVATA-562.2.patch, AIRAVATA-562.3.patch, AIRAVATA-562.4.patch, AIRAVATA-562.5.patch, AIRAVATA-562.6.patch, AIRAVATA-562.7.patch, AIRAVATA-562.8.patch, AIRAVATA-562.9.patch, data.sql, registry.sql
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (AIRAVATA-562) Replacing existing Jackrabbit registry with MySQL

Posted by "Chathuri Wimalasena (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/AIRAVATA-562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chathuri Wimalasena updated AIRAVATA-562:
-----------------------------------------

    Attachment: AIRAVATA-562.7.patch
    
> Replacing existing Jackrabbit registry with MySQL
> -------------------------------------------------
>
>                 Key: AIRAVATA-562
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-562
>             Project: Airavata
>          Issue Type: New Feature
>          Components: Registry API
>    Affects Versions: 0.4-INCUBATING
>            Reporter: Chathuri Wimalasena
>             Fix For: 0.5-INCUBATING
>
>         Attachments: AIRAVATA-562.1.patch, AIRAVATA-562.2.patch, AIRAVATA-562.3.patch, AIRAVATA-562.4.patch, AIRAVATA-562.5.patch, AIRAVATA-562.6.patch, AIRAVATA-562.7.patch, data.sql, registry.sql
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira