Process configured with JDBC Connection for DB2 database will fail with a runtime error even if the Test Connection in Design time had no issues.
Article ID: KB0094288
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks | - |
| Not Applicable | - |
Description
Description:
Process configured with JDBC Connection for DB2 database will fail with a runtime error even if the Test Connection in Design time had no issues.
Symptoms:
The following exception will be seen in console logs
+++++++
ERROR [CM Configuration Updater (Update:
pid=bw.resource.jdbc.cbc267bf-ebf9-400a-8585-0cb3d782e014)]
c.t.b.s.r.c.SharedResourceModulePropertyTracker -
TIBCO-BW-SR-FRWK-502000: Failed to create SharedResource [db2test.db2]
for Module [db2test:1.0.0.qualifier], DeploymentUnit
[db2test.application:1.0].
<CausedBy> java.lang.RuntimeException: java.lang.reflect.InvocationTargetException.
<CausedBy> java.lang.reflect.InvocationTargetException.
<CausedBy> java.lang.NoSuchMethodError: com.ibm.db2.jcc.DB2BaseDataSource.setAllowNextOnExhaustedResultSet(I)V
+++++++
Cause:
Incorrect driver for DB2 database provisioned in the runtime db2jcc.jar instead of db2jcc4.jar .
Environment
Product: TIBCO ActiveMatrix BusinessWorks
Version: 6.x
OS: All Supported Operating SystemsDatabase: DB2
--------------------
Resolution
Review the following locations to confirm the filename of the DB2 driver JAR.
- <TIBCO_HOME>\bw6\bw\6.x\config\drivers\shells\jdbc.db2.runtime\runtime\plugins\com.tibco.bw.jdbc.datasourcefactory.db2\lib
- <TIBCO_HOME>\bw6\bw\6.x\config\design\thirdparty
Remove the db2jcc.jar /db2jcc_license_cu.jar files, copy db2jcc4.jar and corresponding license file at the above locations. Restart Studio for the changes to take effect.
Issue/Introduction
Process configured with JDBC Connection for DB2 database will fail with a runtime error even if the Test Connection in Design time had no issues.
Feedback
Yes
No
Powered by
