2 Replies Latest reply on Mar 6, 2008 3:55 AM by mputz

    Switching the Database Backend

    b_

      Hi all,

      I followed the getting started guide to switch the database backend to mysql however when i start the jbpm-server i get the following stack trace:



      12:58:48,046 INFO [STDOUT] java.lang.NoClassDefFoundError: net/sf/ehcache/CacheException
      12:58:48,046 INFO [STDOUT] at java.lang.Class.getDeclaredConstructors0(Native Method)
      12:58:48,062 INFO [STDOUT] at java.lang.Class.privateGetDeclaredConstructors(Class.java:2357)
      12:58:48,062 INFO [STDOUT] at java.lang.Class.getConstructor0(Class.java:2671)
      12:58:48,062 INFO [STDOUT] at java.lang.Class.newInstance0(Class.java:321)
      12:58:48,062 INFO [STDOUT] at java.lang.Class.newInstance(Class.java:303)
      12:58:48,062 INFO [NamingHelper] JNDI InitialContext properties:{}
      12:58:48,062 INFO [STDOUT] at org.hibernate.cfg.SettingsFactory.createCacheProvider(SettingsFactory.java:327)
      12:58:48,062 INFO [DatasourceConnectionProvider] Using datasource: java:/JbpmDS
      12:58:48,078 INFO [STDOUT] at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:219)
      12:58:48,078 INFO [SettingsFactory] RDBMS: MySQL, version: 5.1.22-rc-community
      12:58:48,078 INFO [STDOUT] at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1823)
      12:58:48,078 INFO [SettingsFactory] JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-3.1.7 ( $Date: 2005/01/25 19:11:41 $, $Revision: 1.27.4.54 $ )
      12:58:48,078 INFO [STDOUT] at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1143)
      12:58:48,078 INFO [Dialect] Using dialect: org.hibernate.dialect.MySQLDialect
      12:58:48,093 INFO [STDOUT] at org.jbpm.persistence.db.DbPersistenceServiceFactory.getSessionFactory(DbPersistenceServiceFactory.java:91)
      12:58:48,093 INFO [TransactionFactoryFactory] Using default transaction strategy (direct JDBC transactions)
      12:58:48,093 INFO [STDOUT] at org.jbpm.persistence.db.DbPersistenceService.getSessionFactory(DbPersistenceService.java:76)
      12:58:48,093 INFO [STDOUT] at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:80)
      12:58:48,109 INFO [STDOUT] at org.jbpm.persistence.db.DbPersistenceService.getMessagingSession(DbPersistenceService.java:252)
      12:58:48,109 INFO [TransactionManagerLookupFactory] No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
      12:58:48,109 INFO [STDOUT] at org.jbpm.JbpmContext.getMessagingSession(JbpmContext.java:523)
      12:58:48,109 INFO [SettingsFactory] Automatic flush during beforeCompletion(): disabled
      12:58:48,109 INFO [STDOUT] at org.jbpm.msg.db.DbMessageService.(DbMessageService.java:49)
      12:58:48,109 INFO [SettingsFactory] Automatic session close at end of transaction: disabled
      12:58:48,109 INFO [STDOUT] at org.jbpm.msg.db.DbMessageServiceFactory.openService(DbMessageServiceFactory.java:32)
      12:58:48,125 INFO [SettingsFactory] JDBC batch size: 15
      12:58:48,125 INFO [STDOUT] at org.jbpm.svc.Services.getService(Services.java:136)
      12:58:48,125 INFO [SettingsFactory] JDBC batch updates for versioned data: disabled
      12:58:48,125 INFO [STDOUT] at org.jbpm.svc.Services.getMessageService(Services.java:172)
      12:58:48,125 INFO [SettingsFactory] Scrollable result sets: enabled
      12:58:48,125 INFO [STDOUT] at org.jbpm.msg.command.CommandExecutorThread.executeCommand(CommandExecutorThread.java:122)
      12:58:48,140 INFO [SettingsFactory] JDBC3 getGeneratedKeys(): enabled
      12:58:48,140 INFO [STDOUT] at org.jbpm.msg.command.CommandExecutorThread.run(CommandExecutorThread.java:83)



      Am i missing something?

      Thanks

        • 1. Re: Switching the Database Backend
          b_

          After searching on google i found that i should also add the following in the hibernate.cfg.xml file:

          org.hibernate.cache.EhCacheProvider

          However this still doesnt solve the problem and i get the same exception. Any help would be mostly appreciated since i am stuck at this point and dont know what else to try!

          • 2. Re: Switching the Database Backend
            mputz

            EhCache? what jBPM version are you using?

            I'd expect to see

            <property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>


            in hibernate.cfg.xml, as this is the default cache provider setting in the recent versions.