# Logstash jdbc output is giving only one record even **URL:** \ **Category:** Logstash\ **Created:** [March 23, 2019, 7:17pm UTC](https://discuss.elastic.co/t/logstash-jdbc-output-is-giving-only-one-record-even/173613 "2019-03-23T19:17:13Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Vikram\_Sivam](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vikram_sivam/32/42638_2.png) [@Vikram\_Sivam](https://discuss.elastic.co/u/Vikram_Sivam)\ **Post date:** [March 23, 2019, 7:17pm UTC](https://discuss.elastic.co/t/logstash-jdbc-output-is-giving-only-one-record-even/173613/1 "2019-03-23T19:17:13Z")
Hello Team, We are using logstash jdbc plugin to inject data to ES from SQL server database. The query used has 50 records as output but the data injected in ES has only 1 record. We have tried using fingerprint and the select statement used has a unique ID for all the records which we have tried giving as document id but the result is still the same - only 1 record is being displayed. Kindly help ---
**Author:** ![AquaX](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aquax/32/92006_2.png) [@AquaX](https://discuss.elastic.co/u/AquaX)\ **Post date:** [March 26, 2019, 6:41pm UTC](https://discuss.elastic.co/t/logstash-jdbc-output-is-giving-only-one-record-even/173613/2 "2019-03-26T18:41:05Z")
Could you post some examples of your data/query/logstash stdout JSON output etc...? ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [April 23, 2019, 6:41pm UTC](https://discuss.elastic.co/t/logstash-jdbc-output-is-giving-only-one-record-even/173613/3 "2019-04-23T18:41:17Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.