nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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.

Find more posts tagged with

Comments

martin_grofcik

Hi,

supported DB types are:

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

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 🙂