Hi, We are evaluating Nuxeo and Alfreso. I have found Nuxeo much better than Alfresco in most of areas until we were trying to configure using Oracle.. things starting to turn opposite way. With Alfresco it is pretty straight-forward, configuring Oracle requirre only very little configuration change. Nuxeo seems be a different story with Oracle... 0 Added ojdbc.jar driver 1 Modify config/sql.properties 2 Configure default-repository-config.xml for Jackrabbit 2 Configure unified-nuxeo-ds.xml for various Nuxeo services 3 Configure comapss.cfg.xml for Compass search
The configurations are spreaded in few places is fine to me even we can probably do a much better job to centralize it. But the real problem is I still does not work after all those configurations, and I tried a few things but the problem did not go away. I am uisng 5.1.6EP. Here are the related error logs: 2009-03-20 15:16:38,390 INFO [org.jbpm.JbpmConfiguration] using jbpm configuration resource 'jbpm.cfg.xml' 2009-03-20 15:16:49,562 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table JBPM_TASKINSTANCE add ORDER_ number(10,0) 2009-03-20 15:16:49,562 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] ORA-00942: table or view does not exist 2009-03-20 15:16:49,577 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table JBPM_TASKINSTANCE add ISREJECTED_ number(1,0) 2009-03-20 15:16:49,577 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] ORA-00942: table or view does not exist 2009-03-20 15:16:49,593 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table JBPM_TASKINSTANCE add DIRECTIVE_ varchar2(255 char) 2009-03-20 15:16:49,593 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] ORA-00942: table or view does not exist 2009-03-20 15:16:49,593 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table JBPM_TASKINSTANCE add COMMENT_ varchar2(255 char) 2009-03-20 15:16:49,593 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] ORA-00942: table or view does not exist 2009-03-20 15:16:49,781 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table JBPM_MESSAGE add constraint FK_CMD_ACTION foreign key (ACTION_) references JBPM_ACTION 2009-03-20 15:16:49,781 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] ORA-00942: table or view does not exist 2009-03-20 15:16:49,796 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table JBPM_MESSAGE add constraint FK_MSG_TOKEN foreign key (TOKEN_) references JBPM_TOKEN 2009-03-20 15:16:49,796 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] ORA-00942: table or view does not exist 2009-03-20 15:16:49,812 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table JBPM_MESSAGE add constraint FK_CMD_NODE foreign key (NODE_) references JBPM_NODE 2009-03-20 15:16:49,812 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] ORA-00942: table or view does not exist 2009-03-20 15:16:49,812 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table JBPM_MESSAGE add constraint FK_CMD_TASKINST foreign key (TASKINSTANCE_) references JBPM_TASKINSTANCE 2009-03-20 15:16:49,812 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] ORA-00942: table or view does not exist 2009-03-20 15:16:49,827 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table JBPM_TIMER add constraint FK_TIMER_PRINST foreign key (PROCESSINSTANCE_) references JBPM_PROCESSINSTANCE 2009-03-20 15:16:49,827 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] ORA-00942: table or view does not exist 2009-03-20 15:16:49,843 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table JBPM_TIMER add constraint FK_TIMER_TOKEN foreign key (TOKEN_) references JBPM_TOKEN 2009-03-20 15:16:49,843 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] ORA-00942: table or view does not exist 2009-03-20 15:16:49,859 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table JBPM_TIMER add constraint FK_TIMER_ACTION foreign key (ACTION_) references JBPM_ACTION 2009-03-20 15:16:49,859 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] ORA-00942: table or view does not exist 2009-03-20 15:16:49,859 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table JBPM_TIMER add constraint FK_TIMER_TSKINST foreign key (TASKINSTANCE_) references JBPM_TASKINSTANCE 2009-03-20 15:16:49,859 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] ORA-00942: table or view does not exist 2009-03-20 15:16:50,140 INFO [STDOUT] Hibernate: select processdef0_.ID_ as ID1_15_0_, processdef0_.NAME_ as NAME2_15_0_, processdef0_.VERSION_ as VERSION3_15_0_, processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_15_0_, processdef0_.STARTSTATE_ as STARTSTATE5_15_0_ from JBPM_PROCESSDEFINITION processdef0_ where processdef0_.ID_=? 2009-03-20 15:16:50,171 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 942, SQLState: 42000 2009-03-20 15:16:50,187 ERROR [org.hibernate.util.JDBCExceptionReporter] ORA-00942: table or view does not exist The prolem is related to jBPM. Has anyone seen this problem before? I like Nuxeo way better than Alfreso as a developer because of its OSGi overal structure, extensibility etc even though our BA like Alfresco better because it looks more like a polished product. I do not want to give up my hope to Nuxeo. I appreciate if someone can give some suggestion how to fix this oracle issue. Another frustrating thing is Nuxeo forum has been down for few days :(. Thanks, Brian
_______________________________________________ ECM mailing list [email protected] http://lists.nuxeo.com/mailman/listinfo/ecm To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
