Hi Vincent, This is now fixed. The hibernate class mapping definition are not duplicated anymore and the file do not contain any dialect declaration.
You can only change the data source file for nxworkflow-jbpm.
Thanks for the feedbacks.
J.
Julien Anguenot wrote:
> Hi Vicent,
>
> Vincent Dutat wrote:
>> here is the hibernate.cfg.xml file for MySQL data sources.
>> That would be nice when it will be in nxworkflow-jbpm.jar, at the moment
>> we have to "inject" it in the jar at deployment time, a bit ugly but it
>> was the only way... And this way gave us some troubles begining of this
>> week ...
>
> Thanks for the file.
>
> I know... Let me take care of this :)
>
> I'll keep you posted.
>
> J.
>
>> Julien Anguenot wrote:
>>> [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
>>>>
>>>
>>>
>>> ------------------------------------------------------------------------
>>>
>>> _______________________________________________
>>> ECM mailing list
>>> [EMAIL PROTECTED]
>>> http://lists.nuxeo.com/mailman/listinfo/ecm
>>
>> ------------------------------------------------------------------------
>>
>> <?xml version='1.0' encoding='utf-8'?>
>>
>> <!DOCTYPE hibernate-configuration PUBLIC
>> "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
>> "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd";>
>>
>> <hibernate-configuration>
>> <session-factory>
>>
>> <!-- jdbc connection properties -->
>> <property
>> name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
>> <property
>> name="hibernate.connection.datasource">java:/nxworkflowjbpm</property>
>>
>> <property name="hibernate.hbm2ddl.auto">update</property>
>>
>> <!-- other hibernate properties
>> <property name="hibernate.show_sql">true</property>
>> <property name="hibernate.format_sql">true</property>
>> <property name="hibernate.use_sql_comments">true</property>
>> -->
>>
>> <!-- ############################################ -->
>> <!-- # mapping files with external dependencies # -->
>> <!-- ######################################### ### -->
>>
>> <!-- following mapping file has a dependendy on -->
>> <!-- 'bsh-{version}.jar'. -->
>> <!-- uncomment this if you don't have bsh on your -->
>> <!-- classpath. you won't be able to use the -->
>> <!-- script element in process definition files -->
>> <mapping resource="org/jbpm/graph/action/Script.hbm.xml"/>
>>
>> <!-- following mapping files have a dependendy on -->
>> <!-- 'jbpm-identity-{version}.jar', mapping files -->
>> <!-- of the pluggable jbpm identity component. -->
>> <!-- comment out the following 3 lines if you don't-->
>> <!-- want to use the default jBPM identity mgmgt -->
>> <!-- component -->
>> <mapping resource="org/jbpm/identity/User.hbm.xml"/>
>> <mapping resource="org/jbpm/identity/Group.hbm.xml"/>
>> <mapping resource="org/jbpm/identity/Membership.hbm.xml"/>
>>
>> <!-- ###################### -->
>> <!-- # jbpm mapping files # -->
>> <!-- ###################### -->
>>
>> <!-- hql queries and type defs -->
>> <mapping
>> resource="org/nuxeo/ecm/platform/workflow/jbpm/db/hibernate.queries.hbm.xml"
>> />
>>
>> <!-- graph.def mapping files -->
>> <mapping resource="org/jbpm/graph/def/ProcessDefinition.hbm.xml"/>
>> <mapping resource="org/jbpm/graph/def/Node.hbm.xml"/>
>> <mapping resource="org/jbpm/graph/def/Transition.hbm.xml"/>
>> <mapping resource="org/jbpm/graph/def/Event.hbm.xml"/>
>> <mapping resource="org/jbpm/graph/def/Action.hbm.xml"/>
>> <mapping resource="org/jbpm/graph/def/SuperState.hbm.xml"/>
>> <mapping resource="org/jbpm/graph/def/ExceptionHandler.hbm.xml"/>
>> <mapping resource="org/jbpm/instantiation/Delegation.hbm.xml"/>
>>
>> <!-- graph.node mapping files -->
>> <mapping resource="org/jbpm/graph/node/StartState.hbm.xml"/>
>> <mapping resource="org/jbpm/graph/node/EndState.hbm.xml"/>
>> <mapping resource="org/jbpm/graph/node/ProcessState.hbm.xml"/>
>> <mapping resource="org/jbpm/graph/node/Decision.hbm.xml"/>
>> <mapping resource="org/jbpm/graph/node/Fork.hbm.xml"/>
>> <mapping resource="org/jbpm/graph/node/Join.hbm.xml"/>
>> <mapping resource="org/jbpm/graph/node/State.hbm.xml"/>
>> <mapping resource="org/jbpm/graph/node/TaskNode.hbm.xml"/>
>>
>> <!-- context.def mapping files -->
>> <mapping resource="org/jbpm/context/def/ContextDefinition.hbm.xml"/>
>> <mapping resource="org/jbpm/context/def/VariableAccess.hbm.xml"/>
>>
>> <!-- taskmgmt.def mapping files -->
>> <mapping resource="org/jbpm/taskmgmt/def/TaskMgmtDefinition.hbm.xml"/>
>> <mapping resource="org/jbpm/taskmgmt/def/Swimlane.hbm.xml"/>
>> <mapping resource="org/jbpm/taskmgmt/def/Task.hbm.xml"/>
>> <mapping resource="org/jbpm/taskmgmt/def/TaskController.hbm.xml"/>
>>
>> <!-- module.def mapping files -->
>> <mapping resource="org/jbpm/module/def/ModuleDefinition.hbm.xml"/>
>>
>> <!-- bytes mapping files -->
>> <mapping resource="org/jbpm/bytes/ByteArray.hbm.xml"/>
>>
>> <!-- file.def mapping files -->
>> <mapping resource="org/jbpm/file/def/FileDefinition.hbm.xml"/>
>>
>> <!-- scheduler.def mapping files -->
>> <mapping resource="org/jbpm/scheduler/def/CreateTimerAction.hbm.xml"/>
>> <mapping resource="org/jbpm/scheduler/def/CancelTimerAction.hbm.xml"/>
>>
>> <!-- graph.exe mapping files -->
>> <mapping resource="org/jbpm/graph/exe/Comment.hbm.xml"/>
>> <mapping resource="org/jbpm/graph/exe/ProcessInstance.hbm.xml"/>
>> <mapping resource="org/jbpm/graph/exe/Token.hbm.xml"/>
>> <mapping resource="org/jbpm/graph/exe/RuntimeAction.hbm.xml"/>
>>
>> <!-- module.exe mapping files -->
>> <mapping resource="org/jbpm/module/exe/ModuleInstance.hbm.xml"/>
>>
>> <!-- context.exe mapping files -->
>> <mapping resource="org/jbpm/context/exe/ContextInstance.hbm.xml"/>
>> <mapping resource="org/jbpm/context/exe/TokenVariableMap.hbm.xml"/>
>> <mapping resource="org/jbpm/context/exe/VariableInstance.hbm.xml"/>
>> <mapping
>> resource="org/jbpm/context/exe/variableinstance/ByteArrayInstance.hbm.xml"/>
>> <mapping
>> resource="org/jbpm/context/exe/variableinstance/DateInstance.hbm.xml"/>
>> <mapping
>> resource="org/jbpm/context/exe/variableinstance/DoubleInstance.hbm.xml"/>
>> <mapping
>> resource="org/jbpm/context/exe/variableinstance/HibernateLongInstance.hbm.xml"/>
>> <mapping
>> resource="org/jbpm/context/exe/variableinstance/HibernateStringInstance.hbm.xml"/>
>> <mapping
>> resource="org/jbpm/context/exe/variableinstance/LongInstance.hbm.xml"/>
>> <mapping
>> resource="org/jbpm/context/exe/variableinstance/NullInstance.hbm.xml"/>
>> <mapping
>> resource="org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml"/>
>>
>> <!-- msg.db mapping files -->
>> <mapping resource="org/jbpm/msg/Message.hbm.xml"/>
>> <mapping resource="org/jbpm/msg/db/TextMessage.hbm.xml"/>
>> <mapping resource="org/jbpm/command/ExecuteActionCommand.hbm.xml"/>
>> <mapping resource="org/jbpm/command/ExecuteNodeCommand.hbm.xml"/>
>> <mapping resource="org/jbpm/command/SignalCommand.hbm.xml"/>
>> <mapping resource="org/jbpm/command/TaskInstanceEndCommand.hbm.xml"/>
>>
>> <!-- taskmgmt.exe mapping files -->
>> <mapping resource="org/jbpm/taskmgmt/exe/TaskMgmtInstance.hbm.xml"/>
>> <mapping resource="org/jbpm/taskmgmt/exe/TaskInstance.hbm.xml"/>
>> <mapping
>> resource="org/nuxeo/ecm/platform/workflow/jbpm/tasks/ExtendedTaskInstance.hbm.xml"/>
>> <mapping resource="org/jbpm/taskmgmt/exe/PooledActor.hbm.xml"/>
>> <mapping resource="org/jbpm/taskmgmt/exe/SwimlaneInstance.hbm.xml"/>
>>
>> <!-- scheduler.exe mapping files -->
>> <mapping resource="org/jbpm/scheduler/exe/Timer.hbm.xml"/>
>>
>> <!-- logging mapping files -->
>> <mapping resource="org/jbpm/logging/log/ProcessLog.hbm.xml"/>
>> <mapping resource="org/jbpm/logging/log/MessageLog.hbm.xml"/>
>> <mapping resource="org/jbpm/logging/log/CompositeLog.hbm.xml"/>
>> <mapping resource="org/jbpm/graph/log/ActionLog.hbm.xml"/>
>> <mapping resource="org/jbpm/graph/log/NodeLog.hbm.xml"/>
>> <mapping resource="org/jbpm/graph/log/ProcessInstanceCreateLog.hbm.xml"/>
>> <mapping resource="org/jbpm/graph/log/ProcessInstanceEndLog.hbm.xml"/>
>> <mapping resource="org/jbpm/graph/log/ProcessStateLog.hbm.xml"/>
>> <mapping resource="org/jbpm/graph/log/SignalLog.hbm.xml"/>
>> <mapping resource="org/jbpm/graph/log/TokenCreateLog.hbm.xml"/>
>> <mapping resource="org/jbpm/graph/log/TokenEndLog.hbm.xml"/>
>> <mapping resource="org/jbpm/graph/log/TransitionLog.hbm.xml"/>
>> <mapping resource="org/jbpm/context/log/VariableLog.hbm.xml"/>
>> <mapping resource="org/jbpm/context/log/VariableCreateLog.hbm.xml"/>
>> <mapping resource="org/jbpm/context/log/VariableDeleteLog.hbm.xml"/>
>> <mapping resource="org/jbpm/context/log/VariableUpdateLog.hbm.xml"/>
>> <mapping
>> resource="org/jbpm/context/log/variableinstance/ByteArrayUpdateLog.hbm.xml"/>
>> <mapping
>> resource="org/jbpm/context/log/variableinstance/DateUpdateLog.hbm.xml"/>
>> <mapping
>> resource="org/jbpm/context/log/variableinstance/DoubleUpdateLog.hbm.xml"/>
>> <mapping
>> resource="org/jbpm/context/log/variableinstance/HibernateLongUpdateLog.hbm.xml"/>
>> <mapping
>> resource="org/jbpm/context/log/variableinstance/HibernateStringUpdateLog.hbm.xml"/>
>> <mapping
>> resource="org/jbpm/context/log/variableinstance/LongUpdateLog.hbm.xml"/>
>> <mapping
>> resource="org/jbpm/context/log/variableinstance/StringUpdateLog.hbm.xml"/>
>> <mapping resource="org/jbpm/taskmgmt/log/TaskLog.hbm.xml"/>
>> <mapping resource="org/jbpm/taskmgmt/log/TaskCreateLog.hbm.xml"/>
>> <mapping resource="org/jbpm/taskmgmt/log/TaskAssignLog.hbm.xml"/>
>> <mapping resource="org/jbpm/taskmgmt/log/TaskEndLog.hbm.xml"/>
>> <mapping resource="org/jbpm/taskmgmt/log/SwimlaneLog.hbm.xml"/>
>> <mapping resource="org/jbpm/taskmgmt/log/SwimlaneCreateLog.hbm.xml"/>
>> <mapping resource="org/jbpm/taskmgmt/log/SwimlaneAssignLog.hbm.xml"/>
>>
>> </session-factory>
>> </hibernate-configuration>
>>
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> ECM mailing list
>> [EMAIL PROTECTED]
>> http://lists.nuxeo.com/mailman/listinfo/ecm
>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> 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
