Configure BPM Suite used MS SQL and set unicode for task

[huyrong]

I have two problem:

1.     I try config BPM Suite used SQL Server 2016 (jdbc: sqljdbc4-2.0.jar , hibernate.dialect, datasource), everything is OK, site no problem, but i look in server.log and have a error:

2017-08-30 00:17:28,087 INFO  [org.jboss.errai.cdi.server.CDIExtensionPoints] (MSC service thread 1-3) starting errai cdi ...

2017-08-30 00:17:28,343 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB default - 2) SQL Error: 102, SQLState: S0001

2017-08-30 00:17:28,344 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB default - 2) Incorrect syntax near 'limit'.

2017-08-30 00:17:28,352 WARN  [org.jbpm.shared.services.impl.TransactionalCommandService] (EJB default - 2) Could not commit session: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet

I don't know cause why appear this error, it's appear so much. I read this topic : Red Hat JBoss BPM Suite 6 Supported Configurations - Red Hat Customer Portal ---> may be that i use SQL Server 2016 is cause appear that error. How to solve this error ?

2.     When i design business process, i type unicode is OK, but when i start process, task name haved error font. I try set JAVA_OPT += "-Dfile.encoding=UTF-8" no success:

ex:Phê duyệt eform (LÐ TCTD) ----> Phê duy?t eform (LÐ TCTD)

or: Thủ tục hành chính cấp chứng thư số ----> Th? t?c hành chính c?p ch?ng thu s?

How to set unicode for BPM suite?

Thank all for your help.

[mccloud]

As you already stated, MS SQLServer 2016 is not a supported configuration for BPM Suite 6.x. Nevertheless, according to some documentation I read, not much has changed between SQL Server 2012 and 2016 from a Hibernate perspective.

You state that you've correctly configured BPM Suite. Can you explain how you configured it? Are you seeing this error when "business-central.war" starts up? Or is it an error from "kie-server.war"?

I don't have a direct answer to the "unicode" problem, will come back to that later.

Cheers,

Duncan

[huyrong]

Thank for your help.

1.Incorrect syntax near 'limit' : Cause "dashbuilder.war" using query have key "limit". I remove it from folder deployments, everything is OK. (i used jdbc 4.0 or hight, hibernate: SQLServer2012Dialect or SQLServerDialect)

2.Unicode : In script for SQL Server, it used data type varchar(..), i only change data type varchar ---> nvarchar.