[jboss-user] [JBoss jBPM] - Re: Install Problems with jbpm/MySQL

[lyallp]

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 at 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 at c3886145 { url=file:/C:/jboss-4.2.3.GA/server/default/deploy/jbpm/jbpm-enterprise-bundle.ear/ }
  |   deployer: org.jboss.deployment.EARDeployer at 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 at 54919e
  | 2008-11-20 21:43:03,734 DEBUG [org.jbpm.svc.Services] closing service 'persistence': org.jbpm.persistence.jta.JtaDbPersistenceService at 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 at 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 at 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 at 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

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

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