Migrating HSQL to Mysql but 404 Error on site

Topics related to running, modifying, or working with the Broadleaf Commerce Demo application

Moderator: jocanas

joshuacanlas
Newbie
Newbie
Posts: 13
Joined: Tue Aug 25, 2015 10:44 pm

Migrating HSQL to Mysql but 404 Error on site

Postby joshuacanlas » Tue Sep 01, 2015 2:48 am

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.

joshuacanlas
Newbie
Newbie
Posts: 13
Joined: Tue Aug 25, 2015 10:44 pm

Re: Migrating HSQL to Mysql but 404 Error on site

Postby joshuacanlas » Thu Sep 03, 2015 1:14 am

any help about this? please help me.

joshuacanlas
Newbie
Newbie
Posts: 13
Joined: Tue Aug 25, 2015 10:44 pm

Re: Migrating HSQL to Mysql but 404 Error on site

Postby joshuacanlas » Thu Sep 10, 2015 3:20 am

Already resolved the problem.

Thanks.

yogesh12
Newbie
Newbie
Posts: 6
Joined: Wed Feb 03, 2016 3:36 pm

Re: Migrating HSQL to Mysql but 404 Error on site

Postby yogesh12 » Wed Feb 03, 2016 4:01 pm

i have same problem,how can i solve pls help

phillipuniverse
Team Member
Team Member
Posts: 1563
Joined: Tue Dec 20, 2011 12:11 pm

Re: Migrating HSQL to Mysql but 404 Error on site

Postby phillipuniverse » Thu Feb 04, 2016 11:31 pm

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.

yogesh12
Newbie
Newbie
Posts: 6
Joined: Wed Feb 03, 2016 3:36 pm

Re: Migrating HSQL to Mysql but 404 Error on site

Postby yogesh12 » Mon Feb 08, 2016 12:03 pm

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

Delorisheinen
Newbie
Newbie
Posts: 1
Joined: Fri Mar 25, 2016 12:34 am

Re: Migrating HSQL to Mysql but 404 Error on site

Postby Delorisheinen » Fri Mar 25, 2016 1:58 am

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


Return to “Broadleaf Commerce Demo”

Who is online

Users browsing this forum: No registered users and 1 guest