----- "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
