Thanx.
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]
>>>
>>> damien.metzler ext.leroymerlin.fr 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, ecm-bounceslists.nuxeo.com 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
>>>>> ECMlists.nuxeo.com
>>>>> http://li
sts.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
>>>> ECMlists.nuxeo.com
>>>> http://li
sts.nuxeo.com/mailman/listinfo/ecm
>>>>
>>>
>>>
>>>
------------------------------------------------------------
------------
>>>
>>>
_______________________________________________
>>> ECM mailing list
>>> ECMlists.nuxeo.com
>>> http://li
sts.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/hiber
nate-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:/nx
workflowjbpm</property>
>>
>> <property
name="hibernate.hbm2ddl.auto">update</proper
ty>
>>
>> <!-- other hibernate properties
>> <property
name="hibernate.show_sql">true</property>
>> <property
name="hibernate.format_sql">true</property&g
t;
>> <property
name="hibernate.use_sql_comments">true</prop
erty>
>> -->
>>
>> <!--
############################################ -->
>> <!-- # mapping files with external
dependencies # -->
>> <!--
######################################### ### -->
>>
>> <!-- following mapping file has a dependendy
on -->
>> <!-- 'bsh-.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"/&g
t;
>>
>> <!-- following mapping files have a
dependendy on -->
>> <!-- 'jbpm-identity-.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"/&g
t;
>>
>> <!-- ###################### -->
>> <!-- # jbpm mapping files # -->
>> <!-- ###################### -->
>>
>> <!-- hql queries and type defs -->
>> <mapping
resource="org/nuxeo/ecm/platform/workflow/jbpm/db/hiber
nate.queries.hbm.xml" />
>>
>> <!-- graph.def mapping files -->
>> <mapping
resource="org/jbpm/graph/def/ProcessDefinition.hbm.xml&
quot;/>
>> <mapping
resource="org/jbpm/graph/def/Node.hbm.xml"/>
>> <mapping
resource="org/jbpm/graph/def/Transition.hbm.xml"/&
gt;
>> <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"/&
gt;
>> <mapping
resource="org/jbpm/graph/def/ExceptionHandler.hbm.xml&q
uot;/>
>> <mapping
resource="org/jbpm/instantiation/Delegation.hbm.xml&quo
t;/>
>>
>> <!-- graph.node mapping files -->
>> <mapping
resource="org/jbpm/graph/node/StartState.hbm.xml"/
>
>> <mapping
resource="org/jbpm/graph/node/EndState.hbm.xml"/&g
t;
>> <mapping
resource="org/jbpm/graph/node/ProcessState.hbm.xml"
;/>
>> <mapping
resource="org/jbpm/graph/node/Decision.hbm.xml"/&g
t;
>> <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"/&g
t;
>>
>> <!-- context.def mapping files -->
>> <mapping
resource="org/jbpm/context/def/ContextDefinition.hbm.xm
l"/>
>> <mapping
resource="org/jbpm/context/def/VariableAccess.hbm.xml&q
uot;/>
>>
>> <!-- 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&
quot;/>
>>
>> <!-- module.def mapping files -->
>> <mapping
resource="org/jbpm/module/def/ModuleDefinition.hbm.xml&
quot;/>
>>
>> <!-- 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&qu
ot;/>
>> <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&qu
ot;/>
>>
>> <!-- context.exe mapping files -->
>> <mapping
resource="org/jbpm/context/exe/ContextInstance.hbm.xml&
quot;/>
>> <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/ByteArr
ayInstance.hbm.xml"/>
>> <mapping
resource="org/jbpm/context/exe/variableinstance/DateIns
tance.hbm.xml"/>
>> <mapping
resource="org/jbpm/context/exe/variableinstance/DoubleI
nstance.hbm.xml"/>
>> <mapping
resource="org/jbpm/context/exe/variableinstance/Hiberna
teLongInstance.hbm.xml"/>
>> <mapping
resource="org/jbpm/context/exe/variableinstance/Hiberna
teStringInstance.hbm.xml"/>
>> <mapping
resource="org/jbpm/context/exe/variableinstance/LongIns
tance.hbm.xml"/>
>> <mapping
resource="org/jbpm/context/exe/variableinstance/NullIns
tance.hbm.xml"/>
>> <mapping
resource="org/jbpm/context/exe/variableinstance/StringI
nstance.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&q
uot;/>
>> <mapping
resource="org/jbpm/command/SignalCommand.hbm.xml"/
>
>> <mapping
resource="org/jbpm/command/TaskInstanceEndCommand.hbm.x
ml"/>
>>
>> <!-- taskmgmt.exe mapping files -->
>> <mapping
resource="org/jbpm/taskmgmt/exe/TaskMgmtInstance.hbm.xm
l"/>
>> <mapping
resource="org/jbpm/taskmgmt/exe/TaskInstance.hbm.xml&qu
ot;/>
>> <mapping
resource="org/nuxeo/ecm/platform/workflow/jbpm/tasks/Ex
tendedTaskInstance.hbm.xml"/>
>> <mapping
resource="org/jbpm/taskmgmt/exe/PooledActor.hbm.xml&quo
t;/>
>> <mapping
resource="org/jbpm/taskmgmt/exe/SwimlaneInstance.hbm.xm
l"/>
>>
>> <!-- scheduler.exe mapping files -->
>> <mapping
resource="org/jbpm/scheduler/exe/Timer.hbm.xml"/&g
t;
>>
>> <!-- 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&quo
t;/>
>> <mapping
resource="org/jbpm/graph/log/ActionLog.hbm.xml"/&g
t;
>> <mapping
resource="org/jbpm/graph/log/NodeLog.hbm.xml"/>
>> <mapping
resource="org/jbpm/graph/log/ProcessInstanceCreateLog.h
bm.xml"/>
>> <mapping
resource="org/jbpm/graph/log/ProcessInstanceEndLog.hbm.
xml"/>
>> <mapping
resource="org/jbpm/graph/log/ProcessStateLog.hbm.xml&qu
ot;/>
>> <mapping
resource="org/jbpm/graph/log/SignalLog.hbm.xml"/&g
t;
>> <mapping
resource="org/jbpm/graph/log/TokenCreateLog.hbm.xml&quo
t;/>
>> <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.xm
l"/>
>> <mapping
resource="org/jbpm/context/log/VariableDeleteLog.hbm.xm
l"/>
>> <mapping
resource="org/jbpm/context/log/VariableUpdateLog.hbm.xm
l"/>
>> <mapping
resource="org/jbpm/context/log/variableinstance/ByteArr
ayUpdateLog.hbm.xml"/>
>> <mapping
resource="org/jbpm/context/log/variableinstance/DateUpd
ateLog.hbm.xml"/>
>> <mapping
resource="org/jbpm/context/log/variableinstance/DoubleU
pdateLog.hbm.xml"/>
>> <mapping
resource="org/jbpm/context/log/variableinstance/Hiberna
teLongUpdateLog.hbm.xml"/>
>> <mapping
resource="org/jbpm/context/log/variableinstance/Hiberna
teStringUpdateLog.hbm.xml"/>
>> <mapping
resource="org/jbpm/context/log/variableinstance/LongUpd
ateLog.hbm.xml"/>
>> <mapping
resource="org/jbpm/context/log/variableinstance/StringU
pdateLog.hbm.xml"/>
>> <mapping
resource="org/jbpm/taskmgmt/log/TaskLog.hbm.xml"/&
gt;
>> <mapping
resource="org/jbpm/taskmgmt/log/TaskCreateLog.hbm.xml&q
uot;/>
>> <mapping
resource="org/jbpm/taskmgmt/log/TaskAssignLog.hbm.xml&q
uot;/>
>> <mapping
resource="org/jbpm/taskmgmt/log/TaskEndLog.hbm.xml"
;/>
>> <mapping
resource="org/jbpm/taskmgmt/log/SwimlaneLog.hbm.xml&quo
t;/>
>> <mapping
resource="org/jbpm/taskmgmt/log/SwimlaneCreateLog.hbm.x
ml"/>
>> <mapping
resource="org/jbpm/taskmgmt/log/SwimlaneAssignLog.hbm.x
ml"/>
>>
>> </session-factory>
>> </hibernate-configuration>
>>
>>
>>
------------------------------------------------------------
------------
>>
>> _______________________________________________
>> ECM mailing list
>> ECMlists.nuxeo.com
>> http://li
sts.nuxeo.com/mailman/listinfo/ecm
>
>
>
>
------------------------------------------------------------
------------
>
> _______________________________________________
> ECM mailing list
> ECMlists.nuxeo.com
> http://li
sts.nuxeo.com/mailman/listinfo/ecm
_______________________________________________
ECM mailing list
ECMlists.nuxeo.com
http://li
sts.nuxeo.com/mailman/listinfo/ecm
|
