topic Re: How to use Activiti in a environment with Sql Server DB configured with NOCOUNT=ON in Alfresco Archive

How to use Activiti in a environment with Sql Server DB configured with NOCOUNT=ON

denisgmarques — Fri, 27 Jun 2014 18:34:11 GMT

Hello, We have a particular situation where we install the Activiti in a SQL SERVER 2008 R2 Server Database, which has other systems running. This server is configured with the NOCOUNT = ON attribute by default. We checked the possibility of leaving the default configuration of SQL SERVER (NOCOUNT O

Re: How to use Activiti in a environment with Sql Server DB configured with NOCOUNT=ON

pmsevestre — Sun, 29 Jun 2014 17:03:56 GMT

Have you tried to add a "set nocount = on" to your SQL connection test statement ? Check your datasource pool documentation how can you achieve this. There usually is a setting called "connection check statement" or somehing like this. E.g, in tomcat the property is called "validationQuery".

Re: How to use Activiti in a environment with Sql Server DB configured with NOCOUNT=ON

denisgmarques — Mon, 30 Jun 2014 19:16:45 GMT

Hi pmsevestre, following your suggestion, we have solved by adding the following statement to the datasource:

<blockcode>

<new-connection-sql>set nocount off</new-connection-sql>

</blockcode>
Thanks for the tip.

😃