Error: com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set with sql server 2008 driver

This happens when a proc execute DML before producing a result set.
Solution is to “SET NOCOUNT ON” in data-source properties.

Modify data source and then add one property with
Type: SQL Name: SET NOCOUNT ON