Bonita Studio with PostgreSQL DB: ERROR: type "longvarchar" does not exist

Q&A
1

I haven’t seen any “direct” documentation showing Bonita Studio 6.5 Community Edition “Process Engine” could be connected to PostgreSQL. Everything I’ve found relates to the deployment environment configuration. Has anyone done this?

I’ve been working on this, but I get this error:

Caused by: org.bonitasoft.engine.platform.exception.SPlatformCreationException: org.postgresql.util.PSQLException: ERROR: type “longvarchar” does not exist
Position: 136
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.createTables(PlatformServiceImpl.java:179)
at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createPlatform(PlatformAPIImpl.java:143)
… 18 more
Caused by: org.postgresql.util.PSQLException: ERROR: type “longvarchar” does not exist
Position: 136

Here is the table creation that failed:

Following SQL command failed: CREATE TABLE category (
tenantid BIGINT NOT NULL,
id BIGINT NOT NULL,
name VARCHAR(50) NOT NULL,
creator BIGINT,
description LONGVARCHAR,
creationDate BIGINT NOT NULL,
lastUpdateDate BIGINT NOT NULL,
UNIQUE (tenantid, name),
PRIMARY KEY (tenantid, id)
)

Anyone experience this error before? Below is the documentation I’ve been working with, but there are a few other changes that needed to made as well.
http://documentation.bonitasoft.com/database-configuration-1

2

It is NOT possible to change the database that Studio Community uses. It is only possible to change the database for a deployed Tomcat/JBOSS Bundle.

You can use PostgreSQL via the database connectors or java code in a script connector but not Studio itself.

regards
Seán

3

I may have missed this in the install documentation. If it isn’t there, I think it would be great to state this somewhere in the installation documentation. Thanks!