Running Bonitasoft 6.5 on WildFly 8.2

Q&A
1

Hi,

I am trying to run BonitaSoft 6.5 on WildFly 8.2.

Why? BonitaSoft 6.5 should work with Java 8. JBoss AS 7 does not work with Java 8, as you can read in this post. So, I still would like to run on an Application Server, I have to upgrade to WildFly 8, which works perfectly with Java 8.

After starting the platform for the first time I run into the following issue:
15:08:06,002 INFO [org.bonitasoft.engine.EngineInitializer] (MSC service thread 1-2) Initializing platform…
15:08:06,002 INFO [org.bonitasoft.engine.EngineInitializer] (MSC service thread 1-2) Creating platform…
15:08:06,497 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (MSC service thread 1-2) SQL Error: 1146, SQLState: 42S02
15:08:06,505 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (MSC service thread 1-2) Table ‘bonita_journal.platform’ doesn’t exist
15:08:06,510 INFO [org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl] (MSC service thread 1-2) HHH000106: Forcing container resource cleanup on transaction completion
15:08:09,041 INFO [org.bonitasoft.engine.EngineInitializer] (MSC service thread 1-2) Platform is already initialized.: org.bonitasoft.engine.exception.CreationException: Platform Creation failed.
at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createPlatform(PlatformAPIImpl.java:159) [bonita-server-6.5.0.jar:]
at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createAndInitializePlatform(PlatformAPIImpl.java:200) [bonita-server-6.5.0.jar:]
at org.bonitasoft.engine.PlatformTenantManager.createPlatform(PlatformTenantManager.java:43) [bonita-server-6.5.0.jar:]
at org.bonitasoft.engine.EngineInitializer.initPlatform(EngineInitializer.java:140) [bonita-server-6.5.0.jar:]
at org.bonitasoft.engine.EngineInitializer.initializeEngine(EngineInitializer.java:93) [bonita-server-6.5.0.jar:]
at org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener.contextInitialized(EngineInitializerListener.java:43) [bonita-server-6.5.0.jar:]
at io.undertow.servlet.core.ApplicationListeners.contextInitialized(ApplicationListeners.java:173) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at io.undertow.servlet.core.DeploymentManagerImpl.deploy(DeploymentManagerImpl.java:193) [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:87)
at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.start(UndertowDeploymentService.java:72)
at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1948)
at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1881)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_40]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_40]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_40]
Caused by: org.bonitasoft.engine.platform.exception.SPlatformCreationException: java.sql.SQLException: You cannot set autocommit during a managed transaction!
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.initializePlatformStructure(PlatformServiceImpl.java:410) [bonita-server-6.5.0.jar:]
at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createPlatform(PlatformAPIImpl.java:147) [bonita-server-6.5.0.jar:]
… 14 more
Caused by: java.sql.SQLException: You cannot set autocommit during a managed transaction!
at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.setJdbcAutoCommit(BaseWrapperManagedConnection.java:968)
at org.jboss.jca.adapters.jdbc.WrappedConnection.setAutoCommit(WrappedConnection.java:716)
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.doExecuteSQLThroughJDBC(PlatformServiceImpl.java:268) [bonita-server-6.5.0.jar:]
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.executeSQLResource(PlatformServiceImpl.java:258) [bonita-server-6.5.0.jar:]
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.executeSQLResources(PlatformServiceImpl.java:199) [bonita-server-6.5.0.jar:]
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.executeSQLResources(PlatformServiceImpl.java:189) [bonita-server-6.5.0.jar:]
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.initializePlatformStructure(PlatformServiceImpl.java:406) [bonita-server-6.5.0.jar:]
… 15 more

The main error is here: You cannot set autocommit during a managed transaction! So my question is, how do I turn of autocommit?

2

Hello,

Presently BonitaBPM 6.5.0 support Java 8 only with TOMCAT.
The support of JBOSS and Weblogic with Java 8 will come in a future release of BonitaBPM.

I’m assuming that no testing has been performed on a JBOSS (WildFly 8 like) with Java 8, and that’s why you are having this error.

You can also try to report an issue here :
http://community.bonitasoft.com/resources/faq#report-issue

Regards,
LL

3

Hi,

Can you share the procedure you followed to install on WilFly?
Especially the configuration of the datasource you made.
Such kind of error message makes me think that the datasource might not be configured properly for JTA.

Captain Bonita.

4

Hi LL,

Any idea which release this is planned for?