Page 1 of 1

Problem with broadleaf using mysql

Posted: Wed Dec 05, 2012 1:50 am
by rdhaneshm
It is giving me error as following :
I can not understand mysql does not suppport clob. I am using
Mysql version 5.5.9
BroadLeaf 2.0.2-GA
Maven 3.0.4

Can anybody help to resolve this?

[artifact:mvn] [ WARN] 12:03:59 Ejb3Configuration - hibernate.connection.autocommit = false break the EJB3 specification
[artifact:mvn] [ WARN] 12:04:01 AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named
[blSandBoxElements]; using defaults.
[artifact:mvn] [ERROR] 12:04:04 SchemaExport - Unsuccessful: create table BLC_CATEGORY (CATEGORY_ID bigint not null, ACTIVE_E
ND_DATE timestamp, ACTIVE_START_DATE timestamp, ARCHIVED char(255), DESCRIPTION varchar(255), DISPLAY_TEMPLATE varchar(255),
LONG_DESCRIPTION clob, NAME varchar(255) not null, URL varchar(255), URL_KEY varchar(255), DEFAULT_PARENT_CATEGORY_ID bigint,
primary key (CATEGORY_ID))
[artifact:mvn] [ERROR] 12:04:04 SchemaExport - You have an error in your SQL syntax; check the manual that corresponds to you
r MySQL server version for the right syntax to use near 'clob, NAME varchar(255) not null, URL varchar(255), URL_KEY varchar(
255), DEFAUL' at line 1
[artifact:mvn] [ERROR] 12:04:04 SchemaExport - Unsuccessful: create table BLC_CONTENT (ID integer not null, ACTIVE_END_DATE t
imestamp, ACTIVE_START_DATE timestamp, APPROVED_BY varchar(255), APPROVED_DATE timestamp, BROWSER_TITLE varchar(255), CONTENT
_DATE timestamp, CONTENT_TYPE varchar(255), DEPLOYED bit, DESCRIPTION clob, DISPLAY_RULE varchar(255), KEYWORDS varchar(255),
LANGUAGE_CODE varchar(255), LAST_MODIFIED_BY varchar(255), LAST_MODIFIED_DATE timestamp, META_DESCRIPTION varchar(255), NOTE
varchar(255), ONLINE_STATE bit, PARENT_CONTENT_ID integer, PRIORITY integer, REJECTED_BY varchar(255), REJECTED_DATE timesta
mp, RENDER_TEMPLATE varchar(255), SANDBOX varchar(255), SUBMITTED_BY varchar(255), SUBMITTED_DATE timestamp, TITLE varchar(25
5), URL_TITLE varchar(255), primary key (ID))

Re: Problem with broadleaf using mysql

Posted: Fri Dec 07, 2012 12:22 pm
by jefffischer
This looks like a similar problem to viewtopic.php?f=14&t=1485&p=3750#p3750. I don't think the MySQL dialect is in place. Take a look at http://docs.broadleafcommerce.org/curre ... orial.html and make sure you've done a maven clean and install.