Hi Olivier, > 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.
Thanks for the advice. > That's the consequence of Nuxeo component model... I can live with that. > 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)? There is no any previously installed JBPM tables under NUXEO schema. I created a completely new schema NUXEO. When Nuxeo starts, I can see some JBPM_ tables are created, some are not. So something is not work properly with Nuxeo/JBPM/Oracle combination. Regards, Brian -----Original Message----- From: Olivier Grisel [mailto:[email protected]] Sent: Monday, March 23, 2009 11:14 AM To: Xiang, Brian (Dean Group Inc.) Cc: [email protected] Subject: Re: [Ecm] Nuxeo on Oracle ----- "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
