cannot safely start the transaction manager

1
0
-1

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

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&useUnicode=true&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

2 answers

1
0
-1
This one is the BEST answer!

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

1
0
-1

That is the information I needed, thank you.

Notifications