AppD Archive

Call Graphs not showing raw sql

CommunityUser
Splunk Employee
Splunk Employee

Hi,

I'm trying to get appdynamics to display raw sql in the call graphs.

I've gone to Configuration -> Instrumentation -> Call Graph Settings and selected "Capture Raw SQL" under SQL Capture Settings.  I have also set to true the value for the capture-raw-sql property in the Java Agent Configuration.

After doing this in the Call Graphs all the sql statements still just contain ? (ie: select * from person where id = ?)

Is there something else that needs to be configured for this to be picked up.

We are on controller version 4.1.2.1, build 30 and the Java agent is Server Agent v4.1.0.0 GA #2015-06-16_21-45-59 r5811fe6820a3121c878e283f368d9c44c6e45a39 8-4.1.0.next-build

Any help would be much appreciated.

Cheers,

Ian

0 Karma

Arun_Dasetty
Super Champion

Hi  Ian,

We see Capture Raw SQL feature will show bind varaible value when preparestatment use .setString .setInt() to add values to queries .

For example listed code snippet:

stmt = new PreparedStatement("select * from user where name= ?")
stmt.bind(1, "test1")
stmt.execute()

Could you please check if above is the case or not at code level?

If above is the case, send the agent collected from UI using "all logs" option for our initial review and also screenshot from UI depicting the issue and we understood you are referring new snapshots collected post making changes in UI:

image.png

 
 
0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...