SQL Execution
Hi,
I am trying to get a plugin that will execute sql statements. I want to use this to monitor when counts stop growing or something similar. I have tried the generic sql execution plugins on here and I cannot seem to get any of them to work. I have narrowed it down to the way that they structure the jdbc connection string. All of these plugins require a port to connect to, but for some reason I cannot use that with my systems ( Sql Server 2008 R2). I created a sample java project to confirm and the query is successful when I remove the port from the connection string and it was.
I have tried to edit these plugins and reinstall them, but I am not having any luck. I was wondering if any one had some step-by-step instructions on how to alter an existing or create a plugin from scratch. Using the documentation on this site did not work for me, I am sure that I am missing some nuance.
Any guidance?
Heath
