Issue with "New Catalog Load in DB" using hibernate
Posted: Sun May 17, 2015 6:48 pm
Hi,
I am running Broadleaf with the default catalog for sometime. But, now I have created a complete new catalog of my own.
I am now trying to load it thorough hibernate during the start time, But the problem is :-
- Only tables are generating, but NO data is inserted into it. Means, only the table structure is getting created without any data.
Whereas, I have all the queries in my .sql files.
These are the changes I have made :-
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_content_data.sql,\
/sql/load_content_structure_i18n.sql,\
/sql/load_content_data_i18n.sql,\
/sql/load_categories.sql,\
/sql/load_categoryXref.sql,\
/sql/load_products.sql,\
/sql/load_productUpdate.sql,\
/sql/load_ProductAttr.sql,\
/sql/load_images_BLC_MEDIA.sql,\
/sql/load_images_BLC_SKU_MEDIA_MAP.sql,\
/sql/load_images_BLC_STATIC_ASSET.sql,\
/sql/Product_Offers_table.sql,\
/sql/load_sitemap_data.sql
blPU.hibernate.hbm2ddl.auto=create-drop
blCMSStorage.hibernate.hbm2ddl.auto=create-drop
blSecurePU.hibernate.hbm2ddl.auto=create-drop
All the sql files are there in my "sql" folder, with all the Database queries and properly structured. So there is not issue with the sql files or queries.
How can I get the data loaded at the start itself. Am I missing something ?
Thanks in advance.
- Sumit
I am running Broadleaf with the default catalog for sometime. But, now I have created a complete new catalog of my own.
I am now trying to load it thorough hibernate during the start time, But the problem is :-
- Only tables are generating, but NO data is inserted into it. Means, only the table structure is getting created without any data.
Whereas, I have all the queries in my .sql files.
These are the changes I have made :-
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_content_data.sql,\
/sql/load_content_structure_i18n.sql,\
/sql/load_content_data_i18n.sql,\
/sql/load_categories.sql,\
/sql/load_categoryXref.sql,\
/sql/load_products.sql,\
/sql/load_productUpdate.sql,\
/sql/load_ProductAttr.sql,\
/sql/load_images_BLC_MEDIA.sql,\
/sql/load_images_BLC_SKU_MEDIA_MAP.sql,\
/sql/load_images_BLC_STATIC_ASSET.sql,\
/sql/Product_Offers_table.sql,\
/sql/load_sitemap_data.sql
blPU.hibernate.hbm2ddl.auto=create-drop
blCMSStorage.hibernate.hbm2ddl.auto=create-drop
blSecurePU.hibernate.hbm2ddl.auto=create-drop
All the sql files are there in my "sql" folder, with all the Database queries and properly structured. So there is not issue with the sql files or queries.
How can I get the data loaded at the start itself. Am I missing something ?
Thanks in advance.
- Sumit