DB2 server connection

1

I want to connect DB2 server (i-series) using JDBC then what will be connection code and jars to add? I tried for this, but I am getting error like: org.flowable.common.engine.api.FlowableException: couldn’t deduct database type from database product name ‘DB2 UDB for AS/400’.

2

Hey,

What exactly have you tried? How does your connection URL look like? Which driver are you using?

For the Flowable QA integration tests we use:

<dependency>
    <groupId>com.ibm.db2.jcc</groupId>
    <artifactId>db2jcc4</artifactId>
    <version>10.1</version>
</dependency>

And a JDBC url can look like: jdbc:db2://host:port/db-name

Cheers,
Filip

3

Hey,

I am using below connection url and driver to connect IBMDB2 server (i-series) .

ProcessEngineConfiguration cfg = new StandaloneProcessEngineConfiguration()
.setJdbcUrl(“jdbc:as400://host/databaseName”)
.setJdbcUsername(“")
.setJdbcPassword("”)
.setJdbcDriver(“com.ibm.as400.access.AS400JDBCDriver”)
.setDatabaseSchemaUpdate(ProcessEngineConfiguration.DB_SCHEMA_UPDATE_TRUE);

But getting this exception :

org.flowable.common.engine.api.FlowableException:couldn’t deduct database type from database product name ‘DB2 UDB for AS/400’.

4

Hi,

Check this out https://github.com/flowable/flowable-engine/issues/337

Try to set databaseType with:
cfg.setDatabaseType(ProcessEngineConfiguration.DATABASE_TYPE_DB2)

It should cause that initDatabaseType method won’t be called.

1 Like