AnsweredAssumed Answered

Activiti integration with mssql 2008

Question asked by roig on Jan 4, 2012
I was trying to integrate activiti with mssql 2008 after reading in "Activiti in Action" that it is possible.
Basically what I was trying to do was to run the explorer and the rest api from the same java class so they will both point to the same DB
I was successful in doing so but when I tried to integrate the msssql 2008 DB, i ran into the following error:

Cannot find data type clob

This was solved by creating a clob data type (think of it as typdef in C) using the following command:

if not exists (select 1 from sys.types where name = 'CLOB')
CREATE TYPE CLOB
FROM NVARCHAR(max) NULL;

Hope this will help someone who encountered the same problem

Outcomes