I am working on getting the demosite run on MS Sql server. Getting following exception messages on eclipse console.
When cross checked the new database on sql server, there were few tables which weren't created and few created. looks like incomplete.
Code: Select all
[artifact:mvn] [ERROR] 09:59:33 Ejb3Configuration - Container is providing a null PersistenceUnitRootUrl: discovery impossible
[artifact:mvn] [ WARN] 09:59:33 Ejb3Configuration - hibernate.connection.autocommit = false break the EJB3 specification
[artifact:mvn] [ WARN] 09:59:34 AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [blSandBoxElements]; using defaults.
[artifact:mvn] [ERROR] 09:59:35 SchemaExport - Unsuccessful: create table BLC_ADDITIONAL_OFFER_INFO (BLC_ORDER_ORDER_ID bigint not null, OFFER_INFO_ID bigint not null, OFFER_ID bigint not null, primary key (BLC_ORDER_ORDER_ID, OFFER_ID))
[artifact:mvn] [ERROR] 09:59:35 SchemaExport - There is already an object named 'BLC_ADDITIONAL_OFFER_INFO' in the database.
[artifact:mvn] [ERROR] 09:59:35 SchemaExport - Unsuccessful: create table BLC_ADDRESS (ADDRESS_ID bigint not null, ADDRESS_LINE1 varchar(255) not null, ADDRESS_LINE2 varchar(255), CITY varchar(255) not null, COMPANY_NAME varchar(255), COUNTY varchar(255), EMAIL_ADDRESS varchar(255), FAX varchar(255), FIRST_NAME varchar(255), IS_ACTIVE bit, IS_BUSINESS bit, IS_DEFAULT bit, LAST_NAME varchar(255), POSTAL_CODE varchar(255) not null, PRIMARY_PHONE varchar(255), SECONDARY_PHONE varchar(255), STANDARDIZED bit, TOKENIZED_ADDRESS varchar(255), VERIFICATION_LEVEL varchar(255), ZIP_FOUR varchar(255), COUNTRY varchar(255) not null, STATE_PROV_REGION varchar(255), primary key (ADDRESS_ID))
[artifact:mvn] [ERROR] 09:59:35 SchemaExport - There is already an object named 'BLC_ADDRESS' in the database.
[artifact:mvn] [ERROR] 09:59:35 SchemaExport - Unsuccessful: create table BLC_ADMIN_PASSWORD_TOKEN (PASSWORD_TOKEN varchar(255) not null, ADMIN_USER_ID bigint not null, CREATE_DATE timestamp not null, TOKEN_USED_DATE timestamp, TOKEN_USED_FLAG bit not null, primary key (PASSWORD_TOKEN))
[artifact:mvn] [ERROR] 09:59:35 SchemaExport - A table can only have one timestamp column. Because table 'BLC_ADMIN_PASSWORD_TOKEN' already has one, the column 'TOKEN_USED_DATE' cannot be added.
[artifact:mvn] [ERROR] 09:59:35 SchemaExport - Unsuccessful: create table BLC_ADMIN_PERMISSION (ADMIN_PERMISSION_ID bigint not null, DESCRIPTION varchar(255) not null, NAME varchar(255) not null, PERMISSION_TYPE varchar(255) not null, primary key (ADMIN_PERMISSION_ID))
[artifact:mvn] [ERROR] 09:59:35 SchemaExport - There is already an object named 'BLC_ADMIN_PERMISSION' in the database.
[artifact:mvn] [ERROR] 09:59:35 SchemaExport - Unsuccessful: create table BLC_ADMIN_PERMISSION_ENTITY (ADMIN_PERMISSION_ENTITY_ID bigint not null, CEILING_ENTITY varchar(255) not null, ADMIN_PERMISSION_ID bigint, primary key (ADMIN_PERMISSION_ENTITY_ID))
[artifact:mvn] [ERROR] 09:59:35 SchemaExport - There is already an object named 'BLC_ADMIN_PERMISSION_ENTITY' in the database.
[artifact:mvn] [ERROR] 09:59:35 SchemaExport - Unsuccessful: create table BLC_ADMIN_ROLE (ADMIN_ROLE_ID bigint not null, DESCRIPTION varchar(255) not null, NAME varchar(255) not null, primary key (ADMIN_ROLE_ID), unique (NAME))
Help with this regard is greatly appreciated!
~ Thank you