Hi Julien,
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 ...
Regards.
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
