Hello All,
I am trying to pull values from JDBC queries using JDBC_RESPONSE probe and everything is working fine where I can connect with DB and pulling the value from query but that value is not saving in QOS_JDBC_VALUE just because it is not numeric.
I am sharing the output we are expecting for each profiles but not getting for profiles where query is returning the value in date+time and string.
Profile name : START_TIME
Output expecting : ""07/20/20 22:00""
Profile name : END_TIME
Output expecting : ""07/20/20 22:07""
Profile name : INPUT_TYPE
Output expecting : ""DB INCR""
Profile name : STATUS
Output expecting : ""COMPLETED WITH WARNINGS""
Profile name : SESSION_KEY
Output we are getting : 1896
Profile name : HRS
Output we are getting : 0.127777778
Please help.