I am trying to setup Flowable to run in wildfly and MSSQL. I am started by setting up the IDM module howerver I am running into the errors below.
Created the tables with the mssql scripts located on github at: flowable-engine/modules/flowable-idm-engine/src/main/resources/org/flowable/idm/db/create/
Modified flowable-idm/web-inf/classes/meta-inf/flowable-ui-app/flowable-ui–app.properties file with the following settings:
datasource.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
datasource.url=jdbc:sqlserver://myserverName:1433;databaseName=mybpmdb
datasource.username=myuserName
datasource.password=mypassword
In the flowable-idm/web-inf/lib folder I placed the sqljdbc4.jar
When starting Wildfly and I profile the database, I get a connection and several commands execute successfully. However then I get the following error:
ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation (“deploy”) failed - address: ([(“deployment” => “flowable-idm.war”)]) - failure description: {
“WFLYCTL0080: Failed services” => {“jboss.undertow.deployment.default-server.default-host./flowable-idm” => "org.jboss.msc.service.StartException in service jboss.undertow.deployment.default-server.default-host./flowable-idm: java.lang.RuntimeException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘bootstrapper’: Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private org.flowable.idm.api.IdmIdentityService org.flowable.app.conf.Bootstrapper.identityService; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘idmIdentityService’ defined in class path resource [org/flowable/app/conf/FlowableIdmEngineConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.flowable.idm.api.IdmIdentityService]: Factory method ‘idmIdentityService’ threw exception; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘idmEngine’ defined in class path resource [org/flowable/app/conf/FlowableIdmEngineConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.flowable.idm.engine.IdmEngine]: Factory method ‘idmEngine’ threw exception; nested exception is java.lang.IllegalStateException: Already value [org.springframework.jdbc.datasource.ConnectionHolder@16e2e646] for key [com.mchange.v2.c3p0.ComboPooledDataSource[ identityToken -> 1b61glg9mzlx9r666mt8a|4e075506, dataSourceName -> 1b61glg9mzlx9r666mt8a|4e075506 ]] bound to thread [ServerService Thread Pool – 69]