topic Re: Postgresql support? in Alfresco Archive

Postgresql support?

mlawler — Wed, 15 Sep 2010 11:44:19 GMT

Hi,I'm entertaining switching my app from JBMP to Activiti. I've tried out the demo, and also got it boot via grails and mysql.How much work is there to get very basic support for postgresql?At this stage, I dont need much tool support, just a basic BPM state-machine integrated into my grails app.Is

Re: Postgresql support?

jbarrez — Thu, 16 Sep 2010 08:30:25 GMT

Christian Mulder is currently working on Postgresql support. Afaik, he pretty much nailed it.

Changes to the engine are minimal: only a few of the queries need to be rewritten because of the specific databases dont get them.

Re: Postgresql support?

farrukh_najmi — Fri, 17 Sep 2010 20:06:45 GMT

Assuming that I will use latest trunk bits for my development what is the earliest that PostgreSQL support will get committed?
I volunteer to test it out as soon as its committed. Thanks.

Re: Postgresql support?

briantopping — Sat, 18 Sep 2010 02:53:36 GMT

Hi, I am evaluating Activiti for the first time. My project has a hard requirement on PostgreSQL, so I can't do much without it. It's great to hear that the issues with it are nearing resolution, I just wanted to express my appreciation for that and attach to this thread so I can see updates on it.

Thanks! Brian

Re: Postgresql support?

briantopping — Sun, 19 Sep 2010 04:26:17 GMT

Hmm, so I found that most of what's necessary to use PSQL is already checked in.

I had some problems earlier with the code, it turns out that parsing dies silently if the resource name does not end with 'bpmn20.xml' at org.activiti.engine.impl.bpmn.deployer.BpmnDeployer line 59.

I'll add more here when I get it today, thanks!

Re: Postgresql support?

briantopping — Sun, 19 Sep 2010 16:28:28 GMT

Whew! I was able to resolve this without learning iBatis!

http://jira.codehaus.org/browse/ACT-161 includes a patch. There were some smallint fields that should have been boolean, plus some inconsistencies between the h2 schema and both the mysql and postgres schemas, which are fixed.

Re: Postgresql support?

tombaeyens — Mon, 20 Sep 2010 13:06:40 GMT

thanks Brian, we'll be looking at your patch asap.

Re: Postgresql support?

farrukh_najmi — Mon, 20 Sep 2010 17:47:32 GMT

What is the patch command to apply the patch. I tried the following command in the root directory of latest trunk (r676):


patch -p0 < activiti-671.patch

But I keep getting the following:


patching file modules/activiti-engine/src/main/resources/org/activiti/db/create/activiti.mysql.create.sql
Hunk #1 FAILED at 154.
1 out of 1 hunk FAILED – saving rejects to file modules/activiti-engine/src/main/resources/org/activiti/db/create/activiti.mysql.create.sql.rej
patching file modules/activiti-engine/src/main/resources/org/activiti/db/drop/activiti.postgres.drop.sql
Hunk #1 FAILED at 40.
1 out of 1 hunk FAILED – saving rejects to file modules/activiti-engine/src/main/resources/org/activiti/db/drop/activiti.postgres.drop.sql.rej
patching file modules/activiti-engine/src/main/resources/org/activiti/db/create/activiti.postgres.create.sql
Hunk #1 FAILED at 35.
Hunk #2 FAILED at 154.
2 out of 2 hunks FAILED – saving rejects to file modules/activiti-engine/src/main/resources/org/activiti/db/create/activiti.postgres.create.sql.rej

Re: Postgresql support?

briantopping — Mon, 20 Sep 2010 17:51:59 GMT

Hmm, are you in a directory that has a folder 'modules'?

It should work, I can't figure out why it's not working…

Re: Postgresql support?

farrukh_najmi — Mon, 20 Sep 2010 18:29:10 GMT

First thanks for the patch Brian 🙂

Yes I am in correct directory AFAIK. See output from my terminal below:

pwd
/home/najmi/activity/svn/trunk

ls
activiti-671.patch activiti.postgres.create.sql.rej activiti-root.iml eclipse modules qa
activiti.mysql.create.sql.rej activiti.postgres.drop.sql.rej distro less.rej pom.xml userguide

It really weird.

I am on Ubuntu Linux 10.04 and latest (r676) activity trunk.
What platform are you on and can you patch latest r676 trunk with your patch.

Re: Postgresql support?

briantopping — Mon, 20 Sep 2010 18:36:07 GMT

I'm on OSX.

It's a very short patch, probably easier to just apply it manually.

Re: Postgresql support?

farrukh_najmi — Mon, 20 Sep 2010 18:40:12 GMT

It seems your patch has already been partially incorporated (at least for the first change). I will post a revised patch file to the issue that works with latest trunk at r676 shortly. Thanks.