[jboss-user] [JBoss jBPM] - Error in changing Database from HSQLDB to MySQL ..

vipul.gupta do-not-reply at jboss.com
Wed May 16 12:33:19 EDT 2007 

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 at 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 at 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 at 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 at 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

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4046216#4046216

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4046216

More information about the jboss-user mailing list