Bonita 7.2.4 using MySQL rather than Oracle

1
0
-1

Trying to migrate from Bonita 7.2.0 to 7.2.4, and when Bonita starts it seems to be using MySQL statements, rather than the expected Oracle statements.

The error I am getting is:
`WARN: SQL Error: 933, SQLState: 42000
2017-02-14 14:44:41.137 +1300 org.hibernate.engine.jdbc.spi.SqlExceptionHelper org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
ERROR: ORA-00933: SQL command not properly ended

SEVERE: THREAD_ID=17 | HOSTNAME=<#######> | Following SQL command failed: CREATE TABLE contract_data (
tenantid BIGINT NOT NULL,
id BIGINT NOT NULL,
kind VARCHAR(20) NOT NULL,
scopeId BIGINT NOT NULL,
name VARCHAR(50) NOT NULL,
val LONGBLOB
)`

I have configured both bitronix-resources.properties and bonita.xml for our Oracle database, so can't see why the above mySQL statement is occuring.

The table 'contract_data' exists also, so there is no need to create the table either.

1 answer

1
+1
-1
This one is the BEST answer!

OK, this has been resolved.

I needed to configure my bin/setenv.sh correctly.

Notifications