topic Re: Activiti 5.0 Engine ported to SQL Server 2008 in Alfresco Archive

Activiti 5.0 Engine ported to SQL Server 2008

k_kunti — Thu, 13 Jan 2011 22:08:22 GMT

Hi AllI was trying to port Activiti 5.0 (ENGINE ONLY) to Microsoft SQL server (as mentioned in the WIKI); got some encouraging results:Tests run: 460, Failures: 2, Errors: 0, Skipped: 0These two cases relates to1. classname="org.activiti.engine.test.api.repository.ProcessDefinitionQueryTest" name="t

Re: Activiti 5.0 Engine ported to SQL Server 2008

ronald_van_kuij — Fri, 14 Jan 2011 01:52:26 GMT

thanks so far. I created ACT-542. hopefully others will help to

Re: Activiti 5.0 Engine ported to SQL Server 2008

thilka — Fri, 14 Jan 2011 17:09:31 GMT

Found some information about the behaviour of SQL Server. It seems like SQL Server does not support the ANSI Standard (allowing multiple nulls in unique constraints) until now.

See this link:
http://connect.microsoft.com/SQLServer/feedback/details/299229/change-unique-constraint-to-allow-multiple-null-values

Tobias

Re: Activiti 5.0 Engine ported to SQL Server 2008

thilka — Fri, 14 Jan 2011 17:12:05 GMT

By the way:

I tried your patches with the current 5.1 release and SQL Server 2008. Besides the issue with the unique constraint ACT_UNIQ_RU_BUS_KEY, the tests of our application run properly with SQL Server 2008.

Hope we will have the SQL Server support in 5.2.

Tobias

Re: Activiti 5.0 Engine ported to SQL Server 2008

k_kunti — Sat, 15 Jan 2011 15:51:58 GMT

Hi

Everyone thank you . it will be great if we can include it in the 5.2 release ….

Thanks gain
krish

Re: Activiti 5.0 Engine ported to SQL Server 2008

tombaeyens — Thu, 20 Jan 2011 14:22:12 GMT

Krich,

It would be great if you could sign a contributor agreement so that we can accept your contribution.
Instructions can be found here: http://docs.codehaus.org/pages/viewpage.action?pageId=163872771

Then we can help you commit these changes on a branch so that we can review and adopt your work in the main codebase.

Re: Activiti 5.0 Engine ported to SQL Server 2008

k_kunti — Fri, 21 Jan 2011 09:52:10 GMT

Hi

I checked the issue related to::::

2. Creation of MYbatis SQL server query for Link for SQL for unique constraint Business Key.txtclassname="org.activiti.engine.test.api.repository.ProcessDefinitionQueryTest" name="testQueryByNameLike"

Looks like SQL server default vocabulary is case insensitive and hence LIKE expression matching will result case insensitive results. I validated the same by running query in my SQL server installation.

So this issue is inherent to default SQL server installation…. any suggestions regarding how to proceed on this one.

Thanks in advance
Krish

Re: Activiti 5.0 Engine ported to SQL Server 2008

k_kunti — Tue, 25 Jan 2011 08:10:42 GMT

Hi Tom/Joram

I have applied for developer membership application in Codehaus Activiti page; as well as got permission from my employer towards making this contribution. I will be mailing you the agreement soon.

Kindly approve.

Thank you
Krish

Re: Activiti 5.0 Engine ported to SQL Server 2008

redwood7 — Mon, 31 Jan 2011 20:32:12 GMT

In SQL Server 2008 you can use filtered indexes for the ACT_UNIQ_RU_BUS_KEY and ACT_UNIQ_HI_BUS_KEY. So instead of removing those constraints entirely from the MSSQL create script, create them like this:


CREATE UNIQUE INDEX ACT_UNIQ_RU_BUS_KEY
ON dbo.ACT_RU_EXECUTION(PROC_DEF_ID_,BUSINESS_KEY_)
WHERE BUSINESS_KEY_ IS NOT NULL; 
    
CREATE UNIQUE INDEX ACT_UNIQ_HI_BUS_KEY
ON dbo.ACT_HI_PROCINST(PROC_DEF_ID_,BUSINESS_KEY_)
WHERE BUSINESS_KEY_ IS NOT NULL;

Re: Activiti 5.0 Engine ported to SQL Server 2008

k_kunti — Tue, 01 Feb 2011 03:55:38 GMT

Hi Redwood

Thank you, I will change the script and re run the test cases, to see the impact.

Krish

Re: Activiti 5.0 Engine ported to SQL Server 2008

jschnitzer — Fri, 11 Mar 2011 03:03:29 GMT

Hello,

Will there be support for SQL Server 2005? We seem to be hitting issues on unique keys that have a filter:

create unique index ACT_UNIQ_RU_BUS_KEY on ACT_RU_EXECUTION (PROC_DEF_ID_, BUSINESS_KEY_) where BUSINESS_KEY_ is not null;

Also, of note: I attempted to install the schema from the following file:

https://svn.codehaus.org/activiti/activiti/tags/activiti-5.3/modules/activiti-engine/src/main/resources/org/activiti/db/create/activiti.mssql.create.engine.sql

I am using the 5.3 version of the engine. If you inspect this file you can see:

insert into ACT_GE_PROPERTY
values ('schema.version', '5.1', 1);

insert into ACT_GE_PROPERTY
values ('schema.history', 'create(5.1)', 1);

Seems to be set to 5.1

Granted I am hacking around a bit to try to get this schema installed as I could not install it from the auto create due to the index issues on 2005.

We are stoked to add Activiti into our environment. Just currently limited by having to use a MS SQL SERVER 2005 database.

Thank you.
Jason

Re: Activiti 5.0 Engine ported to SQL Server 2008

frederikherema1 — Mon, 14 Mar 2011 07:22:19 GMT

Hi,

There are no plans for supporting mssql 2005 yet.

About the version-issue in the create-scripts, thank you for reporting, i'll fix this on trunk. We still don't have full QA set up for mssql now (also thats why it's still marked as "experimental"), this slipped in under the radar.