[
https://issues.apache.org/jira/browse/RAVE-874?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13562828#comment-13562828
]
Raminderjeet Singh commented on RAVE-874:
-----------------------------------------
Thanks Dagmar for the patch. I applied the patch and that does not seem to fix
the problems for me. Data tables are created fine but initial data is not
getting populated. I am still getting lot of other error related to data
population. Some of the error are:
[INFO] [talledLocalContainer] ERROR:
org.apache.rave.persistence.jpa.PopulatedLocalContainerEntityManagerFactory -
Database population has failed. It will be empty.
[INFO] [talledLocalContainer] java.lang.RuntimeException: SQL exception
occurred loading data from initial_data.sql
[INFO] [talledLocalContainer] Caused by:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in
your SQL syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near 'set @page_layout_seq = 'page_layout'; set
@region_seq = 'region'; set @region_wi' at line 1
[INFO] [talledLocalContainer] Caused by:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in
your SQL syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near 'set @oauth_consumer_store_seq =
'oauth_consumer_store'; set @application_data_se' at line 1
> 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
> 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
