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))
This forum is in readonly mode and serves as an archive of old information. All posting, registration and commenting abilities have been turned off. To get help, the Broadleaf team reguarly monitors the broadleaf-commerce tag on Stack Overflow so please ask your questions there.