# JDBC importer 1.6.0.0 for Elasticsearch 1.6.0

**URL:** <https://discuss.elastic.co/t/jdbc-importer-1-6-0-0-for-elasticsearch-1-6-0/2254>\
**Category:** Community Ecosystem\
**Created:** [June 9, 2015, 9:01pm UTC](https://discuss.elastic.co/t/jdbc-importer-1-6-0-0-for-elasticsearch-1-6-0/2254 "2015-06-09T21:01:19Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jprante](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jprante/32/44941_2.png) [@jprante](https://discuss.elastic.co/u/jprante)\
**Post date:** [June 9, 2015, 9:01pm UTC](https://discuss.elastic.co/t/jdbc-importer-1-6-0-0-for-elasticsearch-1-6-0/2254/1 "2015-06-09T21:01:19Z")

</div>

Hi,

I released JDBC importer 1.6.0.0 (the project previously known as JDBC river or JDBC plugin) for Elasticsearch 1.6

For documentation, see the README at

> **[jprante/elasticsearch-jdbc](https://github.com/jprante/elasticsearch-jdbc)**
>
> elasticsearch-jdbc - JDBC importer for Elasticsearch

I like to invite you to this version and try out the standalone JVM solution for importing data from JDBC into Elasticsearch.

Don't hesitate to give your feedback and bug reports if something does not work, also pull requests are most welcome.

Previous JDBC river version will only be supported for Elasticserach 1.4 and 1.5 and will not receive any new features from now on.

Best,

Jörg

---

<div class="post-metadata">

**Author:** ![vaniaravinda](https://avatars.discourse-cdn.com/v4/letter/v/7993a0/32.png) [@vaniaravinda](https://discuss.elastic.co/u/vaniaravinda)\
**Post date:** [September 9, 2015, 6:22am UTC](https://discuss.elastic.co/t/jdbc-importer-1-6-0-0-for-elasticsearch-1-6-0/2254/2 "2015-09-09T06:22:36Z")

</div>

Hi @jprante,

I'm Using the JDBC importer for indexing data from SqlServer table with the below syntax. If I remove Where condition then it is working or else indexing is not working. Please let me know how can I include where condition in my query.

{  
"type" : "jdbc",  
"jdbc": {  
"url":"jdbc:sqlserver://serverip;databaseName=dbname",  
"user":"user",  
"password":"password",  
"sql":"SELECT id, name FROM employee where status = 'Y'",  
"index" : "employee",  
"type" : "employeetype"  
}  
}

Closing the query. Solved my issue.

Thanks,  
Vani Aravinda

---

<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 5, 2017, 9:48pm UTC](https://discuss.elastic.co/t/jdbc-importer-1-6-0-0-for-elasticsearch-1-6-0/2254/3 "2017-07-05T21:48:28Z")

</div>