1 Reply Latest reply on Nov 24, 2005 2:07 PM by Ronald van Kuijk

    Getting HSQLDB scripts instead of Oracle Scripts

    ch praveen Newbie

      Hi ,

      Iam trying to use oracle 8 as a back end. I tried to generate sql scripts for oracle with ant oracle.scripts command. It ran successfully but the scripts that got generated were meant for HSQLDB and they were placed in jbpm-db\build\oracle\scripts folder.

      I included hibernate.properties file in jbpm-db\oracle folder with respective settings done and oracle jdbc jar files in jbpm-db\oracle\lib folder of starters kit. I also modified build.properties to point to jbpm folder. Are there any other settings to be done to generate oracle scripts.

      D:\jbpm-starters-kit-3.0.1\jbpm-db\oracle\ hibernate.properties
      ---------------------------------------------------------------------------

      #hibernate.dialect=org.hibernate.dialect.Oracle9Dialect
      # for Oracle 8 compatibility use
      hibernate.dialect=org.hibernate.dialect.OracleDialect
      
      hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
      hibernate.connection.url=jdbc:oracle:thin:@251.17.160.10:1423:TEST
      hibernate.connection.username=testname
      hibernate.connection.password=testname
      
      hibernate.show_sql=true
      hibernate.c3p0.min_size=1
      hibernate.c3p0.max_size=3
      
      hibernate.query.substitutions=true 1, false 0
      



      Directory of D:\jbpm-starters-kit-3.0.1\jbpm-db\oracle\lib
      --------------------------------------------------------------------
      11/24/2005 07:52 PM <DIR> .
      11/24/2005 07:52 PM <DIR> ..
      04/26/2002 11:47 AM 1,033,402 classes111.jar
      04/26/2002 11:47 AM 1,043,528 classes111.zip
      04/26/2002 11:47 AM 1,196,109 classes12.jar
      04/26/2002 11:47 AM 1,207,068 classes12.zip
      04/26/2002 11:47 AM 1,201,552 classes12dms.jar
      04/26/2002 11:47 AM 1,781,005 nls_charset11.jar
      04/26/2002 11:47 AM 1,810,518 nls_charset11.zip
      04/26/2002 11:47 AM 1,781,898 nls_charset12.jar
      04/26/2002 11:47 AM 1,811,415 nls_charset12.zip
      04/26/2002 11:47 AM 36,640 ocrs12.jar
      04/26/2002 11:47 AM 36,664 ocrs12.zip
      04/26/2002 11:47 AM 1,174,976 ojdbc14.jar
      04/26/2002 11:47 AM 1,383,922 ojdbc14_g.jar
      09/05/2005 09:44 AM 0 put_jdbc_driver_here.txt
       14 File(s) 15,498,697 bytes
       2 Dir(s) 2,440,134,656 bytes free
      



      Console output for ant command
      --------------------------------------

      D:\jbpm-starters-kit-3.0.1\jbpm-db>%ant_home%\bin\ant oracle.scripts
      Buildfile: build.xml

      oracle.scripts:

      prepare:

      compile.jbpm:

      compile.jbpm.test:

      compile.identity:

      compile.webapp:

      compile.identity.test:

      compile.examples:

      compile:

      db.scripts:
      [delete] Deleting directory D:\jbpm-starters-kit-3.0.1\jbpm-db\build\oracle\scripts
      [mkdir] Created dir: D:\jbpm-starters-kit-3.0.1\jbpm-db\build\oracle\scripts
      [java] 20:20:05,880 DEBUG JbpmConfiguration : jbpm.session.factory.jndi.name=java:/jbpm/JbpmSessionFactory
      [java] 20:20:05,880 DEBUG JbpmConfiguration : jbpm.task.instance.class=org.jbpm.taskmgmt.exe.TaskInstance
      [java] 20:20:05,880 DEBUG JbpmConfiguration : jbpm.hibernate.cfg.xml=jbpm.hibernate.cfg.xml
      [java] 20:20:05,880 DEBUG JbpmConfiguration : jbpm.scheduler.service.factory=org.jbpm.scheduler.impl.SchedulerServiceImpl
      [java] 20:20:05,880 DEBUG JbpmConfiguration : jbpm.hibernate.properties=jbpm.hibernate.properties
      [java] 20:20:05,927 INFO Environment : Hibernate 3.0.5
      [java] 20:50:34,365 INFO Environment : loaded properties from resource hibernate.properties: {hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver, hibernate.cglib.use_reflection_optimizer=true, hibernate.c3p0.max_size=3, hibernate.dialect=org.hibernate.dialect.OracleDialect, hibernate.c3p0.min_size=1, hibernate.query.substitutions=true 1, false 0, hibernate.connection.username=testname, hibernate.connection.url=jdbc:oracle:thin:@251.17.160.10:1423:TEST, hibernate.show_sql=true, hibernate.connection.password=****}
      [java] 20:20:05,943 INFO Environment : using CGLIB reflection optimizer
      [java] 20:20:05,958 INFO Environment : using JDK 1.4 java.sql.Timestamp handling
      [java] 20:20:06,036 DEBUG JbpmSessionFactory : using 'jbpm.hibernate.cfg.xml' as hibernate configuration for jbpm
      [java] 20:20:06,036 INFO Configuration : configuring from resource: jbpm.hibernate.cfg.xml
      [java] 20:20:06,036 INFO Configuration : Configuration resource: jbpm.hibernate.cfg.xml
      [java] 20:20:06,505 INFO Configuration : Mapping resource: org/jbpm/identity/User.hbm.xml
      [java] 20:20:06,677 INFO HbmBinder : Mapping class: org.jbpm.identity.User -> JBPM_ID_USER
      [java] 20:20:06,708 INFO HbmBinder : Mapping collection: org.jbpm.identity.User.permissions -> JBPM_ID_PERMISSIONS
      [java] 20:20:06,708 INFO Configuration : Mapping resource: org/jbpm/identity/Group.hbm.xml
      [java] 20:20:06,771 INFO HbmBinder : Mapping class: org.jbpm.identity.Group -> JBPM_ID_GROUP
      [java] 20:20:06,771 INFO HbmBinder : Mapping collection: org.jbpm.identity.Group.permissions -> JBPM_ID_PERMISSIONS
      [java] 20:20:06,771 INFO Configuration : Mapping resource: org/jbpm/identity/Membership.hbm.xml
      [java] 20:20:06,818 INFO HbmBinder : Mapping class: org.jbpm.identity.Membership -> JBPM_ID_MEMBERSHIP
      [java] 20:20:06,880 INFO HbmBinder : Mapping collection: org.jbpm.identity.Membership.permissions -> JBPM_ID_PERMISSIONS
      [java] 20:20:06,880 INFO Configuration : Mapping resource: org/jbpm/graph/def/ProcessDefinition.hbm.xml
      [java] 20:20:06,927 INFO HbmBinder : Mapping class: org.jbpm.graph.def.ProcessDefinition -> JBPM_PROCESSDEFINITION
      [java] 20:20:06,958 INFO Configuration : Mapping resource: org/jbpm/graph/def/Node.hbm.xml
      [java] 20:20:07,005 INFO HbmBinder : Mapping class: org.jbpm.graph.def.Node -> JBPM_NODE
      [java] 20:20:07,005 INFO Configuration : Mapping resource: org/jbpm/graph/def/Transition.hbm.xml
      [java] 20:20:07,036 INFO HbmBinder : Mapping class: org.jbpm.graph.def.Transition -> JBPM_TRANSITION
      [java] 20:20:07,036 INFO Configuration : Mapping resource: org/jbpm/graph/def/Event.hbm.xml
      [java] 20:20:07,068 INFO HbmBinder : Mapping class: org.jbpm.graph.def.Event -> JBPM_EVENT
      [java] 20:20:07,068 INFO Configuration : Mapping resource: org/jbpm/graph/def/Action.hbm.xml
      [java] 20:20:07,083 INFO HbmBinder : Mapping class: org.jbpm.graph.def.Action -> JBPM_ACTION
      [java] 20:20:07,083 INFO Configuration : Mapping resource: org/jbpm/graph/def/SuperState.hbm.xml
      [java] 20:20:07,146 INFO HbmBinder : Mapping subclass: org.jbpm.graph.def.SuperState -> JBPM_NODE
      [java] 20:20:07,146 INFO Configuration : Mapping resource: org/jbpm/graph/def/ExceptionHandler.hbm.xml
      [java] 20:20:07,177 INFO HbmBinder : Mapping class: org.jbpm.graph.def.ExceptionHandler -> JBPM_EXCEPTIONHANDLER
      [java] 20:20:07,177 INFO Configuration : Mapping resource: org/jbpm/instantiation/Delegation.hbm.xml
      [java] 20:20:07,255 INFO HbmBinder : Mapping class: org.jbpm.instantiation.Delegation -> JBPM_DELEGATION
      [java] 20:20:07,255 INFO Configuration : Mapping resource: org/jbpm/graph/node/StartState.hbm.xml
      [java] 20:20:07,349 INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.StartState -> JBPM_NODE
      [java] 20:20:07,349 INFO Configuration : Mapping resource: org/jbpm/graph/node/EndState.hbm.xml
      [java] 20:20:07,365 INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.EndState -> JBPM_NODE
      [java] 20:20:07,365 INFO Configuration : Mapping resource: org/jbpm/graph/node/ProcessState.hbm.xml
      [java] 20:20:07,396 INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.ProcessState -> JBPM_NODE
      [java] 20:20:07,396 INFO Configuration : Mapping resource: org/jbpm/graph/node/Decision.hbm.xml
      [java] 20:20:07,427 INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.Decision -> JBPM_NODE
      [java] 20:20:07,427 INFO HbmBinder : Mapping collection: org.jbpm.graph.node.Decision.decisionConditions -> JBPM_DECISIONCONDITIONS
      [java] 20:20:07,427 INFO Configuration : Mapping resource: org/jbpm/graph/node/Fork.hbm.xml
      [java] 20:20:07,443 INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.Fork -> JBPM_NODE
      [java] 20:20:07,443 INFO Configuration : Mapping resource: org/jbpm/graph/node/Join.hbm.xml
      [java] 20:20:07,458 INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.Join -> JBPM_NODE
      [java] 20:20:07,458 INFO Configuration : Mapping resource: org/jbpm/graph/node/State.hbm.xml
      [java] 20:20:07,474 INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.State -> JBPM_NODE
      [java] 20:20:07,474 INFO Configuration : Mapping resource: org/jbpm/graph/node/TaskNode.hbm.xml
      [java] 20:20:07,505 INFO HbmBinder : Mapping subclass: org.jbpm.graph.node.TaskNode -> JBPM_NODE
      [java] 20:20:07,505 INFO Configuration : Mapping resource: org/jbpm/graph/action/Script.hbm.xml
      [java] 20:20:07,583 INFO HbmBinder : Mapping subclass: org.jbpm.graph.action.Script -> JBPM_ACTION
      [java] 20:20:07,599 INFO Configuration : Mapping resource: org/jbpm/context/def/ContextDefinition.hbm.xml
      [java] 20:20:07,615 INFO Configuration : Mapping resource: org/jbpm/context/def/VariableAccess.hbm.xml
      [java] 20:20:07,615 INFO HbmBinder : Mapping class: org.jbpm.context.def.VariableAccess -> JBPM_VARIABLEACCESS
      [java] 20:20:07,630 INFO Configuration : Mapping resource: org/jbpm/taskmgmt/def/TaskMgmtDefinition.hbm.xml
      [java] 20:20:07,646 INFO Configuration : Mapping resource: org/jbpm/taskmgmt/def/Swimlane.hbm.xml
      [java] 20:20:07,661 INFO HbmBinder : Mapping class: org.jbpm.taskmgmt.def.Swimlane -> JBPM_SWIMLANE
      [java] 20:20:07,661 INFO Configuration : Mapping resource: org/jbpm/taskmgmt/def/Task.hbm.xml
      [java] 20:20:07,693 INFO HbmBinder : Mapping class: org.jbpm.taskmgmt.def.Task -> JBPM_TASK
      [java] 20:20:07,693 INFO Configuration : Mapping resource: org/jbpm/taskmgmt/def/TaskController.hbm.xml
      [java] 20:20:07,708 INFO HbmBinder : Mapping class: org.jbpm.taskmgmt.def.TaskController -> JBPM_TASKCONTROLLER
      [java] 20:20:07,724 INFO Configuration : Mapping resource: org/jbpm/module/def/ModuleDefinition.hbm.xml
      [java] 20:20:07,740 INFO HbmBinder : Mapping class: org.jbpm.module.def.ModuleDefinition -> JBPM_MODULEDEFINITION
      [java] 20:20:07,740 INFO Configuration : Mapping resource: org/jbpm/bytes/ByteArray.hbm.xml
      [java] 20:20:07,755 INFO HbmBinder : Mapping class: org.jbpm.bytes.ByteArray -> JBPM_BYTEARRAY
      [java] 20:20:07,755 INFO HbmBinder : Mapping collection: org.jbpm.bytes.ByteArray.byteBlocks -> JBPM_BYTEBLOCK
      [java] 20:20:07,755 INFO Configuration : Mapping resource: org/jbpm/file/def/FileDefinition.hbm.xml
      [java] 20:20:07,833 INFO HbmBinder : Mapping subclass: org.jbpm.file.def.FileDefinition -> JBPM_MODULEDEFINITION
      [java] 20:20:07,833 INFO Configuration : Mapping resource: org/jbpm/scheduler/def/CreateTimerAction.hbm.xml
      [java] 20:20:07,849 INFO HbmBinder : Mapping subclass: org.jbpm.scheduler.def.CreateTimerAction -> JBPM_ACTION
      [java] 20:20:07,865 INFO Configuration : Mapping resource: org/jbpm/scheduler/def/CancelTimerAction.hbm.xml
      [java] 20:20:07,865 INFO HbmBinder : Mapping subclass: org.jbpm.scheduler.def.CancelTimerAction -> JBPM_ACTION
      [java] 20:20:07,865 INFO Configuration : Mapping resource: org/jbpm/graph/exe/Comment.hbm.xml
      [java] 20:20:07,880 INFO HbmBinder : Mapping class: org.jbpm.graph.exe.Comment -> JBPM_COMMENT
      [java] 20:20:07,896 INFO Configuration : Mapping resource: org/jbpm/graph/exe/ProcessInstance.hbm.xml
      [java] 20:20:07,911 INFO HbmBinder : Mapping class: org.jbpm.graph.exe.ProcessInstance -> JBPM_PROCESSINSTANCE
      [java] 20:20:07,911 INFO Configuration : Mapping resource: org/jbpm/graph/exe/Token.hbm.xml
      [java] 20:20:07,927 INFO HbmBinder : Mapping class: org.jbpm.graph.exe.Token -> JBPM_TOKEN
      [java] 20:20:07,943 INFO Configuration : Mapping resource: org/jbpm/graph/exe/RuntimeAction.hbm.xml
      [java] 20:20:07,958 INFO HbmBinder : Mapping class: org.jbpm.graph.exe.RuntimeAction -> JBPM_RUNTIMEACTION
      [java] 20:20:07,958 INFO Configuration : Mapping resource: org/jbpm/module/exe/ModuleInstance.hbm.xml
      [java] 20:20:07,974 INFO HbmBinder : Mapping class: org.jbpm.module.exe.ModuleInstance -> JBPM_MODULEINSTANCE
      [java] 20:20:07,974 INFO Configuration : Mapping resource: org/jbpm/context/exe/ContextInstance.hbm.xml
      [java] 20:20:07,990 INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.ContextInstance -> JBPM_MODULEINSTANCE
      [java] 20:20:07,990 INFO Configuration : Mapping resource: org/jbpm/context/exe/TokenVariableMap.hbm.xml
      [java] 20:20:08,052 INFO HbmBinder : Mapping class: org.jbpm.context.exe.TokenVariableMap -> JBPM_TOKENVARIABLEMAP
      [java] 20:20:08,068 INFO Configuration : Mapping resource: org/jbpm/context/exe/VariableInstance.hbm.xml
      [java] 20:20:08,083 INFO HbmBinder : Mapping class: org.jbpm.context.exe.VariableInstance -> JBPM_VARIABLEINSTANCE
      [java] 20:20:08,083 INFO Configuration : Mapping resource: org/jbpm/context/exe/variableinstance/ByteArrayInstance.hbm.xml
      [java] 20:20:08,099 INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.ByteArrayInstance -> JBPM_VARIABLEINSTANCE
      [java] 20:20:08,099 INFO Configuration : Mapping resource: org/jbpm/context/exe/variableinstance/DateInstance.hbm.xml
      [java] 20:20:08,115 INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.DateInstance -> JBPM_VARIABLEINSTANCE
      [java] 20:20:08,115 INFO Configuration : Mapping resource: org/jbpm/context/exe/variableinstance/DoubleInstance.hbm.xml
      [java] 20:20:08,130 INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.DoubleInstance -> JBPM_VARIABLEINSTANCE
      [java] 20:20:08,130 INFO Configuration : Mapping resource: org/jbpm/context/exe/variableinstance/HibernateLongInstance.hbm.xml
      [java] 20:20:08,146 INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.HibernateLongInstance -> JBPM_VARIABLEINSTANCE
      [java] 20:20:08,146 INFO Configuration : Mapping resource: org/jbpm/context/exe/variableinstance/HibernateStringInstance.hbm.xml
      [java] 20:20:08,161 INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.HibernateStringInstance -> JBPM_VARIABLEINSTANCE
      [java] 20:20:08,161 INFO Configuration : Mapping resource: org/jbpm/context/exe/variableinstance/LongInstance.hbm.xml
      [java] 20:20:08,161 INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.LongInstance -> JBPM_VARIABLEINSTANCE
      [java] 20:20:08,161 INFO Configuration : Mapping resource: org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml
      [java] 20:20:08,193 INFO HbmBinder : Mapping subclass: org.jbpm.context.exe.variableinstance.StringInstance -> JBPM_VARIABLEINSTANCE
      [java] 20:20:08,193 INFO Configuration : Mapping resource: org/jbpm/taskmgmt/exe/TaskMgmtInstance.hbm.xml
      [java] 20:20:08,193 INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.exe.TaskMgmtInstance -> JBPM_MODULEINSTANCE
      [java] 20:20:08,208 INFO Configuration : Mapping resource: org/jbpm/taskmgmt/exe/TaskInstance.hbm.xml
      [java] 20:20:08,224 INFO HbmBinder : Mapping class: org.jbpm.taskmgmt.exe.TaskInstance -> JBPM_TASKINSTANCE
      [java] 20:20:08,224 INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.exe.TaskInstance.pooledActors -> JBPM_TASKACTORPOOL
      [java] 20:20:08,224 INFO Configuration : Mapping resource: org/jbpm/taskmgmt/exe/PooledActor.hbm.xml
      [java] 20:20:08,240 INFO HbmBinder : Mapping class: org.jbpm.taskmgmt.exe.PooledActor -> JBPM_POOLEDACTOR
      [java] 20:20:08,240 INFO HbmBinder : Mapping collection: org.jbpm.taskmgmt.exe.PooledActor.taskInstances -> JBPM_TASKACTORPOOL
      [java] 20:20:08,240 INFO Configuration : Mapping resource: org/jbpm/taskmgmt/exe/SwimlaneInstance.hbm.xml
      [java] 20:20:08,396 INFO HbmBinder : Mapping class: org.jbpm.taskmgmt.exe.SwimlaneInstance -> JBPM_SWIMLANEINSTANCE
      [java] 20:20:08,411 INFO Configuration : Mapping resource: org/jbpm/scheduler/exe/Timer.hbm.xml
      [java] 20:20:08,427 INFO HbmBinder : Mapping class: org.jbpm.scheduler.exe.Timer -> JBPM_TIMER
      [java] 20:20:08,427 INFO Configuration : Mapping resource: org/jbpm/logging/log/ProcessLog.hbm.xml
      [java] 20:20:08,443 INFO HbmBinder : Mapping class: org.jbpm.logging.log.ProcessLog -> JBPM_LOG
      [java] 20:20:08,443 INFO Configuration : Mapping resource: org/jbpm/logging/log/MessageLog.hbm.xml
      [java] 20:20:08,443 INFO HbmBinder : Mapping subclass: org.jbpm.logging.log.MessageLog -> JBPM_LOG
      [java] 20:20:08,458 INFO Configuration : Mapping resource: org/jbpm/logging/log/CompositeLog.hbm.xml
      [java] 20:20:08,458 INFO HbmBinder : Mapping subclass: org.jbpm.logging.log.CompositeLog -> JBPM_LOG
      [java] 20:20:08,458 INFO Configuration : Mapping resource: org/jbpm/graph/log/ActionLog.hbm.xml
      [java] 20:20:08,474 INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.ActionLog -> JBPM_LOG
      [java] 20:20:08,490 INFO Configuration : Mapping resource: org/jbpm/graph/log/NodeLog.hbm.xml
      [java] 20:20:08,490 INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.NodeLog -> JBPM_LOG
      [java] 20:20:08,505 INFO Configuration : Mapping resource: org/jbpm/graph/log/ProcessInstanceCreateLog.hbm.xml
      [java] 20:20:08,505 INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.ProcessInstanceCreateLog -> JBPM_LOG
      [java] 20:20:08,505 INFO Configuration : Mapping resource: org/jbpm/graph/log/ProcessInstanceEndLog.hbm.xml
      [java] 20:20:08,521 INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.ProcessInstanceEndLog -> JBPM_LOG
      [java] 20:20:08,521 INFO Configuration : Mapping resource: org/jbpm/graph/log/SignalLog.hbm.xml
      [java] 20:20:08,536 INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.SignalLog -> JBPM_LOG
      [java] 20:20:08,536 INFO Configuration : Mapping resource: org/jbpm/graph/log/TokenCreateLog.hbm.xml
      [java] 20:20:08,552 INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.TokenCreateLog -> JBPM_LOG
      [java] 20:20:08,552 INFO Configuration : Mapping resource: org/jbpm/graph/log/TokenEndLog.hbm.xml
      [java] 20:20:08,552 INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.TokenEndLog -> JBPM_LOG
      [java] 20:20:08,568 INFO Configuration : Mapping resource: org/jbpm/graph/log/TransitionLog.hbm.xml
      [java] 20:20:08,630 INFO HbmBinder : Mapping subclass: org.jbpm.graph.log.TransitionLog -> JBPM_LOG
      [java] 20:20:08,630 INFO Configuration : Mapping resource: org/jbpm/context/log/VariableLog.hbm.xml
      [java] 20:20:08,646 INFO HbmBinder : Mapping subclass: org.jbpm.context.log.VariableLog -> JBPM_LOG
      [java] 20:20:08,646 INFO Configuration : Mapping resource: org/jbpm/context/log/VariableCreateLog.hbm.xml
      [java] 20:20:08,661 INFO HbmBinder : Mapping subclass: org.jbpm.context.log.VariableCreateLog -> JBPM_LOG
      [java] 20:20:08,661 INFO Configuration : Mapping resource: org/jbpm/context/log/VariableDeleteLog.hbm.xml
      [java] 20:20:08,661 INFO HbmBinder : Mapping subclass: org.jbpm.context.log.VariableDeleteLog -> JBPM_LOG
      [java] 20:20:08,677 INFO Configuration : Mapping resource: org/jbpm/context/log/VariableUpdateLog.hbm.xml
      [java] 20:20:08,693 INFO HbmBinder : Mapping subclass: org.jbpm.context.log.VariableUpdateLog -> JBPM_LOG
      [java] 20:20:08,693 INFO Configuration : Mapping resource: org/jbpm/context/log/variableinstance/ByteArrayUpdateLog.hbm.xml
      [java] 20:20:08,693 INFO HbmBinder : Mapping subclass: org.jbpm.context.log.variableinstance.ByteArrayUpdateLog -> JBPM_LOG
      [java] 20:20:08,708 INFO Configuration : Mapping resource: org/jbpm/context/log/variableinstance/DateUpdateLog.hbm.xml
      [java] 20:20:08,708 INFO HbmBinder : Mapping subclass: org.jbpm.context.log.variableinstance.DateUpdateLog -> JBPM_LOG
      [java] 20:20:08,708 INFO Configuration : Mapping resource: org/jbpm/context/log/variableinstance/DoubleUpdateLog.hbm.xml
      [java] 20:20:08,724 INFO HbmBinder : Mapping subclass: org.jbpm.context.log.variableinstance.DoubleUpdateLog -> JBPM_LOG
      [java] 20:20:08,724 INFO Configuration : Mapping resource: org/jbpm/context/log/variableinstance/HibernateLongUpdateLog.hbm.xml
      [java] 20:20:08,740 INFO HbmBinder : Mapping subclass: org.jbpm.context.log.variableinstance.HibernateLongUpdateLog -> JBPM_LOG
      [java] 20:20:08,740 INFO Configuration : Mapping resource: org/jbpm/context/log/variableinstance/HibernateStringUpdateLog.hbm.xml
      [java] 20:20:08,755 INFO HbmBinder : Mapping subclass: org.jbpm.context.log.variableinstance.HibernateStringUpdateLog -> JBPM_LOG
      [java] 20:20:08,755 INFO Configuration : Mapping resource: org/jbpm/context/log/variableinstance/LongUpdateLog.hbm.xml
      [java] 20:20:08,771 INFO HbmBinder : Mapping subclass: org.jbpm.context.log.variableinstance.LongUpdateLog -> JBPM_LOG
      [java] 20:20:08,771 INFO Configuration : Mapping resource: org/jbpm/context/log/variableinstance/StringUpdateLog.hbm.xml
      [java] 20:20:08,786 INFO HbmBinder : Mapping subclass: org.jbpm.context.log.variableinstance.StringUpdateLog -> JBPM_LOG
      [java] 20:20:08,786 INFO Configuration : Mapping resource: org/jbpm/taskmgmt/log/TaskLog.hbm.xml
      [java] 20:20:08,802 INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.log.TaskLog -> JBPM_LOG
      [java] 20:20:08,802 INFO Configuration : Mapping resource: org/jbpm/taskmgmt/log/TaskCreateLog.hbm.xml
      [java] 20:20:08,802 INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.log.TaskCreateLog -> JBPM_LOG
      [java] 20:20:08,818 INFO Configuration : Mapping resource: org/jbpm/taskmgmt/log/TaskAssignLog.hbm.xml
      [java] 20:20:08,833 INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.log.TaskAssignLog -> JBPM_LOG
      [java] 20:20:08,833 INFO Configuration : Mapping resource: org/jbpm/taskmgmt/log/TaskEndLog.hbm.xml
      [java] 20:20:08,896 INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.log.TaskEndLog -> JBPM_LOG
      [java] 20:20:08,911 INFO Configuration : Mapping resource: org/jbpm/taskmgmt/log/SwimlaneLog.hbm.xml
      [java] 20:20:08,911 INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.log.SwimlaneLog -> JBPM_LOG
      [java] 20:20:08,911 INFO Configuration : Mapping resource: org/jbpm/taskmgmt/log/SwimlaneCreateLog.hbm.xml
      [java] 20:20:08,927 INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.log.SwimlaneCreateLog -> JBPM_LOG
      [java] 20:20:08,927 INFO Configuration : Mapping resource: org/jbpm/taskmgmt/log/SwimlaneAssignLog.hbm.xml
      [java] 20:20:08,943 INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.log.SwimlaneAssignLog -> JBPM_LOG
      [java] 20:20:08,943 INFO Configuration : Configured SessionFactory: null
      [java] 20:20:08,943 DEBUG JbpmSessionFactory : overriding hibernate properties with {hibernate.dialect=org.hibernate.dialect.HSQLDialect, hibernate.connection.datasource=java:/DefaultDS}
      [java] 20:20:08,974 INFO Dialect : Using dialect: org.hibernate.dialect.HSQLDialect

      [java] 20:20:08,974 INFO Configuration : processing extends queue
      [java] 20:20:08,974 INFO HbmBinder : Mapping subclass: org.jbpm.context.def.ContextDefinition -> JBPM_MODULEDEFINITION
      [java] 20:20:08,974 INFO HbmBinder : Mapping subclass: org.jbpm.taskmgmt.def.TaskMgmtDefinition -> JBPM_MODULEDEFINITION
      [java] 20:20:08,990 INFO Configuration : processing collection mappings
      [java] 20:20:08,990 INFO HbmBinder : Mapping collection: org.jbpm.identity.User.memberships -> JBPM_ID_MEMBERSHIP
      [java] 20:20:08,990 INFO HbmBinder : Mapping collection: org.jbpm.identity.Group.memberships -> JBPM_ID_MEMBERSHIP
      ......... [CONTINUED LIKE THIS AND ENDED SUCCESFULLY IN 9 SECS]
      .........


      By observing lines which are in bold, initially it loaded settings from D:\jbpm-starters-kit-3.0.1\jbpm-db\oracle\hibernate.properties file [meant for oracle] afterwards it overrided it with hsqldb settings. I need to map the database to oracle and finally after testing in jboss , I have to move my application to websphere. What can be reson for above problem.

      Thanks in advance