topic what to do if project with activiti must have to be migrated to Postgres EnterpriseDB??? in Alfresco Archive

what to do if project with activiti must have to be migrated to Postgres EnterpriseDB???

amit4nonstop — Mon, 12 Jan 2015 05:24:23 GMT

Currently I am using postgres open database. So my project having activiti is working fine. But nowI am using edb-jdbc16.jar to connect to same postgres database. But this time I am getting this error.org.activiti.engine.ActivitiException: couldn't deduct database type from database product name 'En

Re: what to do if project with activiti must have to be migrated to Postgres EnterpriseDB???

martin_grofcik — Mon, 12 Jan 2015 13:56:25 GMT

Hi,

supported DB types are:


  protected static Properties getDefaultDatabaseTypeMappings() {
    Properties databaseTypeMappings = new Properties();
    databaseTypeMappings.setProperty("H2", DATABASE_TYPE_H2);
    databaseTypeMappings.setProperty("MySQL", DATABASE_TYPE_MYSQL);
    databaseTypeMappings.setProperty("Oracle", DATABASE_TYPE_ORACLE);
    databaseTypeMappings.setProperty("PostgreSQL", DATABASE_TYPE_POSTGRES);
    databaseTypeMappings.setProperty("Microsoft SQL Server", DATABASE_TYPE_MSSQL);
    databaseTypeMappings.setProperty(DATABASE_TYPE_DB2,DATABASE_TYPE_DB2);
    databaseTypeMappings.setProperty(DATABASE_TYPE_DB2,DATABASE_TYPE_DB2);
    databaseTypeMappings.setProperty("DB2/NT",DATABASE_TYPE_DB2);
    databaseTypeMappings.setProperty("DB2/NT64",DATABASE_TYPE_DB2);
    databaseTypeMappings.setProperty("DB2 UDP",DATABASE_TYPE_DB2);
    databaseTypeMappings.setProperty("DB2/LINUX",DATABASE_TYPE_DB2);
    databaseTypeMappings.setProperty("DB2/LINUX390",DATABASE_TYPE_DB2);
    databaseTypeMappings.setProperty("DB2/LINUXX8664",DATABASE_TYPE_DB2);
    databaseTypeMappings.setProperty("DB2/LINUXZ64",DATABASE_TYPE_DB2);
    databaseTypeMappings.setProperty("DB2/400 SQL",DATABASE_TYPE_DB2);
    databaseTypeMappings.setProperty("DB2/6000",DATABASE_TYPE_DB2);
    databaseTypeMappings.setProperty("DB2 UDB iSeries",DATABASE_TYPE_DB2);
    databaseTypeMappings.setProperty("DB2/AIX64",DATABASE_TYPE_DB2);
    databaseTypeMappings.setProperty("DB2/HPUX",DATABASE_TYPE_DB2);
    databaseTypeMappings.setProperty("DB2/HP64",DATABASE_TYPE_DB2);
    databaseTypeMappings.setProperty("DB2/SUN",DATABASE_TYPE_DB2);
    databaseTypeMappings.setProperty("DB2/SUN64",DATABASE_TYPE_DB2);
    databaseTypeMappings.setProperty("DB2/PTX",DATABASE_TYPE_DB2);
    databaseTypeMappings.setProperty("DB2/2",DATABASE_TYPE_DB2);
    databaseTypeMappings.setProperty("DB2 UDB AS400", DATABASE_TYPE_DB2);
    return databaseTypeMappings;

You must use the name from the properties. (Does PostgreSQL work for you?)

Regards
Martin

Re: what to do if project with activiti must have to be migrated to Postgres EnterpriseDB???

trademak — Mon, 12 Jan 2015 15:38:03 GMT

We currently don't support Postgres EnterpriseDB, but would all schema's for the open source Postgres work on EnterpriseDB as well? If so, then we can add the databaseTypeMapping and it should work.

Best regards,

Re: what to do if project with activiti must have to be migrated to Postgres EnterpriseDB???

amit4nonstop — Tue, 13 Jan 2015 05:15:32 GMT

Hi Tijs Rademakers,

thanks for your valuable comments. Can u please elaborate on how to add databaseTypeMapping in Activiti so that it will work with enter prise DB???

Regards,
Amit

Re: what to do if project with activiti must have to be migrated to Postgres EnterpriseDB???

trademak — Fri, 16 Jan 2015 11:51:15 GMT

We'll add the databaseTypeMapping when I know if Enterprise DB runs on our default Postgres scripts. Did you test that already? Are there differences between the SQL dialect of Postgres and Enterprise DB?

Best regards,

Re: what to do if project with activiti must have to be migrated to Postgres EnterpriseDB???

rajib — Wed, 27 Jan 2016 03:56:01 GMT

Hi

I am also migrating to another DB.. and it is also currently not in Activiti Database Mapping.
Migrating from Oracle to Tibero.
help please..

Re: what to do if project with activiti must have to be migrated to Postgres EnterpriseDB???

jbarrez — Wed, 27 Jan 2016 14:50:43 GMT

We don't have support for Tibero (this is the first time I even heard of it …). If it's compatible with some other db … then you could try to use that … but otherwise, no.

Re: what to do if project with activiti must have to be migrated to Postgres EnterpriseDB???

rajib — Fri, 29 Jan 2016 02:26:45 GMT

thnk you for the reply.
tibero is a korean database. my dba explain its like a cheaper oracle database clone.

databaseTypeMappings.setProperty("Tibero", DATABASE_TYPE_ORACLE);

it is now working.

Re: what to do if project with activiti must have to be migrated to Postgres EnterpriseDB???

jbarrez — Mon, 01 Feb 2016 09:04:03 GMT

Great to hear 🙂