I am trying to install Bonita BPM Community 7.2.2 (Tomcat Bundle) with Postgresql database, however I got following exception during first time server startup. Seems the script is using some incompatible DDL to create tables (creating longblob type column which is not supported by PGSQL). I am sure all DB configurations are done properly.
（anther question is why it has H2 related warnings while I have removed H2 configuration and jars? ）
=============================================
2016-04-21 13:54:46.565 +0800 org.bonitasoft.engine.EngineInitializer org.bonitasoft.engine.EngineInitializer initializeEngine
信息: Initializing Bonita Engine…
2016-04-21 13:54:46.566 +0800 org.bonitasoft.engine.EngineInitializer org.bonitasoft.engine.EngineInitializer initializeEngine
信息: Initializing Spring context…
2016-04-21 13:54:48.755 +0800 org.hibernate.dialect.H2Dialect org.hibernate.dialect.H2Dialect
WARN: HHH000431: Unable to determine H2 database version, certain features may not work
2016-04-21 13:54:51.748 +0800 org.hibernate.dialect.H2Dialect org.hibernate.dialect.H2Dialect
WARN: HHH000431: Unable to determine H2 database version, certain features may not work
2016-04-21 13:54:51.757 +0800 org.hibernate.type.TypeFactory org.hibernate.type.TypeFactory$TypeScopeImpl injectSessionFactory
WARN: HHH000233: Scoping types to session factory org.hibernate.internal.SessionFactoryImpl@51e4a58d after already scoped org.hibernate.internal.SessionFactoryImpl@1a042a05
2016-04-21 13:54:53.270 +0800 org.bonitasoft.engine.EngineInitializer org.bonitasoft.engine.EngineInitializer initializeEngine
信息: Initializing platform…
2016-04-21 13:54:53.270 +0800 org.bonitasoft.engine.EngineInitializer org.bonitasoft.engine.EngineInitializer initPlatform
信息: Creating platform…
2016-04-21 13:54:53.393 +0800 org.hibernate.engine.jdbc.spi.SqlExceptionHelper org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
WARN: SQL Error: 0, SQLState: 42P01
2016-04-21 13:54:53.393 +0800 org.hibernate.engine.jdbc.spi.SqlExceptionHelper org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
ERROR: 错误: 关系 “platform” 不存在
位置：293
2016-04-21 13:54:53.410 +0800 org.bonitasoft.engine.platform.impl.PlatformServiceImpl org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
严重: THREAD_ID=16 | HOSTNAME=BonitaBPM-A | 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
)
2016-04-21 13:54:53.411 +0800 org.bonitasoft.engine.EngineInitializer org.bonitasoft.engine.EngineInitializer initializeEngine
信息: Platform is already initialized.
org.bonitasoft.engine.exception.CreationException: Platform Creation failed.
at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createPlatform(PlatformAPIImpl.java:145)
at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createAndInitializePlatform(PlatformAPIImpl.java:186)
at org.bonitasoft.engine.PlatformTenantManager.createPlatform(PlatformTenantManager.java:42)
at org.bonitasoft.engine.EngineInitializer.initPlatform(EngineInitializer.java:140)
at org.bonitasoft.engine.EngineInitializer.initializeEngine(EngineInitializer.java:93)
at org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener.contextInitialized(EngineInitializerListener.java:42)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5077)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5591)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:677)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1939)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: org.bonitasoft.engine.platform.exception.SPlatformCreationException: org.postgresql.util.PSQLException: 错误: 类型 “longblob” 不存在
位置：171
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.createTables(PlatformServiceImpl.java:179)
at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createPlatform(PlatformAPIImpl.java:129)
… 18 more
Caused by: org.postgresql.util.PSQLException: 错误: 类型 “longblob” 不存在
位置：171
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:405)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:397)
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.doExecuteSQLThroughJDBC(PlatformServiceImpl.java:283)
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.executeSQLResource(PlatformServiceImpl.java:258)
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.executeSQLResources(PlatformServiceImpl.java:199)
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.executeSQLResources(PlatformServiceImpl.java:189)
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.createTables(PlatformServiceImpl.java:177)
… 19 more