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.