Errors while loading BPM.zip 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 https://www.dropbox.com/sh/qqzsztuvzoqjtix/AADX0NILbRlvzXLoW96xlR0Xa?dl=...
Hi RVermeulen,
Did you configured the file: <bonita.home>\server\platform\tenant-template\conf\bonita-server.properties
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/bitronix-resources.properties 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\bonita-server.properties**
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: http://documentation.bonitasoft.com/database-configuration-0#configdatas...
Best, Florian
Comments
Florian,
We did but we still have some issues with uploading the bdm.zip 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 bonita-server.properties 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 https://www.dropbox.com/sh/qqzsztuvzoqjtix/AADX0NILbRlvzXLoW96xlR0Xa?dl=0
Can you please give me an update on the status?
Comments
I think you didn't put a correct dropbox link, it shows a .pptx file...
that was indeed a wrong one, it should be this one https://www.dropbox.com/sh/qqzsztuvzoqjtix/AADX0NILbRlvzXLoW96xlR0Xa?dl=0
Thanks Florian, IT-staff here tells me indeed that they see differences between current set-up and what you have underlined in your answer.