topic Re: DB2 support going stable? in Alfresco Archive

DB2 support going stable?

rlm — Thu, 26 May 2011 13:27:21 GMT

Hi ActivitiWe 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 runni

Re: DB2 support going stable?

frederikherema1 — Thu, 26 May 2011 16:01:38 GMT

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?

Re: DB2 support going stable?

rlm — Fri, 27 May 2011 07:23:06 GMT

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

Re: DB2 support going stable?

rlm — Wed, 01 Jun 2011 08:01:54 GMT

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?

Re: DB2 support going stable?

rlm — Tue, 07 Jun 2011 14:31:27 GMT

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

Re: DB2 support going stable?

rlm — Tue, 21 Jun 2011 12:50:29 GMT

Bump!

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

/René

Re: DB2 support going stable?

frederikherema1 — Fri, 24 Jun 2011 06:39:26 GMT

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…

Re: DB2 support going stable?

kulandai — Wed, 01 Aug 2012 05:27:04 GMT

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

Re: DB2 support going stable?

frederikherema1 — Wed, 01 Aug 2012 05:52:26 GMT

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

Re: DB2 support going stable?

kulandai — Wed, 01 Aug 2012 06:11:35 GMT

Thank you frederikheremans for the very quick response.

Re: DB2 support going stable?

bernd_ruecker — Wed, 01 Aug 2012 16:24:21 GMT

Hi Frederik.

We just changed the LIMIT's on DB2 because we had quite some performance issues on big installations for DB2. We have it in our QA as well, see the commit from today, we had to add the license JAR's. I hope that doesn't break anything on your side? Otherwise let me know!

Cheers
Bernd

Re: DB2 support going stable?

frederikherema1 — Thu, 02 Aug 2012 06:43:28 GMT

Bernd,

If your QA works for it (I presume it's the regular engine test-suite) I'm confident it works

Re: DB2 support going stable?

bernd_ruecker — Thu, 02 Aug 2012 07:27:57 GMT

It does now, I fixed a bug in the constraints, and I could even remove the licenses again. Now it's fine again.