# I have a error with sql in elasticsearch?/(i used JDBC)

**URL:** <https://discuss.elastic.co/t/i-have-a-error-with-sql-in-elasticsearch-i-used-jdbc/83437>\
**Category:** Elasticsearch\
**Created:** [April 24, 2017, 4:17pm UTC](https://discuss.elastic.co/t/i-have-a-error-with-sql-in-elasticsearch-i-used-jdbc/83437 "2017-04-24T16:17:47Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![thang](https://avatars.discourse-cdn.com/v4/letter/t/8edcca/32.png) [@thang](https://discuss.elastic.co/u/thang)\
**Post date:** [April 24, 2017, 4:17pm UTC](https://discuss.elastic.co/t/i-have-a-error-with-sql-in-elasticsearch-i-used-jdbc/83437/1 "2017-04-24T16:17:47Z")

</div>

![](https://us1.discourse-cdn.com/elastic/original/3X/e/2/e26e5bc2b07891d6ac50710accb176485041b3a1.png)

---

<div class="post-metadata">

**Author:** ![Mark\_Harwood](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mark_harwood/32/10538_2.png) [@Mark\_Harwood](https://discuss.elastic.co/u/Mark_Harwood)\
**Post date:** [April 24, 2017, 4:30pm UTC](https://discuss.elastic.co/t/i-have-a-error-with-sql-in-elasticsearch-i-used-jdbc/83437/2 "2017-04-24T16:30:23Z")

</div>

You are trying to search an index called "testing" that does not exist.

To see which indices do exist try access [http://127.0.0.1:9200/\_cat/indices](http://127.0.0.1:9200/_cat/indices)

---

<div class="post-metadata">

**Author:** ![thang](https://avatars.discourse-cdn.com/v4/letter/t/8edcca/32.png) [@thang](https://discuss.elastic.co/u/thang)\
**Post date:** [April 24, 2017, 4:33pm UTC](https://discuss.elastic.co/t/i-have-a-error-with-sql-in-elasticsearch-i-used-jdbc/83437/3 "2017-04-24T16:33:28Z")

</div>

this is a file mysql-simple-example.bat to connect to sql

 ![](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1aa5f0dba43c94ca0b92c26176deae13ffc840e8.png)

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [April 24, 2017, 4:34pm UTC](https://discuss.elastic.co/t/i-have-a-error-with-sql-in-elasticsearch-i-used-jdbc/83437/4 "2017-04-24T16:34:57Z")

</div>

Please don't post images

---

<div class="post-metadata">

**Author:** ![thang](https://avatars.discourse-cdn.com/v4/letter/t/8edcca/32.png) [@thang](https://discuss.elastic.co/u/thang)\
**Post date:** [April 24, 2017, 4:36pm UTC](https://discuss.elastic.co/t/i-have-a-error-with-sql-in-elasticsearch-i-used-jdbc/83437/5 "2017-04-24T16:36:35Z")

</div>

ok!!

---

<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:** [April 25, 2017, 6:03pm UTC](https://discuss.elastic.co/t/i-have-a-error-with-sql-in-elasticsearch-i-used-jdbc/83437/6 "2017-04-25T18:03:18Z")

</div>

@thang This looks like a script for my tool Elasticsearch JDBC importer. If you have an issue, feel free to open a github issue at [https://github.com/jprante/elasticsearch-jdbc/issues](https://github.com/jprante/elasticsearch-jdbc/issues) Thanks.

---

<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:** [May 23, 2017, 6:17pm UTC](https://discuss.elastic.co/t/i-have-a-error-with-sql-in-elasticsearch-i-used-jdbc/83437/7 "2017-05-23T18:17:31Z")

</div>

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