# Connection error

**URL:** <https://discuss.elastic.co/t/connection-error/12800>\
**Category:** Elasticsearch\
**Created:** [July 16, 2013, 3:12am UTC](https://discuss.elastic.co/t/connection-error/12800 "2013-07-16T03:12:46Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![signin\_vasanth](https://avatars.discourse-cdn.com/v4/letter/s/a183cd/32.png) [@signin\_vasanth](https://discuss.elastic.co/u/signin_vasanth)\
**Post date:** [July 16, 2013, 3:12am UTC](https://discuss.elastic.co/t/connection-error/12800/1 "2013-07-16T03:12:46Z")

</div>

Hi to All,

When i try to give put request with the below particulars, (In All requesttab in elastic search head)

{  
"type": "jdbc",  
"jdbc": {  
"driver": "com.mysql.jdbc.driver",  
"url": "jdbc:mysql://192.168.1.223:3306;databaseName=amwaj",  
"user": "root",  
"password": "root",  
"sql": "select \* from account",  
"poll": "30s"  
},  
"index": {  
"index": "amwaj",  
"type": "account",  
"bulk\_size": 500  
}  
}  
i am getting the below error,

[ERROR][org.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource]  
com.mysql.jdbc.driver  
java.lang.ClassNotFoundException: com.mysql.jdbc.driver

Kindly help me out what are things i have to cross check and what i left out

--  
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).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<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:** [July 16, 2013, 3:51am UTC](https://discuss.elastic.co/t/connection-error/12800/2 "2013-07-16T03:51:30Z")

</div>

Add mysql JDBC driver to ES classpath.  
Basically, read JDBC river's doc. It's described there.

--  
David 😉  
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 16 juil. 2013 à 05:12, [signin.vasanth@gmail.com](mailto:signin.vasanth@gmail.com) a écrit :

> Hi to All,
> 
> When i try to give put request with the below particulars, (In All request tab in Elasticsearch head)
> 
> {  
> "type": "jdbc",  
> "jdbc": {  
> "driver": "com.mysql.jdbc.driver",  
> "url": "jdbc:mysql://192.168.1.223:3306;databaseName=amwaj",  
> "user": "root",  
> "password": "root",  
> "sql": "select \* from account",  
> "poll": "30s"  
> },  
> "index": {  
> "index": "amwaj",  
> "type": "account",  
> "bulk\_size": 500  
> }  
> }  
> i am getting the below error,
> 
> [ERROR][org.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource] com.mysql.jdbc.driver  
> java.lang.ClassNotFoundException: com.mysql.jdbc.driver
> 
> ## Kindly help me out what are things i have to cross check and what i left out
> 
> 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).  
> For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

--  
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).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<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, 2:26am UTC](https://discuss.elastic.co/t/connection-error/12800/3 "2017-07-06T02:26:21Z")

</div>