# ElasticSearch Error: MapperParsingException failed to parse

**URL:** <https://discuss.elastic.co/t/elasticsearch-error-mapperparsingexception-failed-to-parse/21137>\
**Category:** Elasticsearch\
**Created:** [December 8, 2014, 10:08am UTC](https://discuss.elastic.co/t/elasticsearch-error-mapperparsingexception-failed-to-parse/21137 "2014-12-08T10:08:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Shoaib\_Ijaz](https://avatars.discourse-cdn.com/v4/letter/s/e5b9ba/32.png) [@Shoaib\_Ijaz](https://discuss.elastic.co/u/Shoaib_Ijaz)\
**Post date:** [December 8, 2014, 10:08am UTC](https://discuss.elastic.co/t/elasticsearch-error-mapperparsingexception-failed-to-parse/21137/1 "2014-12-08T10:08:36Z")

</div>

I am trying to integrate MYSQL in ElasticSearch On windows 7 from this link

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

I have completed the following steps:

1:

Download & Unzip in C Directory  
[https://download.elasticsearch.org/elasticsearch/elasticsearch/elasticsearch-1.3.4.zip](https://download.elasticsearch.org/elasticsearch/elasticsearch/elasticsearch-1.3.4.zip)

2:

Run this command on CMD ./bin/plugin --install jdbc --url  
[http://xbib.org/repository/org/xbib/elasticsearch/plugin/elasticsearch-river-jdbc/1.3.4.4/elasticsearch-river-jdbc-1.3.4.4-plugin.zip](http://xbib.org/repository/org/xbib/elasticsearch/plugin/elasticsearch-river-jdbc/1.3.4.4/elasticsearch-river-jdbc-1.3.4.4-plugin.zip)

3:

Download MYSQL Connector mysql-connector-java-5.1.33.zip from MYSQL website.

Unzip and copy mysql-connector-java-5.1.33-bin.jar file.

Place it into C:\elasticsearch-1.3.4\plugins\jdbc

I have checked now there are two files in plugins directory

- 

## elasticsearch-river-jdbc-1.3.4.4.jar

mysql-connector-java-5.1.33-bin

Now i tried to execute this command on CMD and i got error

curl -XPUT 'localhost:9200/\_river/jdbc-1.3.4.4-d2e33c3/\_meta' -d '{  
"type" : "jdbc",  
"jdbc" : {  
"url" : "jdbc:mysql://localhost:3306/test",  
"user" : "root",  
"password" : "pass",  
"sql" : "select \* from abc"  
}  
}'

{"error":"MapperParsingException[failed to parse]; nested:  
JsonParseException[Unexpected character (''' (code 39)): expected a valid  
value (number, String, array, object, 'true', 'false' or 'null')\n at  
[Source: [B@3cf756; line: 1, column:2]]; ","status":400}

curl: (6) Could not resolve host: type; Host not found

curl: (6) Could not resolve host: :; No data record of requested type

curl: (6) Could not resolve host: jdbc,jdbc; No data record of requested  
type

curl: (6) Could not resolve host: :; No data record of requested type

curl: (3) [globbing] unmatched brace at pos 5

curl: (6) Could not resolve host: :; No data record of requested type

curl: (6) Could not resolve host: jdbc:mysql:; No data record of requested  
type

curl: (6) Could not resolve host: :; No data record of requested type

curl: (6) Could not resolve host: root,password; No data record of  
requested typ e curl: (6) Could not resolve host: :; No data record of  
requested type

curl: (6) Could not resolve host: pass,sql; No data record of requested type

curl: (6) Could not resolve host: :; No data record of requested type

curl: (6) Could not resolve host: select \* from abc; No data record of  
requested type

MYSQL(5.5.37) Database (test) contains just one table (abc) with two  
columns id(pk) and address (varchar)

I am using this _jdbc-1.3.4.4-d2e33c3_ name as jdbc driver. I get this name  
from this link.

[http://localhost:9200/\_nodes?settings=true&pretty=true](http://localhost:9200/_nodes?settings=true&pretty=true)

I have searched on it but cannot found any issue like this related to mysql  
integration.

My Question is anything still missing or I am doing wrong setup.?

Thank you

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/2c7e92aa-0b10-476e-a799-ebae1752af19%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/2c7e92aa-0b10-476e-a799-ebae1752af19%40googlegroups.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<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, 12:45am UTC](https://discuss.elastic.co/t/elasticsearch-error-mapperparsingexception-failed-to-parse/21137/2 "2017-07-06T00:45:04Z")

</div>