DX Application Performance Management

Hi All,

Need assistance in checking compatibility for CA APM 10.2 SQLAgent.pbd with respect to JDBC version.

Environment Details:

• CA APM Version : 10.2
• Weblogic Agent : 10.2
• Weblogic Server : 12C
• JDBC Driver Version : 5.5

Already referred the CA APM Compatibility matrix but I am not able to get the desired answer

As per CA APM CM : SQL Agent -> Oracle 12C -> oracle.jdbc.driver.OracleDriver / Oracle supplied thin client XA driver / com.microsoft.jdbc.sqlserver.SQLServerDriver  (however this is not giving the clear Idea for SQL Drive)

The reason for the above question is that I am getting Unknown SQL appearing in the Investigator and as per the below article foremost important thing is message is associated with the JDBC driver version used by the application reporting, there are possibly other reason also agree. 

https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.tec616386.html

Thanks in advance

Regards,

Winkle Khurana

For JDBC driver compatibility, adding Florian_Cheval to see if he can clear this up.

The JDBC driver will have a fully-qualified name, there are multiple JDBC drivers for the same database, different types.

Just a version of 5.5 is not enough to determine compatibility, but, at a wild guess, it sounds like something related to MySQL, which isn't supported anyway.

To really know compatibility, anyone would need to know the actual name of the jar file, class used to initiate connection, stated version of JDBC driver, if not obvious from file name, and JDBC driver type, usually 2 or 4.

Usually if the agent is run in DEBUG mode, it will tell you to skip a particular class to stop the Unknown SQL metrics from appearing, but further work in the code would be required to actually get SQL metrics out as we know them.

And then an idea can be raised to request full support for the driver.

Hi David,

Thanks for your prompt response, refering to below community link

https://communities.ca.com/message/241945340?commentID=241945340#comment-241945340 able to retrieve data however getting Unknown statements.

With respect to actual name of the jar file, class used to initiate connection, stated version of JDBC driver will get back to you tomorrow.

I am getting Unknown SQL statements for not only MYSQL database but also for MS SQL also (Both data  bases are being used by the application).

Regards,

Winkle Khurana

Hi Winkle:

      Please let us know if both answers were helpful If you have access to the Yammer internal forums, Product Management can also found there

Thanks

Hal German

Hi Hal German,

Would be needing some more advice on the same.

Regards,

Winkle Khurana

Hi Winkle: 

    I placed the question in the APM Group for you. Per our discussion. Nice to talk with you

   Wishing you the Best,

Hal German

Dear Winkle:

     There were no responses in the internal community of this topic or further comments from David. Please open a case to help you resolve this faster. You are welcome to post any updates or resolutions here to help other customers that may be experiencing the same thing.

Thanks

Hal German