2 Replies Latest reply on Sep 4, 2017 9:47 PM by huyrong

    Configure BPM Suite used MS SQL and set unicode for task


      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.

        • 1. Re: Configure BPM Suite used MS SQL and set unicode for task

          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.





          • 2. Re: Configure BPM Suite used MS SQL and set unicode for task

            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.