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
