1 Reply Latest reply on Jul 27, 2009 10:27 AM by Ronald van Kuijk

    Problem with JobExecutor - hibernate.cfg.xml not found

    S Prasad Newbie

      I have configured Jbpm 3.3.0.GA with Spring webflow. It was working fine. But when I used JobExecutor, it shows the following error:


      org.hibernate.HibernateException: hibernate.cfg.xml not found
      at org.hibernate.util.ConfigHelper.getResourceAsStrea m(ConfigHelper.java:147)
      at org.hibernate.cfg.Configuration.getConfigurationIn putStream(Configuration.java:1329)
      at org.hibernate.cfg.Configuration.configure(Configur ation.java:1351)
      at org.jbpm.db.hibernate.HibernateHelper.createConfig uration(HibernateHelper.java:91)
      at org.jbpm.persistence.db.DbPersistenceServiceFactor y.getConfiguration(DbPersistenceServiceFactory.jav a:69)
      at org.jbpm.persistence.db.DbPersistenceServiceFactor y.getSessionFactory(DbPersistenceServiceFactory.ja va:91)
      at org.jbpm.persistence.db.DbPersistenceService.getSe ssionFactory(DbPersistenceService.java:94)
      at org.jbpm.persistence.db.DbPersistenceService.getSe ssion(DbPersistenceService.java:98)
      at org.jbpm.persistence.db.DbPersistenceService.getJo bSession(DbPersistenceService.java:352)
      at org.jbpm.JbpmContext.getJobSession(JbpmContext.jav a:563)
      at org.jbpm.job.executor.JobExecutorThread.acquireJob s(JobExecutorThread.java:109)
      at org.jbpm.job.executor.JobExecutorThread.run(JobExe cutorThread.java:56)


      Following is my web.xml entry:

      <servlet>
      <servlet-name>JobExecutorServlet</servlet-name>
      <servlet-class>org.jbpm.job.executor.JobExecutorServlet</servlet-class>
       <init-param>
       <param-name>jbpm.configuration.resource</param-name>
       <param-value>default.jbpm.cfg.xml</param-value>
       </init-param>
       <load-on-startup>1</load-on-startup>
       </servlet>
       <servlet-mapping >
       <servlet-name>JobExecutorServlet</servlet-name>
       <url-pattern>/jobexecutor</url-pattern>
       </servlet-mapping>


      Following is my hibernate config entry in applicaionContext.xml

      <bean id="sessionFactory"
       class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
       <property name="dataSource" ref="dataSource" />
       <property name="mappingLocations" value="classpath*:/org/jbpm/**/*.hbm.xml" />
       <property name="configLocation">
       <value>/WEB-INF/hibernate.cfg.xml</value>
       </property>
       <property name="hibernateProperties">
       <props>
       <prop key="hibernate.dialect">${dataSource.dialect}</prop>
       <prop key="hibernate.default_batch_fetch_size">30</prop>
       <prop key="hibernate.jdbc.fetch_size">20</prop>
       <prop key="org.hibernate.cache">info</prop>
       <prop key="org.hibernate.transaction">debug</prop>
       <prop key="hibernate.jdbc.batch_size">100</prop>
       <prop key="hibernate.show_sql">false</prop>
       <prop key="hibernate.use_sql_comments">true</prop>
       <prop key="hibernate.max_fetch_depth">3</prop>
       <prop key="hibernate.jdbc.batch_versioned_data">true</prop>
       <!--
       <prop key="connection.pool_size">1</prop>
       <prop
       key="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</prop>
       <prop key="hibernate.cache.use_query_cache">true</prop> <prop
       key="hibernate.cache.use_second_level_cache">true</prop> <prop
       key="hbm2ddl.auto">update</prop>
       -->
       </props>
       </property>
       <property name="schemaUpdate" value="false" />
      
       </bean>


      my jbpm config in applicationContext.xml
      <bean id="jbpmConfiguration" class="org.springmodules.workflow.jbpm31.LocalJbpmConfigurationFactoryBean">
       <property name="sessionFactory" ref="sessionFactory"/>
       <property name="configuration" value="classpath:org/jbpm/default.jbpm.cfg.xml"/>
       <property name="processDefinitionsResources">
       <list>
       <!-- -->
       <value>classpath:org/isro/dwf/account/workflow/bill_preparation/processdefinition.xml</value>
       <value>classpath:org/isro/dwf/account/workflow/cheque_preparation/processdefinition.xml</value>
       <value>classpath:org/isro/dwf/account/workflow/pre_cheque_preparation/processdefinition.xml</value>
       <!-- -->
       </list>
       </property>
       </bean>



      Iam desperately working on this for a week, but yet to find a solution.
      I kindly request you to please help me on this.

      much thanks in advance,
      Prasad.