[sorry for the late reply trying to get back on the list] [EMAIL PROTECTED] wrote: > 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.
Thanks Damien for the anwser which is absolutly correct.
I will try out to not include the dialect within the hibernate.cfg since
the data source already provides the db specific information. I had
troubles in the past trying this in the past since Hibernate didn't want
to initialize if the dialiect wasn't within the bibernate.cfg.xml file.
I'll get back on this so that it would be less painful to setup another
db than hsqldb for nxworkflow-jbpm and as well to avoid class mappings
definition duplication...
In the meanwhile, Vincent if you want to provide the mysql profile I
could integrate it within the base product with a dedicated target.
I put that on my todo list.
Cheers,
J.
> 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
>
--
Julien Anguenot | Nuxeo R&D (Paris, France)
Open Source ECM - http://www.nuxeo.com
Nuxeo 5 : http://www.nuxeo.org
Mobile: +33 (0) 6 72 57 57 66
signature.asc
Description: OpenPGP digital signature
_______________________________________________ ECM mailing list [EMAIL PROTECTED] http://lists.nuxeo.com/mailman/listinfo/ecm
