# Document count increase every time with jdbc driver

**URL:** <https://discuss.elastic.co/t/document-count-increase-every-time-with-jdbc-driver/260932>\
**Category:** Logstash\
**Created:** [January 13, 2021, 5:18am UTC](https://discuss.elastic.co/t/document-count-increase-every-time-with-jdbc-driver/260932 "2021-01-13T05:18:41Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![beachjf](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/beachjf/32/82139_2.png) [@beachjf](https://discuss.elastic.co/u/beachjf)\
**Post date:** [January 13, 2021, 5:18am UTC](https://discuss.elastic.co/t/document-count-increase-every-time-with-jdbc-driver/260932/1 "2021-01-13T05:18:41Z")

</div>

```auto
input {
  jdbc {
    jdbc_driver_library => ""
    jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
    jdbc_connection_string => "jdbc:sqlserver://aasdf;instanceName=aaSQL;databasename=aaa"
    jdbc_user => "elkuser"
    jdbc_password => "elk1234"
    schedule => "* * * * *"
    statement => "SELECT * FROM Orders;"
  }
}

```

The document count always increase even if there is no movement in my SQL Table Orders.  
How come it is possible ?.

The count in the Orders table should match the document count of elastic search right ?.

Thanks a lot for your help

---

<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:** [February 10, 2021, 5:18am UTC](https://discuss.elastic.co/t/document-count-increase-every-time-with-jdbc-driver/260932/2 "2021-02-10T05:18:45Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.