# JDBC input failure connecting to FileMaker

**URL:** <https://discuss.elastic.co/t/jdbc-input-failure-connecting-to-filemaker/52082>\
**Category:** Logstash\
**Created:** [June 7, 2016, 1:35pm UTC](https://discuss.elastic.co/t/jdbc-input-failure-connecting-to-filemaker/52082 "2016-06-07T13:35:26Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![belac9615](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/belac9615/32/10872_2.png) [@belac9615](https://discuss.elastic.co/u/belac9615)\
**Post date:** [June 7, 2016, 1:35pm UTC](https://discuss.elastic.co/t/jdbc-input-failure-connecting-to-filemaker/52082/1 "2016-06-07T13:35:26Z")

</div>

I'm having an issue using the JDBC input in Logstash while attempting to pull all of the records out of our inventory database. When I run Logstash with the --debug option I see this error. (I "WHERE'd" it down to one part number for this example)

`Java::ComFilemakerJdbc::FMSQLException: [FileMaker][FileMaker JDBC] FQL0001/(1:34): There is an error in the syntax of the query.: SELECT count(*) AS "COUNT" FROM (SELECT * FROM Inventory WHERE Model_num LIKE '015107') AS "T1" LIMIT 1 {:level=>:error, :file=>"sequel/database/logging.rb", :line=>"72", :method=>"log_each"} Exception when executing JDBC query {:exception=>#<Sequel::DatabaseError: Java::ComFilemakerJdbc::FMSQLException: [FileMaker][FileMaker JDBC] FQL0001/(1:34): There is an error in the syntax of the query.>, :level=>:warn, :file=>"logstash/plugin_mixins/jdbc.rb", :line=>"219", :method=>"execute_statement"}`

This makes sense because I know FileMaker's JDBC driver does not support subqueries or LIMIT. It uses FETCH FIRST N ROWS ONLY instead. Is there any way that I can work around this issue?

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [June 10, 2016, 5:37am UTC](https://discuss.elastic.co/t/jdbc-input-failure-connecting-to-filemaker/52082/2 "2016-06-10T05:37:27Z")

</div>

This sounds more like a FileMaker question than a Logstash one.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 4:53am UTC](https://discuss.elastic.co/t/jdbc-input-failure-connecting-to-filemaker/52082/3 "2017-07-06T04:53:46Z")

</div>