[Registry-dev] [jira] Commented: (REGISTRY-289) modules/core/target/classes/database-scripts/mysql-registry.sql file is empty (mvn install executed against r16629 checkout)

[Krishantha Samaraweera (JIRA)]

    [ https://wso2.org/jira/browse/REGISTRY-289?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16701#action_16701 ] 

Krishantha Samaraweera commented on REGISTRY-289:
-------------------------------------------------

I have tested on both window and linux environments. Registry run successfully with mysql after creating the DB and tables manually. But when I try to start the registry with create=true in the mysql db url,exception came up with saying mysql doesn't recognize the create=true option. After that I created only the database and point the url to it. Registry successfully created all the tables inside the given database. So registry support mysql db on windows without problem.

On the linux environment, registry was able to create the tables on given database automatically. But once I try to start registry though a browse, following exception is encounted. Registry 1.0 also didn't support for mysql on linux. This seems to be the same issue. 

exception.
======
java.lang.NullPointerException
	org.wso2.registry.web.actions.AbstractRegistryAction.getRegistry(AbstractRegistryAction.java:54)
	org.wso2.registry.web.actions.ResourceDetailsAction.execute(ResourceDetailsAction.java:92)
	org.wso2.registry.web.ControllerServlet.forwardToResources(ControllerServlet.java:834)
	org.wso2.registry.web.ControllerServlet.doGet(ControllerServlet.java:456)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

> modules/core/target/classes/database-scripts/mysql-registry.sql file is empty (mvn install executed against r16629 checkout)
> ----------------------------------------------------------------------------------------------------------------------------
>
>                 Key: REGISTRY-289
>                 URL: https://wso2.org/jira/browse/REGISTRY-289
>             Project: WSO2 Registry
>          Issue Type: Bug
>          Components: core
>    Affects Versions: SNAPSHOT
>         Environment: Windows XP, Eclipse 3.3.2, Maven 2.0.7
>            Reporter: Kelvin Meeks
>            Assignee: Chathura Ekanayake
>            Priority: Blocker
>
> I did a checkout of the latest revision from the Subversion repository (r16629) - and executed a "mvn install"
> It appeared that the bulid and all tests executed ok, however, it appears that the mysql-registry.sql file is empty - the other database files (derby-complete.sql, derby-registry.sql, hsql-registry.sql) appear to have been correctly generated.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://wso2.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira