Tomcat Agent Recording Not capturing Transactions

Document ID : KB000094778
Last Modified Date : 04/05/2018
Show Technical Document Details
Issue:
We have configured Java Agent on Apache Tomcat , we followed the document as per the link below https://support.ca.com/us/knowledge-base-articles.TEC603956.html , When we try to record JDBC trafffic, no transactions are being capture..  Seeing the below errors in the logs.  


Error virtualizing oracle.jdbc.driver.PhysicalConnection.createSQLXML 
java.lang.RuntimeException: com.itko.javassist.NotFoundException: oracle.xdb.XMLType 
at com.itko.javassist.CtClassType.getClassFile2(CtClassType.java:208) 
at com.itko.javassist.CtClassType.getSuperclass(CtClassType.java:765) 

[DevTest AGENT:A][WARN][8605][91][ActiveMQ Session Task][03/07 10:45:26 (492)] hotSwap oracle.jdbc.driver.PhysicalConnection: java.lang.VerifyError 
[DevTest AGENT:A][ERROR][8605][91][ActiveMQ Session Task][03/07 10:45:34 (440)] Error virtualizing oracle.sql.BLOB.toSQLXML 
java.lang.RuntimeException: com.itko.javassist.NotFoundException: oracle.xdb.XMLType 
at com.itko.javassist.CtClassType.getClassFile2(CtClassType.java:208) 
at com.itko.javassist.CtClassType.getSuperclass(CtClassType.java:765) 
Environment:
All Supported DevTest Environments 
Cause:
xdb6.jar  was missing in the library path. 
Resolution:
Customer is using JDBC Driver version - ojdbc8-12.2.0.1.jar   , we had to use an additional jar to fix the issue
  • In Dev Test place the required xdb6.jar into the same directory where ojdbc8.jar resides 
  • Use the IDE and add the xdb6 jar (preferred way) , and then Rebuild the application. It will update the config/ project.xml file... the xml file is different in every environment. . So just make sure you verify its updated in your configuration file.