# ELK logstash config statement error for mongodb input-jdbc plugin

**URL:** <https://discuss.elastic.co/t/elk-logstash-config-statement-error-for-mongodb-input-jdbc-plugin/210690>\
**Category:** Logstash\
**Created:** [December 5, 2019, 11:38am UTC](https://discuss.elastic.co/t/elk-logstash-config-statement-error-for-mongodb-input-jdbc-plugin/210690 "2019-12-05T11:38:41Z")\
**Posts on this page:** 1\
**Showing post:** 8

<div class="post-metadata">

**Author:** ![ErikWarming](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/erikwarming/32/39525_2.png) [@ErikWarming](https://discuss.elastic.co/u/ErikWarming)\
**Post date:** [December 11, 2019, 9:48am UTC](https://discuss.elastic.co/t/elk-logstash-config-statement-error-for-mongodb-input-jdbc-plugin/210690/8 "2019-12-11T09:48:11Z")

</div>

When I see the error

> SELECT count(\*) AS "COUNT" FROM (db.testcaseresults.find({})) AS "T1" LIMIT 1

I think of the issuse I had this summer  
[https://discuss.elastic.co/t/jdbc-static-getting-a-sql-syntax-error-i-didnt-write/187844/4](https://discuss.elastic.co/t/jdbc-static-getting-a-sql-syntax-error-i-didnt-write/187844/4)

---

_[View the full topic](https://discuss.elastic.co/t/elk-logstash-config-statement-error-for-mongodb-input-jdbc-plugin/210690)._