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]
[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
_______________________________________________
ECM mailing list
[EMAIL PROTECTED]
http://lists.nuxeo.com/mailman/listinfo/ecm
