cannot safely start the transaction manager

BonitaBPMCommunity-6.2.2-Tomcat-6.0.37

java version "1.7.0_51"
Java(TM) SE Runtime Environment (build 1.7.0_51-b13)
Java HotSpot(TM) 64-Bit Server VM (build 24.51-b03, mixed mode)

Ubuntu 12.10 x64

Attempting to start bonita I am getting the following error message(s), Caused by: bitronix.tm.utils.InitializationException: initialization failed, cannot safely start the transaction manager

Followed the guidlines at http://documentation.bonitasoft.com/tomcat-bundle, I'm using MYSql on a different server, commented out the H2 listener, changed setenv.sh to DB_OPTS="-Dsysprop.bonita.db.vendor=mysql". Changed bitronix-resources.properties to

# MySQL example
resource.ds1.className=com.mysql.jdbc.jdbc2.optional.MysqlXADataSource
resource.ds1.driverProperties.user=bonita
resource.ds1.driverProperties.password=xxxx
resource.ds1.driverProperties.URL=jdbc:mysql://srvmysql:3306/bonita?dontTrackOpenResources=true&useUnicode=true&characterEncoding=UTF-8
resource.ds1.driverProperties.testQuery=SELECT 1

Changed bonita.xml to

<!-- MySQL Example -->

      <Resource name="bonitaSequenceManagerDS" 
              auth="Container" 
              type="javax.sql.DataSource"
              maxActive="17" 
              minIdle="5" 
              maxWait="10000" 
              initialSize="3"
              maxPoolSize="15"
              minPoolSize="3"
              maxConnectionAge="0"
              maxIdleTime="1800"
              maxIdleTimeExcessConnections="120"
              idleConnectionTestPeriod="30"
              acquireIncrement="3"
              validationQuery="SELECT 1"
              validationInterval="30000"
              testConnectionOnCheckout="true"
              removeAbandoned="true"
              logAbandoned="true"
              username="bonita"
              password="xxx"
              driverClassName="com.mysql.jdbc.Driver"
              url="jdbc:mysql://srvmysql:3306/bonita?dontTrackOpenResources=true&amp;useUnicode=true&amp;characterEncoding=UTF-8"/>

Believe where I"m hung up at is the installation of the JDBC driver, I downloaded the file, "unzipped" it to lib folder, inside the lib folder is another folder called mysql-connector-java-5.1.29, is this correct? Just need a bit of help pointing me in the right direction where to look to determine why the transaction manager is not starting.

Thanks

 

That is the information I needed, thank you.

Hi

The only file that you need under CATALINA-HOME/lib is mysql-connector-java-5.1.29-bin.jar and not the whole folder.

Hope it can solve you problem