Page 1 of 1

Wrong column type in ***.blc_address for column IS

Posted: Mon Jun 22, 2015 7:03 am
by blondeMatrix
Hello all, ;)

I'm hoping someone can help explain why I am getting the following errors...

Code: Select all

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in resource loaded from byte array: Invocation of init method failed; nested exception is javax.persistence.PersistenceException: [PersistenceUnit: blPU] Unable to build EntityManagerFactory
Caused by: javax.persistence.PersistenceException: [PersistenceUnit: blPU] Unable to build EntityManagerFactory
Caused by: org.hibernate.HibernateException: Wrong column type in senseCommerce.blc_address for column IS_ACTIVE. Found: bit, expected: boolean


Despite common-shared.properties stipulating the correct hibernate dialect for MySQL...

Code: Select all

blPU.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
...
blCMSStorage.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
...
blSecurePU.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect


I am running MySQL 5.6.25.

Thanks & regards,

Chris.

Re: Wrong column type in ***.blc_address for column IS

Posted: Mon Jun 22, 2015 1:25 pm
by phillipuniverse
Pretty sure you're running into this problem: https://github.com/BroadleafCommerce/Br ... issues/189

Make sure that you don't have 'validate' anywhere in your properties files. If you see 'validate' change it to 'none'.

Re: Wrong column type in ***.blc_address for column IS

Posted: Tue Jun 23, 2015 2:19 am
by blondeMatrix
Thanks Phillip, I have changed all instances of 'validate' to 'none'. I guess once Hibernate fix this bug this work-around will no longer be necessary.

Regards,

Chris.