Error when deploying a new bdm.zip on Server installed with PostgreSQL 9.6 and higher
Component: Engine | Version: N/A
I cannot deploy the bdm.zip 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 java.lang.NullPointerException
As per Bonita supported Hardware and software requirements matrix (https://documentation.bonitasoft.com/bonita/7.8/hardware-and-software-re...) , 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: https://jdbc.postgresql.org/download.html
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.