Page 3 of 3

Re: Moving DataBase HSQLDB to MySQL

Posted: Thu Jun 19, 2014 11:33 pm
by yileizheng
Another step may help to solve this problem is to delete data folder under DemoSite/Site. I notice it generates that folder when run the demo site under HSQLDB. After I remove the folder and it works for me.

Re: Moving DataBase HSQLDB to MySQL

Posted: Fri Aug 01, 2014 6:08 am
by mathias.lin
I had this problem as well. I had deployed the DemoSite to Tomcat using MySql, then switched to HSQL, then back to MySql. After switching back to MySql, I got this error above.
Even a

Code: Select all

mvn clean install
did not help. All references to HSQL were correctly changed back as far as I saw it.

My solution was to create a mysql database under a new name, so instead of "broadleaf" I created a new one named "blf" and the error was gone.
I had tried to drop and re-create the database "broadleaf" under the same name before, but still got that error. So it seems that something was cached somewhere, but I still could not figure out, where.

Re: Moving DataBase HSQLDB to MySQL

Posted: Fri Aug 01, 2014 6:09 am
by mathias.lin
@yileizheng: Which Data folder under DemoSite/Site are you referring to? I didnt't find any? Is it only when you run the project from within Eclipse and Jetty?

I just did a

Code: Select all

git clone
and

Code: Select all

mvn clean install
and put the war to Tomcat. But didn't see any data folder anywhere.
Thanks.