# JDBC River plugin Error

**URL:** <https://discuss.elastic.co/t/jdbc-river-plugin-error/21379>\
**Category:** Elasticsearch\
**Created:** [December 24, 2014, 4:26am UTC](https://discuss.elastic.co/t/jdbc-river-plugin-error/21379 "2014-12-24T04:26:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ashutosh\_Parab](https://avatars.discourse-cdn.com/v4/letter/a/e495f1/32.png) [@Ashutosh\_Parab](https://discuss.elastic.co/u/Ashutosh_Parab)\
**Post date:** [December 24, 2014, 4:26am UTC](https://discuss.elastic.co/t/jdbc-river-plugin-error/21379/1 "2014-12-24T04:26:48Z")

</div>

I am trying to use JDBC River plugin to connect my DB To Elastic Search. I  
was able to put the river config using curl but I am getting the following  
error on startup :-

[2014-12-24 09:52:45,170][WARN][river] [LDN] failed to  
create river [jdbc][mybooks]  
org.elasticsearch.common.settings.NoClassSettingsException: Failed to load  
class  
with value [jdbc]  
at  
org.elasticsearch.river.RiverModule.loadTypeModule(RiverModule.java:8  
7)  
at  
org.elasticsearch.river.RiverModule.spawnModules(RiverModule.java:58)

```
    at 

```

org.elasticsearch.common.inject.ModulesBuilder.add(ModulesBuilder.jav  
a:44)  
at  
org.elasticsearch.river.RiversService.createRiver(RiversService.java:  
137)  
at  
org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(Rivers  
Service.java:275)  
at  
org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(Rivers  
Service.java:269)  
at  
org.elasticsearch.action.support.TransportAction$ThreadedActionListen  
er$1.run(TransportAction.java:93)  
at  
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExec  
utor.java:886)  
at  
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor  
.java:908)  
at java.lang.Thread.run(Thread.java:662)  
Caused by: java.lang.ClassNotFoundException: jdbc  
at java.net.URLClassLoader$1.run(URLClassLoader.java:202)  
at java.security.AccessController.doPrivileged(Native Method)  
at java.net.URLClassLoader.findClass(URLClassLoader.java:190)  
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)  
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)  
at java.lang.ClassLoader.loadClass(ClassLoader.java:247)  
at  
org.elasticsearch.river.RiverModule.loadTypeModule(RiverModule.java:7  
3)

My config file is as follows:-  
{  
"type": "jdbc",  
"jdbc": {  
"driver": "com.microsoft.sqlserver.jdbc.SQLServerDriver",  
"url":

"jdbc:sqlserver://LOCALHOST\SQLEXPRESS;databaseName=Report",  
"user": "user",  
"password": "password",  
"sql": "select \* from abc"  
}  
}

Please advice. My Elastic Search version is 1.0.1 and JDBC plugin version  
is 1.4.0.6.

--  
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/9e9a1906-3f9c-4da3-9037-c84a599444f1%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/9e9a1906-3f9c-4da3-9037-c84a599444f1%40googlegroups.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![Ashutosh\_Parab](https://avatars.discourse-cdn.com/v4/letter/a/e495f1/32.png) [@Ashutosh\_Parab](https://discuss.elastic.co/u/Ashutosh_Parab)\
**Post date:** [December 24, 2014, 9:56am UTC](https://discuss.elastic.co/t/jdbc-river-plugin-error/21379/2 "2014-12-24T09:56:28Z")

</div>

Got it. Chnaged JDBC plugin version to 1.0.3.0 and used JAVA 7.  
Cheers !

On Wednesday, 24 December 2014 09:56:48 UTC+5:30, Ashutosh Parab wrote:

> I am trying to use JDBC River plugin to connect my DB To Elastic Search. I  
> was able to put the river config using curl but I am getting the following  
> error on startup :-
> 
> [2014-12-24 09:52:45,170][WARN][river] [LDN] failed  
> to create river [jdbc][mybooks]  
> org.elasticsearch.common.settings.NoClassSettingsException: Failed to load  
> class  
> with value [jdbc]  
> at  
> org.elasticsearch.river.RiverModule.loadTypeModule(RiverModule.java:8  
> 7)  
> at  
> org.elasticsearch.river.RiverModule.spawnModules(RiverModule.java:58)
> 
> ```
> at 
> 
> ```
> 
> org.elasticsearch.common.inject.ModulesBuilder.add(ModulesBuilder.jav  
> a:44)  
> at  
> org.elasticsearch.river.RiversService.createRiver(RiversService.java:  
> 137)  
> at  
> org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(Rivers  
> Service.java:275)  
> at  
> org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(Rivers  
> Service.java:269)  
> at  
> org.elasticsearch.action.support.TransportAction$ThreadedActionListen  
> er$1.run(TransportAction.java:93)  
> at  
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExec  
> utor.java:886)  
> at  
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor  
> .java:908)  
> at java.lang.Thread.run(Thread.java:662)  
> Caused by: java.lang.ClassNotFoundException: jdbc  
> at java.net.URLClassLoader$1.run(URLClassLoader.java:202)  
> at java.security.AccessController.doPrivileged(Native Method)  
> at java.net.URLClassLoader.findClass(URLClassLoader.java:190)  
> at java.lang.ClassLoader.loadClass(ClassLoader.java:306)  
> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)  
> at java.lang.ClassLoader.loadClass(ClassLoader.java:247)  
> at  
> org.elasticsearch.river.RiverModule.loadTypeModule(RiverModule.java:7  
> 3)
> 
> My config file is as follows:-  
> {  
> "type": "jdbc",  
> "jdbc": {  
> "driver": "com.microsoft.sqlserver.jdbc.SQLServerDriver",  
> "url":
> 
> "jdbc:sqlserver://LOCALHOST\SQLEXPRESS;databaseName=Report",  
> "user": "user",  
> "password": "password",  
> "sql": "select \* from abc"  
> }  
> }
> 
> Please advice. My Elastic Search version is 1.0.1 and JDBC plugin version  
> is 1.4.0.6.

--  
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/0b9b0a0d-ddb7-42e5-ba91-2d0382bf84cd%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/0b9b0a0d-ddb7-42e5-ba91-2d0382bf84cd%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:42am UTC](https://discuss.elastic.co/t/jdbc-river-plugin-error/21379/3 "2017-07-06T00:42:03Z")

</div>