title: ElasticSearch Error: MapperParsingException failed to parse
body: <p>I am trying to integrate MYSQL in ElasticSearch On windows 7 from this <a href="https://github.com/jprante/elasticsearch-river-jdbc" rel="nofollow noreferrer">link</a></p>
  
  <p>I have completed the following steps:</p>
  
  <p>1:</p>
  
  <blockquote>
    <p>Download &amp; Unzip in C Directory
    <a href="https://download.elasticsearch.org/elasticsearch/elasticsearch/elasticsearch-1.3.4.zip" rel="nofollow noreferrer">https://download.elasticsearch.org/elasticsearch/elasticsearch/elasticsearch-1.3.4.zip</a></p>
  </blockquote>
  
  <p>2:</p>
  
  <blockquote>
    <p>Run this command on CMD  ./bin/plugin --install jdbc --url
    <a href="http://xbib.org/repository/org/xbib/elasticsearch/plugin/elasticsearch-river-jdbc/1.3.4.4/elasticsearch-river-jdbc-1.3.4.4-plugin.zip" rel="nofollow noreferrer">http://xbib.org/repository/org/xbib/elasticsearch/plugin/elasticsearch-river-jdbc/1.3.4.4/elasticsearch-river-jdbc-1.3.4.4-plugin.zip</a></p>
  </blockquote>
  
  <p>3:</p>
  
  <blockquote>
    <p>Download MYSQL Connector mysql-connector-java-5.1.33.zip from MYSQL website.</p>
    
    <p>Unzip and copy mysql-connector-java-5.1.33-bin.jar file.</p>
    
    <p>Place it into C:\elasticsearch-1.3.4\plugins\jdbc</p>
  </blockquote>
  
  <p>I have checked now there are two files in plugins directory</p>
  
  <ul>
  <li><p>elasticsearch-river-jdbc-1.3.4.4.jar</p></li>
  <li><p>mysql-connector-java-5.1.33-bin</p></li>
  </ul>
  
  <p>Now I tried to execute this command on CMD and I got error</p>
  
  <pre><code>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"
      }
  }'
  </code></pre>
  
  <hr>
  
  <pre><code>{
    "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
  }
  </code></pre>
  
  <hr>
  
  <pre><code>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
  </code></pre>
  
  <blockquote>
    <p>MYSQL(5.5.37) Database (test) contains just one table (abc) with two columns
    id(pk) and address (varchar)</p>
  </blockquote>
  
  <p>I am using this <strong>jdbc-1.3.4.4-d2e33c3</strong> name as jdbc driver. I get this name from this link.</p>
  
  <pre><code>http://localhost:9200/_nodes?settings=true&amp;pretty=true
  </code></pre>
  
  <p>I have searched on it but cannot found any issue like this related to mysql integration.</p>
  
  <p>My Question is anything still missing or I am doing wrong setup.?</p>