[
https://issues.apache.org/jira/browse/RAVE-874?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
John McCoey updated RAVE-874:
-----------------------------
Comment: was deleted
(was: I am running Rave 0.14 and I'm trying to switch from the H2 database to
MySQL on Linux, but I cannot get the included initial_data.sql to execute. It
creates the RAVE_PORTAL_SEQUENCES table, but after that gets stuck trying to
insert values into the not-yet-created page_layout table. Is there some other
SQL file or a setting I am missing?)
> 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
