Error in changing Database from HSQLDB to MySQL ..
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
