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