Hello,
I have a VDB deployed which contains metadata from an Oracle database and a DB2 database. I can execute the VDB and select from the Oracle tables without any issues. However, when I execute a select against the DB2 tables, I get the following error message:
Remote org.teiid.core.TeiidProcessingException: cdr: Unable to get managed connection for cdr; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for cdr)
Caused by: org.jboss.resource.JBossResourceException: Failed to register driver for: com.ibm.db2.jcc.DB2Driver; - nested throwable: (java.lang.ClassNotFoundException: com.ibm.db2.jcc.DB2Driver from BaseClassLoader@2e4d3abf{vfsfile:/C:/biapps/product/jboss_soap_530/jboss-soa-p-5/jboss-as/server/default/deploy/teiid/teiid-jboss-beans.xml})
I have placed the following jar files - db2jcc.jar and db2jcc_license_cu.jar - under server/default/lib folder. I am not sure if I am missing anything that's obvious. With Oracle, I placed the ojdbc6.jar under the same location and things went well, but not with DB2.
Any help is greatly appreciated.
Thanks in advance
rajesh