JDBC River plugin Error

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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/9e9a1906-3f9c-4da3-9037-c84a599444f1%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/0b9b0a0d-ddb7-42e5-ba91-2d0382bf84cd%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.