You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@rave.apache.org by "Raminderjeet Singh (JIRA)" <ji...@apache.org> on 2013/02/18 22:57:13 UTC
[jira] [Closed] (RAVE-874) Unable to load initial data on a MySQL
database when using linux
[ https://issues.apache.org/jira/browse/RAVE-874?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Raminderjeet Singh closed RAVE-874.
-----------------------------------
Resolution: Fixed
Fix Version/s: 0.20
Patch was applied on Jan28th.
> 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
> Assignee: Dagmar
> Fix For: 0.20
>
> 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