Postgresql support?

[mlawler]

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 it just a case of schema creation, or is there a lot of internals that would still be required.

regards,
Michael

[jbarrez]

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.

[farrukh_najmi]

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.

[briantopping]

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

[briantopping]

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!

[briantopping]

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.

[tombaeyens]

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

[farrukh_najmi]

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


[briantopping]

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

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

[farrukh_najmi]

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.