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

[amit4nonstop]

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 'EnterpriseDB'

Please someone help out me in this.

Thanks in advance.

[martin_grofcik]

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

[trademak]

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,

[amit4nonstop]

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

[trademak]

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,

[rajib]

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..

[jbarrez]

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.

[rajib]

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.

[jbarrez]

Great to hear 🙂