Postby saman » Mon Jul 30, 2012 3:05 am
Hi everyone,
I have downloaded, build and successfully run the demo project (heat clinic) comes with Broadleaf verion 2.0. But it is in-memory database and I wanted to migrate it into MySQL database. I changed the datasource and dependency changes to MySQL as described in the wiki page. But I encountered following exception. Have anyone experience this and fix the issue.
[artifact:mvn] [ INFO] 12:48:00 SchemaExport - exporting generated schema to database
[artifact:mvn] [ERROR] 12:48:01 SchemaExport - Unsuccessful: create table BLC_CATEGORY (CATEGORY_ID bigint not null, ACTIVE_END_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:48:01 SchemaExport - You have an error in your SQL syntax; check the manual that corresponds to your 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:48:01 SchemaExport - Unsuccessful: create table BLC_CONTENT (ID integer not null, ACTIVE_END_DATE timestamp, ACTIVE_START_DA
TE timestamp, APPROVED_BY varchar(255), APPROVED_DATE timestamp, BROWSER_TITLE varchar(255), CONTENT_DATE timestamp, CONTENT_TYPE varchar(255), DEPLOY
ED bit, DESCRIPTION clob, DISPLAY_RULE varchar(255), KEYWORDS varchar(255), LANGUAGE_CODE varchar(255), LAST_MODIFIED_BY varchar(255), LAST_MODIFIED_D
ATE timestamp, META_DESCRIPTION varchar(255), NOTE varchar(255), ONLINE_STATE bit, PARENT_CONTENT_ID integer, PRIORITY integer, REJECTED_BY varchar(25
5), REJECTED_DATE timestamp, 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))
[artifact:mvn] [ERROR] 12:48:02 SchemaExport - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version fo
r the right syntax to use near 'clob, DISPLAY_RULE varchar(255), KEYWORDS varchar(255), LANGUAGE_CODE varchar(25' at line 1
[artifact:mvn] [ERROR] 12:48:02 SchemaExport - Unsuccessful: create table BLC_CONTENT_DETAILS (CONTENT_HASH varchar(255), XML_CONTENT clob, ID integer
not null, primary key (ID))
[artifact:mvn] [ERROR] 12:48:02 SchemaExport - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version fo
r the right syntax to use near 'clob, ID integer not null, primary key (ID))' at line 1
[artifact:mvn] [ERROR] 12:48:03 SchemaExport - Unsuccessful: create table BLC_FULFILLMENT_OPTION (FULFILLMENT_OPTION_ID bigint not null, FULFILLMENT_T
YPE varchar(255) not null, LONG_DESCRIPTION clob, NAME varchar(255), USE_FLAT_RATES bit, primary key (FULFILLMENT_OPTION_ID))
[artifact:mvn] [ERROR] 12:48:03 SchemaExport - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version fo
r the right syntax to use near 'clob, NAME varchar(255), USE_FLAT_RATES bit, primary key (FULFILLMENT_OPTION_ID)' at line 1
[artifact:mvn] [ERROR] 12:48:04 SchemaExport - Unsuccessful: create table BLC_OFFER_ITEM_CRITERIA (OFFER_ITEM_CRITERIA_ID bigint not null, ORDER_ITEM_
MATCH_RULE clob, QUANTITY integer not null, primary key (OFFER_ITEM_CRITERIA_ID))
[artifact:mvn] [ERROR] 12:48:04 SchemaExport - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version fo
r the right syntax to use near 'clob, QUANTITY integer not null, primary key (OFFER_ITEM_CRITERIA_ID))' at line 1
[artifact:mvn] [ERROR] 12:48:04 SchemaExport - Unsuccessful: create table BLC_OFFER_RULE (OFFER_RULE_ID bigint not null, MATCH_RULE clob, primary key
(OFFER_RULE_ID))
[artifact:mvn] [ERROR] 12:48:04 SchemaExport - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version fo
r the right syntax to use near 'clob, primary key (OFFER_RULE_ID))' at line 1
[artifact:mvn] [ERROR] 12:48:05 SchemaExport - Unsuccessful: create table BLC_PAGE_FLD (PAGE_FLD_ID bigint not null, DATE_CREATED timestamp, DATE_UPDA
TED timestamp, FLD_KEY varchar(255), LOB_VALUE clob, VALUE varchar(255), CREATED_BY bigint, UPDATED_BY bigint, PAGE_ID bigint, primary key (PAGE_FLD_I
D))
[artifact:mvn] [ERROR] 12:48:05 SchemaExport - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version fo
r the right syntax to use near 'clob, VALUE varchar(255), CREATED_BY bigint, UPDATED_BY bigint, PAGE_ID bigint, ' at line 1
[artifact:mvn] [ERROR] 12:48:05 SchemaExport - Unsuccessful: create table BLC_PAGE_ITEM_CRITERIA (PAGE_ITEM_CRITERIA_ID bigint not null, ORDER_ITEM_MA
TCH_RULE clob, QUANTITY integer not null, primary key (PAGE_ITEM_CRITERIA_ID))
[artifact:mvn] [ERROR] 12:48:05 SchemaExport - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version fo
r the right syntax to use near 'clob, QUANTITY integer not null, primary key (PAGE_ITEM_CRITERIA_ID))' at line 1
[artifact:mvn] [ERROR] 12:48:05 SchemaExport - Unsuccessful: create table BLC_PAGE_RULE (PAGE_RULE_ID bigint not null, MATCH_RULE clob, primary key (P
AGE_RULE_ID))
[artifact:mvn] [ERROR] 12:48:05 SchemaExport - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version fo
r the right syntax to use near 'clob, primary key (PAGE_RULE_ID))' at line 1
[artifact:mvn] [ERROR] 12:48:07 SchemaExport - Unsuccessful: create table BLC_SC_FLD (SC_FLD_ID bigint not null, DATE_CREATED timestamp, DATE_UPDATED
timestamp, FLD_KEY varchar(255), LOB_VALUE clob, VALUE varchar(255), CREATED_BY bigint, UPDATED_BY bigint, SC_ID bigint, primary key (SC_FLD_ID))
[artifact:mvn] [ERROR] 12:48:07 SchemaExport - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version fo
r the right syntax to use near 'clob, VALUE varchar(255), CREATED_BY bigint, UPDATED_BY bigint, SC_ID bigint, pr' at line 1
[artifact:mvn] [ERROR] 12:48:08 SchemaExport - Unsuccessful: create table BLC_SC_ITEM_CRITERIA (SC_ITEM_CRITERIA_ID bigint not null, ORDER_ITEM_MATCH_
RULE clob, QUANTITY integer not null, primary key (SC_ITEM_CRITERIA_ID))
[artifact:mvn] [ERROR] 12:48:08 SchemaExport - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version fo
r the right syntax to use near 'clob, QUANTITY integer not null, primary key (SC_ITEM_CRITERIA_ID))' at line 1
[artifact:mvn] [ERROR] 12:48:08 SchemaExport - Unsuccessful: create table BLC_SC_RULE (SC_RULE_ID bigint not null, MATCH_RULE clob, primary key (SC_RU
LE_ID))
[artifact:mvn] [ERROR] 12:48:08 SchemaExport - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version fo
r the right syntax to use near 'clob, primary key (SC_RULE_ID))' at line 1
[artifact:mvn] [ERROR] 12:48:08 SchemaExport - Unsuccessful: create table BLC_SKU (SKU_ID bigint not null, ACTIVE_END_DATE timestamp, ACTIVE_START_DAT
E timestamp, AVAILABLE_FLAG char(255), DESCRIPTION varchar(255), CONTAINER_SHAPE varchar(255), DEPTH numeric(19,2), DIMENSION_UNIT_OF_MEASURE varchar(
255), GIRTH numeric(19,2), HEIGHT numeric(19,2), CONTAINER_SIZE varchar(255), WIDTH numeric(19,2), DISCOUNTABLE_FLAG char(255), IS_MACHINE_SORTABLE bi
t, LONG_DESCRIPTION clob, NAME varchar(255), RETAIL_PRICE numeric(19,5), SALE_PRICE numeric(19,5), TAXABLE_FLAG char(255), WEIGHT numeric(19,2), WEIGH
T_UNIT_OF_MEASURE varchar(255), primary key (SKU_ID))
[artifact:mvn] [ERROR] 12:48:08 SchemaExport - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version fo
r the right syntax to use near 'clob, NAME varchar(255), RETAIL_PRICE numeric(19,5), SALE_PRICE numeric(19,5), T' at line 1
[artifact:mvn] [ERROR] 12:48:09 SchemaExport - Unsuccessful: create table BLC_SKU_FEE (SKU_FEE_ID bigint not null, AMOUNT numeric(19,5) not null, DESC
RIPTION varchar(255), EXPRESSION clob, FEE_TYPE varchar(255), NAME varchar(255), TAXABLE bit, primary key (SKU_FEE_ID))
[artifact:mvn] [ERROR] 12:48:09 SchemaExport - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version fo
r the right syntax to use near 'clob, FEE_TYPE varchar(255), NAME varchar(255), TAXABLE bit, primary key (SKU_FE' at line 1
[artifact:mvn] [ERROR] 12:48:10 SchemaExport - Unsuccessful: alter table BLC_ADDITIONAL_OFFER_INFO add constraint FK3BFDBD63D5F3FAF4 foreign key (OFFE
R_ID) references BLC_OFFER
[artifact:mvn] [ERROR] 12:48:10 SchemaExport - Can't create table 'broadleaf2-demo.#sql-5c8_74' (errno: 150)
[artifact:mvn] [ERROR] 12:48:10 SchemaExport - Unsuccessful: alter table BLC_ADDITIONAL_OFFER_INFO add constraint FK3BFDBD63B5D9C34D foreign key (OFFE
R_INFO_ID) references BLC_OFFER_INFO
[artifact:mvn] [ERROR] 12:48:10 SchemaExport - Can't create table 'broadleaf2-demo.#sql-5c8_74' (errno: 150)
[artifact:mvn] [ERROR] 12:48:10 SchemaExport - Unsuccessful: alter table BLC_ADDITIONAL_OFFER_INFO add constraint FK3BFDBD631891FF79 foreign key (BLC_
ORDER_ORDER_ID) references BLC_ORDER
[artifact:mvn] [ERROR] 12:48:10 SchemaExport - Can't create table 'broadleaf2-demo.#sql-5c8_74' (errno: 150)
[artifact:mvn] [ERROR] 12:48:10 SchemaExport - Unsuccessful: alter table BLC_ADDRESS add constraint FK299F86CE337C4D50 foreign key (STATE_PROV_REGION)
references BLC_STATE
[artifact:mvn] [ERROR] 12:48:10 SchemaExport - Can't create table 'broadleaf2-demo.#sql-5c8_74' (errno: 150)
[artifact:mvn] [ERROR] 12:48:10 SchemaExport - Unsuccessful: alter table BLC_ADDRESS add constraint FK299F86CEA46E16CF foreign key (COUNTRY) reference
s BLC_COUNTRY
[artifact:mvn] [ERROR] 12:48:10 SchemaExport - Can't create table 'broadleaf2-demo.#sql-5c8_74' (errno: 150)
[artifact:mvn] [ERROR] 12:48:11 SchemaExport - Unsuccessful: alter table BLC_ADMIN_PERMISSION_ENTITY add constraint FK23C09E3DE88B7D38 foreign key (AD
MIN_PERMISSION_ID) references BLC_ADMIN_PERMISSION
[artifact:mvn] [ERROR] 12:48:11 SchemaExport - Can't create table 'broadleaf2-demo.#sql-5c8_74' (errno: 150)
[artifact:mvn] [ERROR] 12:48:11 SchemaExport - Unsuccessful: alter table BLC_ADMIN_ROLE_PERMISSION_XREF add constraint FK4A819D985F43AAD8 foreign key
(ADMIN_ROLE_ID) references BLC_ADMIN_ROLE
[artifact:mvn] [ERROR] 12:48:11 SchemaExport - Can't create table 'broadleaf2-demo.#sql-5c8_74' (errno: 150)
[artifact:mvn] [ERROR] 12:48:11 SchemaExport - Unsuccessful: alter table BLC_ADMIN_ROLE_PERMISSION_XREF add constraint FK4A819D98E88B7D38 foreign key
(ADMIN_PERMISSION_ID) references BLC_ADMIN_PERMISSION
[artifact:mvn] [ERROR] 12:48:11 SchemaExport - Can't create table 'broadleaf2-demo.#sql-5c8_74' (errno: 150)
[artifact:mvn] [ERROR] 12:48:12 SchemaExport - Unsuccessful: alter table BLC_ADMIN_USER_PERMISSION_XREF add constraint FKF0B3BEED46EBC38 foreign key (
ADMIN_USER_ID) references BLC_ADMIN_USER
[artifact:mvn] [ERROR] 12:48:12 SchemaExport - Can't create table 'broadleaf2-demo.#sql-5c8_74' (errno: 150)
[artifact:mvn] [ERROR] 12:48:12 SchemaExport - Unsuccessful: alter table BLC_ADMIN_USER_PERMISSION_XREF add constraint FKF0B3BEEDE88B7D38 foreign key
(ADMIN_PERMISSION_ID) references BLC_ADMIN_PERMISSION
[artifact:mvn] [ERROR] 12:48:12 SchemaExport - Can't create table 'broadleaf2-demo.#sql-5c8_74' (errno: 150)
[artifact:mvn] [ERROR] 12:48:12 SchemaExport - Unsuccessful: alter table BLC_ADMIN_USER_ROLE_XREF add constraint FKFFD33A265F43AAD8 foreign key (ADMIN
_ROLE_ID) references BLC_ADMIN_ROLE
[artifact:mvn] [ERROR] 12:48:12 SchemaExport - Can't create table 'broadleaf2-demo.#sql-5c8_74' (errno: 150)
[artifact:mvn] [ERROR] 12:48:12 SchemaExport - Unsuccessful: alter table BLC_ADMIN_USER_ROLE_XREF add constraint FKFFD33A2646EBC38 foreign key (ADMIN_
USER_ID) references BLC_ADMIN_USER
[artifact:mvn] [ERROR] 12:48:12 SchemaExport - Can't create table 'broadleaf2-demo.#sql-5c8_74' (errno: 150)
[artifact:mvn] [ERROR] 12:48:12 SchemaExport - Unsuccessful: alter table BLC_ADMIN_USER_SANDBOX add constraint FKD0A97E0946EBC38 foreign key (ADMIN_US
ER_ID) references BLC_ADMIN_USER
[artifact:mvn] [ERROR] 12:48:12 SchemaExport - Can't create table 'broadleaf2-demo.#sql-5c8_74' (errno: 150)
[artifact:mvn] [ERROR] 12:48:12 SchemaExport - Unsuccessful: alter table BLC_ADMIN_USER_SANDBOX add constraint FKD0A97E09579FE59D foreign key (SANDBOX
_ID) references BLC_SANDBOX
[artifact:mvn] [ERROR] 12:48:12 SchemaExport - Can't create table 'broadleaf2-demo.#sql-5c8_74' (errno: 150)
[artifact:mvn] [ERROR] 12:48:13 SchemaExport - Unsuccessful: alter table BLC_AMOUNT_ITEM add constraint FKB98530944BC71D98 foreign key (PAYMENT_ID) re
ferences BLC_ORDER_PAYMENT
[artifact:mvn] [ERROR] 12:48:13 SchemaExport - Can't create table 'broadleaf2-demo.#sql-5c8_74' (errno: 150)
[artifact:mvn] [ERROR] 12:48:13 SchemaExport - Unsuccessful: alter table BLC_ASSET_DESC_MAP add constraint FKE886BAE367F70B63 foreign key (STATIC_ASSE
T_ID) references BLC_STATIC_ASSET
[artifact:mvn] [ERROR] 12:48:13 SchemaExport - Can't create table 'broadleaf2-demo.#sql-5c8_74' (errno: 150)
[artifact:mvn] [ERROR] 12:48:13 SchemaExport - Unsuccessful: alter table BLC_ASSET_DESC_MAP add constraint FKE886BAE3E2BA0C9D foreign key (STATIC_ASSE
T_DESC_ID) references BLC_STATIC_ASSET_DESC
[artifact:mvn] [ERROR] 12:48:13 SchemaExport - Can't create table 'broadleaf2-demo.#sql-5c8_74' (errno: 150)
[artifact:mvn] [ERROR] 12:48:13 SchemaExport - Unsuccessful: alter table BLC_BUNDLE_ORDER_ITEM add constraint FK489703DB9AF166DF foreign key (ORDER_IT
EM_ID) references BLC_ORDER_ITEM
[artifact:mvn] [ERROR] 12:48:13 SchemaExport - Can't create table 'broadleaf2-demo.#sql-5c8_74' (errno: 150)
[artifact:mvn] [ERROR] 12:48:13 SchemaExport - Unsuccessful: alter table BLC_BUNDLE_ORDER_ITEM add constraint FK489703DBB78C9977 foreign key (SKU_ID)
references BLC_SKU
[artifact:mvn] [ERROR] 12:48:13 SchemaExport - Can't create table 'broadleaf2-demo.#sql-5c8_74' (errno: 150)
[artifact:mvn] [ERROR] 12:48:13 SchemaExport - Unsuccessful: alter table BLC_BUNDLE_ORDER_ITEM add constraint FK489703DBCCF29B96 foreign key (PRODUCT_
BUNDLE_ID) references BLC_PRODUCT_BUNDLE
[artifact:mvn] [ERROR] 12:48:13 SchemaExport - Can't create table 'broadleaf2-demo.#sql-5c8_74' (errno: 150)
[artifact:mvn] [ERROR] 12:48:13 SchemaExport - Unsuccessful: alter table BLC_BUND_ITEM_FEE_PRICE add constraint FK14267A943FC68307 foreign key (BUND_O
RDER_ITEM_ID) references BLC_BUNDLE_ORDER_ITEM
[artifact:mvn] [ERROR] 12:48:13 SchemaExport - Can't create table 'broadleaf2-demo.#sql-5c8_74' (errno: 150)
[artifact:mvn] [ERROR] 12:48:13 SchemaExport - Unsuccessful: alter table BLC_CANDIDATE_FG_OFFER add constraint FKCE78560D5F3FAF4 foreign key (OFFER_ID
) references BLC_OFFER
[artifact:mvn] [ERROR] 12:48:13 SchemaExport - Can't create table 'broadleaf2-demo.#sql-5c8_74' (errno: 150)
[artifact:mvn] [ERROR] 12:48:13 SchemaExport - Unsuccessful: alter table BLC_CANDIDATE_FG_OFFER add constraint FKCE785605028DC55 foreign key (FULFILLM
ENT_GROUP_ID) references BLC_FULFILLMENT_GROUP
.
.
.
.
.
.
I suspect that "your 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" line (bold above) cause the issue.
Have anyone encountered and fixed this..??
Thanks,
Saman