Call Graphs not showing raw sql

[CommunityUser]

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

[Arun_Dasetty]

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: