https://community.splunk.com/t5/Splunk-AppDynamics/Machine-Agent-Command-Watcher-Extension-Unable-to-make-an-SQL/m-p/740001#M11694 <P>I have been trying to find or create a way to monitor an Oracle SQL query for elapsed time. I decided to try to use the Command Watcher extension on the Machine Agent for Linux.&nbsp; I have created a small Java program that takes the system time at the start, opens a connection, runs the query, retrieves the first row of the result set, calculates the elapsed time of the program and then returns that value using an exit() call.&nbsp;<BR />When I run the program in a linux shell, it functions perfectly. When I configure the Command Watcher to execute the Java program, I consistently receive a "NoClassDefFoundError" when attempting to load java.sql.Date. I have tried to manipulate the classpath to include the rt.jar file directly and still encounter the error.&nbsp;<BR />Is either the CommandWatcher, or the machine agent in which it runs, configured in such a way as to prevent the use of java.sql package? If so, how can I get around this? If not, what am I missing when attempting to run this program inside of the CommandWatcher?</P><P>Dale</P> Mon, 07 Jun 2021 16:52:29 GMT Dale_Chapman 2021-06-07T16:52:29Z https://community.splunk.com/t5/Splunk-AppDynamics/Machine-Agent-Command-Watcher-Extension-Unable-to-make-an-SQL/m-p/740001#M11694 <P>I have been trying to find or create a way to monitor an Oracle SQL query for elapsed time. I decided to try to use the Command Watcher extension on the Machine Agent for Linux.&nbsp; I have created a small Java program that takes the system time at the start, opens a connection, runs the query, retrieves the first row of the result set, calculates the elapsed time of the program and then returns that value using an exit() call.&nbsp;<BR />When I run the program in a linux shell, it functions perfectly. When I configure the Command Watcher to execute the Java program, I consistently receive a "NoClassDefFoundError" when attempting to load java.sql.Date. I have tried to manipulate the classpath to include the rt.jar file directly and still encounter the error.&nbsp;<BR />Is either the CommandWatcher, or the machine agent in which it runs, configured in such a way as to prevent the use of java.sql package? If so, how can I get around this? If not, what am I missing when attempting to run this program inside of the CommandWatcher?</P><P>Dale</P> Mon, 07 Jun 2021 16:52:29 GMT https://community.splunk.com/t5/Splunk-AppDynamics/Machine-Agent-Command-Watcher-Extension-Unable-to-make-an-SQL/m-p/740001#M11694 Dale_Chapman 2021-06-07T16:52:29Z https://community.splunk.com/t5/Splunk-AppDynamics/Machine-Agent-Command-Watcher-Extension-Unable-to-make-an-SQL/m-p/740002#M11695 <P>I contacted AppDynamics support about this and apparently the problem is that the CommandWatcher extension is not currently supported on the latest (21.5.x) generation of the machine agent.<BR />The fix is to use an older machine agent.</P><P>Thanks to everyone who read my question.</P> Wed, 09 Jun 2021 14:37:54 GMT https://community.splunk.com/t5/Splunk-AppDynamics/Machine-Agent-Command-Watcher-Extension-Unable-to-make-an-SQL/m-p/740002#M11695 Dale_Chapman 2021-06-09T14:37:54Z https://community.splunk.com/t5/Splunk-AppDynamics/Machine-Agent-Command-Watcher-Extension-Unable-to-make-an-SQL/m-p/740003#M11696 <P>Thanks for reporting back your findings to the community&nbsp;<A href="https://community.appdynamics.com/t5/user/viewprofilepage/user-id/62699">@Dale.Chapman</A>! This is helpful to know.&nbsp;</P> Wed, 16 Jun 2021 00:59:38 GMT https://community.splunk.com/t5/Splunk-AppDynamics/Machine-Agent-Command-Watcher-Extension-Unable-to-make-an-SQL/m-p/740003#M11696 Jeanie_Kedia1 2021-06-16T00:59:38Z