Error when deploying a new on Server installed with PostgreSQL 9.6 and higher

Blog Categories: 

Component: Engine | Version: N/A

I cannot deploy the in my portal and see this error in the bonita logs:

13-Feb-2018 00:19:22.751 WARNING [http-nio-8080-exec-6] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logExceptions SQL Error: 0, SQLState: 42703
13-Feb-2018 00:19:22.751 SEVERE [http-nio-8080-exec-6] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logExceptions ERROR: column am.amcanorder does not exist
Position: 407
13-Feb-2018 00:19:22.751 SEVERE [http-nio-8080-exec-6] org.hibernate.tool.hbm2ddl.SchemaUpdate.execute HHH000299: Could not complete schema update


As per Bonita supported Hardware and software requirements matrix ( , PostgreSQL supported version are 9.3 and higher in the 9.3.x line.
So the jdb driver postgresql-9.3-1102-jdbc41.jar that is provided in the product out of the box (in the bundles and in the migration tool), is only compatible for these versions.


When you use PostgreSQL 9.6 or higher, you need to use the relevant jdbc driver for your version.

1.Go to PostgreSQL JDBC driver download page:
Download the driver that supports your PostgreSQL version (version 42.2.x when your java version is 1.8)
2. Replace it the default driver by the one you just downloaded in your install:
SETUP_TOOL/lib/ (for Bonita version 7.3+)
TOMCAT_HOME/lib/bonita/ (for Bonita version < 7.3 or for Deploy bundle)
3. Re-start the server.