|
when I start up my ofbiz4 and the database is oracle9.
I get the error as follow:
"DatabaseUtil.java:351:ERROR] Could not create table [PERIOD_TYPE]: SQL Exception while executing the following:
CREATE TABLE PERIOD_TYPE (PERIOD_TYPE_ID VARCHAR2(20) NOT NULL, DESCRIPTION VARCHAR2(255), PERIOD_LENGTH NUMBER(20,0), UOM_ID VARCHAR2(20), LAST_UPDATED_STAMP TIMESTAMP, LAST_UPDATED_TX_STAMP TIMESTAMP, CREATED_STAMP TIMESTAMP, CREATED_TX_STAMP TIMESTAMP, CONSTRAINT PK_PERIOD_TYPE PRIMARY KEY (PERIOD_TYPE_ID))
Error was: java.sql.SQLException: ORA-00955: name is already used by an existing object
"
But when I use mysql.I get no error.I debug it .And then I get the question.ofbiz compare the name,but the name of oracle is instancename.PERIOD_TYPE.So they won't equal for ever.How could I do in oracle in order to avoiding the error?
|