Generic SQL Execution Plugin
I am considering the possibility of developing a generic SQL execution plugin, but I want to know a few things first.
Here is the scenario I have:
In order to determine if a batch processor has been run, I need to execute a stored procedure on a SQL server. The result of this run will tell me if this processing has happened, is still happening, etc. Ideally, I would like to have the result of this execution setup as a measure. While I could use the boolean logic of generic execution plugin to cobble this together, I can easily see how this could be extended. For example, if I were to run a sql statement, and I want all the results from the result set tracked as measures.
Firstly, I want to know if there is any plugin I could use for this that is already existing. The key requirements would be that it would need to result in measures that I could then track (even if its for a single value, that would get me over the hump of what I am trying to do).
Secondly, if a plugin doesn't currently exist to do something similar, is this type of generic execution on the road map? I don't want to do the work if there is a feature coming up that would trump this.
Thanks,
Chris
Hi all,
Is there an official page of the GenericSQLPlugin?
At the moment I'm configuring it on customer site, to run a custom query. Thing is, the query is too long for the plugin, that automatically truncates it. Do you guys know how to extend the default "Query Size" value, so it could accept longer queries?
Thanks, Valerio
Hi Valerio
your best bet, is to checkout the module (via the client in the plugin menu) and modify the code yourself to achieve what you need. Repackage it and re-deploy it as a new version.
Regards
Flo
can you turn the plug-in on to log level 'fine', and send me the logs around this, and any SQL State error codes?
which database/version are you seeing this with?
Nice Jim, I will take a look.
Just one thing I noticed about the behavior of the plugin. Sometimes, looks like the plugin looses the conection with the DB, So when that happens it does not renew the db connection then I have to manually stop and start the plugin or sometimes restart the collector to make it to work again.
Checkout the latest version of the DB Query Monitor plug-in. It supports query timeout periods, and also has measures that you can hook up to incidents for total response time, query response time, and connect response time. Regards, Jim
During the execution of some long queries in this client, the plugin could not fetch some data because of the connection timeout.
So what i did was setting the timeout to 300 seconds, just in case, in the createConnection() Method
DriverManager.setLoginTimeout(300);
But this could be added as a setting parameter when creating the monitor.
Hey guys, does anyone here have the newest version of this SQL Query Execution Plugin? I want to use part of the code to create a custom plugin for this customer.
I have attached the most current version I have to this post. If you make further changes or fixes please post it back here for whoever needs it...
Best, Roman
Hello,
Cannot get this to work and the LOG isn't really helpful since it only outputs the connection parameters in SEVERE log level. How to find out what is wrong?
2013-06-24 10:56:41 SEVERE [GenericSQLMonitor@MSSQL-invoicesvalidationstarted10mins_0] Here 2013-06-24 10:56:41 SEVERE [GenericSQLMonitor@MSSQL-invoicesvalidationstarted10mins_0] dbType=MSSQLServer 2013-06-24 10:56:41 SEVERE [GenericSQLMonitor@MSSQL-invoicesvalidationstarted10mins_0] Port=1433 2013-06-24 10:56:41 SEVERE [GenericSQLMonitor@MSSQL-invoicesvalidationstarted10mins_0] dbname=bscstracking 2013-06-24 10:56:41 SEVERE [GenericSQLMonitor@MSSQL-invoicesvalidationstarted10mins_0] host=10.xxx.xxx.xxx 2013-06-24 10:56:41 SEVERE [GenericSQLMonitor@MSSQL-invoicesvalidationstarted10mins_0] com.microsoft.jdbc.sqlserver.SQLServerDriver
Hi Jan,
I will email you a version of the plugin I built a few weeks ago that has more error handling. Never got around to fully test and clean it up but it should at least show you where the problem occurs...
Best, Roman
Hey Christopher,
I'm not sure where you're at on the progress of the plug-in that can perform SQL queries but Bill (William) Zajac, a former Compuware Guardian, developed the attached plug-in that can perform SQL queries. You'll have to refer to him for any questions.
Please note that this is not an officially supported plug-in.
Hope this helps!
Do similar plugins exist for Oracle?
From the looks of the properties, this one works for Oracle, SQL server, DB2, and Postgre SQL.
