Derby database with Activiti

[ayusman]

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

[frederikherema1]

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

[krraghavan]

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);
    }
}