Errors while loading to a Postgres Bonita server


The attached .zip is an extract from my 6.3.7. studio and can be loaded to the local portal which is of course based on H2. When loaded to our Bonita server with Postgres database it reports errors as also visible in attached log file.

Can somebody please help me in solving this issue?

The .zip & Log-file can be found on


Submitted by haris.subasic on Wed, 11/12/2014 - 09:51

I think you didn't put a correct dropbox link, it shows a .pptx file...

Submitted by RVermeulen on Wed, 11/12/2014 - 10:40
Submitted by RVermeulen on Thu, 11/13/2014 - 14:35

Thanks Florian, IT-staff here tells me indeed that they see differences between current set-up and what you have underlined in your answer.

2 answers

This one is the BEST answer!

Hi RVermeulen,

Did you configured the file: <bonita.home>\server\platform\tenant-template\conf\

For Business data data source (default name DS2 specific to business data), change the DS2 to DBMS value.

To do this:

Open <TOMCAT_HOME>/conf/ file.
Update the value for the following settings:
    resource.ds2.driverProperties.user put your DBMS user name.
    resource.ds2.driverProperties.password put your DBMS password.
    resource.ds2.driverProperties.serverName put the address (IP or hostname) of your DBMS server.
    resource.ds2.driverProperties.portNumber put the port of your DBMS server.
    resource.ds2.driverProperties.databaseName put the database name.
Save and close the file.

In addition, change the dialect in the following file: ** <bonita.home>\server\platform\tenant-template\conf\**

before changes (MySQL example): businessdata.hibernate.dialect=org.hibernate.dialect.H2Dialect

after changes (MySQL example): businessdata.hibernate.dialect=org.hibernate.dialect.MySQLDialect - See more at:

Best, Florian


Submitted by mmeijer on Fri, 11/14/2014 - 10:20


We did but we still have some issues with uploading the Portal note is: USERNAME=install | org.hibernate.HibernateException: Dialect class not found: org.hibernate.dialect.PostgreSQLDialect

So there is something wrong with org.hibernate.dialect.PostgreSQLDialect config in my file

i already tried org.hibernate.dialect.PostgressDialect

( I change this in template and tenants)

Whe are using postgress 9.3 and the tomacat bundel

regards, Mark


Hi Haris, not sure if you have seen my comment on your remark.

that was indeed a wrong hyperlink, it should be this one

Can you please give me an update on the status?


Submitted by haris.subasic on Thu, 11/13/2014 - 09:21

Sorry but I have no tips for your problem, I just wanted to warn you that your attachment was wrong, so that someone could try to help you.