unknown SQL error : SkipClass: net.java.ao.ParameterMetadataCachingPreparedStatement" in .pbd to suppress "Unknown SQL" metric

Products

• CA Application Performance Management (APM / Wily / Introscope)
• DX APM SaaS
• DX Application Performance Management
• DX OI SaaS
• DX Operational Intelligence
• DX SaaS
• DX Operational Observability

Issue/Introduction

Error message :

[IntroscopeAgent.Agent] Could not find normalized sql for statement: [email protected] insert "SkipClass: net.java.ao.ParameterMetadataCachingPreparedStatement" in .pbd to suppress "Unknown SQL" metrics.

Environment

JAVA  Agent 25.1

Resolution

After adding the class SkipClass: net.java.ao.ForwardingPreparedStatement to the sqlagent.pbd, no more  unknown sql metrics under dynamic/prepared statement folders.