Hi Joaquin, Thanks for your reply and helpful links. I may try the latest 5.2 milestone release to see whether it has the same problem.
Regards, Brian -----Original Message----- From: Joaquin Hernandez [mailto:[email protected]] Sent: Monday, March 23, 2009 11:25 AM To: Olivier Grisel Cc: Xiang, Brian (Dean Group Inc.); [email protected] Subject: Re: [Ecm] Nuxeo on Oracle Brian, The problem that you have is not from Nuxeo, is from jBPM... during the boostrap of jBPM it discovers that the related tables does not exists within the database, and (as it relies on Hibernate)... Hibernate is trying to create or alter some of the tables... I suggest looking further information within the community website of jBPM (http://www.jboss.org/jbossjbpm/jbpm_community/ ) Some links that might help: http://www.jboss.org/community/docs/DOC-11155 http://www.jboss.org/community/docs/DOC-9328 http://www.jboss.org/community/docs/DOC-13114 The easiest way to fix this is dropping all the jBPM tables (they all have JBPM_ prefix ) and restarting your JBoss server. (YOU WILL LOSE PROCESES INFORMATION!!!!) Hope this helps... good luck! Best regards, -------------------------------------------------- <EPI/> - Deploying ideas -------------------------------------------------- Joaquin Hernandez Epidata Consulting Maipu 521 1 A Ofi: (+5411) 5031-0060/61 Cel:(+54911) 56456399 www.epidataconsulting.com On Mar 23, 2009, at 12:13 PM, Olivier Grisel wrote: > > ----- "brian xiang" <[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 > > I would advise you to leave the compass indexes on the filesytem > instead of using the JDBC backend which has a couple of problems when > it grows to much. > >> The configurations are spreaded in few places is fine to me even we >> can probably do a much better job to centralize it. > > That's the consequence of Nuxeo component model... > >> 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 > > It looks like the JPBM configuration decided to update a partially > existing set of tables and is missing some of them (e.g. > JBPM_TASKINSTANCE). > > Are you sure you had no previous partial installation of JPBM tables > in that database? Have you tried to drop the complete database and > restart jboss / nuxeo (provided you don't have any valuable data in > it)? > > -- > Olivier > _______________________________________________ > 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
