Hello,
I think someone is trying to see what your problem can be.
I don't know what is your purpose for now. You might also be
interested to set up the zip I preconfigured here for a demo on
oracle ,with a readme : http://public.dev.nuxeo.com/~aescaffre/kisiwa/oracle/
Note that it is a " 5.2 pre-RC" package.
Kind regards,
Alain
Le 23 mars 09 à 15:11, <[email protected]> <[email protected]
> a écrit :
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
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
