topic Re: How to configure Activiti with AS400/DB2 in Alfresco Archive

How to configure Activiti with AS400/DB2

nxd1184 — Wed, 16 Jul 2014 19:06:58 GMT

databaseTypeMappings.setProperty("H2","h2"); databaseTypeMappings.setProperty("MySQL","mysql"); databaseTypeMappings.setProperty("Oracle","oracle"); databaseTypeMappings.setProperty("PostgreSQL","postgres"); databaseTypeMappings.setProperty("Microsoft SQL Server","mssql"); databaseTyp

Re: How to configure Activiti with AS400/DB2

trademak — Thu, 17 Jul 2014 08:49:39 GMT

We can of course add DB2 UDB AS400 to the mapping list. Would that solve your issue?

Best regards,

Re: How to configure Activiti with AS400/DB2

nxd1184 — Thu, 17 Jul 2014 09:25:12 GMT

Below are db properties, I create schema activiti in AS/400 DB2 and when I run activiti-explorer (deploy in tomcat 7 on windows 7) then exception is "couldn't deduct database type from database product name DB2 UDB for AS/400".

db=db2
jdbc.driver=com.ibm.as400.access.AS400JDBCDriver
jdbc.url=jdbc:as400://192.168.0.54/activiti
jdbc.username=username
jdbc.password=password

Re: How to configure Activiti with AS400/DB2

trademak — Thu, 17 Jul 2014 16:57:10 GMT

I've added DB2 UDB AS400 to the mapping list.

Best regards,

Re: How to configure Activiti with AS400/DB2

nxd1184 — Thu, 17 Jul 2014 17:17:26 GMT

please change databaseTypeMappings.setProperty("DB2 UDB AS400", "db2") to databaseTypeMappings.setProperty("DB2 UDB for AS/400", "db2");

Re: How to configure Activiti with AS400/DB2

nxd1184 — Thu, 17 Jul 2014 17:22:23 GMT

I checked out source code of version 5.15.1 and add "DB2 UDB for AS/400" and it works but after activiti tables have been created then spring transaction commit failed and roll back everything (means activiti tables are deleted)

Re: How to configure Activiti with AS400/DB2

nxd1184 — Thu, 17 Jul 2014 17:27:23 GMT

We're also put jt400 (maven) into pom.xml so that we can use AS/400 DB2 Driver

Re: How to configure Activiti with AS400/DB2

trademak — Thu, 17 Jul 2014 19:08:16 GMT

So, adding the additional mapping doesn't solve it? Is there a specific error message logged?

Re: How to configure Activiti with AS400/DB2

nxd1184 — Thu, 17 Jul 2014 19:14:48 GMT

Adding the additional mapping solve AS/400 DB2 connection, but now, I'm facing activiti tables can not create automatically issue. When I debug on class: SpringTransactionInterceptor on the line "return next.execute(config, command)" I check in database and the tables still exists but if I step over this step then activiti tables are deleted.

Re: How to configure Activiti with AS400/DB2

trademak — Mon, 21 Jul 2014 09:22:09 GMT

How do you test this? Do you have a unit test? Can you share the code and the Activiti Engine configuration you are using?

Best regards,