AnsweredAssumed Answered

About SQLServer Engine, can't get the Task category value

Question asked by fuhang on Mar 16, 2016
Latest reply on Mar 25, 2016 by jbarrez
I countered a problem. My Activiti use SQLServer2012 verson, When I get a Task, can't get the category property of that task, but When I use oracle, it's ok.
code :
TaskQuery taskQuery = taskService.createTaskQuery().taskAssignee( assignee );
….
task.getCategory() is null
the database ACT_RU_TASK table's CATEGORY_ column exists a varchar value, and the value length in 255.
the problem is not throwing any exception.

this is my configuration :
        <bean id="dataSourceDBCP" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
      <property name="driverClassName" value="net.sourceforge.jtds.jdbc.Driver" />
      <property name="url" value="jdbc:jtds:sqlserver://192.168.15.5:1433;DatabaseName=OA_NEW_IDEA;tds=8.0;lastupdatecount=true" />
      <!– <property name="username" value="sa" />
      <property name="password" value="TEAMteam9999" /> –>
      <property name="initialSize" value="25"/>
      <property name="maxActive" value="350"/>
      <property name="minIdle" value="5"/>
      <property name="maxIdle" value="35"/>
      <property name="removeAbandoned" value="true"/>
      <property name="removeAbandonedTimeout" value="180"/>
      <property name="maxWait" value="6000"/>
      <property name="testOnBorrow">
         <value>true</value>
      </property>
   </bean>
   
   <bean id="processEngineConfiguration" class="org.activiti.engine.impl.cfg.StandaloneProcessEngineConfiguration">
      <property name="dataSource" ref="dataSourceDBCP"/>
      <!– none, activity, audit, full –>
      <property name="history" value="none"/>
      <property name="bulkInsertEnabled" value="false"/>
      <property name="databaseType" value="mssql"/>
      <property name="activityFontName" value="宋体"/>
      <property name="labelFontName" value="宋体"/>
   </bean>


Outcomes