DB2 support going stable?

[rlm]

Hi Activiti

We are looking into using Activiti as a major part of the next version of our core main-system.
We are using DB2 on the latest version of i/OS (IBM iSeries) as the backend DB and would like to use it as backend for Activiti as well.

We are currently testing the DB2 integration but are running into some problems. Until now we haven't seen any problems we couldn't solve though.

We would really like to see the DB2 integration be stable, which it obvious isn't right now.
What will it take for it to be stable? and how can we help exactly.
Is it "just" a matter of getting the creation scripts running, and all unit tests turning green?
or what is your "stable" criteria?

Depending on the amount of work we might be able to help out.

Best regards

René Markvard

[frederikherema1]

Hi,

We're setting up DB2 and MSSQL QA, but that process has been stuck in the pipeline somewhere But the plan is to have test-coverage on DB2 asap. Once all tests run green on DB2, it's no longer experimental and considered stable.

Do you have the test running against a DB2-instance?

[rlm]

Hi,

Do you have the test running against a DB2-instance?

Not yet, but we are working on it. We are running into trouble in the creation-scripts, which we are working on fixing right now. After that we are going to run the tests (and maybe try some examples to).

Regarding the examples we have identified some challenges using JPA.
We are using system-naming but some of the SQL in the OpenJPA DB2Dialect is not. This is of cause not related directly to Activiti.

/René Markvard

[rlm]

Now we have all tests passing 
and we have a patch ready for 5.7. Do I just open a new issue in Jira and add the patch?

We have changed the JDBC driver and fixed some minor (but still blocking) issues.
Again this is agains the latest version of DB2 running on IBM iSeries.

It might be necessary to distinguish between the different versions of DB2 (or DB2 host) environments.
Like db2.iseries, db2.windows, db2.express is this acceptable. We are only able to do the db2.iseries part.

Right now we are testing the examples. Regarding JPA we have changed the persistence provider to using Hibernate
as the DB2Dialect are allowing the use of system-naming.

/René

PS: Should this actually go to the developer forum?

[rlm]

I just created a new jira issue with patches attached

http://jira.codehaus.org/browse/ACT-844

I'm looking forward to answer any questions…

Also it would be interesting to hear from other users of DB2 if these changes also passes all tests on their version/OS.

Best regards

René Lund Markvard

[rlm]

Bump!

Any comments on this?
(any chance it will make it to the roadmap?)

/René

[frederikherema1]

Thanks for the patches. Our QA is almost up and running for this, so we should be able to start stabilizing it in the near future…

[kulandai]

Team,

Though its a very old post, I am reviving this as it is the same question I want to repeat.

We are considering using Activiti, and we have DB2 as our database. In supporteddatabases section of userguide we have support for DB2 as EXPERIMENTAL.

Can you please help me understand, what is the gap to make it stable.

Regards,
Joseph

[frederikherema1]

This is just an outdated user guide. DB2-support iOS fully stable, and QA'ed as part of the alfresco enterprise edition.

[kulandai]

Thank you frederikheremans for the very quick response.