Page 1 of 1

Migrating HSQL to Mysql but 404 Error on site

Posted: Tue Sep 01, 2015 2:48 am
by joshuacanlas
Hello people.

I have problem on migrating hsql to mysql. First i already run it on ant tomcat with hsql then i want to use it with mysql. I followed all steps on this documentaion http://www.broadleafcommerce.com/docs/c ... l-tutorial

But it has error when accessing the site it give error 404. and when i checked on database. all tables are created but their is no data on some of it.

here the some log.

[artifact:mvn] [ERROR] 15:34:02 SchemaExport - HHH000231: Schema export unsuccessful
[artifact:mvn] org.hibernate.tool.hbm2ddl.ImportScriptException: Error during statement execution (file: '/sql/load_i18n_countries.sql'): INSERT INTO BLC_ISO_COUNTRY (ALPHA_2, NAME, ALPHA_3, NUMERIC_CODE, STATUS) VALUES ('AX', 'Ă…land Islands', 'ALA', '248', 'OFFICIALLY_ASSIGNED')
[artifact:mvn] at org.hibernate.tool.hbm2ddl.SchemaExport.importScript(SchemaExport.java:451)
[artifact:mvn] at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:378)
[artifact:mvn] at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:304)
[artifact:mvn] at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:293)
[artifact:mvn] at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:498)
[artifact:mvn] at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1742)
[artifact:mvn] at org.hibernate.ejb.EntityManagerFactoryImpl.<init>(EntityManagerFactoryImpl.java:94)
[artifact:mvn] at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:905)
[artifact:mvn] at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:890)
[artifact:mvn] at org.springframework.orm.jpa.vendor.SpringHibernateEjbPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateEjbPersistenceProvider.java:51)


Please help me. Thank you.

Re: Migrating HSQL to Mysql but 404 Error on site

Posted: Thu Sep 03, 2015 1:14 am
by joshuacanlas
any help about this? please help me.

Re: Migrating HSQL to Mysql but 404 Error on site

Posted: Thu Sep 10, 2015 3:20 am
by joshuacanlas
Already resolved the problem.

Thanks.

Re: Migrating HSQL to Mysql but 404 Error on site

Posted: Wed Feb 03, 2016 4:01 pm
by yogesh12
i have same problem,how can i solve pls help

Re: Migrating HSQL to Mysql but 404 Error on site

Posted: Thu Feb 04, 2016 11:31 pm
by phillipuniverse
By the way, this is likely due to MySQL not running in UTF-8 mode. See this link in the Broadleaf docs: http://www.broadleafcommerce.com/docs/c ... tion/mysql.

Basically, ensure that your my.cnf configuration tells MySQL to run with the following:

Code: Select all

[mysqld]
lower_case_table_names=1
character-set-server=utf8
collation-server=utf8_general_ci


After you do this, you might need to create another database that will be defaulted to UTF-8. If you don't configure this, MySQL usually starts up in MYISAM which is incompatible with UTF-8.

Re: Migrating HSQL to Mysql but 404 Error on site

Posted: Mon Feb 08, 2016 12:03 pm
by yogesh12
i configured broadleaf project with tomcat and the site module is up on running but when i go to register new user it will says like--please enter valid password and also by submit button user is successfully added in user when i go to admin panel i see the same user i registered but i can't login with that same user name and password that i provided while registration and it will give following errors--The e-mail address and/or password entered do not match our records. Please try again

Re: Migrating HSQL to Mysql but 404 Error on site

Posted: Fri Mar 25, 2016 1:58 am
by Delorisheinen
I am very familiar with netbeans and I want configure broadleaf commerce for netbeans so what are the precaution I have to take for configure broadleaf for netbeans