[
https://issues.apache.org/jira/browse/RAVE-874?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13560668#comment-13560668
]
John McCoey commented on RAVE-874:
----------------------------------
I may have asked the question too early, as I now realize JPA should generate
the tables, so I'm attempting that now
> 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
