2 Replies Latest reply on May 16, 2007 3:15 PM by Ronald van Kuijk

    Error in changing Database from HSQLDB to MySQL ..

    vipul gupta Newbie

      Hi ,

      I was trying to change the database from HSQLDB to MySQL as has been described in
      http://docs.jboss.com/jbpm/v3/userguide/thejbpmdatabase.html

      I have rechecked that i have done everything as mentioned in this page.

      I get the following error in startup ... Any clues


      :56:46,406 INFO [FacesConfigurator] Reading config /WEB-INF/faces-config.xml
      :56:46,484 DEBUG [ApplicationFactory] New ApplicationFactory instance created
      :56:46,484 ERROR [LocaleUtils] Locale name null or empty, ignoring
      :56:46,781 INFO [StartupServletContextListener] ServletContext 'C:\Tools\workspace\jbpm-starters-kit-3.1.3\jbpm-server\server\jbpm\.\tmp\deploy\tmp8744jbpm-exp.war\' initia
      zed.
      :56:46,796 DEBUG [JbpmThreadsServlet] using default jbpm cfg resource
      :56:46,796 DEBUG [JbpmThreadsServlet] using default jbpm context
      :56:46,812 DEBUG [JbpmContextInfo] creating jbpm context with service factories '[message, scheduler, logging, persistence, authentication]'
      :56:46,812 DEBUG [JbpmContext] creating JbpmContext
      :56:46,812 DEBUG [DbPersistenceServiceFactory] creating persistence service
      :56:46,828 DEBUG [DbPersistenceServiceFactory] building hibernate session factory
      :56:46,828 DEBUG [JbpmContextInfo] creating jbpm context with service factories '[message, scheduler, logging, persistence, authentication]'
      :56:46,843 DEBUG [JbpmContext] creating JbpmContext
      :56:46,843 DEBUG [DbPersistenceServiceFactory] creating persistence service
      :56:46,859 INFO [Environment] Hibernate 3.1
      :56:46,875 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=.../deploy/jmx-console.war/
      :56:46,875 INFO [Environment] hibernate.properties not found
      :56:46,875 INFO [Environment] using CGLIB reflection optimizer
      :56:46,875 INFO [Environment] using JDK 1.4 java.sql.Timestamp handling
      :56:46,953 DEBUG [HibernateHelper] creating hibernate configuration resource 'hibernate.cfg.xml'
      :56:46,953 INFO [Configuration] configuring from resource: hibernate.cfg.xml
      :56:46,953 INFO [Configuration] Configuration resource: hibernate.cfg.xml
      :56:46,953 DEBUG [CommandExecutorThread] command 'null' threw exception. rolling back transaction
      g.hibernate.HibernateException: hibernate.cfg.xml not found
      at org.hibernate.util.ConfigHelper.getResourceAsStream(ConfigHelper.java:147)
      at org.hibernate.cfg.Configuration.getConfigurationInputStream(Configuration.java:1236)
      at org.hibernate.cfg.Configuration.configure(Configuration.java:1258)
      at org.jbpm.db.hibernate.HibernateHelper.createConfiguration(HibernateHelper.java:90)
      at org.jbpm.persistence.db.DbPersistenceServiceFactory.getConfiguration(DbPersistenceServiceFactory.java:68)
      at org.jbpm.persistence.db.DbPersistenceServiceFactory.getSessionFactory(DbPersistenceServiceFactory.java:90)
      at org.jbpm.persistence.db.DbPersistenceService.getSessionFactory(DbPersistenceService.java:74)
      at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:78)
      at org.jbpm.persistence.db.DbPersistenceService.getMessagingSession(DbPersistenceService.java:245)
      at org.jbpm.JbpmContext.getMessagingSession(JbpmContext.java:521)
      at org.jbpm.msg.db.DbMessageService.(DbMessageService.java:49)
      at org.jbpm.msg.db.DbMessageServiceFactory.openService(DbMessageServiceFactory.java:32)
      at org.jbpm.svc.Services.getService(Services.java:136)
      at org.jbpm.svc.Services.getMessageService(Services.java:172)
      at org.jbpm.msg.command.CommandExecutorThread.executeCommand(CommandExecutorThread.java:122)
      at org.jbpm.msg.command.CommandExecutorThread.run(CommandExecutorThread.java:83)
      :56:46,953 DEBUG [DbPersistenceServiceFactory] building hibernate session factory
      :56:46,968 DEBUG [JbpmContext] closing JbpmContext
      :56:46,968 DEBUG [Services] closing service 'persistence': org.jbpm.persistence.db.DbPersistenceService@1ad0d89
      :56:46,968 DEBUG [HibernateHelper] creating hibernate configuration resource 'hibernate.cfg.xml'
      :56:46,968 INFO [Configuration] configuring from resource: hibernate.cfg.xml
      :56:46,968 INFO [Configuration] Configuration resource: hibernate.cfg.xml
      :56:46,968 DEBUG [JbpmContext] closing JbpmContext
      :56:46,968 DEBUG [Services] closing service 'persistence': org.jbpm.persistence.db.DbPersistenceService@53bbfa
      :56:46,968 ERROR [CommandExecutorThread] org.hibernate.HibernateException: hibernate.cfg.xml not found
      :56:46,968 INFO [SchedulerThread] runtime exception while executing timers
      g.hibernate.HibernateException: hibernate.cfg.xml not found
      at org.hibernate.util.ConfigHelper.getResourceAsStream(ConfigHelper.java:147)
      at org.hibernate.cfg.Configuration.getConfigurationInputStream(Configuration.java:1236)
      at org.hibernate.cfg.Configuration.configure(Configuration.java:1258)
      at org.jbpm.db.hibernate.HibernateHelper.createConfiguration(HibernateHelper.java:90)
      at org.jbpm.persistence.db.DbPersistenceServiceFactory.getConfiguration(DbPersistenceServiceFactory.java:68)
      at org.jbpm.persistence.db.DbPersistenceServiceFactory.getSessionFactory(DbPersistenceServiceFactory.java:90)
      at org.jbpm.persistence.db.DbPersistenceService.getSessionFactory(DbPersistenceService.java:74)
      at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:78)
      at org.jbpm.persistence.db.DbPersistenceService.getSchedulerSession(DbPersistenceService.java:254)
      at org.jbpm.JbpmContext.getSchedulerSession(JbpmContext.java:529)
      at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:104)
      at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:71)
      :56:47,062 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-0.0.0.0-8080
      :56:47,359 INFO [ChannelSocket] JK: ajp13 listening on /0.0.0.0:8009
      :56:47,359 INFO [JkMain] Jk running ID=0 time=0/16 config=null
      :56:47,375 INFO [Server] JBoss (MX MicroKernel) [4.0.3SP1 (build: CVSTag=JBoss_4_0_3_SP1 date=200510231054)] Started in 9s:204ms
      :56:51,968 DEBUG [JbpmContextInfo] creating jbpm context with service factories '[message, scheduler, logging, persistence, authentication]'
      :56:51,968 DEBUG [JbpmContext] creating JbpmContext
      :56:51,968 DEBUG [DbPersistenceServiceFactory] creating persistence service
      :56:51,968 DEBUG [DbPersistenceServiceFactory] building hibernate session factory
      :56:51,968 DEBUG [HibernateHelper] creating hibernate configuration resource 'hibernate.cfg.xml'
      :56:51,968 INFO [Configuration] configuring from resource: hibernate.cfg.xml
      :56:51,968 INFO [Configuration] Configuration resource: hibernate.cfg.xml
      :56:51,968 DEBUG [JbpmContextInfo] creating jbpm context with service factories '[message, scheduler, logging, persistence, authentication]'
      :56:51,968 DEBUG [JbpmContext] creating JbpmContext
      :56:51,968 DEBUG [DbPersistenceServiceFactory] creating persistence service
      :56:51,968 DEBUG [CommandExecutorThread] command 'null' threw exception. rolling back transaction
      g.hibernate.HibernateException: hibernate.cfg.xml not found
      at org.hibernate.util.ConfigHelper.getResourceAsStream(ConfigHelper.java:147)
      at org.hibernate.cfg.Configuration.getConfigurationInputStream(Configuration.java:1236)
      at org.hibernate.cfg.Configuration.configure(Configuration.java:1258)
      at org.jbpm.db.hibernate.HibernateHelper.createConfiguration(HibernateHelper.java:90)
      at org.jbpm.persistence.db.DbPersistenceServiceFactory.getConfiguration(DbPersistenceServiceFactory.java:68)
      at org.jbpm.persistence.db.DbPersistenceServiceFactory.getSessionFactory(DbPersistenceServiceFactory.java:90)
      at org.jbpm.persistence.db.DbPersistenceService.getSessionFactory(DbPersistenceService.java:74)
      at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:78)
      at org.jbpm.persistence.db.DbPersistenceService.getMessagingSession(DbPersistenceService.java:245)
      at org.jbpm.JbpmContext.getMessagingSession(JbpmContext.java:521)
      at org.jbpm.msg.db.DbMessageService.(DbMessageService.java:49)
      at org.jbpm.msg.db.DbMessageServiceFactory.openService(DbMessageServiceFactory.java:32)
      at org.jbpm.svc.Services.getService(Services.java:136)
      at org.jbpm.svc.Services.getMessageService(Services.java:172)
      at org.jbpm.msg.command.CommandExecutorThread.executeCommand(CommandExecutorThread.java:122)
      at org.jbpm.msg.command.CommandExecutorThread.run(CommandExecutorThread.java:83)
      :56:51,968 DEBUG [DbPersistenceServiceFactory] building hibernate session factory
      :56:51,968 DEBUG [JbpmContext] closing JbpmContext
      :56:51,968 DEBUG [Services] closing service 'persistence': org.jbpm.persistence.db.DbPersistenceService@393167
      :56:51,968 DEBUG [HibernateHelper] creating hibernate configuration resource 'hibernate.cfg.xml'
      :56:51,968 ERROR [CommandExecutorThread] org.hibernate.HibernateException: hibernate.cfg.xml not found
      :56:51,968 INFO [Configuration] configuring from resource: hibernate.cfg.xml
      :56:51,968 INFO [Configuration] Configuration resource: hibernate.cfg.xml
      :56:51,968 DEBUG [JbpmContext] closing JbpmContext
      :56:51,968 DEBUG [Services] closing service 'persistence': org.jbpm.persistence.db.DbPersistenceService@da8742
      :56:51,968 INFO [SchedulerThread] runtime exception while executing timers
      g.hibernate.HibernateException: hibernate.cfg.xml not found
      at org.hibernate.util.ConfigHelper.getResourceAsStream(ConfigHelper.java:147)
      at org.hibernate.cfg.Configuration.getConfigurationInputStream(Configuration.java:1236)


      - Vipul