3 Replies Latest reply on Nov 19, 2008 11:56 PM by Lyall Pearce

    Install Problems with jbpm/MySQL

    Lyall Pearce Newbie

      I am having problems with getting jbpm working.

      eclipse-jee-ganymede-SR1-win32.zip
      jboss-4.2.3.GA.zip
      jbpm-installer-3.3.0.GA.jar
      jbpm-jpdl-designer-suite-3.1.5.zip
      jdk-6u5-windows-i586-p.exe
      mysql-5.0.67-win32.exe
      mysql-connector-java-3.1.14.zip

      OS = Windows 2003 Server SP2 (x86 32 bit)

      MySQL on same server in C:/jboss-4.2.3.GA
      I copied the mysql-connector-java-3.1.14-bin.jar into c:/jboss-4.2.3.GA/server/default/lib/
      I have updated c:/jboss-4.2.3.GA/server/default/conf/login-config.xml

       <application-policy name = "MySqlDbRealm">
       <authentication>
       <login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule"
       flag = "required">
       <module-option name = "principal">jboss</module-option>
       <module-option name = "userName">jboss</module-option>
       <module-option name = "password">password</module-option>
       <module-option name = "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=DefaultDS</module-option>
       </login-module>
       </authentication>
       </application-policy>
      


      I have created c:/jboss-4.2.3.GA/server/default/deploy/mysql-default-ds.xml
       <?xml version="1.0" encoding="UTF-8"?>
      
       <!-- $Id: mysql-ds.xml 71535 2008-04-01 07:05:03Z adrian@jboss.org $ -->
       <!-- Datasource config for MySQL using 3.0.9 available from:
       http://www.mysql.com/downloads/api-jdbc-stable.html
       -->
      
       <datasources>
       <local-tx-datasource>
       <jndi-name>DefaultDS</jndi-name>
       <connection-url>jdbc:mysql://localhost:3306/jbossdb</connection-url>
       <driver-class>com.mysql.jdbc.Driver</driver-class>
       <user-name>jboss</user-name>
       <password>password</password>
       <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
       <!-- should only be used on drivers after 3.22.1 with "ping" support -->
       <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>
       <!-- sql to call when connection is created
       <new-connection-sql>some arbitrary sql</new-connection-sql>
       -->
       <!-- sql to call on an existing pooled connection when it is obtained from pool - MySQLValidConnectionChecker is preferred for newer drivers
       <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
       -->
      
       <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
       <metadata>
       <type-mapping>mySQL</type-mapping>
       </metadata>
       </local-tx-datasource>
      
       </datasources>
      


      I copied c:/jboss-4.2.3.GA/docs/examples/jms/mysql-jdbc2-service.xml
      to c:/jboss-4.2.3.GA/server/default/deploy/jms/mysql-jdbc2-service.xml
      and updated with the following fragment (updated name=DefaultDS)
       <mbean code="org.jboss.mq.pm.jdbc2.PersistenceManager"
       name="jboss.mq:service=PersistenceManager">
       <depends optional-attribute-name="ConnectionManager">jboss.jca:service=DataSourceBinding,name=DefaultDS</depends>
      


      I then created a database in MySQL called 'jbossdb' and a user 'jboss' which has full control over the 'jbossdb' database.

      I boot jBoss and the jms tables appeared and everything appeares to operate correctly.

      I then shutdown jBoss and then install 'jbpm' using jboss-4.2.3.GA

      I install into c:/jbpm-3.3.0.GA
      * point it at C:/jboss-4.2.3.GA
      * use MySQL

      I then created a database in MySQL called 'jbpmdb' and a user 'jbpm' which has full control over all databases (in my desparation)

      I then edit c:/jboss-4.2.3.GA/server/default/deploy/jbpm/jbpm-mysql-ds.xml
       <?xml version="1.0" encoding="UTF-8"?>
       <datasources>
      
       <xa-datasource>
       <jndi-name>JbpmDS</jndi-name>
      
       <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
       <xa-datasource-property name="URL">jdbc:mysql://localhost:3306/jbpmdb</xa-datasource-property>
       <user-name>jbpm</user-name>
       <password>password</password>
      
       <!-- reduce isolation from the default level (repeatable read) -->
       <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
       <!-- separate connections used with and without JTA transaction -->
       <no-tx-separate-pools />
       <!-- disable transaction interleaving -->
       <track-connection-by-tx />
      
       <!-- leverage mysql integration features -->
       <exception-sorter-class-name>
       com.mysql.jdbc.integration.jboss.ExtendedMysqlExceptionSorter
       </exception-sorter-class-name>
       <valid-connection-checker-class-name>
       com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker
       </valid-connection-checker-class-name>
      
       <!-- corresponding type-mapping in conf/standardjbosscmp-jdbc.xml -->
       <metadata>
       <type-mapping>mySQL</type-mapping>
       </metadata>
       </xa-datasource>
      
       </datasources>
      


      I then copied c:/jbpm-3.3.0.GA/config/hibernate.cfg.mysql.xml into c:/jbpm-3.3.0.GA/config/hibernate.cfg.xml
      and edited the following fragment
       <session-factory>
      
       <!-- hibernate dialect -->
       <property name="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
      
       <!-- JDBC connection properties (begin) -->
       <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
       <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/jbpmdb</property>
       <property name="hibernate.connection.username">jbpm</property>
       <property name="hibernate.connection.password">Password1</property>
       <property name="hibernate.query.substitutions">true 1, false 0</property>
       <!-- JDBC connection properties (end) -->
      
      
       <!-- DataSource properties (begin) -->
       <property name="hibernate.connection.datasource">java:comp/env/jdbc/JbpmDataSource</property>
       <!-- DataSource properties (end) -->
      


      I then copied this into C:\jboss-4.2.3.GA\server\default\deploy\jbpm\jbpm-service.sar\hibernate.cfg.xml

      When I boot JBOSS, the following diagnostics are generated..
       --- Incompletely deployed packages ---
       org.jboss.deployment.DeploymentInfo@8ebe4553 { url=file:/C:/jboss-4.2.3.GA/server/default/deploy/jbpm/jbpm-enterprise-bundle.ear/jsf-console.war/ }
       deployer: MBeanProxyExt[jboss.web:service=WebServer]
       status: Deployment FAILED reason: URL file:/C:/jboss-4.2.3.GA/server/default/deploy/jbpm/jbpm-enterprise-bundle.ear/jsf-console.war/ deployment failed
       state: FAILED
       watch: file:/C:/jboss-4.2.3.GA/server/default/deploy/jbpm/jbpm-enterprise-bundle.ear/jsf-console.war/WEB-INF/web.xml
       altDD: null
       lastDeployed: 1227111755625
       lastModified: 1227087751875
       mbeans:
      
       org.jboss.deployment.DeploymentInfo@c3886145 { url=file:/C:/jboss-4.2.3.GA/server/default/deploy/jbpm/jbpm-enterprise-bundle.ear/ }
       deployer: org.jboss.deployment.EARDeployer@1b158db
       status: Deployment FAILED reason: URL file:/C:/jboss-4.2.3.GA/server/default/deploy/jbpm/jbpm-enterprise-bundle.ear/jsf-console.war/ deployment failed
       state: FAILED
       watch: file:/C:/jboss-4.2.3.GA/server/default/deploy/jbpm/jbpm-enterprise-bundle.ear/META-INF/application.xml
       altDD: null
       lastDeployed: 1227111755625
       lastModified: 1227087751562
       mbeans:
      
       --- MBeans waiting for other MBeans ---
       ObjectName: jboss.j2ee:service=EjbModule,module=jbpm-enterprise-beans.jar
       State: FAILED
       Reason: org.jboss.deployment.DeploymentException: Error while fixing table name; - nested throwable: (org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.lang.reflect.UndeclaredThrowableException); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.lang.reflect.UndeclaredThrowableException)))
      
       ObjectName: jboss.web.deployment:war=jsf-console.war,id=-1900133037
       State: FAILED
       Reason: org.jboss.deployment.DeploymentException: URL file:/C:/jboss-4.2.3.GA/server/default/deploy/jbpm/jbpm-enterprise-bundle.ear/jsf-console.war/ deployment failed
      
       --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
       ObjectName: jboss.web.deployment:war=jsf-console.war,id=-1900133037
       State: FAILED
       Reason: org.jboss.deployment.DeploymentException: URL file:/C:/jboss-4.2.3.GA/server/default/deploy/jbpm/jbpm-enterprise-bundle.ear/jsf-console.war/ deployment failed
      
       ObjectName: jboss.j2ee:service=EjbModule,module=jbpm-enterprise-beans.jar
       State: FAILED
       Reason: org.jboss.deployment.DeploymentException: Error while fixing table name; - nested throwable: (org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.lang.reflect.UndeclaredThrowableException); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.lang.reflect.UndeclaredThrowableException)))
      


      with more detailed logs from the first failure.

       2008-11-20 02:52:36,000 DEBUG [org.jboss.system.ServiceController] starting service jboss.j2ee:service=EjbModule,module=jbpm-enterprise-beans.jar
       2008-11-20 02:52:36,000 DEBUG [org.jboss.ejb.EjbModule] Starting jboss.j2ee:service=EjbModule,module=jbpm-enterprise-beans.jar
       2008-11-20 02:52:36,000 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.TimerEntityBean] Initializing CMP plugin for TimerEntityBean
       2008-11-20 02:52:36,015 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.TimerEntityBean] Loading standardjbosscmp-jdbc.xml : file:/C:/jboss-4.2.3.GA/server/default/conf/standardjbosscmp-jdbc.xml
       2008-11-20 02:52:36,312 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.TimerEntityBean] file:/C:/jboss-4.2.3.GA/server/default/deploy/jbpm/jbpm-enterprise-bundle.ear/jbpm-enterprise-beans.jar/META-INF/jbosscmp-jdbc.xml found. Overriding defaults
       2008-11-20 02:52:36,437 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] internalRegisterPool: registering pool with interval 900000 old interval: 450000
       2008-11-20 02:52:36,468 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.parentTraceEnabled=true
       2008-11-20 02:52:36,468 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.nestedTraceEnabled=false
       2008-11-20 02:52:36,468 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.detectDuplicateNesting=true
       2008-11-20 02:52:36,468 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
       org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.lang.reflect.UndeclaredThrowableException)
       at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.createManagedConnection(XAManagedConnectionFactory.java:155)
       at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:619)
       at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:264)
       at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:575)
       at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:347)
       at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:330)
       at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:402)
       at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:849)
       at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
       at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.fixTableName(SQLUtil.java:172)
       at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCEntityBridge.init(JDBCEntityBridge.java:157)
       at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.initStoreManager(JDBCStoreManager.java:435)
       at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:368)
       at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:172)
       at org.jboss.ejb.EjbModule.startService(EjbModule.java:414)
       at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
       at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
       at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
       ...
      


      I edited a copy of C:\jbpm-3.3.0.GA\database\jbpm.jpdl.mysql.sql to put a ';' at the end of each line
      then used 'mysql' to execute it, generating all the tables in the jbpmdb database.

      This makes no difference.

      I tried changing the password of the 'jbpm' user - instead of unable to connect, I then receive authorisation
      failures, so this indicates, at least to me, that I am successfully connecting to MySQL but something is going wrong.

      I use phpMyAdmin on a different server to administer MySQL, so I am quite confident that MySQL is ok.


      Suggestions as to where I am going wrong would be greatly appreciated.

      ...Lyall


        • 1. Re: Install Problems with jbpm/MySQL
          Lyall Pearce Newbie

          I think the hard thing about this whole thing is that the connection creation fails, which is fine, but the diagnostics, which are plentiful, are completely useless, because they don't say why the failure occurred.

          I have log4j DEBUG turned on (the default for JBoss) and there is nothing that helps.

          Even MySQL does not log (as far as I can tell) error situations.

          Suggestions actively pursued!

          ...Lyall

          • 2. Re: Install Problems with jbpm/MySQL
            Lyall Pearce Newbie

            Ok, making progress!

            I updated the c:/jboss-4.2.3.GA/server/default/deploy/jbpm/jbpm-mysql-ds.xml to have the JbpmDS as a local-tx-datasource, rather than a xa-datasource.

            <local-tx-datasource>
             <jndi-name>JbpmDS</jndi-name>
             <connection-url>jdbc:mysql://localhost:3306/jbpmdb</connection-url>
             <driver-class>com.mysql.jdbc.Driver</driver-class>
             <user-name>jbpm</user-name>
             <password>Password1</password>
             <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
             <!-- should only be used on drivers after 3.22.1 with "ping" support -->
             <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>
             <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
             <metadata>
             <type-mapping>mySQL</type-mapping>
             </metadata>
            
             </local-tx-datasource>
            


            Now, I can connect and the database has been populated with all the required tables (32 of them).

            Now I receive a different error...
            2008-11-20 21:43:04,359 ERROR [org.jboss.deployment.scanner.URLDeploymentScanner] Incomplete Deployment listing:
            
            --- Incompletely deployed packages ---
            org.jboss.deployment.DeploymentInfo@8ebe4553 { url=file:/C:/jboss-4.2.3.GA/server/default/deploy/jbpm/jbpm-enterprise-bundle.ear/jsf-console.war/ }
             deployer: MBeanProxyExt[jboss.web:service=WebServer]
             status: Deployment FAILED reason: URL file:/C:/jboss-4.2.3.GA/server/default/deploy/jbpm/jbpm-enterprise-bundle.ear/jsf-console.war/ deployment failed
             state: FAILED
             watch: file:/C:/jboss-4.2.3.GA/server/default/deploy/jbpm/jbpm-enterprise-bundle.ear/jsf-console.war/WEB-INF/web.xml
             altDD: null
             lastDeployed: 1227179572015
             lastModified: 1227087751875
             mbeans:
            
            org.jboss.deployment.DeploymentInfo@c3886145 { url=file:/C:/jboss-4.2.3.GA/server/default/deploy/jbpm/jbpm-enterprise-bundle.ear/ }
             deployer: org.jboss.deployment.EARDeployer@1b158db
             status: Deployment FAILED reason: URL file:/C:/jboss-4.2.3.GA/server/default/deploy/jbpm/jbpm-enterprise-bundle.ear/jsf-console.war/ deployment failed
             state: FAILED
             watch: file:/C:/jboss-4.2.3.GA/server/default/deploy/jbpm/jbpm-enterprise-bundle.ear/META-INF/application.xml
             altDD: null
             lastDeployed: 1227179572015
             lastModified: 1227087751562
             mbeans:
            
            --- MBeans waiting for other MBeans ---
            ObjectName: jboss.web.deployment:war=jsf-console.war,id=-1900133037
             State: FAILED
             Reason: org.jboss.deployment.DeploymentException: URL file:/C:/jboss-4.2.3.GA/server/default/deploy/jbpm/jbpm-enterprise-bundle.ear/jsf-console.war/ deployment failed
            
            --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
            ObjectName: jboss.web.deployment:war=jsf-console.war,id=-1900133037
             State: FAILED
             Reason: org.jboss.deployment.DeploymentException: URL file:/C:/jboss-4.2.3.GA/server/default/deploy/jbpm/jbpm-enterprise-bundle.ear/jsf-console.war/ deployment failed
            
            


            Which, if my assumptions are correct, are derived from the following message, earlier in the 'server.log'.

            2008-11-20 21:43:03,718 DEBUG [org.hibernate.impl.SessionFactoryImpl] Checking 0 named SQL queries
            2008-11-20 21:43:03,718 DEBUG [org.jbpm.persistence.jta.JtaDbPersistenceService] begin user transaction
            2008-11-20 21:43:03,734 DEBUG [org.jbpm.persistence.db.DbPersistenceService] using current hibernate session
            2008-11-20 21:43:03,734 DEBUG [org.jbpm.JbpmContext] closing jbpmContext org.jbpm.JbpmContext@54919e
            2008-11-20 21:43:03,734 DEBUG [org.jbpm.svc.Services] closing service 'persistence': org.jbpm.persistence.jta.JtaDbPersistenceService@b1b290
            2008-11-20 21:43:03,734 DEBUG [org.jbpm.persistence.jta.JtaDbPersistenceService] rolling back user transaction
            2008-11-20 21:43:03,734 DEBUG [org.jbpm.svc.Services] closing service 'tx': org.jbpm.tx.TxService@422e25
            2008-11-20 21:43:03,734 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/jbpm-console]] Exception sending context initialized event to listener instance of class org.jbpm.web.BootstrapListener
            org.hibernate.HibernateException: No CurrentSessionContext configured!
             at org.hibernate.impl.SessionFactoryImpl.getCurrentSession(SessionFactoryImpl.java:542)
             at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:105)
             at org.jbpm.persistence.db.DbPersistenceService.getGraphSession(DbPersistenceService.java:351)
            
            ...
            
            2008-11-20 21:43:03,921 ERROR [org.apache.catalina.core.StandardContext] Error listenerStart
            2008-11-20 21:43:03,921 ERROR [org.apache.catalina.core.StandardContext] Context [/jbpm-console] startup failed due to previous errors
            2008-11-20 21:43:03,921 DEBUG [org.jbpm.configuration.JbpmContextInfo] creating jbpm context with service factories '[message, tx, scheduler, authentication, persistence, logging]'
            2008-11-20 21:43:03,921 DEBUG [org.jbpm.JbpmContext] creating org.jbpm.JbpmContext@1ee1619
            2008-11-20 21:43:03,921 DEBUG [org.jbpm.persistence.db.DbPersistenceServiceFactory] closing hibernate session factory
            2008-11-20 21:43:03,921 INFO [org.hibernate.impl.SessionFactoryImpl] closing
            2008-11-20 21:43:03,921 DEBUG [org.jbpm.JbpmContext] closing jbpmContext org.jbpm.JbpmContext@1ee1619
            2008-11-20 21:43:03,921 DEBUG [javax.enterprise.resource.webcontainer.jsf.config] ConfigureListener.contextDestroyed(null)
            2008-11-20 21:43:03,953 DEBUG [org.jboss.web.WebModule] Starting failed jboss.web.deployment:war=jsf-console.war,id=-1900133037
            2008-11-20 21:43:03,953 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.parentTraceEnabled=true
            2008-11-20 21:43:03,953 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.nestedTraceEnabled=false
            2008-11-20 21:43:03,953 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.detectDuplicateNesting=true
            org.jboss.deployment.DeploymentException: URL file:/C:/jboss-4.2.3.GA/server/default/deploy/jbpm/jbpm-enterprise-bundle.ear/jsf-console.war/ deployment failed
             at org.jboss.web.tomcat.service.TomcatDeployer.performDeployInternal(TomcatDeployer.java:386)
             at org.jboss.web.tomcat.service.TomcatDeployer.performDeploy(TomcatDeployer.java:104)
             at org.jboss.web.AbstractWebDeployer.start(AbstractWebDeployer.java:375)
             at org.jboss.web.WebModule.startModule(WebModule.java:83)
            


            Any insights would be nice...


            ...Lyall

            • 3. [Partially Solved]: Install Problems with jbpm/MySQL
              Lyall Pearce Newbie

              I feel like an idiot.

              I found I was using a positively fossilized version of mysql connector.

              I use mysql-connector-java-5.1.7 instead of mysql-connector-java-3.1.14 and I seem to have much more success.