3 Replies Latest reply on Apr 8, 2009 1:49 PM by karthizap

    Deploying Jbpm BPEL with PostGres

    dhanushgopinath

      Hi,

      I want to deploy the JBPM Bpel 1.1.1 on Postgres DB. What all changes should I make to the configurations?

      I edited the jbpm-ds.xml like this.

      <?xml version="1.0" encoding="UTF-8"?>
      
      <!-- The Hypersonic embedded database JCA connection factory config -->
      
      <!-- $Id: hsqldb-ds.xml 71535 2008-04-01 07:05:03Z adrian@jboss.org $ -->
      
      <datasources>
       <local-tx-datasource>
      
       <!-- The jndi name of the DataSource, it is prefixed with java:/ -->
       <!-- Datasources are not available outside the virtual machine -->
       <jndi-name>JbpmDS</jndi-name>
      
       <!-- For in-process persistent db, saved when jboss stops.
       The org.jboss.jdbc.HypersonicDatabase mbean is required for proper db shutdown
       -->
       <connection-url>jdbc:postgresql://localhost:5432/JbpmDB</connection-url>
      
       <!-- The driver class -->
       <driver-class>org.postgresql.Driver</driver-class>
      
       <!-- The login and password -->
       <user-name>postgres</user-name>
       <password>postgres</password>
      
       <!-- The minimum connections in a pool/sub-pool. Pools are lazily constructed on first use -->
       <min-pool-size>5</min-pool-size>
      
       <!-- The maximum connections in a pool/sub-pool -->
       <max-pool-size>20</max-pool-size>
      
       <!-- The time before an unused connection is destroyed -->
       <!-- NOTE: This is the check period. It will be destroyed somewhere between 1x and 2x this timeout after last use -->
       <!-- TEMPORARY FIX! - Disable idle connection removal, HSQLDB has a problem with not reaping threads on closed connections -->
       <idle-timeout-minutes>0</idle-timeout-minutes>
      
       <!-- Whether to check all statements are closed when the connection is returned to the pool,
       this is a debugging feature that should be turned off in production -->
       <track-statements/>
      
       <!-- HSQL DB benefits from prepared statement caching -->
       <prepared-statement-cache-size>32</prepared-statement-cache-size>
      
       <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
       <metadata>
       <type-mapping>PostgreSQL 8.3</type-mapping>
       </metadata>
      
       <!-- When using in-process (standalone) mode
       <depends>jboss:service=Hypersonic,database=JbpmDB</depends>-->
       <!-- Uncomment when using hsqldb in server mode
       <depends>jboss:service=Hypersonic</depends>
       -->
       </local-tx-datasource>
      
       <!-- For hsqldb accessed from jboss only, in-process (standalone) mode -->
       <!-- <mbean code="org.jboss.jdbc.HypersonicDatabase"
       name="jboss:service=Hypersonic,database=JbpmDB">
       <attribute name="Database">JbpmDB</attribute>
       <attribute name="InProcessMode">true</attribute>
       </mbean>
       -->
      </datasources>
      


      But its throwing out this exception while deploying jbpm bpel
      
      2009-01-20 15:04:36,291 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/jbpm-bpel]] Exception sending context initialized event to listener instance of class org.jbpm.bpel.web.JbpmConfigurationLoader
      org.jbpm.JbpmException: could not retrieve message destination
       at org.jbpm.msg.jms.JmsMessageServiceFactoryImpl.getDestination(JmsMessageServiceFactoryImpl.java:86)
       at org.jbpm.msg.jms.JmsMessageServiceFactoryImpl.openService(JmsMessageServiceFactoryImpl.java:112)
       at org.jbpm.svc.Services.getService(Services.java:150)
       at org.jbpm.svc.Services.getMessageService(Services.java:186)
       at org.jbpm.bpel.web.JbpmConfigurationLoader.contextInitialized(JbpmConfigurationLoader.java:54)
       at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3854)
       at org.apache.catalina.core.StandardContext.start(StandardContext.java:4359)
       at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:761)
       at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:741)
       at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:553)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:297)
       at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
       at org.apache.catalina.core.StandardContext.init(StandardContext.java:5310)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:297)
       at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
       at org.jboss.web.tomcat.service.TomcatDeployer.performDeployInternal(TomcatDeployer.java:301)
       at org.jboss.web.tomcat.service.TomcatDeployer.performDeploy(TomcatDeployer.java:104)
       at org.jboss.web.AbstractWebDeployer.start(AbstractWebDeployer.java:375)
       at org.jboss.web.WebModule.startModule(WebModule.java:83)
       at org.jboss.web.WebModule.startService(WebModule.java:61)
       at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
       at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
       at sun.reflect.GeneratedMethodAccessor121.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
       at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
       at $Proxy0.start(Unknown Source)
       at org.jboss.system.ServiceController.start(ServiceController.java:417)
       at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
       at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
       at $Proxy45.start(Unknown Source)
       at org.jboss.web.AbstractWebContainer.start(AbstractWebContainer.java:466)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
       at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
       at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
       at org.jboss.mx.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:97)
       at org.jboss.system.InterceptorServiceMBeanSupport.invokeNext(InterceptorServiceMBeanSupport.java:238)
       at org.jboss.ws.integration.jboss42.DeployerInterceptor.start(DeployerInterceptor.java:93)
       at org.jboss.deployment.SubDeployerInterceptorSupport$XMBeanInterceptor.start(SubDeployerInterceptorSupport.java:188)
       at org.jboss.deployment.SubDeployerInterceptor.invoke(SubDeployerInterceptor.java:95)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
       at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
       at $Proxy46.start(Unknown Source)
       at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
       at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1015)
       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
       at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
       at sun.reflect.GeneratedMethodAccessor18.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       at java.lang.reflect.Method.invoke(Method.java:585)
       at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
       at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
       at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
       at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
       at $Proxy9.deploy(Unknown Source)
       at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
       at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)
       at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
       at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:274)
       at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:225)
      Caused by: javax.naming.NamingException: Could not dereference object [Root exception is javax.naming.NameNotFoundException: JbpmJobQueue not bound]
       at org.jnp.interfaces.NamingContext.resolveLink(NamingContext.java:1067)
       at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:700)
       at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:716)
       at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:587)
       at javax.naming.InitialContext.lookup(InitialContext.java:351)
       at org.jbpm.msg.jms.JmsMessageServiceFactoryImpl.lookup(JmsMessageServiceFactoryImpl.java:95)
       at org.jbpm.msg.jms.JmsMessageServiceFactoryImpl.getDestination(JmsMessageServiceFactoryImpl.java:83)
       ... 94 more
      Caused by: javax.naming.NameNotFoundException: JbpmJobQueue not bound
       at org.jnp.server.NamingServer.getBinding(NamingServer.java:529)
       at org.jnp.server.NamingServer.getBinding(NamingServer.java:537)
       at org.jnp.server.NamingServer.getObject(NamingServer.java:543)
       at org.jnp.server.NamingServer.lookup(NamingServer.java:296)
       at org.jnp.server.NamingServer.lookup(NamingServer.java:270)
       at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:625)
       at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:587)
       at javax.naming.InitialContext.lookup(InitialContext.java:351)
       at org.jnp.interfaces.NamingContext.resolveLink(NamingContext.java:1061)
      


      The jbpm-hibernate.cfg.xml file is as given

      <?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>
      
       <!-- SQL dialect -->
      <property name="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</property>
       <property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>
      
       <!-- JDBC connection properties (begin) ===
       <property name="hibernate.connection.driver_class">org.hsqldb.jdbcDriver</property>
       <property name="hibernate.connection.url">jdbc:hsqldb:mem:jbpm;sql.enforce_strict_size=true</property>
       <property name="hibernate.connection.username">sa</property>
       <property name="hibernate.connection.password"/>
       <property name="hibernate.hbm2ddl.auto">create</property>
       ==== JDBC connection properties (end) -->
      
       <!-- DataSource properties (begin) -->
       <property name="hibernate.connection.datasource">java:JbpmDS</property>
       <!-- DataSource properties (end) -->
      
       <!-- JTA transaction properties (begin) -->
       <property name="hibernate.transaction.factory_class">org.hibernate.transaction.JTATransactionFactory</property>
       <property name="hibernate.transaction.manager_lookup_class">org.hibernate.transaction.JBossTransactionManagerLookup</property>
       <!-- JTA transaction properties (end) -->
      
       <!-- logging properties (begin) -->
       <property name="hibernate.format_sql">true</property>
       <property name="hibernate.use_sql_comments">true</property>
       <!-- logging properties (end) -->
      
       <!-- ############################################ -->
       <!-- # 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.jar', mapping files -->
       <!-- of the pluggable jbpm identity component. -->
       <!-- Uncomment the following 3 lines if you -->
       <!-- want to use the jBPM identity mgmgt -->
       <!-- component. -->
       <!-- identity mappings (begin) -->
       <mapping resource="org/jbpm/identity/User.hbm.xml"/>
       <mapping resource="org/jbpm/identity/Group.hbm.xml"/>
       <mapping resource="org/jbpm/identity/Membership.hbm.xml"/>
       <!-- identity mappings (end) -->
      
       <!-- following mapping files have a dependendy on -->
       <!-- the JCR API -->
       <!-- jcr mappings (begin) ===
       <mapping resource="org/jbpm/context/exe/variableinstance/JcrNodeInstance.hbm.xml"/>
       ==== jcr mappings (end) -->
      
       <!-- ###################### -->
       <!-- # 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"/>
      
       <!-- job mapping files -->
       <mapping resource="org/jbpm/job/Job.hbm.xml"/>
       <mapping resource="org/jbpm/job/Timer.hbm.xml"/>
       <mapping resource="org/jbpm/job/ExecuteNodeJob.hbm.xml"/>
       <mapping resource="org/jbpm/job/ExecuteActionJob.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"/>
      
       <!-- 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"/>
      
       <!-- ###################### -->
       <!-- # bpel mapping files # -->
       <!-- ###################### -->
      
       <!-- hql queries and type defs -->
       <mapping resource="org/jbpm/bpel/persistence/db/hibernate.queries.hbm.xml" />
      
       <!-- graph.def mapping files -->
       <mapping resource="org/jbpm/bpel/graph/def/BpelProcessDefinition.hbm.xml" />
       <mapping resource="org/jbpm/bpel/graph/def/ImportDefinition.hbm.xml" />
       <mapping resource="org/jbpm/bpel/graph/def/Import.hbm.xml" />
       <mapping resource="org/jbpm/bpel/graph/def/LinkDefinition.hbm.xml" />
       <mapping resource="org/jbpm/bpel/graph/def/Activity.hbm.xml" />
       <mapping resource="org/jbpm/bpel/graph/def/Namespace.hbm.xml" />
      
       <!-- graph.basic mapping files -->
       <mapping resource="org/jbpm/bpel/graph/basic/BasicActivity.hbm.xml" />
       <mapping resource="org/jbpm/bpel/graph/basic/AssignOperation.hbm.xml" />
       <mapping resource="org/jbpm/bpel/graph/basic/assign/Copy.hbm.xml" />
       <mapping resource="org/jbpm/bpel/graph/basic/assign/From.hbm.xml" />
       <mapping resource="org/jbpm/bpel/graph/basic/assign/To.hbm.xml" />
      
       <!-- graph.struct mapping files -->
       <mapping resource="org/jbpm/bpel/graph/struct/StructuredActivity.hbm.xml" />
      
       <!-- graph.scope mapping files -->
       <mapping resource="org/jbpm/bpel/graph/scope/Scope.hbm.xml" />
       <mapping resource="org/jbpm/bpel/graph/scope/Handler.hbm.xml" />
       <mapping resource="org/jbpm/bpel/graph/scope/Compensate.hbm.xml" />
      
       <!-- graph.exe mapping files -->
       <mapping resource="org/jbpm/bpel/graph/exe/LinkInstance.hbm.xml" />
       <mapping resource="org/jbpm/bpel/graph/exe/ScopeInstance.hbm.xml" />
       <mapping resource="org/jbpm/bpel/graph/exe/FaultInstance.hbm.xml" />
      
       <!-- variable.def mapping files -->
       <mapping resource="org/jbpm/bpel/variable/def/VariableDefinition.hbm.xml" />
       <mapping resource="org/jbpm/bpel/variable/def/VariableType.hbm.xml" />
      
       <!-- variable.exe mapping files -->
       <mapping resource="org/jbpm/bpel/variable/exe/ElementInstance.hbm.xml" />
       <mapping resource="org/jbpm/bpel/variable/exe/MessageValue.hbm.xml" />
      
       <!-- sublang.def mapping files -->
       <mapping resource="org/jbpm/bpel/sublang/def/Snippet.hbm.xml" />
      
       <!-- alarm mapping files -->
       <mapping resource="org/jbpm/bpel/alarm/AlarmAction.hbm.xml" />
      
       <!-- integration.catalog mapping files -->
       <mapping resource="org/jbpm/bpel/integration/catalog/CatalogEntry.hbm.xml" />
      
       <!-- integration.def mapping files -->
       <mapping resource="org/jbpm/bpel/integration/def/CorrelationSetDefinition.hbm.xml" />
       <mapping resource="org/jbpm/bpel/integration/def/PartnerLinkDefinition.hbm.xml" />
       <mapping resource="org/jbpm/bpel/integration/def/Correlations.hbm.xml" />
       <mapping resource="org/jbpm/bpel/integration/def/Correlation.hbm.xml" />
       <mapping resource="org/jbpm/bpel/integration/def/MessageAction.hbm.xml" />
       <mapping resource="org/jbpm/bpel/integration/def/ReceiveAction.hbm.xml" />
       <mapping resource="org/jbpm/bpel/integration/def/ReplyAction.hbm.xml" />
       <mapping resource="org/jbpm/bpel/integration/def/InvokeAction.hbm.xml" />
      
       <!-- integration.exe mapping files -->
       <mapping resource="org/jbpm/bpel/integration/exe/CorrelationSetInstance.hbm.xml" />
       <mapping resource="org/jbpm/bpel/integration/exe/PartnerLinkInstance.hbm.xml" />
      
       <!-- endpointref mapping files -->
       <mapping resource="org/jbpm/bpel/endpointref/EndpointReference.hbm.xml" />
       <mapping resource="org/jbpm/bpel/endpointref/SoapEndpointReference.hbm.xml" />
      
       <!-- wsdl mapping files -->
       <mapping resource="org/jbpm/bpel/wsdl/impl/PropertyImpl.hbm.xml" />
       <mapping resource="org/jbpm/bpel/wsdl/impl/PartnerLinkTypeImpl.hbm.xml" />
       <mapping resource="org/jbpm/bpel/wsdl/impl/PropertyAliasImpl.hbm.xml" />
       <mapping resource="org/jbpm/bpel/wsdl/impl/OperationImpl.hbm.xml" />
       <mapping resource="org/jbpm/bpel/wsdl/impl/PortTypeImpl.hbm.xml" />
       <mapping resource="org/jbpm/bpel/wsdl/impl/OperationMember.hbm.xml" />
       <mapping resource="org/jbpm/bpel/wsdl/impl/MessageImpl.hbm.xml" />
       <mapping resource="org/jbpm/bpel/wsdl/impl/PartImpl.hbm.xml" />
      
       </session-factory>
      
      </hibernate-configuration>


      Please let me know what i am doing wrong in the configuration. Thanks in Advance.

      Dhanush

        • 1. Re: Deploying Jbpm BPEL with PostGres
          karthizap

          I am also getting same stack trace. do you have any solution to this problem.

          • 2. Re: Deploying Jbpm BPEL with PostGres
            aguizar

            Danush, as the stack trace and error message states, this is no data source problem. It is a problem with the JMS queue. What JDK and appserver versions are you using?

            • 3. Re: Deploying Jbpm BPEL with PostGres
              karthizap

              I am trying to deploy jbpm-bpel.ear into Jboss 5.0.1EA app server with Oracle 10g environment. Here is the stacktrace i am getting.

              10:40:13,770 INFO [SettingsFactory] JDBC driver: Oracle JDBC driver, version: 10.2.0.4.0
              10:40:13,804 INFO [Dialect] Using dialect: org.hibernate.dialect.Oracle10gDialect
              10:40:13,812 INFO [TransactionFactoryFactory] Transaction strategy: org.hibernate.transaction.JTATransactionFactory
              10:40:13,815 INFO [NamingHelper] JNDI InitialContext properties:{}
              10:40:13,817 INFO [TransactionManagerLookupFactory] instantiating TransactionManagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup
              10:40:13,819 INFO [TransactionManagerLookupFactory] instantiated TransactionManagerLookup
              10:40:13,819 INFO [TransactionManagerLookupFactory] instantiating TransactionManagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup
              10:40:13,819 INFO [TransactionManagerLookupFactory] instantiated TransactionManagerLookup
              10:40:13,819 INFO [SettingsFactory] Automatic flush during beforeCompletion(): disabled
              10:40:13,819 INFO [SettingsFactory] Automatic session close at end of transaction: disabled
              10:40:13,820 INFO [SettingsFactory] JDBC batch size: 15
              10:40:13,820 INFO [SettingsFactory] JDBC batch updates for versioned data: disabled
              10:40:13,821 INFO [SettingsFactory] Scrollable result sets: enabled
              10:40:13,821 INFO [SettingsFactory] JDBC3 getGeneratedKeys(): disabled
              10:40:13,821 INFO [SettingsFactory] Connection release mode: auto
              10:40:13,823 INFO [SettingsFactory] Default batch fetch size: 1
              10:40:13,823 INFO [SettingsFactory] Generate SQL with comments: enabled
              10:40:13,823 INFO [SettingsFactory] Order SQL updates by primary key: disabled
              10:40:13,823 INFO [SettingsFactory] Order SQL inserts for batching: disabled
              10:40:13,823 INFO [SettingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
              10:40:13,827 INFO [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory
              10:40:13,827 INFO [SettingsFactory] Query language substitutions: {}
              10:40:13,828 INFO [SettingsFactory] JPA-QL strict compliance: disabled
              10:40:13,828 INFO [SettingsFactory] Second-level cache: enabled
              10:40:13,828 INFO [SettingsFactory] Query cache: disabled
              10:40:13,837 INFO [SettingsFactory] Cache region factory : org.hibernate.cache.impl.bridge.RegionFactoryCacheProviderBridge
              10:40:13,837 INFO [RegionFactoryCacheProviderBridge] Cache provider: org.hibernate.cache.HashtableCacheProvider
              10:40:13,839 INFO [SettingsFactory] Optimize cache for minimal puts: disabled
              10:40:13,839 INFO [SettingsFactory] Structured second-level cache entries: disabled
              10:40:13,847 INFO [SettingsFactory] Statistics: disabled
              10:40:13,847 INFO [SettingsFactory] Deleted entity synthetic identifier rollback: disabled
              10:40:13,847 INFO [SettingsFactory] Default entity-mode: pojo
              10:40:13,848 INFO [SettingsFactory] Named query checking : enabled
              10:40:13,914 INFO [SessionFactoryImpl] building session factory
              10:40:16,442 INFO [SessionFactoryObjectFactory] Not binding factory to JNDI, no JNDI name configured
              10:40:16,442 INFO [NamingHelper] JNDI InitialContext properties:{}
              10:40:17,976 ERROR [[/jbpm-bpel]] Exception sending context initialized event to listener instance of class org.jbpm.bpel.web.JbpmConfigurationLoader
              org.jbpm.JbpmException: could not retrieve message destination
              at org.jbpm.msg.jms.JmsMessageServiceFactoryImpl.getDestination(JmsMessageServiceFactoryImpl.java:86)
              at org.jbpm.msg.jms.JmsMessageServiceFactoryImpl.openService(JmsMessageServiceFactoryImpl.java:112)
              at org.jbpm.svc.Services.getService(Services.java:150)
              at org.jbpm.svc.Services.getMessageService(Services.java:186)
              at org.jbpm.bpel.web.JbpmConfigurationLoader.contextInitialized(JbpmConfigurationLoader.java:54)
              at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3910)
              at org.apache.catalina.core.StandardContext.start(StandardContext.java:4393)
              at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeployInternal(TomcatDeployment.java:312)
              at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeploy(TomcatDeployment.java:144)
              at org.jboss.web.deployers.AbstractWarDeployment.start(AbstractWarDeployment.java:461)
              at org.jboss.web.deployers.WebModule.startModule(WebModule.java:118)
              at org.jboss.web.deployers.WebModule.start(WebModule.java:97)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
              at java.lang.reflect.Method.invoke(Method.java:585)
              at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)
              at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)
              at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
              at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
              at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668)
              at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:206)
              at $Proxy36.start(Unknown Source)
              at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42)
              at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37)
              at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)
              at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)
              at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
              at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
              at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:286)
              at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)
              at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
              at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)
              at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
              at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
              at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
              at org.jboss.system.ServiceController.doChange(ServiceController.java:688)
              at org.jboss.system.ServiceController.start(ServiceController.java:460)
              at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:163)
              at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:99)
              at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46)
              at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)
              at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50)
              at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)
              at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439)
              at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157)
              at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1178)
              at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1210)
              at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098)
              at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
              at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)
              at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
              at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)
              at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
              at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
              at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
              at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781)
              at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:698)
              at org.jboss.system.server.profileservice.ProfileServiceBootstrap.loadProfile(ProfileServiceBootstrap.java:304)
              at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:205)
              at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:405)
              at org.jboss.Main.boot(Main.java:209)
              at org.jboss.Main$1.run(Main.java:547)
              at java.lang.Thread.run(Thread.java:613)
              Caused by: javax.naming.NamingException: Could not dereference object [Root exception is javax.naming.NameNotFoundException: JbpmJobQueue not bound]
              at org.jnp.interfaces.NamingContext.resolveLink(NamingContext.java:1348)
              at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:813)
              at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:829)
              at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:682)
              at javax.naming.InitialContext.lookup(InitialContext.java:351)
              at org.jbpm.msg.jms.JmsMessageServiceFactoryImpl.lookup(JmsMessageServiceFactoryImpl.java:95)
              at org.jbpm.msg.jms.JmsMessageServiceFactoryImpl.getDestination(JmsMessageServiceFactoryImpl.java:83)
              ... 63 more
              Caused by: javax.naming.NameNotFoundException: JbpmJobQueue not bound
              at org.jnp.server.NamingServer.getBinding(NamingServer.java:771)
              at org.jnp.server.NamingServer.getBinding(NamingServer.java:779)
              at org.jnp.server.NamingServer.getObject(NamingServer.java:785)
              at org.jnp.server.NamingServer.lookup(NamingServer.java:443)
              at org.jnp.server.NamingServer.lookup(NamingServer.java:399)
              at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:722)
              at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:682)
              at javax.naming.InitialContext.lookup(InitialContext.java:351)
              at org.jnp.interfaces.NamingContext.resolveLink(NamingContext.java:1342)