Broadleaf Commerce Discussion Forums


http://forum.broadleafcommerce.org/

Error in changing from Jetty to Tomcat

http://forum.broadleafcommerce.org/viewtopic.php?f=14&t=1520

Page 1 of 1

Error in changing from Jetty to Tomcat

Posted: Thu Dec 20, 2012 4:49 am
by 22dec1960
Hi,

I tried to change server from jetty to tomcat following the http://docs.broadleafcommerce.org/current/Tomcat.html tutorial. And then I started tomcat-demo ant task for website and get the following error:


[artifact:mvn] [ERROR] 15:51:58 SchemaExport - user lacks privilege or object not found: BLC_SANDBOX
[artifact:mvn] [ERROR] 15:51:58 SchemaExport - Unsuccessful: alter table BLC_SANDBOX_ACTION add index FK3657DE9424568C27 (CREATED_BY), add constraint FK3657DE9424568C27 foreign key (CREATED_BY) references BLC_ADMIN_USER (ADMIN_USER_ID)
[artifact:mvn] [ERROR] 15:51:58 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SANDBOX_ACTION
[artifact:mvn] [ERROR] 15:51:58 SchemaExport - Unsuccessful: alter table BLC_SANDBOX_ACTION add index FK3657DE94C1167574 (UPDATED_BY), add constraint FK3657DE94C1167574 foreign key (UPDATED_BY) references BLC_ADMIN_USER (ADMIN_USER_ID)
[artifact:mvn] [ERROR] 15:51:58 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SANDBOX_ACTION
[artifact:mvn] [ERROR] 15:51:58 SchemaExport - Unsuccessful: create index ARCHIVED_FLAG_INDEX on BLC_SANDBOX_ITEM (ARCHIVED_FLAG)
[artifact:mvn] [ERROR] 15:51:58 SchemaExport - user lacks privilege or object not found: BLC_SANDBOX_ITEM
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - Unsuccessful: create index SANDBOX_ITEM_TYPE_INDEX on BLC_SANDBOX_ITEM (SANDBOX_ITEM_TYPE)
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - user lacks privilege or object not found: BLC_SANDBOX_ITEM
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - Unsuccessful: create index SB_ORIG_ITEM_ID_INDEX on BLC_SANDBOX_ITEM (ORIGINAL_ITEM_ID)
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - user lacks privilege or object not found: BLC_SANDBOX_ITEM
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - Unsuccessful: create index TEMP_ITEM_INDEX on BLC_SANDBOX_ITEM (TEMPORARY_ITEM_ID)
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - user lacks privilege or object not found: BLC_SANDBOX_ITEM
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - Unsuccessful: create index SANDBOX_ID_INDEX on BLC_SANDBOX_ITEM (SANDBOX_ID)
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - user lacks privilege or object not found: BLC_SANDBOX_ITEM
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - Unsuccessful: create index ORIG_SANDBOX_ID_INDEX on BLC_SANDBOX_ITEM (ORIG_SANDBOX_ID)
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - user lacks privilege or object not found: BLC_SANDBOX_ITEM
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - Unsuccessful: alter table BLC_SANDBOX_ITEM add index FK48435EF124568C27 (CREATED_BY), add constraint FK48435EF124568C27 foreign key (CREATED_BY) references BLC_ADMIN_USER (ADMIN_USER_ID)
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SANDBOX_ITEM
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - Unsuccessful: alter table BLC_SANDBOX_ITEM add index FK48435EF1C1167574 (UPDATED_BY), add constraint FK48435EF1C1167574 foreign key (UPDATED_BY) references BLC_ADMIN_USER (ADMIN_USER_ID)
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SANDBOX_ITEM
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - Unsuccessful: create index SC_ORIG_ITEM_ID_INDEX on BLC_SC (ORIG_ITEM_ID)
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - user lacks privilege or object not found: BLC_SC
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - Unsuccessful: create index SC_LCKD_FLG_INDX on BLC_SC (LOCKED_FLAG)
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - user lacks privilege or object not found: BLC_SC
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - Unsuccessful: create index SC_DLTD_FLG_INDX on BLC_SC (DELETED_FLAG)
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - user lacks privilege or object not found: BLC_SC
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - Unsuccessful: create index CONTENT_NAME_INDEX on BLC_SC (CONTENT_NAME)
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - user lacks privilege or object not found: BLC_SC
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - Unsuccessful: create index SC_OFFLN_FLG_INDX on BLC_SC (OFFLINE_FLAG)
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - user lacks privilege or object not found: BLC_SC
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - Unsuccessful: create index SC_ARCHVD_FLG_INDX on BLC_SC (ARCHIVED_FLAG)
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - user lacks privilege or object not found: BLC_SC
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - Unsuccessful: alter table BLC_SC add index FK74EEB71624568C27 (CREATED_BY), add constraint FK74EEB71624568C27 foreign key (CREATED_BY) references BLC_ADMIN_USER (ADMIN_USER_ID)
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SC
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - Unsuccessful: alter table BLC_SC add index FK74EEB71671EBFA46 (SC_TYPE_ID), add constraint FK74EEB71671EBFA46 foreign key (SC_TYPE_ID) references BLC_SC_TYPE (SC_TYPE_ID)
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SC
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - Unsuccessful: alter table BLC_SC add index FK74EEB716A1E1C128 (LOCALE_CODE), add constraint FK74EEB716A1E1C128 foreign key (LOCALE_CODE) references BLC_LOCALE (LOCALE_CODE)
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SC
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - Unsuccessful: alter table BLC_SC add index FK74EEB716579FE59D (SANDBOX_ID), add constraint FK74EEB716579FE59D foreign key (SANDBOX_ID) references BLC_SANDBOX (SANDBOX_ID)
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SC
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - Unsuccessful: alter table BLC_SC add index FK74EEB716F9C4A5B (ORIG_SANDBOX_ID), add constraint FK74EEB716F9C4A5B foreign key (ORIG_SANDBOX_ID) references BLC_SANDBOX (SANDBOX_ID)
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SC
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - Unsuccessful: alter table BLC_SC add index FK74EEB716C1167574 (UPDATED_BY), add constraint FK74EEB716C1167574 foreign key (UPDATED_BY) references BLC_ADMIN_USER (ADMIN_USER_ID)
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SC
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - Unsuccessful: alter table BLC_SC_FLD add index FK621D7B9524568C27 (CREATED_BY), add constraint FK621D7B9524568C27 foreign key (CREATED_BY) references BLC_ADMIN_USER (ADMIN_USER_ID)
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SC_FLD
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - Unsuccessful: alter table BLC_SC_FLD add index FK621D7B95C1167574 (UPDATED_BY), add constraint FK621D7B95C1167574 foreign key (UPDATED_BY) references BLC_ADMIN_USER (ADMIN_USER_ID)
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SC_FLD
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - Unsuccessful: alter table BLC_SC_FLD add index FK621D7B9513D95585 (SC_ID), add constraint FK621D7B9513D95585 foreign key (SC_ID) references BLC_SC (SC_ID)
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SC_FLD
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - Unsuccessful: alter table BLC_SC_FLDGRP_XREF add index FK71612AEAF6B0BA84 (SC_FLD_TMPLT_ID), add constraint FK71612AEAF6B0BA84 foreign key (SC_FLD_TMPLT_ID) references BLC_SC_FLD_TMPLT (SC_FLD_TMPLT_ID)
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SC_FLDGRP_XREF
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - Unsuccessful: alter table BLC_SC_FLDGRP_XREF add index FK71612AEA6A79BDB5 (FLD_GROUP_ID), add constraint FK71612AEA6A79BDB5 foreign key (FLD_GROUP_ID) references BLC_FLD_GROUP (FLD_GROUP_ID)
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SC_FLDGRP_XREF
[artifact:mvn] [ERROR] 15:51:59 SchemaExport - Unsuccessful: alter table BLC_SC_FLD_MAP add index FKD9480192DD6FD28A (SC_FLD_ID), add constraint FKD9480192DD6FD28A foreign key (SC_FLD_ID) references BLC_SC_FLD (SC_FLD_ID)
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SC_FLD_MAP
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - Unsuccessful: alter table BLC_SC_FLD_MAP add index FKD948019213D95585 (SC_ID), add constraint FKD948019213D95585 foreign key (SC_ID) references BLC_SC (SC_ID)
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SC_FLD_MAP
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - Unsuccessful: alter table BLC_SC_RULE_MAP add index FK169F1C8256E51A06 (SC_RULE_ID), add constraint FK169F1C8256E51A06 foreign key (SC_RULE_ID) references BLC_SC_RULE (SC_RULE_ID)
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SC_RULE_MAP
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - Unsuccessful: alter table BLC_SC_RULE_MAP add index FK169F1C82156E72FC (BLC_SC_SC_ID), add constraint FK169F1C82156E72FC foreign key (BLC_SC_SC_ID) references BLC_SC (SC_ID)
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SC_RULE_MAP
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - Unsuccessful: alter table BLC_SC_TYPE add index FKE19886C3F6B0BA84 (SC_FLD_TMPLT_ID), add constraint FKE19886C3F6B0BA84 foreign key (SC_FLD_TMPLT_ID) references BLC_SC_FLD_TMPLT (SC_FLD_TMPLT_ID)
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SC_TYPE
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - Unsuccessful: alter table BLC_SEARCH_FACET add index FK4FFCC9863C3907C4 (FIELD_ID), add constraint FK4FFCC9863C3907C4 foreign key (FIELD_ID) references BLC_FIELD (FIELD_ID)
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SEARCH_FACET
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - Unsuccessful: create index SEARCH_FACET_INDEX on BLC_SEARCH_FACET_RANGE (SEARCH_FACET_ID)
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - user lacks privilege or object not found: BLC_SEARCH_FACET_RANGE
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - Unsuccessful: alter table BLC_SEARCH_FACET_RANGE add index FK7EC3B124B96B1C93 (SEARCH_FACET_ID), add constraint FK7EC3B124B96B1C93 foreign key (SEARCH_FACET_ID) references BLC_SEARCH_FACET (SEARCH_FACET_ID)
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SEARCH_FACET_RANGE
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - Unsuccessful: create index SEARCH_ACTIVE_INDEX on BLC_SEARCH_INTERCEPT (ACTIVE_END_DATE)
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - user lacks privilege or object not found: BLC_SEARCH_INTERCEPT
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - Unsuccessful: create index SEARCHSYNONYM_TERM_INDEX on BLC_SEARCH_SYNONYM (TERM)
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - user lacks privilege or object not found: BLC_SEARCH_SYNONYM
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - Unsuccessful: create index SHIPPINGRATE_FEE_INDEX on BLC_SHIPPING_RATE (FEE_TYPE)
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - user lacks privilege or object not found: BLC_SHIPPING_RATE
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - Unsuccessful: create index SHIPPINGRATE_FEESUB_INDEX on BLC_SHIPPING_RATE (FEE_SUB_TYPE)
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - user lacks privilege or object not found: BLC_SHIPPING_RATE
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - Unsuccessful: alter table BLC_SITE add index FKF41D6A8D64EBCCE3 (PRODUCTION_SANDBOX_ID), add constraint FKF41D6A8D64EBCCE3 foreign key (PRODUCTION_SANDBOX_ID) references BLC_SANDBOX (SANDBOX_ID)
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SITE
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - Unsuccessful: alter table BLC_SITE_SANDBOX add index FKAD4F7EF5579FE59D (SANDBOX_ID), add constraint FKAD4F7EF5579FE59D foreign key (SANDBOX_ID) references BLC_SANDBOX (SANDBOX_ID)
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SITE_SANDBOX
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - Unsuccessful: alter table BLC_SITE_SANDBOX add index FKAD4F7EF5843A8B63 (SITE_ID), add constraint FKAD4F7EF5843A8B63 foreign key (SITE_ID) references BLC_SITE (SITE_ID)
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SITE_SANDBOX
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - Unsuccessful: create index SKU_ACTIVE_INDEX on BLC_SKU (ACTIVE_END_DATE)
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - user lacks privilege or object not found: BLC_SKU
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - Unsuccessful: create index SKU_NAME_INDEX on BLC_SKU (NAME)
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - user lacks privilege or object not found: BLC_SKU
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - Unsuccessful: create index SKU_AVAILABLE_INDEX on BLC_SKU (AVAILABLE_FLAG)
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - user lacks privilege or object not found: BLC_SKU
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - Unsuccessful: create index SKU_TAXABLE_INDEX on BLC_SKU (TAXABLE_FLAG)
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - user lacks privilege or object not found: BLC_SKU
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - Unsuccessful: create index SKU_DISCOUNTABLE_INDEX on BLC_SKU (DISCOUNTABLE_FLAG)
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - user lacks privilege or object not found: BLC_SKU
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - Unsuccessful: alter table BLC_SKU add index FK28E82CF77E555D75 (DEFAULT_PRODUCT_ID), add constraint FK28E82CF77E555D75 foreign key (DEFAULT_PRODUCT_ID) references BLC_PRODUCT (PRODUCT_ID)
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SKU
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - Unsuccessful: create index SKUATTR_NAME_INDEX on BLC_SKU_ATTRIBUTE (NAME)
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - user lacks privilege or object not found: BLC_SKU_ATTRIBUTE
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - Unsuccessful: create index SKUATTR_SKU_INDEX on BLC_SKU_ATTRIBUTE (SKU_ID)
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - user lacks privilege or object not found: BLC_SKU_ATTRIBUTE
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - Unsuccessful: alter table BLC_SKU_ATTRIBUTE add index FK6C6A5934B78C9977 (SKU_ID), add constraint FK6C6A5934B78C9977 foreign key (SKU_ID) references BLC_SKU (SKU_ID)
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SKU_ATTRIBUTE
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - Unsuccessful: create index SKUAVAIL_STATUS_INDEX on BLC_SKU_AVAILABILITY (AVAILABILITY_STATUS)
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - user lacks privilege or object not found: BLC_SKU_AVAILABILITY
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - Unsuccessful: create index SKUAVAIL_LOCATION_INDEX on BLC_SKU_AVAILABILITY (LOCATION_ID)
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - user lacks privilege or object not found: BLC_SKU_AVAILABILITY
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - Unsuccessful: create index SKUAVAIL_SKU_INDEX on BLC_SKU_AVAILABILITY (SKU_ID)
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - user lacks privilege or object not found: BLC_SKU_AVAILABILITY
[artifact:mvn] [ERROR] 15:52:00 SchemaExport - Unsuccessful: alter table BLC_SKU_BUNDLE_ITEM add index FKD55968B78C9977 (SKU_ID), add constraint FKD55968B78C9977 foreign key (SKU_ID) references BLC_SKU (SKU_ID)
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SKU_BUNDLE_ITEM
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - Unsuccessful: alter table BLC_SKU_BUNDLE_ITEM add index FKD55968CCF29B96 (PRODUCT_BUNDLE_ID), add constraint FKD55968CCF29B96 foreign key (PRODUCT_BUNDLE_ID) references BLC_PRODUCT_BUNDLE (PRODUCT_ID)
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SKU_BUNDLE_ITEM
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - Unsuccessful: alter table BLC_SKU_FEE_XREF add index FKD88D409CB78C9977 (SKU_ID), add constraint FKD88D409CB78C9977 foreign key (SKU_ID) references BLC_SKU (SKU_ID)
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SKU_FEE_XREF
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - Unsuccessful: alter table BLC_SKU_FEE_XREF add index FKD88D409CCF4C9A82 (SKU_FEE_ID), add constraint FKD88D409CCF4C9A82 foreign key (SKU_FEE_ID) references BLC_SKU_FEE (SKU_FEE_ID)
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SKU_FEE_XREF
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - Unsuccessful: alter table BLC_SKU_FULFILLMENT_EXCLUDED add index FK84162D73B78C9977 (SKU_ID), add constraint FK84162D73B78C9977 foreign key (SKU_ID) references BLC_SKU (SKU_ID)
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SKU_FULFILLMENT_EXCLUDED
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - Unsuccessful: alter table BLC_SKU_FULFILLMENT_EXCLUDED add index FK84162D7381F34C7F (FULFILLMENT_OPTION_ID), add constraint FK84162D7381F34C7F foreign key (FULFILLMENT_OPTION_ID) references BLC_FULFILLMENT_OPTION (FULFILLMENT_OPTION_ID)
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SKU_FULFILLMENT_EXCLUDED
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - Unsuccessful: alter table BLC_SKU_FULFILLMENT_FLAT_RATES add index FKC1988C96B78C9977 (SKU_ID), add constraint FKC1988C96B78C9977 foreign key (SKU_ID) references BLC_SKU (SKU_ID)
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SKU_FULFILLMENT_FLAT_RATES
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - Unsuccessful: alter table BLC_SKU_FULFILLMENT_FLAT_RATES add index FKC1988C9681F34C7F (FULFILLMENT_OPTION_ID), add constraint FKC1988C9681F34C7F foreign key (FULFILLMENT_OPTION_ID) references BLC_FULFILLMENT_OPTION (FULFILLMENT_OPTION_ID)
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SKU_FULFILLMENT_FLAT_RATES
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - Unsuccessful: alter table BLC_SKU_MEDIA_MAP add index FKEB4AECF9D93D857F (BLC_SKU_SKU_ID), add constraint FKEB4AECF9D93D857F foreign key (BLC_SKU_SKU_ID) references BLC_SKU (SKU_ID)
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SKU_MEDIA_MAP
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - Unsuccessful: alter table BLC_SKU_MEDIA_MAP add index FKEB4AECF919D1156C (MEDIA_ID), add constraint FKEB4AECF919D1156C foreign key (MEDIA_ID) references BLC_MEDIA (MEDIA_ID)
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SKU_MEDIA_MAP
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - Unsuccessful: alter table BLC_SKU_OPTION_VALUE_XREF add index FK7B61DC0BB78C9977 (SKU_ID), add constraint FK7B61DC0BB78C9977 foreign key (SKU_ID) references BLC_SKU (SKU_ID)
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SKU_OPTION_VALUE_XREF
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - Unsuccessful: alter table BLC_SKU_OPTION_VALUE_XREF add index FK7B61DC0BB0C16A73 (PRODUCT_OPTION_VALUE_ID), add constraint FK7B61DC0BB0C16A73 foreign key (PRODUCT_OPTION_VALUE_ID) references BLC_PRODUCT_OPTION_VALUE (PRODUCT_OPTION_VALUE_ID)
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_SKU_OPTION_VALUE_XREF
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - Unsuccessful: create index STATE_NAME_INDEX on BLC_STATE (NAME)
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - user lacks privilege or object not found: BLC_STATE
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - Unsuccessful: alter table BLC_STATE add index FK8F94A1EBA46E16CF (COUNTRY), add constraint FK8F94A1EBA46E16CF foreign key (COUNTRY) references BLC_COUNTRY (ABBREVIATION)
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_STATE
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - Unsuccessful: create index ORIG_ASSET_ID_INDX on BLC_STATIC_ASSET (ORIG_ASSET_ID)
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - user lacks privilege or object not found: BLC_STATIC_ASSET
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - Unsuccessful: create index ASST_DLTD_FLG_INDX on BLC_STATIC_ASSET (DELETED_FLAG)
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - user lacks privilege or object not found: BLC_STATIC_ASSET
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - Unsuccessful: create index ASST_LCKD_FLG_INDX on BLC_STATIC_ASSET (LOCKED_FLAG)
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - user lacks privilege or object not found: BLC_STATIC_ASSET
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - Unsuccessful: create index ASST_ARCHVD_FLG_INDX on BLC_STATIC_ASSET (ARCHIVED_FLAG)
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - user lacks privilege or object not found: BLC_STATIC_ASSET
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - Unsuccessful: create index ASST_FULL_URL_INDX on BLC_STATIC_ASSET (FULL_URL)
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - user lacks privilege or object not found: BLC_STATIC_ASSET
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - Unsuccessful: alter table BLC_STATIC_ASSET add index FK9875FB0524568C27 (CREATED_BY), add constraint FK9875FB0524568C27 foreign key (CREATED_BY) references BLC_ADMIN_USER (ADMIN_USER_ID)
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_STATIC_ASSET
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - Unsuccessful: alter table BLC_STATIC_ASSET add index FK9875FB05579FE59D (SANDBOX_ID), add constraint FK9875FB05579FE59D foreign key (SANDBOX_ID) references BLC_SANDBOX (SANDBOX_ID)
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_STATIC_ASSET
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - Unsuccessful: alter table BLC_STATIC_ASSET add index FK9875FB05F9C4A5B (ORIG_SANDBOX_ID), add constraint FK9875FB05F9C4A5B foreign key (ORIG_SANDBOX_ID) references BLC_SANDBOX (SANDBOX_ID)
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_STATIC_ASSET
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - Unsuccessful: alter table BLC_STATIC_ASSET add index FK9875FB05C1167574 (UPDATED_BY), add constraint FK9875FB05C1167574 foreign key (UPDATED_BY) references BLC_ADMIN_USER (ADMIN_USER_ID)
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_STATIC_ASSET
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - Unsuccessful: alter table BLC_STATIC_ASSET_DESC add index FKC6F1CF8B24568C27 (CREATED_BY), add constraint FKC6F1CF8B24568C27 foreign key (CREATED_BY) references BLC_ADMIN_USER (ADMIN_USER_ID)
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_STATIC_ASSET_DESC
[artifact:mvn] [ERROR] 15:52:01 SchemaExport - Unsuccessful: alter table BLC_STATIC_ASSET_DESC add index FKC6F1CF8BC1167574 (UPDATED_BY), add constraint FKC6F1CF8BC1167574 foreign key (UPDATED_BY) references BLC_ADMIN_USER (ADMIN_USER_ID)
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_STATIC_ASSET_DESC
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - Unsuccessful: create index STORE_STATE_INDEX on BLC_STORE (STORE_STATE)
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - user lacks privilege or object not found: BLC_STORE
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - Unsuccessful: create index STORE_COUNTRY_INDEX on BLC_STORE (STORE_COUNTRY)
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - user lacks privilege or object not found: BLC_STORE
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - Unsuccessful: create index STORE_ZIP_INDEX on BLC_STORE (STORE_ZIP)
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - user lacks privilege or object not found: BLC_STORE
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - Unsuccessful: create index STORE_LONGITUDE_INDEX on BLC_STORE (LONGITUDE)
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - user lacks privilege or object not found: BLC_STORE
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - Unsuccessful: create index STORE_LATITUDE_INDEX on BLC_STORE (LATITUDE)
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - user lacks privilege or object not found: BLC_STORE
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - Unsuccessful: create index STORE_NAME_INDEX on BLC_STORE (STORE_NAME)
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - user lacks privilege or object not found: BLC_STORE
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - Unsuccessful: create index STORE_CITY_INDEX on BLC_STORE (STORE_CITY)
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - user lacks privilege or object not found: BLC_STORE
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - Unsuccessful: create index TARGETCONTENT_TYPE_INDEX on BLC_TARGET_CONTENT (CONTENT_TYPE)
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - user lacks privilege or object not found: BLC_TARGET_CONTENT
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - Unsuccessful: create index TARGETCONTENT_NAME_INDEX on BLC_TARGET_CONTENT (CONTENT_NAME)
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - user lacks privilege or object not found: BLC_TARGET_CONTENT
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - Unsuccessful: create index TARGETCONTENT_URL_INDEX on BLC_TARGET_CONTENT (URL)
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - user lacks privilege or object not found: BLC_TARGET_CONTENT
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - Unsuccessful: alter table BLC_TAR_CRIT_OFFER_XREF add index FK125F5803D5F3FAF4 (OFFER_ID), add constraint FK125F5803D5F3FAF4 foreign key (OFFER_ID) references BLC_OFFER (OFFER_ID)
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_TAR_CRIT_OFFER_XREF
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - Unsuccessful: alter table BLC_TAR_CRIT_OFFER_XREF add index FK125F58033615A91A (OFFER_ITEM_CRITERIA_ID), add constraint FK125F58033615A91A foreign key (OFFER_ITEM_CRITERIA_ID) references BLC_OFFER_ITEM_CRITERIA (OFFER_ITEM_CRITERIA_ID)
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - user lacks privilege or object not found: PUBLIC.BLC_TAR_CRIT_OFFER_XREF
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - Unsuccessful: create index ZIPCODE_STATE_INDEX on BLC_ZIP_CODE (ZIP_STATE)
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - user lacks privilege or object not found: BLC_ZIP_CODE
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - Unsuccessful: create index ZIPCODE_LONGITUDE_INDEX on BLC_ZIP_CODE (ZIP_LONGITUDE)
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - user lacks privilege or object not found: BLC_ZIP_CODE
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - Unsuccessful: create index ZIPCODE_CITY_INDEX on BLC_ZIP_CODE (ZIP_CITY)
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - user lacks privilege or object not found: BLC_ZIP_CODE
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - Unsuccessful: create index ZIPCODE_ZIP_INDEX on BLC_ZIP_CODE (ZIPCODE)
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - user lacks privilege or object not found: BLC_ZIP_CODE
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - Unsuccessful: create index ZIPCODE_LATITUDE_INDEX on BLC_ZIP_CODE (ZIP_LATITUDE)
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - user lacks privilege or object not found: BLC_ZIP_CODE
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - Unsuccessful: alter table SANDBOX_ITEM_ACTION add index FKB270D74A9797A024 (SANDBOX_ACTION_ID), add constraint FKB270D74A9797A024 foreign key (SANDBOX_ACTION_ID) references BLC_SANDBOX_ACTION (SANDBOX_ACTION_ID)
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - user lacks privilege or object not found: PUBLIC.SANDBOX_ITEM_ACTION
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - Unsuccessful: alter table SANDBOX_ITEM_ACTION add index FKB270D74AFE239304 (SANDBOX_ITEM_ID), add constraint FKB270D74AFE239304 foreign key (SANDBOX_ITEM_ID) references BLC_SANDBOX_ITEM (SANDBOX_ITEM_ID)
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - user lacks privilege or object not found: PUBLIC.SANDBOX_ITEM_ACTION
[artifact:mvn] [ERROR] 15:52:02 SchemaExport - schema export unsuccessful
[artifact:mvn] org.hibernate.JDBCException: Error during import script execution at line 13
[artifact:mvn] at org.hibernate.tool.hbm2ddl.SchemaExport.importScript(SchemaExport.java:370)
[artifact:mvn] at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:276)
[artifact:mvn] at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:219)
[artifact:mvn] at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:372)
[artifact:mvn] at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1872)
[artifact:mvn] at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:906)
[artifact:mvn] at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:74)
[artifact:mvn] at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:268)
[artifact:mvn] at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:310)
[artifact:mvn] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1514)
[artifact:mvn] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1452)
[artifact:mvn] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
[artifact:mvn] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
[artifact:mvn] at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
[artifact:mvn] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
[artifact:mvn] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
[artifact:mvn] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
[artifact:mvn] at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:567)
[artifact:mvn] at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:913)
[artifact:mvn] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:464)
[artifact:mvn] at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:385)
[artifact:mvn] at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:284)
[artifact:mvn] at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)
[artifact:mvn] at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)
[artifact:mvn] at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)
[artifact:mvn] at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
[artifact:mvn] at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
[artifact:mvn] at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
[artifact:mvn] at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
[artifact:mvn] at org.apache.catalina.startup.Embedded.start(Embedded.java:825)
[artifact:mvn] at org.apache.tomcat.maven.plugin.tomcat6.AbstractRunMojo.startContainer(AbstractRunMojo.java:767)
[artifact:mvn] at org.apache.tomcat.maven.plugin.tomcat6.AbstractRunMojo.execute(AbstractRunMojo.java:353)
[artifact:mvn] at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:101)
[artifact:mvn] at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:209)
[artifact:mvn] at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153)
[artifact:mvn] at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145)
[artifact:mvn] at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:84)
[artifact:mvn] at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:59)
[artifact:mvn] at org.apache.maven.lifecycle.internal.LifecycleStarter.singleThreadedBuild(LifecycleStarter.java:183)
[artifact:mvn] at org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:161)
[artifact:mvn] at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:320)
[artifact:mvn] at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:156)
[artifact:mvn] at org.apache.maven.cli.MavenCli.execute(MavenCli.java:537)
[artifact:mvn] at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:196)
[artifact:mvn] at org.apache.maven.cli.MavenCli.main(MavenCli.java:141)
[artifact:mvn] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[artifact:mvn] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[artifact:mvn] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[artifact:mvn] at java.lang.reflect.Method.invoke(Method.java:597)
[artifact:mvn] at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:290)
[artifact:mvn] at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:230)
[artifact:mvn] at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409)
[artifact:mvn] at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352)
[artifact:mvn] at org.codehaus.classworlds.Launcher.main(Launcher.java:47)
[artifact:mvn] Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: BLC_ADMIN_ROLE
[artifact:mvn] at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
[artifact:mvn] at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
[artifact:mvn] at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
[artifact:mvn] at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
[artifact:mvn] at org.hibernate.tool.hbm2ddl.SchemaExport.importScript(SchemaExport.java:366)
[artifact:mvn] ... 53 more
[artifact:mvn] [ WARN] 15:52:02 AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.hibernate.cache.UpdateTimestampsCache]; using defaults.
[artifact:mvn] [ERROR] 15:52:04 Ejb3Configuration - Container is providing a null PersistenceUnitRootUrl: discovery impossible
[artifact:mvn] [ WARN] 15:52:04 Ejb3Configuration - hibernate.connection.autocommit = false break the EJB3 specification
[artifact:mvn] [ERROR] 15:52:04 SchemaUpdate - Unsuccessful: create table BLC_BANK_ACCOUNT_PAYMENT (PAYMENT_ID bigint not null, ACCOUNT_NUMBER varchar(255) not null, REFERENCE_NUMBER varchar(255) not null, ROUTING_NUMBER varchar(255) not null, primary key (PAYMENT_ID)) ENGINE=InnoDB
[artifact:mvn] [ERROR] 15:52:04 SchemaUpdate - unexpected token: ENGINE
[artifact:mvn] [ERROR] 15:52:04 SchemaUpdate - Unsuccessful: create table BLC_CREDIT_CARD_PAYMENT (PAYMENT_ID bigint not null, EXPIRATION_MONTH integer not null, EXPIRATION_YEAR integer not null, NAME_ON_CARD varchar(255) not null, PAN varchar(255) not null, REFERENCE_NUMBER varchar(255) not null, primary key (PAYMENT_ID)) ENGINE=InnoDB
[artifact:mvn] [ERROR] 15:52:04 SchemaUpdate - unexpected token: ENGINE
[artifact:mvn] [ERROR] 15:52:04 SchemaUpdate - Unsuccessful: create table BLC_GIFT_CARD_PAYMENT (PAYMENT_ID bigint not null, PAN varchar(255) not null, PIN varchar(255), REFERENCE_NUMBER varchar(255) not null, primary key (PAYMENT_ID)) ENGINE=InnoDB
[artifact:mvn] [ERROR] 15:52:04 SchemaUpdate - unexpected token: ENGINE
[artifact:mvn] [ERROR] 15:52:04 SchemaUpdate - Unsuccessful: create index BANKACCOUNT_INDEX on BLC_BANK_ACCOUNT_PAYMENT (REFERENCE_NUMBER)
[artifact:mvn] [ERROR] 15:52:04 SchemaUpdate - user lacks privilege or object not found: BLC_BANK_ACCOUNT_PAYMENT
[artifact:mvn] [ERROR] 15:52:04 SchemaUpdate - Unsuccessful: create index CREDITCARD_INDEX on BLC_CREDIT_CARD_PAYMENT (REFERENCE_NUMBER)
[artifact:mvn] [ERROR] 15:52:04 SchemaUpdate - user lacks privilege or object not found: BLC_CREDIT_CARD_PAYMENT
[artifact:mvn] [ERROR] 15:52:04 SchemaUpdate - Unsuccessful: create index GIFTCARD_INDEX on BLC_GIFT_CARD_PAYMENT (REFERENCE_NUMBER)
[artifact:mvn] [ERROR] 15:52:04 SchemaUpdate - user lacks privilege or object not found: BLC_GIFT_CARD_PAYMENT
[artifact:mvn] [ WARN] 15:52:07 IndexSchema - no uniqueKey specified in schema.
[artifact:mvn] [ERROR] 15:52:10 Ejb3Configuration - Container is providing a null PersistenceUnitRootUrl: discovery impossible
[artifact:mvn] [ WARN] 15:52:10 Ejb3Configuration - hibernate.connection.autocommit = false break the EJB3 specification
[artifact:mvn] [ERROR] 15:52:10 SchemaExport - Unsuccessful: create table BLC_STATIC_ASSET_STRG (STATIC_ASSET_STRG_ID bigint not null, FILE_DATA longblob, STATIC_ASSET_ID bigint not null, primary key (STATIC_ASSET_STRG_ID)) ENGINE=InnoDB
[artifact:mvn] [ERROR] 15:52:10 SchemaExport - type not found or user lacks privilege: LONGBLOB
[artifact:mvn] [ERROR] 15:52:10 SchemaExport - Unsuccessful: create index STATIC_ASSET_ID_INDEX on BLC_STATIC_ASSET_STRG (STATIC_ASSET_ID)
[artifact:mvn] [ERROR] 15:52:10 SchemaExport - user lacks privilege or object not found: BLC_STATIC_ASSET_STRG
[artifact:mvn] [ WARN] 15:52:12 JDBCExceptionReporter - SQL Error: -5501, SQLState: 42501
[artifact:mvn] [ERROR] 15:52:12 JDBCExceptionReporter - user lacks privilege or object not found: BLC_SC_RULE
[artifact:mvn] [ERROR] 15:52:12 ContextLoader - Context initialization failed
[artifact:mvn] javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
[artifact:mvn] at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1389)
[artifact:mvn] at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1317)
[artifact:mvn] at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:255)
[artifact:mvn] at org.broadleafcommerce.common.persistence.SequenceGeneratorCorruptionDetection.onApplicationEvent(SequenceGeneratorCorruptionDetection.java:137)
[artifact:mvn] at org.broadleafcommerce.common.persistence.SequenceGeneratorCorruptionDetection.onApplicationEvent(SequenceGeneratorCorruptionDetection.java:47)
[artifact:mvn] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[artifact:mvn] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[artifact:mvn] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[artifact:mvn] at java.lang.reflect.Method.invoke(Method.java:597)
[artifact:mvn] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
[artifact:mvn] at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
[artifact:mvn] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
[artifact:mvn] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
[artifact:mvn] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
[artifact:mvn] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
[artifact:mvn] at $Proxy98.onApplicationEvent(Unknown Source)
[artifact:mvn] at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:97)
[artifact:mvn] at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:324)
[artifact:mvn] at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:929)
[artifact:mvn] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:467)
[artifact:mvn] at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:385)
[artifact:mvn] at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:284)
[artifact:mvn] at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)
[artifact:mvn] at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)
[artifact:mvn] at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)
[artifact:mvn] at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
[artifact:mvn] at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
[artifact:mvn] at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
[artifact:mvn] at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
[artifact:mvn] at org.apache.catalina.startup.Embedded.start(Embedded.java:825)
[artifact:mvn] at org.apache.tomcat.maven.plugin.tomcat6.AbstractRunMojo.startContainer(AbstractRunMojo.java:767)
[artifact:mvn] at org.apache.tomcat.maven.plugin.tomcat6.AbstractRunMojo.execute(AbstractRunMojo.java:353)
[artifact:mvn] at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:101)
[artifact:mvn] at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:209)
[artifact:mvn] at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153)
[artifact:mvn] at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145)
[artifact:mvn] at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:84)
[artifact:mvn] at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:59)
[artifact:mvn] at org.apache.maven.lifecycle.internal.LifecycleStarter.singleThreadedBuild(LifecycleStarter.java:183)
[artifact:mvn] at org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:161)
[artifact:mvn] at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:320)
[artifact:mvn] at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:156)
[artifact:mvn] at org.apache.maven.cli.MavenCli.execute(MavenCli.java:537)
[artifact:mvn] at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:196)
[artifact:mvn] at org.apache.maven.cli.MavenCli.main(MavenCli.java:141)
[artifact:mvn] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[artifact:mvn] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[artifact:mvn] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[artifact:mvn] at java.lang.reflect.Method.invoke(Method.java:597)
[artifact:mvn] at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:290)
[artifact:mvn] at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:230)
[artifact:mvn] at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409)
[artifact:mvn] at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352)
[artifact:mvn] at org.codehaus.classworlds.Launcher.main(Launcher.java:47)
[artifact:mvn] Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
[artifact:mvn] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
[artifact:mvn] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
[artifact:mvn] at org.hibernate.loader.Loader.doList(Loader.java:2545)
[artifact:mvn] at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
[artifact:mvn] at org.hibernate.loader.Loader.list(Loader.java:2271)
[artifact:mvn] at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
[artifact:mvn] at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
[artifact:mvn] at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
[artifact:mvn] at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
[artifact:mvn] at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
[artifact:mvn] at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:246)
[artifact:mvn] ... 51 more
[artifact:mvn] Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: BLC_SC_RULE
[artifact:mvn] at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
[artifact:mvn] at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
[artifact:mvn] at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
[artifact:mvn] at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
[artifact:mvn] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[artifact:mvn] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[artifact:mvn] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[artifact:mvn] at java.lang.reflect.Method.invoke(Method.java:597)
[artifact:mvn] at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126)
[artifact:mvn] at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
[artifact:mvn] at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:67)
[artifact:mvn] at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
[artifact:mvn] at org.apache.tomcat.jdbc.pool.interceptor.ConnectionState.invoke(ConnectionState.java:153)
[artifact:mvn] at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
[artifact:mvn] at org.apache.tomcat.jdbc.pool.TrapException.invoke(TrapException.java:41)
[artifact:mvn] at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
[artifact:mvn] at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:80)
[artifact:mvn] at $Proxy89.prepareStatement(Unknown Source)
[artifact:mvn] at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
[artifact:mvn] at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
[artifact:mvn] at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
[artifact:mvn] at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
[artifact:mvn] at org.hibernate.loader.Loader.doQuery(Loader.java:801)
[artifact:mvn] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
[artifact:mvn] at org.hibernate.loader.Loader.doList(Loader.java:2542)
[artifact:mvn] ... 59 more
[artifact:mvn] Dec 20, 2012 3:52:12 PM org.apache.catalina.core.StandardContext listenerStart
[artifact:mvn] SEVERE: Exception sending context initialized event to listener instance of class org.broadleafcommerce.common.web.extensibility.MergeContextLoaderListener
[artifact:mvn] javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
[artifact:mvn] at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1389)
[artifact:mvn] at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1317)
[artifact:mvn] at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:255)
[artifact:mvn] at org.broadleafcommerce.common.persistence.SequenceGeneratorCorruptionDetection.onApplicationEvent(SequenceGeneratorCorruptionDetection.java:137)
[artifact:mvn] at org.broadleafcommerce.common.persistence.SequenceGeneratorCorruptionDetection.onApplicationEvent(SequenceGeneratorCorruptionDetection.java:47)
[artifact:mvn] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[artifact:mvn] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[artifact:mvn] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[artifact:mvn] at java.lang.reflect.Method.invoke(Method.java:597)
[artifact:mvn] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
[artifact:mvn] at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
[artifact:mvn] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
[artifact:mvn] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
[artifact:mvn] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
[artifact:mvn] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
[artifact:mvn] at $Proxy98.onApplicationEvent(Unknown Source)
[artifact:mvn] at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:97)
[artifact:mvn] at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:324)
[artifact:mvn] at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:929)
[artifact:mvn] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:467)
[artifact:mvn] at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:385)
[artifact:mvn] at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:284)
[artifact:mvn] at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)
[artifact:mvn] at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)
[artifact:mvn] at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)
[artifact:mvn] at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
[artifact:mvn] at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
[artifact:mvn] at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
[artifact:mvn] at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
[artifact:mvn] at org.apache.catalina.startup.Embedded.start(Embedded.java:825)
[artifact:mvn] at org.apache.tomcat.maven.plugin.tomcat6.AbstractRunMojo.startContainer(AbstractRunMojo.java:767)
[artifact:mvn] at org.apache.tomcat.maven.plugin.tomcat6.AbstractRunMojo.execute(AbstractRunMojo.java:353)
[artifact:mvn] at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:101)
[artifact:mvn] at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:209)
[artifact:mvn] at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153)
[artifact:mvn] at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145)
[artifact:mvn] at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:84)
[artifact:mvn] at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:59)
[artifact:mvn] at org.apache.maven.lifecycle.internal.LifecycleStarter.singleThreadedBuild(LifecycleStarter.java:183)
[artifact:mvn] at org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:161)
[artifact:mvn] at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:320)
[artifact:mvn] at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:156)
[artifact:mvn] at org.apache.maven.cli.MavenCli.execute(MavenCli.java:537)
[artifact:mvn] at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:196)
[artifact:mvn] at org.apache.maven.cli.MavenCli.main(MavenCli.java:141)
[artifact:mvn] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[artifact:mvn] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[artifact:mvn] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[artifact:mvn] at java.lang.reflect.Method.invoke(Method.java:597)
[artifact:mvn] at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:290)
[artifact:mvn] at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:230)
[artifact:mvn] at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409)
[artifact:mvn] at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352)
[artifact:mvn] at org.codehaus.classworlds.Launcher.main(Launcher.java:47)
[artifact:mvn] Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
[artifact:mvn] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
[artifact:mvn] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
[artifact:mvn] at org.hibernate.loader.Loader.doList(Loader.java:2545)
[artifact:mvn] at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
[artifact:mvn] at org.hibernate.loader.Loader.list(Loader.java:2271)
[artifact:mvn] at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
[artifact:mvn] at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
[artifact:mvn] at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
[artifact:mvn] at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
[artifact:mvn] at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
[artifact:mvn] at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:246)
[artifact:mvn] ... 51 more
[artifact:mvn] Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: BLC_SC_RULE
[artifact:mvn] at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
[artifact:mvn] at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
[artifact:mvn] at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
[artifact:mvn] at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
[artifact:mvn] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[artifact:mvn] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[artifact:mvn] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[artifact:mvn] at java.lang.reflect.Method.invoke(Method.java:597)
[artifact:mvn] at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126)
[artifact:mvn] at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
[artifact:mvn] at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:67)
[artifact:mvn] at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
[artifact:mvn] at org.apache.tomcat.jdbc.pool.interceptor.ConnectionState.invoke(ConnectionState.java:153)
[artifact:mvn] at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
[artifact:mvn] at org.apache.tomcat.jdbc.pool.TrapException.invoke(TrapException.java:41)
[artifact:mvn] at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
[artifact:mvn] at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:80)
[artifact:mvn] at $Proxy89.prepareStatement(Unknown Source)
[artifact:mvn] at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
[artifact:mvn] at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
[artifact:mvn] at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
[artifact:mvn] at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
[artifact:mvn] at org.hibernate.loader.Loader.doQuery(Loader.java:801)
[artifact:mvn] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
[artifact:mvn] at org.hibernate.loader.Loader.doList(Loader.java:2542)
[artifact:mvn] ... 59 more



