Dagmar created RAVE-874:
---------------------------
Summary: 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
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".
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
