MySQL Tables Only Partially Created
Posted: Tue Jul 16, 2013 1:03 pm
by tperez
I have followed the official documentation on how to switch to MySQL and it seems to almost work. In fact, I see several tables created and populated. However, there seems to be tables and data missing. The first true exception I encounter while running "jetty-demo" is the following:
[ERROR] 11:49:04 SchemaExport - HHH000231: Schema export unsuccessful
[artifact:mvn] org.hibernate.tool.hbm2ddl.ImportScriptException: Error during statement execution (file: '/sql/load_catalog_data.sql'): INSERT INTO BLC_CATEGORY (CATEGORY_ID,DESCRIPTION,NAME,URL,DEFAULT_PARENT_CATEGORY_ID,ACTIVE_START_DATE) VALUES (1,'Root','Root',NULL,NULL,CURRENT_TIMESTAMP)
From what I can see, the "BLC_CATEGORY" table is missing entirely, hence the error.
Re: MySQL Tables Only Partially Created
Posted: Thu Feb 06, 2014 9:11 pm
by rcampion
I am having this same problem switching to MySQL. Some tables do get created.
mysql> show tables;
+--------------------------------+
| Tables_in_shop |
+--------------------------------+
| BLC_ADDITIONAL_OFFER_INFO |
| BLC_ADDRESS |
| BLC_ADMIN_MODULE |
| BLC_ADMIN_PASSWORD_TOKEN |
| BLC_ADMIN_PERMISSION |
| BLC_ADMIN_PERMISSION_ENTITY |
| BLC_ADMIN_ROLE |
| BLC_ADMIN_ROLE_PERMISSION_XREF |
| BLC_ADMIN_SECTION |
| BLC_ADMIN_SEC_PERM_XREF |
| BLC_ADMIN_USER |
| BLC_ADMIN_USER_PERMISSION_XREF |
| BLC_ADMIN_USER_ROLE_XREF |
| BLC_ADMIN_USER_SANDBOX |
| BLC_AMOUNT_ITEM |
| BLC_ASSET_DESC_MAP |
| BLC_BUNDLE_ORDER_ITEM |
| BLC_BUND_ITEM_FEE_PRICE |
| BLC_CANDIDATE_FG_OFFER |
| BLC_CANDIDATE_ITEM_OFFER |
| BLC_CANDIDATE_ORDER_OFFER |
| BLC_CATALOG |
| BLC_CATEGORY_ATTRIBUTE |
| BLC_CATEGORY_IMAGE |
| BLC_CATEGORY_MEDIA_MAP |
| BLC_CATEGORY_PRODUCT_XREF |
| BLC_CATEGORY_XREF |
| BLC_CAT_SEARCH_FACET_EXCL_XREF |
| BLC_CAT_SEARCH_FACET_XREF |
| BLC_CHALLENGE_QUESTION |
| BLC_CODE_TYPES |
| BLC_COUNTRY |
| BLC_CURRENCY |
| BLC_CUSTOMER |
| BLC_CUSTOMER_ADDRESS |
| BLC_CUSTOMER_ATTRIBUTE |
| BLC_CUSTOMER_OFFER_XREF |
| BLC_CUSTOMER_PASSWORD_TOKEN |
| BLC_CUSTOMER_PAYMENT |
| BLC_CUSTOMER_PAYMENT_FIELDS |
| BLC_CUSTOMER_PHONE |
| BLC_CUSTOMER_ROLE |
| BLC_DATA_DRVN_ENUM |
| BLC_DATA_DRVN_ENUM_VAL |
| BLC_DISCRETE_ORDER_ITEM |
| BLC_DISC_ITEM_FEE_PRICE |
| BLC_DYN_DISCRETE_ORDER_ITEM |
| BLC_EMAIL_TRACKING |
| BLC_EMAIL_TRACKING_CLICKS |
| BLC_EMAIL_TRACKING_OPENS |
| BLC_FG_ADJUSTMENT |
| BLC_FG_FEE_TAX_XREF |
| BLC_FG_FG_TAX_XREF |
| BLC_FG_ITEM_TAX_XREF |
| BLC_FIELD |
| BLC_FIELD_SEARCH_TYPES |
| BLC_FLD_DEF |
| BLC_FLD_ENUM |
| BLC_FLD_ENUM_ITEM |
| BLC_FLD_GROUP |
| BLC_FULFILLMENT_GROUP |
| BLC_FULFILLMENT_GROUP_FEE |
| BLC_FULFILLMENT_GROUP_ITEM |
| BLC_FULFILLMENT_OPTION_FIXED |
| BLC_FULFILLMENT_OPT_BANDED_PRC |
| BLC_FULFILLMENT_OPT_BANDED_WGT |
| BLC_FULFILLMENT_PRICE_BAND |
| BLC_FULFILLMENT_WEIGHT_BAND |
| BLC_GIFTWRAP_ORDER_ITEM |
| BLC_ID_GENERATION |
| BLC_IMG_STATIC_ASSET |
| BLC_ITEM_OFFER_QUALIFIER |
| BLC_LOCALE |
| BLC_MEDIA |
| BLC_MODULE_CONFIGURATION |
| BLC_OFFER_AUDIT |
| BLC_OFFER_CODE |
| BLC_OFFER_INFO |
| BLC_OFFER_INFO_FIELDS |
| BLC_OFFER_RULE_MAP |
| BLC_ORDER |
| BLC_ORDER_ADJUSTMENT |
| BLC_ORDER_ATTRIBUTE |
| BLC_ORDER_ITEM |
| BLC_ORDER_ITEM_ADD_ATTR |
| BLC_ORDER_ITEM_ADJUSTMENT |
| BLC_ORDER_ITEM_ATTRIBUTE |
| BLC_ORDER_ITEM_DTL_ADJ |
| BLC_ORDER_ITEM_PRICE_DTL |
| BLC_ORDER_MULTISHIP_OPTION |
| BLC_ORDER_OFFER_CODE_XREF |
| BLC_ORDER_PAYMENT |
| BLC_ORDER_PAYMENT_DETAILS |
| BLC_PAGE |
| BLC_PAGE_FLD_MAP |
| BLC_PAGE_RULE_MAP |
| BLC_PAGE_TMPLT |
| BLC_PAYINFO_ADDITIONAL_FIELDS |
| BLC_PAYMENT_ADDITIONAL_FIELDS |
| BLC_PAYMENT_LOG |
| BLC_PAYMENT_RESPONSE_ITEM |
| BLC_PERSONAL_MESSAGE |
| BLC_PGTMPLT_FLDGRP_XREF |
| BLC_PHONE |
| BLC_PRODUCT |
| BLC_PRODUCT_ATTRIBUTE |
| BLC_PRODUCT_BUNDLE |
| BLC_PRODUCT_CROSS_SALE |
| BLC_PRODUCT_FEATURED |
| BLC_PRODUCT_OPTION |
| BLC_PRODUCT_OPTION_VALUE |
| BLC_PRODUCT_OPTION_XREF |
| BLC_PRODUCT_SKU_XREF |
| BLC_PRODUCT_UP_SALE |
| BLC_QUAL_CRIT_OFFER_XREF |
| BLC_QUAL_CRIT_PAGE_XREF |
| BLC_QUAL_CRIT_SC_XREF |
| BLC_RATING_DETAIL |
| BLC_RATING_SUMMARY |
| BLC_REVIEW_DETAIL |
| BLC_REVIEW_FEEDBACK |
| BLC_ROLE |
| BLC_SANDBOX |
| BLC_SANDBOX_ACTION |
| BLC_SANDBOX_ITEM |
| BLC_SC |
| BLC_SC_FLDGRP_XREF |
| BLC_SC_FLD_MAP |
| BLC_SC_FLD_TMPLT |
| BLC_SC_RULE_MAP |
| BLC_SC_TYPE |
| BLC_SEARCH_FACET |
| BLC_SEARCH_FACET_RANGE |
| BLC_SEARCH_FACET_XREF |
| BLC_SEARCH_INTERCEPT |
| BLC_SEARCH_SYNONYM |
| BLC_SHIPPING_RATE |
| BLC_SITE |
| BLC_SITE_CATALOG |
| BLC_SITE_SANDBOX |
| BLC_SKU_ATTRIBUTE |
| BLC_SKU_AVAILABILITY |
| BLC_SKU_BUNDLE_ITEM |
| BLC_SKU_FEE_XREF |
| BLC_SKU_FULFILLMENT_EXCLUDED |
| BLC_SKU_FULFILLMENT_FLAT_RATES |
| BLC_SKU_MEDIA_MAP |
| BLC_SKU_OPTION_VALUE_XREF |
| BLC_STATE |
| BLC_STATIC_ASSET |
| BLC_STATIC_ASSET_DESC |
| BLC_STORE |
| BLC_SYSTEM_PROPERTY |
| BLC_TAR_CRIT_OFFER_XREF |
| BLC_TAX_DETAIL |
| BLC_URL_HANDLER |
| BLC_UserConnection |
| BLC_ZIP_CODE |
| SANDBOX_ITEM_ACTION |
| SEQUENCE_GENERATOR |
+--------------------------------+
160 rows in set (0.00 sec)
Any ideas?
Q
Posted: Fri Feb 07, 2014 4:36 pm
by rcampion
Thanks for your quick reply.
I did a dump of the HSQLDB tables and compared it to the MySQL tables at the sate of failure during / upon conversion from HSQLDB to MySQL following the tutorial instructions.
Here's what I was to deduce (visually). See missing table list at the end this comparison.
mysql> show tables;
+--------------------------------+
| Tables_in_shop |
+--------------------------------+
| BLC_ADDITIONAL_OFFER_INFO |
| BLC_ADDRESS |
| BLC_ADMIN_MODULE |
| BLC_ADMIN_PASSWORD_TOKEN |
| BLC_ADMIN_PERMISSION |
| BLC_ADMIN_PERMISSION_ENTITY |
| BLC_ADMIN_ROLE |
| BLC_ADMIN_ROLE_PERMISSION_XREF |
| BLC_ADMIN_SECTION |
| BLC_ADMIN_SEC_PERM_XREF |
| BLC_ADMIN_USER |
| BLC_ADMIN_USER_PERMISSION_XREF |
| BLC_ADMIN_USER_ROLE_XREF |
| BLC_ADMIN_USER_SANDBOX |
| BLC_AMOUNT_ITEM |
| BLC_ASSET_DESC_MAP |
| BLC_BUNDLE_ORDER_ITEM |
| BLC_BUND_ITEM_FEE_PRICE |
| BLC_CANDIDATE_FG_OFFER |
| BLC_CANDIDATE_ITEM_OFFER |
| BLC_CANDIDATE_ORDER_OFFER |
| BLC_CATALOG |
| BLC_CATEGORY_ATTRIBUTE |
| BLC_CATEGORY_IMAGE |
| BLC_CATEGORY_MEDIA_MAP |
| BLC_CATEGORY_PRODUCT_XREF |
| BLC_CATEGORY_XREF |
| BLC_CAT_SEARCH_FACET_EXCL_XREF |
| BLC_CAT_SEARCH_FACET_XREF |
| BLC_CHALLENGE_QUESTION |
| BLC_CODE_TYPES |
| BLC_COUNTRY |
| BLC_CURRENCY |
| BLC_CUSTOMER |
| BLC_CUSTOMER_ADDRESS |
| BLC_CUSTOMER_ATTRIBUTE |
| BLC_CUSTOMER_OFFER_XREF |
| BLC_CUSTOMER_PASSWORD_TOKEN |
| BLC_CUSTOMER_PAYMENT |
| BLC_CUSTOMER_PAYMENT_FIELDS |
| BLC_CUSTOMER_PHONE |
| BLC_CUSTOMER_ROLE |
| BLC_DATA_DRVN_ENUM |
| BLC_DATA_DRVN_ENUM_VAL |
| BLC_DISCRETE_ORDER_ITEM |
| BLC_DISC_ITEM_FEE_PRICE |
| BLC_DYN_DISCRETE_ORDER_ITEM |
| BLC_EMAIL_TRACKING |
| BLC_EMAIL_TRACKING_CLICKS |
| BLC_EMAIL_TRACKING_OPENS |
| BLC_FG_ADJUSTMENT |
| BLC_FG_FEE_TAX_XREF |
| BLC_FG_FG_TAX_XREF |
| BLC_FG_ITEM_TAX_XREF |
| BLC_FIELD |
| BLC_FIELD_SEARCH_TYPES |
| BLC_FLD_DEF |
| BLC_FLD_ENUM |
| BLC_FLD_ENUM_ITEM |
| BLC_FLD_GROUP |
| BLC_FULFILLMENT_GROUP |
| BLC_FULFILLMENT_GROUP_FEE |
| BLC_FULFILLMENT_GROUP_ITEM |
| BLC_FULFILLMENT_OPTION_FIXED |
| BLC_FULFILLMENT_OPT_BANDED_PRC |
| BLC_FULFILLMENT_OPT_BANDED_WGT |
| BLC_FULFILLMENT_PRICE_BAND |
| BLC_FULFILLMENT_WEIGHT_BAND |
| BLC_GIFTWRAP_ORDER_ITEM |
| BLC_ID_GENERATION |
| BLC_IMG_STATIC_ASSET |
| BLC_ITEM_OFFER_QUALIFIER |
| BLC_LOCALE |
| BLC_MEDIA |
| BLC_MODULE_CONFIGURATION |
| BLC_OFFER_AUDIT |
| BLC_OFFER_CODE |
| BLC_OFFER_INFO |
| BLC_OFFER_INFO_FIELDS |
| BLC_OFFER_RULE_MAP |
| BLC_ORDER |
| BLC_ORDER_ADJUSTMENT |
| BLC_ORDER_ATTRIBUTE |
| BLC_ORDER_ITEM |
| BLC_ORDER_ITEM_ADD_ATTR |
| BLC_ORDER_ITEM_ADJUSTMENT |
| BLC_ORDER_ITEM_ATTRIBUTE |
| BLC_ORDER_ITEM_DTL_ADJ |
| BLC_ORDER_ITEM_PRICE_DTL |
| BLC_ORDER_MULTISHIP_OPTION |
| BLC_ORDER_OFFER_CODE_XREF |
| BLC_ORDER_PAYMENT |
| BLC_ORDER_PAYMENT_DETAILS |
| BLC_PAGE |
| BLC_PAGE_FLD_MAP |
| BLC_PAGE_RULE_MAP |
| BLC_PAGE_TMPLT |
| BLC_PAYINFO_ADDITIONAL_FIELDS |
| BLC_PAYMENT_ADDITIONAL_FIELDS |
| BLC_PAYMENT_LOG |
| BLC_PAYMENT_RESPONSE_ITEM |
| BLC_PERSONAL_MESSAGE |
| BLC_PGTMPLT_FLDGRP_XREF |
| BLC_PHONE |
| BLC_PRODUCT |
| BLC_PRODUCT_ATTRIBUTE |
| BLC_PRODUCT_BUNDLE |
| BLC_PRODUCT_CROSS_SALE |
| BLC_PRODUCT_FEATURED |
| BLC_PRODUCT_OPTION |
| BLC_PRODUCT_OPTION_VALUE |
| BLC_PRODUCT_OPTION_XREF |
| BLC_PRODUCT_SKU_XREF |
| BLC_PRODUCT_UP_SALE |
| BLC_QUAL_CRIT_OFFER_XREF |
| BLC_QUAL_CRIT_PAGE_XREF |
| BLC_QUAL_CRIT_SC_XREF |
| BLC_RATING_DETAIL |
| BLC_RATING_SUMMARY |
| BLC_REVIEW_DETAIL |
| BLC_REVIEW_FEEDBACK |
| BLC_ROLE |
| BLC_SANDBOX |
| BLC_SANDBOX_ACTION |
| BLC_SANDBOX_ITEM |
| BLC_SC |
| BLC_SC_FLDGRP_XREF |
| BLC_SC_FLD_MAP |
| BLC_SC_FLD_TMPLT |
| BLC_SC_RULE_MAP |
| BLC_SC_TYPE |
| BLC_SEARCH_FACET |
| BLC_SEARCH_FACET_RANGE |
| BLC_SEARCH_FACET_XREF |
| BLC_SEARCH_INTERCEPT |
| BLC_SEARCH_SYNONYM |
| BLC_SHIPPING_RATE |
| BLC_SITE |
| BLC_SITE_CATALOG |
| BLC_SITE_SANDBOX |
| BLC_SKU_ATTRIBUTE |
| BLC_SKU_AVAILABILITY |
| BLC_SKU_BUNDLE_ITEM |
| BLC_SKU_FEE_XREF |
| BLC_SKU_FULFILLMENT_EXCLUDED |
| BLC_SKU_FULFILLMENT_FLAT_RATES |
| BLC_SKU_MEDIA_MAP |
| BLC_SKU_OPTION_VALUE_XREF |
| BLC_STATE |
| BLC_STATIC_ASSET |
| BLC_STATIC_ASSET_DESC |
| BLC_STORE |
| BLC_SYSTEM_PROPERTY |
| BLC_TAR_CRIT_OFFER_XREF |
| BLC_TAX_DETAIL |
| BLC_URL_HANDLER |
| BLC_UserConnection |
| BLC_ZIP_CODE |
| SANDBOX_ITEM_ACTION |
| SEQUENCE_GENERATOR |
+--------------------------------+
//-------------------------
// HSQL BLC_ ... tables
//-------------------------
BLC_ADDITIONAL_OFFER_INFO
BLC_ADDRESS
BLC_ADMIN_MODULE
BLC_ADMIN_PASSWORD_TOKEN
BLC_ADMIN_PERMISSION
BLC_ADMIN_PERMISSION_ENTITY
BLC_ADMIN_ROLE
BLC_ADMIN_ROLE_PERMISSION_XREF
BLC_ADMIN_SEC_PERM_XREF
BLC_ADMIN_SECTION
BLC_ADMIN_USER
BLC_ADMIN_USER_PERMISSION_XREF
BLC_ADMIN_USER_ROLE_XREF
BLC_ADMIN_USER_SANDBOX
BLC_AMOUNT_ITEM
BLC_ASSET_DESC_MAP
BLC_BANK_ACCOUNT_PAYMENT
BLC_BUND_ITEM_FEE_PRICE
BLC_BUNDLE_ORDER_ITEM
BLC_CANDIDATE_FG_OFFER
BLC_CANDIDATE_ITEM_OFFER
BLC_CANDIDATE_ORDER_OFFER
BLC_CAT_SEARCH_FACET_EXCL_XREF
BLC_CAT_SEARCH_FACET_XREF
BLC_CATALOG
BLC_CATEGORY
BLC_CATEGORY_ATTRIBUTE
BLC_CATEGORY_IMAGE
BLC_CATEGORY_MEDIA_MAP
BLC_CATEGORY_PRODUCT_XREF
BLC_CATEGORY_XREF
BLC_CHALLENGE_QUESTION
BLC_CODE_TYPES
BLC_COUNTRY
BLC_CREDIT_CARD_PAYMENT
BLC_CURRENCY
BLC_CUSTOMER
BLC_CUSTOMER_ADDRESS
BLC_CUSTOMER_ATTRIBUTE
BLC_CUSTOMER_OFFER_XREF
BLC_CUSTOMER_PASSWORD_TOKEN
BLC_CUSTOMER_PAYMENT
BLC_CUSTOMER_PAYMENT_FIELDS
BLC_CUSTOMER_PHONE
BLC_CUSTOMER_ROLE
BLC_DATA_DRVN_ENUM
BLC_DATA_DRVN_ENUM_VAL
BLC_DISC_ITEM_FEE_PRICE
BLC_DISCRETE_ORDER_ITEM
BLC_DYN_DISCRETE_ORDER_ITEM
BLC_EMAIL_TRACKING
BLC_EMAIL_TRACKING_CLICKS
BLC_EMAIL_TRACKING_OPENS
BLC_FG_ADJUSTMENT
BLC_FG_FEE_TAX_XREF
BLC_FG_FG_TAX_XREF
BLC_FG_ITEM_TAX_XREF
BLC_FIELD
BLC_FIELD_SEARCH_TYPES
BLC_FLD_DEF
BLC_FLD_ENUM
BLC_FLD_ENUM_ITEM
BLC_FLD_GROUP
BLC_FULFILLMENT_GROUP
BLC_FULFILLMENT_GROUP_FEE
BLC_FULFILLMENT_GROUP_ITEM
BLC_FULFILLMENT_OPT_BANDED_PRC
BLC_FULFILLMENT_OPT_BANDED_WGT
BLC_FULFILLMENT_OPTION
BLC_FULFILLMENT_OPTION_FIXED
BLC_FULFILLMENT_PRICE_BAND
BLC_FULFILLMENT_WEIGHT_BAND
BLC_GIFT_CARD_PAYMENT
BLC_GIFTWRAP_ORDER_ITEM
BLC_ID_GENERATION
BLC_IMG_STATIC_ASSET
BLC_ITEM_OFFER_QUALIFIER
BLC_LOCALE
BLC_MEDIA
BLC_MODULE_CONFIGURATION
BLC_OFFER
BLC_OFFER_AUDIT
BLC_OFFER_CODE
BLC_OFFER_INFO
BLC_OFFER_INFO_FIELDS
BLC_OFFER_ITEM_CRITERIA
BLC_OFFER_RULE
BLC_OFFER_RULE_MAP
BLC_ORDER
BLC_ORDER_ADJUSTMENT
BLC_ORDER_ATTRIBUTE
BLC_ORDER_ITEM
BLC_ORDER_ITEM_ADD_ATTR
BLC_ORDER_ITEM_ADJUSTMENT
BLC_ORDER_ITEM_ATTRIBUTE
BLC_ORDER_ITEM_DTL_ADJ
BLC_ORDER_ITEM_PRICE_DTL
BLC_ORDER_MULTISHIP_OPTION
BLC_ORDER_OFFER_CODE_XREF
BLC_ORDER_PAYMENT
BLC_ORDER_PAYMENT_DETAILS
BLC_PAGE
BLC_PAGE_FLD
BLC_PAGE_FLD_MAP
BLC_PAGE_ITEM_CRITERIA
BLC_PAGE_RULE
BLC_PAGE_RULE_MAP
BLC_PAGE_TMPLT
BLC_PAYINFO_ADDITIONAL_FIELDS
BLC_PAYMENT_ADDITIONAL_FIELDS
BLC_PAYMENT_LOG
BLC_PAYMENT_RESPONSE_ITEM
BLC_PERSONAL_MESSAGE
BLC_PGTMPLT_FLDGRP_XREF
BLC_PHONE
BLC_PRODUCT
BLC_PRODUCT_ATTRIBUTE
BLC_PRODUCT_BUNDLE
BLC_PRODUCT_CROSS_SALE
BLC_PRODUCT_FEATURED
BLC_PRODUCT_OPTION
BLC_PRODUCT_OPTION_VALUE
BLC_PRODUCT_OPTION_XREF
BLC_PRODUCT_SKU_XREF
BLC_PRODUCT_UP_SALE
BLC_QUAL_CRIT_OFFER_XREF
BLC_QUAL_CRIT_PAGE_XREF
BLC_QUAL_CRIT_SC_XREF
BLC_RATING_DETAIL
BLC_RATING_SUMMARY
BLC_REVIEW_DETAIL
BLC_REVIEW_FEEDBACK
BLC_ROLE
BLC_SANDBOX
BLC_SANDBOX_ACTION
BLC_SANDBOX_ITEM
BLC_SC
BLC_SC_FLD
BLC_SC_FLD_MAP
BLC_SC_FLD_TMPLT
BLC_SC_FLDGRP_XREF
BLC_SC_ITEM_CRITERIA
BLC_SC_RULE
BLC_SC_RULE_MAP
BLC_SC_TYPE
BLC_SEARCH_FACET
BLC_SEARCH_FACET_RANGE
BLC_SEARCH_FACET_XREF
BLC_SEARCH_INTERCEPT
BLC_SEARCH_SYNONYM
BLC_SHIPPING_RATE
BLC_SITE
BLC_SITE_CATALOG
BLC_SITE_SANDBOX
BLC_SKU
BLC_SKU_ATTRIBUTE
BLC_SKU_AVAILABILITY
BLC_SKU_BUNDLE_ITEM
BLC_SKU_FEE
BLC_SKU_FEE_XREF
BLC_SKU_FULFILLMENT_EXCLUDED
BLC_SKU_FULFILLMENT_FLAT_RATES
BLC_SKU_MEDIA_MAP
BLC_SKU_OPTION_VALUE_XREF
BLC_STATE
BLC_STATIC_ASSET
BLC_STATIC_ASSET_DESC
BLC_STATIC_ASSET_STRG
BLC_STORE
BLC_SYSTEM_PROPERTY
BLC_TAR_CRIT_OFFER_XREF
BLC_TAX_DETAIL
BLC_TRANSLATION
BLC_URL_HANDLER
BLC_USERCONNECTION
BLC_ZIP_CODE
----------------------------------------
//-------------------------
// Missing HSQLDB tables from MySQL
//-------------------------
BLC_BANK_ACCOUNT_PAYMENT
BLC_CATEGORY
BLC_CREDIT_CARD_PAYMENT
BLC_FULFILLMENT_OPTION
BLC_GIFT_CARD_PAYMENT
BLC_SC_FLD
BLC_SC_ITEM_CRITERIA
BLC_SC_RULE
BLC_SKU
BLC_SKU_FEE
BLC_STATIC_ASSET_STRG
BLC_TRANSLATION
//-------------------------
I could attempt to create these tables in MySQL and recreate / populated the demo data, but that begs the following question(s).
Would you know of any documentation on how one would prepare Broadleaf for a production installation using MySQL as the backend?
Thanks,
Richard
Re: MySQL Tables Only Partially Created
Posted: Thu Feb 13, 2014 11:39 pm
by rcampion
Yes, "create-drop" is still set as I was simply attempting to follow the directions that are posted on your website as to how you can run the demo using a MySQL database.
I was not able to capture any error prior to the error that has already been posted / documented..
I suspect that the error is a Hibernate problem attempting and failing to create all tables referenced within the import scripts.
As an alternative to letting hibernate "create-drop" each time that I run the demo, I would prefer to use a MySQL database and attempt to prepare for a more "production like" scenario.
As such, Here are the steps I have taken.
Run the demo using the HSQLDB database.
With the demo running ...
Create a database connection to the the HSQL database.
Export the DDL of the HSQL database tables to a CREATE_DATABASE.sql file.
Create a connection to MySQL.
Run the saved CREATE_DATABASE.sql script against the MySQL database.
All tables, including the previously missing tables, have now been created in MySQL.
As for database population ... I see these scripts referenced in the development-shared.properties file.
blPU.hibernate.hbm2ddl.import_files=/config/bc/sql/load_admin_permissions.sql,\
/config/bc/sql/load_admin_roles.sql,\
/config/bc/sql/load_admin_menu.sql,\
/sql/load_admin_users.sql,\
/sql/load_code_tables.sql,\
/sql/load_table_sequences.sql,\
/sql/load_content_structure.sql,\
/sql/load_catalog_data.sql,\
/sql/load_catalog_pricesplit_data.sql,\
/sql/load_content_data.sql,\
/sql/load_content_structure_i18n.sql,\
/sql/load_content_data_i18n.sql,\
/sql/load_catalog_i18n_data_FR.sql,\
/sql/load_catalog_i18n_data_ES.sql
blPU.hibernate.hbm2ddl.auto=create-drop
Are these the import scripts that you are refering to?
-Richard
Re: MySQL Tables Only Partially Created
Posted: Fri Feb 14, 2014 1:44 am
by rcampion
Ooops, spoke too soon .... BLC_CATEGORY did not get created.
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),
FULFILLMENT_TYPE VARCHAR(255),
INVENTORY_TYPE VARCHAR(255),
LONG_DESCRIPTION null,
NAME VARCHAR(255) NOT NULL,
TAX_CODE VARCHAR(255),
URL VARCHAR(255),
URL_KEY VARCHAR(255),
DEFAULT_PARENT_CATEGORY_ID BIGINT
);
LONG_DESCRIPTION does not look right to me, no datatype.
-hmmm
Re: MySQL Tables Only Partially Created
Posted: Fri Feb 14, 2014 2:00 am
by rcampion
CategoryImpl
.
.
.
@Lob
@Type(type = "org.hibernate.type.StringClobType")
@Column(name = "LONG_DESCRIPTION", length = Integer.MAX_VALUE - 1)
@AdminPresentation(friendlyName = "CategoryImpl_Category_Long_Description", order = 3000,
group = Presentation.Group.Name.General, groupOrder = Presentation.Group.Order.General,
largeEntry = true,
fieldType = SupportedFieldType.HTML_BASIC,
translatable = true)
protected String longDescription;
.
.
.
http://docs.jboss.org/hibernate/orm/3.5 ... mmary.htmlStringClobType Deprecated. replaced by Hibernate Core's MaterializedClobType
.
.
.
Not sure what MySQL datatype to use for this.
Any idea.
Re: MySQL Tables Only Partially Created
Posted: Fri Feb 14, 2014 9:20 am
by rcampion
Here are the tables that cannot be created in MySQL via the exported DDL of HSQL ...
//---------------------------
CREATE TABLE BLC_SC_FLD (
SC_FLD_ID BIGINT NOT NULL,
CREATED_BY BIGINT,
DATE_CREATED TIMESTAMP,
DATE_UPDATED TIMESTAMP,
UPDATED_BY BIGINT,
FLD_KEY VARCHAR(255),
LOB_VALUE null,
VALUE VARCHAR(255),
SC_ID BIGINT
)
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 'null,
VALUE VARCHAR(255),
SC_ID BIGINT
)' at line 8
Elapsed Time: 0 hr, 0 min, 0 sec, 0 ms.
//---------------------------
CREATE TABLE BLC_ORDER_PAYMENT (
PAYMENT_ID BIGINT NOT NULL,
AMOUNT NUMERIC(19 , 5),
CUSTOMER_IP_ADDRESS VARCHAR(255),
REFERENCE_NUMBER VARCHAR(255),
PAYMENT_TYPE VARCHAR(255) NOT NULL,
ADDRESS_ID BIGINT,
CUSTOMER_PAYMENT_ID BIGINT,
ORDER_ID BIGINT NOT NULL,
PHONE_ID BIGINT
)
Table 'BLC_ORDER_PAYMENT' already exists
Elapsed Time: 0 hr, 0 min, 0 sec, 0 ms.
//---------------------------
CREATE TABLE BLC_SKU_FEE (
SKU_FEE_ID BIGINT NOT NULL,
AMOUNT NUMERIC(19 , 5) NOT NULL,
DESCRIPTION VARCHAR(255),
EXPRESSION null,
FEE_TYPE VARCHAR(255),
NAME VARCHAR(255),
TAXABLE BOOLEAN,
CURRENCY_CODE VARCHAR(255)
)
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 'null,
FEE_TYPE VARCHAR(255),
NAME VARCHAR(255),
TAXABLE BOOLEAN,
CURRENC' at line 5
Elapsed Time: 0 hr, 0 min, 0 sec, 0 ms.
//---------------------------
CREATE TABLE BLC_PAGE_FLD (
PAGE_FLD_ID BIGINT NOT NULL,
CREATED_BY BIGINT,
DATE_CREATED TIMESTAMP,
DATE_UPDATED TIMESTAMP,
UPDATED_BY BIGINT,
FLD_KEY VARCHAR(255),
LOB_VALUE null,
VALUE VARCHAR(255),
PAGE_ID BIGINT
)
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 'null,
VALUE VARCHAR(255),
PAGE_ID BIGINT
)' at line 8
Elapsed Time: 0 hr, 0 min, 0 sec, 0 ms.
//---------------------------
CREATE TABLE BLC_TRANSLATION (
TRANSLATION_ID BIGINT NOT NULL,
ENTITY_ID VARCHAR(255),
ENTITY_TYPE VARCHAR(255),
FIELD_NAME VARCHAR(255),
LOCALE_CODE VARCHAR(255),
TRANSLATED_VALUE null
)
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 'null
)' at line 7
Elapsed Time: 0 hr, 0 min, 0 sec, 0 ms.
//---------------------------
CREATE TABLE BLC_SC_ITEM_CRITERIA (
SC_ITEM_CRITERIA_ID BIGINT NOT NULL,
ORDER_ITEM_MATCH_RULE null,
QUANTITY INTEGER NOT NULL
)
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 'null,
QUANTITY INTEGER NOT NULL
)' at line 3
Elapsed Time: 0 hr, 0 min, 0 sec, 0 ms.
//---------------------------
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),
FULFILLMENT_TYPE VARCHAR(255),
INVENTORY_TYPE VARCHAR(255),
LONG_DESCRIPTION null,
NAME VARCHAR(255) NOT NULL,
TAX_CODE VARCHAR(255),
URL VARCHAR(255),
URL_KEY VARCHAR(255),
DEFAULT_PARENT_CATEGORY_ID BIGINT
)
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 'null,
NAME VARCHAR(255) NOT NULL,
TAX_CODE VARCHAR(255),
URL VARCHAR(255),' at line 10
Elapsed Time: 0 hr, 0 min, 0 sec, 0 ms.
//---------------------------
CREATE TABLE BLC_PAGE_ITEM_CRITERIA (
PAGE_ITEM_CRITERIA_ID BIGINT NOT NULL,
ORDER_ITEM_MATCH_RULE null,
QUANTITY INTEGER NOT NULL
)
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 'null,
QUANTITY INTEGER NOT NULL
)' at line 3
Elapsed Time: 0 hr, 0 min, 0 sec, 0 ms.
//---------------------------
CREATE TABLE BLC_FULFILLMENT_OPTION (
FULFILLMENT_OPTION_ID BIGINT NOT NULL,
FULFILLMENT_TYPE VARCHAR(255) NOT NULL,
LONG_DESCRIPTION null,
NAME VARCHAR(255),
TAX_CODE VARCHAR(255),
TAXABLE BOOLEAN,
USE_FLAT_RATES BOOLEAN
)
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 'null,
NAME VARCHAR(255),
TAX_CODE VARCHAR(255),
TAXABLE BOOLEAN,
USE_FLA' at line 4
Elapsed Time: 0 hr, 0 min, 0 sec, 0 ms.
//---------------------------
CREATE TABLE BLC_OFFER (
OFFER_ID BIGINT NOT NULL,
APPLIES_WHEN_RULES null,
APPLIES_TO_RULES null,
APPLY_OFFER_TO_MARKED_ITEMS BOOLEAN,
APPLY_TO_SALE_PRICE BOOLEAN,
ARCHIVED CHAR(255),
AUTOMATICALLY_ADDED BOOLEAN,
COMBINABLE_WITH_OTHER_OFFERS BOOLEAN,
OFFER_DELIVERY_TYPE VARCHAR(255),
OFFER_DESCRIPTION VARCHAR(255),
OFFER_DISCOUNT_TYPE VARCHAR(255),
END_DATE TIMESTAMP,
MARKETING_MESSASGE VARCHAR(255),
MAX_USES_PER_CUSTOMER BIGINT,
MAX_USES INTEGER,
OFFER_NAME VARCHAR(255) NOT NULL,
OFFER_ITEM_QUALIFIER_RULE VARCHAR(255),
OFFER_ITEM_TARGET_RULE VARCHAR(255),
OFFER_PRIORITY INTEGER,
QUALIFYING_ITEM_MIN_TOTAL NUMERIC(19 , 5),
STACKABLE BOOLEAN,
START_DATE TIMESTAMP,
TARGET_SYSTEM VARCHAR(255),
TOTALITARIAN_OFFER BOOLEAN,
USE_NEW_FORMAT BOOLEAN,
OFFER_TYPE VARCHAR(255) NOT NULL,
USES INTEGER,
OFFER_VALUE NUMERIC(19 , 5) NOT NULL
)
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 'null,
APPLIES_TO_RULES null,
APPLY_OFFER_TO_MARKED_ITEMS BOOLEAN,
APPLY_TO' at line 3
Elapsed Time: 0 hr, 0 min, 0 sec, 0 ms.
//---------------------------
CREATE TABLE BLC_OFFER_RULE (
OFFER_RULE_ID BIGINT NOT NULL,
MATCH_RULE null
)
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 'null
)' at line 3
Elapsed Time: 0 hr, 0 min, 0 sec, 0 ms.
//---------------------------
CREATE TABLE BLC_SC_RULE (
SC_RULE_ID BIGINT NOT NULL,
MATCH_RULE null
)
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 'null
)' at line 3
Elapsed Time: 0 hr, 0 min, 0 sec, 0 ms.
//---------------------------
Todo: Inspect the corresponding domain entities ...