5 Replies Latest reply on Jun 28, 2006 6:43 AM by Ronald van Kuijk

    Database exportation

    auré manga Novice

      Hi all,

      I try to develop a Jbpm portlet in the Jboss portal.
      when I execute my process I want to use the login in order to assign my poeple to a specific task. In order to do this I use Jbpmcontext class which need to work with hibernate and un database. I have seen in the jbpm that the database of base is HSQL but I don't know how can I export this database in jboss portal.

      Must I copy the hsql files in a specific folder in Jboss portal or put in my portlet war?

      Somebody can help me please?

      thank you for your help.

      antitrust1982

        • 1. Re: Database exportation
          David Hosier Novice

          This does not sound like a jBPM question to me. However, I can clear up one misconception it sounds like you have. You can use any DBMS you want with jBPM, not just HSQL. There is a section in the User Guide that discusses how to setup the database. You should not use HSQL for any production-level application anyway...at least that's been the advice from JBoss folks in the past.

          • 2. Re: Database exportation
            auré manga Novice

            hi,

            I don't want to install a database more. I just know where I must put the hsql folder and files in order to use it with my jbpm portlet. must I put this files in the portlet war file? or must I put in the jboss portal folder? and if yes where? because I use the hibernate.cfg.xml file of webapp in my portlet in order to link the both but I don't find in the documentation where I must put the HSQL database in order to make working the database

            thank you for your response and advice, I prefer use HSQL that install another database and polute my server of database.

            antitrust1982

            • 3. Re: Database exportation
              Ronald van Kuijk Master

              Wrong choice, HSQLDB is NOT for full blown production environments. It's not performing at all. With 200 tasks assigned the performance already drops if multiple users are accessing the system

              • 4. Re: Database exportation
                auré manga Novice

                hi,

                So I decide to use MySQL, but I can find in the documentation how configure the hibernate.cfg.xml. Somebody, can give me some advises or a documentation which can explain how change this file:

                <?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.HSQLDialect</property>
                 <property name="hibernate.connection.driver_class">org.hsqldb.jdbcDriver</property>
                 <property name="hibernate.connection.url">jdbc:hsqldb:mem:.;sql.enforce_strict_size=true</property>
                 <property name="hibernate.connection.username">sa</property>
                 <property name="hibernate.connection.password"></property>
                
                 <!-- other hibernate properties
                 <property name="hibernate.show_sql">true</property>
                 <property name="hibernate.format_sql">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/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/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/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>
                


                This files correspond to the hibernate.cfg.xml of the jbpm webapp.

                Thank you for your response and your help.

                antitrust1982

                • 5. Re: Database exportation
                  Ronald van Kuijk Master

                  Search the hibernate docs, forums, etc or maybe even search the jbpm forums, wiki, doc etc.

                  There are some things you have to learn yourself