OFBiz › OFBiz - User

I get startup error

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

2 messages Options

kongqz

I get startup error

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?

micman.manoj

Re: I get startup error

I changed the default database to the Oracle version I am using, then ran "build" and "run".
Ofbiz adapted to the new db and the application tables were created successfully. However, if I try to make the same changes to anoter ofbiz application using the same production database, I end up with the same error posted above:

[java] Error was: java.sql.SQLException: ORA-00955: name is already used by an existing object
[java] 2012-03-26 04:21:18,884 (main) [ DatabaseUtil.java:344:WARN ] Entity [GlJournal] has no table in the database
[java] 2012-03-26 04:21:19,400 (main) [ DatabaseUtil.java:352:ERROR] Could not create table [abreportsdev.GL_JOURNAL]: SQL

etc.

Is it not possible to access two instances of the production database simultaneously?