Broadleaf Commerce Discussion Forums

Try to set up a base site based on DemoSite that works with latest broadleafcommerce-3.1. However, the current DemoSite works with 3.0.8. There are two approaches:

1) Run Demo broadleafcommerce-3.0.8 to create the 3.0.8 schema and populate data by 3.0.8 scripts, then convert 3.0.8 schema to 3.1 schema.
2) Run Demo with broadleafcommerce-3.1 to create 3.1 schema, then modify load_data scripts to populate data into 3.1 schema.

Neither approach is easy. Any advice?

Thanks.

-Charlie

Download ... DemoSite-3.1.0-GA-eclipse-workspace.zip

Thank you for pull this new demo site together. Just found a few syntax errors in the data loading files:

load_catalog_data.sql:
following line is missing semi colon:
INSERT INTO BLC_CATEGORY_XREF (SUB_CATEGORY_ID, CATEGORY_ID, DISPLAY_ORDER) VALUES (2,1,1);

Can't find load_catalog_pricesplit_data.sql

comment line must be leading with two dashes -- only. Cannot have many unbroken dashes like
----------------------------------------------------------------------

The workaround is two dashes followed by a space then many dashes
-- --------------------------------------------------------------------

After fixed these problems (except for the missing file), it loads.

Thanks.

-Charlie

This is from the workspace download? What is the load_catalog_pricesplit_data.sql file?

Yes, it's present in core runtime configuration development-shared.properties:
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,\
/sql/load_sitemap_data.sql

It's in 3.0.8 as well, but this sql file doesn't exist. Also the other issues in these sql files exist in 3.0.8, too.

Thanks.

-Charlie