[Registry-dev] [jira] Resolved: (REGISTRY-269) Table doesn't exist error while setting up connection to MySql on Linux

[Chathura Ekanayake (JIRA)]

     [ https://wso2.org/jira/browse/REGISTRY-269?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chathura Ekanayake resolved REGISTRY-269.
-----------------------------------------

    Resolution: Fixed

This error in Linux is due to case sensitivity of table names. User manager SQLs were written in lower case, but the tables are created with upper case names. The error is fixed after changing all SQLs to upper case. Now WSO2 Registry works fine with MySQL under Linux and Windows platforms.

Thanks Dimuthu for commiting the updated SQLs for User Manager data access layer. 

> Table doesn't exist error while setting up connection to MySql on Linux
> -----------------------------------------------------------------------
>
>                 Key: REGISTRY-269
>                 URL: https://wso2.org/jira/browse/REGISTRY-269
>             Project: WSO2 Registry
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 1.0
>         Environment: - Red Hat Enterprise Linux AS release 4 (Nahant Update 4)
> - mysql  Ver 14.12 Distrib 5.0.17c, for redhat-linux-gnu (i386) using readline 5.0
>            Reporter: Krishantha Samaraweera
>            Assignee: Chathura Ekanayake
>            Priority: Blocker
>
> http://wso2.org/forum/thread/3356#comment-5433
> [JIRA created for forum post]

-- 
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