# Elasticserach jdbc river when i index document not created

**URL:** <https://discuss.elastic.co/t/elasticserach-jdbc-river-when-i-index-document-not-created/17734>\
**Category:** Elasticsearch\
**Created:** [May 27, 2014, 12:31am UTC](https://discuss.elastic.co/t/elasticserach-jdbc-river-when-i-index-document-not-created/17734 "2014-05-27T00:31:23Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jakjothi](https://avatars.discourse-cdn.com/v4/letter/j/f1d935/32.png) [@jakjothi](https://discuss.elastic.co/u/jakjothi)\
**Post date:** [May 27, 2014, 12:31am UTC](https://discuss.elastic.co/t/elasticserach-jdbc-river-when-i-index-document-not-created/17734/1 "2014-05-27T00:31:23Z")

</div>

I follow this tutorial to indexing document elasticsearch

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

when i make index api call (PUT)

[http://somedomain.com:9200/\_river/myriver/\_meta](http://somedomain.com:9200/_river/myriver/_meta)

{  
"type" : "jdbc",  
"jdbc" : {  
"strategy" : "oneshot",  
"driver" : "com.mysql.jdbc.Driver",  
"url" : "jdbc:mysql://xx.xx.xxx.xxx:3306/portal",  
"user" : "username",  
"password" : "password",  
"sql" : "select item\_id as \_id, item\_id as itemId, item\_name as  
name from item limit 10"  
},  
"index" : {  
"index" : "myindex",  
"type" : "mytype"  
}  
}

The the response shows

{  
"\_index": "\_river",  
"\_type": "myriver",  
"\_id": "\_meta",  
"\_version": 1,  
"created": true  
}

when i get GET \_river/myriver/\_meta

it shows only 1 document what i sent in jdbc properties.

{  
"\_index": "\_river",  
"\_type": "myriver",  
"\_id": "\_meta",  
"\_version": 1,  
"found": true,  
"\_source": {  
"type": "jdbc",  
"jdbc": {  
"strategy": "oneshot",  
"driver": "com.mysql.jdbc.Driver",  
"url": "jdbc:mysql://xx.xx.xxx.xxx:3306/portal",  
"user": "username",  
"password": "password",  
"sql": "select item\_id as \_id, item\_id as itemId, item\_name as  
name from item limit 10"  
},  
"index": {  
"index": "myindex",  
"type": "mytype"  
}  
}  
}

in my error log

[2014-05-27 00:17:25,402][WARN][river] [Typhoid Mary]  
failed to get \_meta from [jdbc]/[myriver]  
java.lang.NoSuchMethodError:  
org.xbib.elasticsearch.support.client.node.NodeClient.maxRequestWait(Lorg/elasticsearch/common/unit/TimeValue;)Lorg/xbib/elasticsearch/support/client/node/NodeClient;  
at  
org.xbib.elasticsearch.plugin.feeder.AbstractFeeder.setClient(AbstractFeeder.java:205)  
at  
org.xbib.elasticsearch.plugin.river.jdbc.JDBCRiver.start(JDBCRiver.java:74)  
at  
org.elasticsearch.river.RiversService.createRiver(RiversService.java:148)  
at  
org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:275)  
at  
org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:269)  
at  
org.elasticsearch.action.support.TransportAction$ThreadedActionListener$1.run(TransportAction.java:93)  
at  
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)  
at  
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)  
at java.lang.Thread.run(Thread.java:724)

--  
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/5b1b9a64-a1b4-4544-8765-786367a51778%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/5b1b9a64-a1b4-4544-8765-786367a51778%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, 1:26am UTC](https://discuss.elastic.co/t/elasticserach-jdbc-river-when-i-index-document-not-created/17734/2 "2017-07-06T01:26:50Z")

</div>