topic Re: Derby database with Activiti in Alfresco Archive

Derby database with Activiti

ayusman — Tue, 18 Jan 2011 10:49:50 GMT

All,I am new to Activiti.Is it possible to configure Activiti to use derby database? Asking this because I see limited database support for activiti at this point.Thanks,Ayusman

Re: Derby database with Activiti

frederikherema1 — Tue, 18 Jan 2011 12:10:20 GMT

Hi,

Currently derby is not supported by activiti, and nothing is planned for this. You can add support for derby yourself, and since most of our SQL works on all DB's (with very few exceptions) this won't be that difficult I suppose.

Read this wiki-page on how to get started on this: http://docs.codehaus.org/display/ACT/How+to+add+support+for+new+databases

Re: Derby database with Activiti

krraghavan — Fri, 08 May 2015 04:05:29 GMT

I realize this is a really old post but I was able to get Derby to work by subclassing SpringProcessEngineConfiguration and adding an entry in the database mapping using the DB2 mapping (tried all mappings until I found one that worked basically). Not sure if I will run into any other issues but my unit tests passed.

public class SpringProcessEngineConfigurationWithDerbySupport extends SpringProcessEngineConfiguration {

    public static final String DERBY = "derby";

    public SpringProcessEngineConfigurationWithDerbySupport() {
        super();
        databaseTypeMappings.put("Apache Derby", DATABASE_TYPE_DB2);
    }
}