Getting Bonita works on mssql server

Submitted by njbour on Wed, 09/24/2014 - 15:18

I followed all the steps to make Bonita works with Sql Server. The only issue we have is when we run the system trying to initialize the database but it stopped with this error: Caused by: org.bonitasoft.engine.platform.SPlatformCreationException: Unable to create platform tables : com.microsoft.sqlserver.jdbc.SQLServerException: Column, parameter, or variable #3: Cannot find data type LONGVARCHAR. at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.createPlatformTables(PlatformServiceImpl.java:151) at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createPlatform(PlatformAPIImpl.java:152) ... 29 more

Which mean that the system trying to run H2 script on sql server.

I checked my setenv.bat and it indeed changed to set the DB_OPTS. in setenv.bat: set DB_OPTS="-Dsysprop.bonita.db.vendor=sqlserver"

I am using windows 8.1 and Sql server 2012.

Any clue?

Log in or register to post comments
2018 reads

Comments

Submitted by haris.subasic on Wed, 09/24/2014 - 16:16

You also need to change the dialect in this file: <bonita.home>\server\platform\tenant-template\conf\bonita-server.properties Did you do it?

Permalink

No answers yet.