Any ideas what may be wrong?

Re: Error in changing from Jetty to Tomcat

Posted: Thu Dec 20, 2012 12:14 pm
by phillipuniverse
This is a database problem. All of those statements mean that those tables do not exist in your database. Try starting up with your ddl set to 'create' or 'create-drop' that that it will initially create the tables and run the import scripts. You can then change it back to 'update' for the next restart.

This is assuming that you've also changed your database configuration in some way; is this right?

Re: Error in changing from Jetty to Tomcat

Posted: Fri Dec 21, 2012 5:44 am
by gk12
I also faced the same problem when switching from Jetty to Tomcat.

How it can be database problem when it works fine with Jetty?

Re: Error in changing from Jetty to Tomcat

Posted: Fri Dec 21, 2012 11:21 am
by phillipuniverse
Maybe your JNDI resources are declared differently? In Jetty, they are declared in jetty-env.xml in the project. For Tomcat, it uses context.xml, either in the META-INF directory of your webapp or in the 'conf' folder of your Tomcat directory.

Everything in this stack trace points to tables not being found, however. But it looks like something is connecting to the database ok, else you would've seen earlier stacktraces about not being able to connect. See if you can verify what is actually in the database before and after startup.

Re: Error in changing from Jetty to Tomcat

Posted: Sun Dec 23, 2012 11:20 pm
by 22dec1960
Thanks phillipuniverse,

Yes you are right. I changed database to MySQL first before changing server to Tomcat. Then I changed to Tomcat and got the error.

Now, I corrected the database configuration in META-INF/context.xml and it is ok now.
All times are UTC-05:00
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/