Tomcat server won't start

Q&A
1

Hello, I need some help.
I would like to connect to a Oracle Database with bonita bpm Community.

What I did was this:
http://documentation.bonitasoft.com/database-configuration-1

I followed these steps:
→ set DB_OPTS=“-Dsysprop.bonita.db.vendor=oracle” to oracle in the setenv.sh
→ was commenting out

in the server.xml
→ commenting this out :

H2 example

#resource.ds1.className=org.h2.jdbcx.JdbcDataSource
#resource.ds1.driverProperties.user=sa
#resource.ds1.driverProperties.password=
#resource.ds1.driverProperties.URL=jdbc:h2:tcp://localhost:9091/bonita_journal.db;MVCC=TRUE;DB_CLOSE_ON_EXIT=TRUE;IGNORECASE=TRUE;
#resource.ds1.testQuery=SELECT 1

and set this insetad :

Oracle example

resource.ds1.className=oracle.jdbc.xa.client.OracleXADataSource
resource.ds1.driverProperties.user=user
resource.ds1.driverProperties.password=pw
resource.ds1.driverProperties.URL=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dbsrv01.desy.de)(PORT=1521))(ADDRESS=(PROTOCOL = TCP)(HOST = dbsrv02.desy.de)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = dbsrv03.desy.de)(PORT = 1521))(LOAD_BALANCE = yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = desy_db.desy.de)(FAILOVER_MODE =(TYPE = NONE)(METHOD = BASIC)(RETRIES = 180)(DELAY = 5))))

in the bitronix-resources.properties

→ and use this in the** bonita.xml:**

<Resource name="bonitaSequenceManagerDS"
          auth="Container"
          type="javax.sql.DataSource"
          maxActive="17"
          minIdle="5"
          maxWait="10000"
          initialSize="3"
          validationQuery="SELECT 1 FROM dual"
          validationInterval="30000"
          removeAbandoned="true"
          logAbandoned="true"
          username="kraemm"
          password="Aho1ho1"
          driverClassName="oracle.jdbc.OracleDriver"
          url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dbsrv01.desy.de)(PORT=1521))(ADDRESS=(PROTOCOL = TCP)(HOST = dbsrv02.desy.de)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = dbsrv03.desy.de)(PORT = 1521))(LOAD_BALANCE = yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = desy_db.desy.de)(FAILOVER_MODE =(TYPE = NONE)(METHOD = BASIC)(RETRIES = 180)(DELAY = 5))))"/>

I copied the odbc.jar in the mentioned folders.

But … it won’t work. The Tomcat server just don’t start. (was waiting for 20 minutes now)

I use Ubuntu 14.04 and Bonita bpm 7.1.4 Community.

Please, can somebody help me and tell me what I have to do to make this stuff work?
(the server URL work’s with SQL Developer and SQLplus)

Edit:
The DB System is Oracle 12c. It seems like, the latest version supported is 11 R2?!
And my problem is, that I just want to connect to a existing Oracle Database, reached by the URL I posted above.

2

Bonita 7.1.4 Community? But which type? Studio (where you develop) or Portal (where you DON’T develop)

If Studio then changing the database is not supported. Only in the portal is it supported.