[RAVE-874] Unable to load initial data on a MySQL database when using linux

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.20
• Component/s: rave-portal
• Environment: MySQL Community Server 5.5.28; Fedora 17
• Assignee: Dagmar
• Reporter: Dagmar
• Created: 17/Jan/13 13:51
• Updated: 18/Feb/13 21:55
• Resolved: 18/Feb/13 21:55

Description

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