Getting the error "Caused by: java.lang.NoClassDefFoundError: com/ibm/db2/jcc/am/ea" when creating a DB2 data source in TIBCO Data Virtualization
Article ID: KB0072649
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All Supported Versions |
Description
The user may come across the following error when trying to create the DB2 connection in TDV and/or when trying to 'Add/Remove Resources...':
======================
ERROR [GetIntrospectableResourceIdsTask Get Introspectable Resource Identifiers] 2565-01-11 09:39:46.844 +0700 TaskManager - Task failed: GetIntrospectableResourceIdsTask Get Introspectable Resource Identifiers
com/ibm/db2/jcc/am/ea
at com.compositesw.server.task.TaskWithResults.run(TaskWithResults.java:87)
at com.compositesw.server.task.TaskManager$TaskRunner.run(TaskManager.java:146)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: com/ibm/db2/jcc/am/ea
at com.compositesw.server.api.core.DataSourceApi.internalGetIntrospectableResourceIds(DataSourceApi.java:1298)
at com.compositesw.cdms.datasource.introspect.task.GetIntrospectableResourceIdsTask.doTaskWithResultsRun(GetIntrospectableResourceIdsTask.java:58)
at com.compositesw.server.task.TaskWithResults.run(TaskWithResults.java:77)
... 4 more
Caused by: java.lang.NoClassDefFoundError: com/ibm/db2/jcc/am/ea
at com.ibm.db2.jcc.am.Connection.getConnectionCallback(Connection.java:8444)
at com.ibm.db2.jcc.am.Connection.createStatement(Connection.java:976)
at com.compositesw.cdms.ds.db2.Db2Introspector2.getIntrospectableResourceChildIds(Db2Introspector2.java:147)
at com.compositesw.cdms.datasource.introspect.Introspector2Wrapper.getIntrospectableResourceChildIds(Introspector2Wrapper.java:142)
... 6 more
======================
Environment
Resolution
A) the driver is not found in the specified location in the TDV installation directory
B) an incorrect driver is added that is not compatible with the DB2 adapter version being used in Studio
After trying the above, if the error is still present then a restart of the TDV server would be required for the driver changes to come into effect.
Issue/Introduction
Feedback
