[
https://issues.apache.org/jira/browse/RAVE-874?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13559468#comment-13559468
]
Dagmar commented on RAVE-874:
-----------------------------
Thanks for the information Raminderjeet. I think that using a setting in MySQL
or JPA would be acceptable when the problem is widespread and you aren't able
to modify the code. The real solution is to ensure that tablenames (and
filenames for that matter) are used consistently. WIDGET and widget are
different in most domains - even in a Java program - it's just that Windows
allows you to ignore the problem.
> Unable to load initial data on a MySQL database when using linux
> ----------------------------------------------------------------
>
> Key: RAVE-874
> URL: https://issues.apache.org/jira/browse/RAVE-874
> Project: Rave
> Issue Type: Bug
> Components: rave-portal
> Environment: MySQL Community Server 5.5.28
> Fedora 17
> Reporter: Dagmar
> Attachments: Rave-874.patch
>
>
> When using a MySQL database on a linux OS it is not possible to load the
> initial data due the OS being case-sensitive.
> The executeScriptQuery parameter of
> org.apache.rave.jdbc.util.DataSourcePopulator is "SELECT * FROM WIDGET" but
> the table is actually named "widget". (see line 31 in Spring configuration
> file named dataContext.xml)
> There are no error logs because it seems the exception where the table is not
> found is swallowed (see line 166 in DataSourcePopulator).
> To reproduce:
> 1. Create a database in MySQL and create a user and grant ALL permissions to
> the user on the database
> 2. Follow instructions on the following page to setup your mysql database
> (using the details of the database created above):
> http://rave.apache.org/documentation/configure-database.html
> 3. Rebuild and restart your server
> 4. Load the Apache Rave login page
> Expected result
> 1. You can login with the canonical user
> 2. Tables have been created in the database and you will see data returned
> if you execute "select * from person"
> Actual result
> 1. You cannot login with the canonical user
> 2. Tables have been created but they are empty
--
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
