I found this to be a bug, if you run logstash in debug mode the jdbc plugin will do a SELECT TOP(1) on the stored procedure which is invalid.
However, if logstash is not in debug mode then it works fine. Not the best solution but at least a work around.
E