The problem with NXWorkflowJBPM is that the nxworkflow.jar includes a
hibernate.cfg.xml file that configure the dialect used by jbpm. In
the org.nuxeo.platform.workflow.jbpm project you have two examples of
this file in th resources/db directory, on for hsql (the default one)
and on for Postgres.
You should write your own for MySQL and replace it in the jar during
the deployment of your extension point.
Damien METZLER
Le 22 mars 07 à 09:27, [EMAIL PROTECTED] a écrit :
Did you also see in my first post the exceptions about
nxworkflowjbm ? It seems that hibernate could not create
nxworkflowjbm's tables.
Florent Guillaume wrote:
Hi Vincent,
On 21 Mar 2007, at 12:20, Vincent Dutat wrote:
Hi,
I updated Nuxeo sources last monday (rev. 13835). This snapshot
has errors with MySQL databases, errors I did not have with
previous revisions. But it works fine with Hypersonic.
Here are the exceptions :
2007-03-21 11:31:22,331 ERROR
[org.hibernate.tool.hbm2ddl.SchemaUpdate] could not get database
metadata
java.sql.SQLException: Unknown table 'system_sequences' in
information_schema
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
According to the third hit in
http://www.google.com/search?q=system_sequences+mysql
this seems to mean that you have a datasource where you still have
hsqldb statements in a <check-valid-connection-sql> tag.
For MySQL one working syntax is: <check-valid-connection-
sql>select count(*) from dual</check-valid-connection-sql>
(Note that standard Nuxeo 5 datasources don't use <check-valid-
connection-sql> -- they will when we start working on HA
configuration.)
Florent
--Florent Guillaume, Director of R&D, Nuxeo
Open Source Enterprise Content Management (ECM)
http://www.nuxeo.com http://www.nuxeo.org +33 1 40 33 79 87
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
Ce message et toutes les pièces jointes sont établis à l'attention exclusive de
leurs destinataires et sont confidentiels. Si vous recevez ce message par
erreur, merci de le détruire et d'en avertir immédiatement l'expéditeur.
L'internet ne permettant pas d'assurer l'intégrité de ce message, le contenu de
ce message ne représente en aucun cas un engagement de la part de Leroy Merlin.
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
