River jdbc plugin install for windows-not working

Hi
Everything worked on a linux machine. Now i need to use the river jdbc
plugin in the windows but there is not much documentation or support. I
tried everything created the plugin folder with river jdbc in the jdbc
folder added all type of mysql connectors in the folder i also added the
jar file in the lib of elastic search. I also added the jar files in the
class path of env variables. Still i get

[2015-04-05 22:49:12,568][ERROR][river.jdbc.SimpleRiverSource] while
opening
read connection: jdbc:mysql://localhost:3306/test No suitable driver found
for jdbc
:mysql://localhost:3306/test
java.sql.SQLException: No suitable driver found for
jdbc:mysql://localhost:3306/
test

I am using cygwin to eecute my river

curl -XPUT 'localhost:9200/_river/my_jdbc_river/_meta' -d '{
"type" : "jdbc",
"jdbc" : {
"url" : "jdbc:mysql://localhost:3306/test",
"user" : "root",
"password" : "",
"sql" : "select * from test.orders"
}
}'

In mysql the connection name is "Sanu" and the data base name is test.
Please help or reffer anything.

--
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/99bf4e67-cee8-4968-92ff-1cb9f34f4c92%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Hi ,

You need to copy the java jars of mysql jdbc libraries to the plugins
folder.
It wont otherwise work.

Thanks
Vineeth Mohan,
Elasticsearch consultant,
qbox.io ( Elasticsearch service provider http://qbox.io/)

On Mon, Apr 6, 2015 at 9:06 AM, Sanu Vimal sanuvimal@gmail.com wrote:

Hi
Everything worked on a linux machine. Now i need to use the river jdbc
plugin in the windows but there is not much documentation or support. I
tried everything created the plugin folder with river jdbc in the jdbc
folder added all type of mysql connectors in the folder i also added the
jar file in the lib of Elasticsearch. I also added the jar files in the
class path of env variables. Still i get

[2015-04-05 22:49:12,568][ERROR][river.jdbc.SimpleRiverSource] while
opening
read connection: jdbc:mysql://localhost:3306/test No suitable driver
found for jdbc
:mysql://localhost:3306/test
java.sql.SQLException: No suitable driver found for
jdbc:mysql://localhost:3306/
test

I am using cygwin to eecute my river

curl -XPUT 'localhost:9200/_river/my_jdbc_river/_meta' -d '{
"type" : "jdbc",
"jdbc" : {
"url" : "jdbc:mysql://localhost:3306/test",
"user" : "root",
"password" : "",
"sql" : "select * from test.orders"
}
}'

In mysql the connection name is "Sanu" and the data base name is test.
Please help or reffer anything.

--
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/99bf4e67-cee8-4968-92ff-1cb9f34f4c92%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/99bf4e67-cee8-4968-92ff-1cb9f34f4c92%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
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/CAGdPd5%3Db5kKrB-48T72C%3D9OPKC6iTU3YsEEf7aQmjS1E8Q3zqA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

I have put all the files of mysql jdbc connector to the plugin/jdbc folder
where my river jars are still i get the below error

curl -XPUT "http://localhos[2015-04-06
09:29:44,105][ERROR][river.jdbc.SimpleRiverSource] while opening rea
d connection: jdbc:mysql://localhost:3306/test No suitable driver found for
jdbc
:mysql://localhost:3306/test
java.sql.SQLException: No suitable driver found for
jdbc:mysql://localhost:3306/
test
at java.sql.DriverManager.getConnection(DriverManager.java:596)
at java.sql.DriverManager.getConnection(DriverManager.java:187)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.g
etConnectionForReading(SimpleRiverSource.java:220)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.e
xecute(SimpleRiverSource.java:393)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.f
etch(SimpleRiverSource.java:332)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverFlow.fet
ch(SimpleRiverFlow.java:226)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverFlow.exe
cute(SimpleRiverFlow.java:152)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.request(RiverPipelin
e.java:88)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.call(RiverPipeline.j
ava:66)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.call(RiverPipeline.j
ava:30)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
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:745)
[2015-04-06 09:30:14,108][ERROR][river.jdbc.SimpleRiverSource] while
opening rea
d connection: jdbc:mysql://localhost:3306/test No suitable driver found for
jdbc
:mysql://localhost:3306/test
java.sql.SQLException: No suitable driver found for
jdbc:mysql://localhost:3306/
test
at java.sql.DriverManager.getConnection(DriverManager.java:596)
at java.sql.DriverManager.getConnection(DriverManager.java:187)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.g
etConnectionForReading(SimpleRiverSource.java:220)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.e
xecute(SimpleRiverSource.java:393)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.f
etch(SimpleRiverSource.java:332)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverFlow.fet
ch(SimpleRiverFlow.java:226)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverFlow.exe
cute(SimpleRiverFlow.java:152)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.request(RiverPipelin
e.java:88)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.call(RiverPipeline.j
ava:66)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.call(RiverPipeline.j
ava:30)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
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:745)
[2015-04-06 09:30:44,560][ERROR][river.jdbc.SimpleRiverSource] while
opening rea
d connection: jdbc:mysql://localhost:3306/test No suitable driver found for
jdbc
:mysql://localhost:3306/test
java.sql.SQLException: No suitable driver found for
jdbc:mysql://localhost:3306/
test
at java.sql.DriverManager.getConnection(DriverManager.java:596)
at java.sql.DriverManager.getConnection(DriverManager.java:187)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.g
etConnectionForReading(SimpleRiverSource.java:220)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.e
xecute(SimpleRiverSource.java:393)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.f
etch(SimpleRiverSource.java:332)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverFlow.fet
ch(SimpleRiverFlow.java:226)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverFlow.exe
cute(SimpleRiverFlow.java:152)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.request(RiverPipelin
e.java:88)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.call(RiverPipeline.j
ava:66)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.call(RiverPipeline.j
ava:30)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
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:745)
[2015-04-06 09:31:14,601][INFO ][index.shard ] [Forearm]
[jdbc][0]
updating refresh_interval from [-1] to [1s]
[2015-04-06 09:31:14,603][INFO ][index.shard ] [Forearm]
[jdbc][1]
updating refresh_interval from [-1] to [1s]
[2015-04-06 09:31:14,604][INFO ][index.shard ] [Forearm]
[jdbc][2]
updating refresh_interval from [-1] to [1s]
[2015-04-06 09:31:14,606][INFO ][index.shard ] [Forearm]
[jdbc][3]
updating refresh_interval from [-1] to [1s]
[2015-04-06 09:31:14,607][INFO ][index.shard ] [Forearm]
[jdbc][4]
updating refresh_interval from [-1] to [1s]
[2015-04-06 09:31:14,639][INFO ][river.jdbc.RiverMetrics ] pipeline
org.xbib.el
asticsearch.plugin.jdbc.RiverPipeline@22404c6f complete: river
jdbc/my_jdbc_rive
r metrics: 0 rows, 0.0 mean, (0.0 0.0 0.0), ingest metrics: elapsed 1
minute 30
seconds, 0.0 bytes bytes, 0.0 bytes avg, 0 MB/s
t:9200/_river/mybooks/_meta" --data-binary "@config.json"

On Monday, April 6, 2015 at 9:06:59 AM UTC+5:30, Sanu Vimal wrote:

Hi
Everything worked on a linux machine. Now i need to use the river jdbc
plugin in the windows but there is not much documentation or support. I
tried everything created the plugin folder with river jdbc in the jdbc
folder added all type of mysql connectors in the folder i also added the
jar file in the lib of Elasticsearch. I also added the jar files in the
class path of env variables. Still i get

[2015-04-05 22:49:12,568][ERROR][river.jdbc.SimpleRiverSource] while
opening
read connection: jdbc:mysql://localhost:3306/test No suitable driver found
for jdbc
:mysql://localhost:3306/test
java.sql.SQLException: No suitable driver found for
jdbc:mysql://localhost:3306/
test

I am using cygwin to eecute my river

curl -XPUT 'localhost:9200/_river/my_jdbc_river/_meta' -d '{
"type" : "jdbc",
"jdbc" : {
"url" : "jdbc:mysql://localhost:3306/test",
"user" : "root",
"password" : "",
"sql" : "select * from test.orders"
}
}'

In mysql the connection name is "Sanu" and the data base name is test.
Please help or reffer anything.

--
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/839f79d8-7b4b-4737-9310-ef0209d8d00e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Hi Sanu ,

Didi you perform 3rd and fourth steps told here -

Thanks
Vineeth

On Mon, Apr 6, 2015 at 9:33 AM, Sanu Vimal sanuvimal@gmail.com wrote:

I have put all the files of mysql jdbc connector to the plugin/jdbc folder
where my river jars are still i get the below error

curl -XPUT "http://localhos[2015-04-06
09:29:44,105][ERROR][river.jdbc.SimpleRiverSource] while opening rea
d connection: jdbc:mysql://localhost:3306/test No suitable driver found
for jdbc
:mysql://localhost:3306/test
java.sql.SQLException: No suitable driver found for
jdbc:mysql://localhost:3306/
test
at java.sql.DriverManager.getConnection(DriverManager.java:596)
at java.sql.DriverManager.getConnection(DriverManager.java:187)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.g
etConnectionForReading(SimpleRiverSource.java:220)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.e
xecute(SimpleRiverSource.java:393)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.f
etch(SimpleRiverSource.java:332)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverFlow.fet
ch(SimpleRiverFlow.java:226)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverFlow.exe
cute(SimpleRiverFlow.java:152)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.request(RiverPipelin
e.java:88)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.call(RiverPipeline.j
ava:66)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.call(RiverPipeline.j
ava:30)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
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:745)
[2015-04-06 09:30:14,108][ERROR][river.jdbc.SimpleRiverSource] while
opening rea
d connection: jdbc:mysql://localhost:3306/test No suitable driver found
for jdbc
:mysql://localhost:3306/test
java.sql.SQLException: No suitable driver found for
jdbc:mysql://localhost:3306/
test
at java.sql.DriverManager.getConnection(DriverManager.java:596)
at java.sql.DriverManager.getConnection(DriverManager.java:187)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.g
etConnectionForReading(SimpleRiverSource.java:220)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.e
xecute(SimpleRiverSource.java:393)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.f
etch(SimpleRiverSource.java:332)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverFlow.fet
ch(SimpleRiverFlow.java:226)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverFlow.exe
cute(SimpleRiverFlow.java:152)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.request(RiverPipelin
e.java:88)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.call(RiverPipeline.j
ava:66)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.call(RiverPipeline.j
ava:30)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
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:745)
[2015-04-06 09:30:44,560][ERROR][river.jdbc.SimpleRiverSource] while
opening rea
d connection: jdbc:mysql://localhost:3306/test No suitable driver found
for jdbc
:mysql://localhost:3306/test
java.sql.SQLException: No suitable driver found for
jdbc:mysql://localhost:3306/
test
at java.sql.DriverManager.getConnection(DriverManager.java:596)
at java.sql.DriverManager.getConnection(DriverManager.java:187)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.g
etConnectionForReading(SimpleRiverSource.java:220)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.e
xecute(SimpleRiverSource.java:393)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.f
etch(SimpleRiverSource.java:332)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverFlow.fet
ch(SimpleRiverFlow.java:226)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverFlow.exe
cute(SimpleRiverFlow.java:152)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.request(RiverPipelin
e.java:88)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.call(RiverPipeline.j
ava:66)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.call(RiverPipeline.j
ava:30)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
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:745)
[2015-04-06 09:31:14,601][INFO ][index.shard ] [Forearm]
[jdbc][0]
updating refresh_interval from [-1] to [1s]
[2015-04-06 09:31:14,603][INFO ][index.shard ] [Forearm]
[jdbc][1]
updating refresh_interval from [-1] to [1s]
[2015-04-06 09:31:14,604][INFO ][index.shard ] [Forearm]
[jdbc][2]
updating refresh_interval from [-1] to [1s]
[2015-04-06 09:31:14,606][INFO ][index.shard ] [Forearm]
[jdbc][3]
updating refresh_interval from [-1] to [1s]
[2015-04-06 09:31:14,607][INFO ][index.shard ] [Forearm]
[jdbc][4]
updating refresh_interval from [-1] to [1s]
[2015-04-06 09:31:14,639][INFO ][river.jdbc.RiverMetrics ] pipeline
org.xbib.el
asticsearch.plugin.jdbc.RiverPipeline@22404c6f complete: river
jdbc/my_jdbc_rive
r metrics: 0 rows, 0.0 mean, (0.0 0.0 0.0), ingest metrics: elapsed 1
minute 30
seconds, 0.0 bytes bytes, 0.0 bytes avg, 0 MB/s
t:9200/_river/mybooks/_meta" --data-binary "@config.json"


On Monday, April 6, 2015 at 9:06:59 AM UTC+5:30, Sanu Vimal wrote:

Hi
Everything worked on a linux machine. Now i need to use the river jdbc
plugin in the windows but there is not much documentation or support. I
tried everything created the plugin folder with river jdbc in the jdbc
folder added all type of mysql connectors in the folder i also added the
jar file in the lib of Elasticsearch. I also added the jar files in the
class path of env variables. Still i get

[2015-04-05 22:49:12,568][ERROR][river.jdbc.SimpleRiverSource] while
opening
read connection: jdbc:mysql://localhost:3306/test No suitable driver
found for jdbc
:mysql://localhost:3306/test
java.sql.SQLException: No suitable driver found for
jdbc:mysql://localhost:3306/
test

I am using cygwin to eecute my river

curl -XPUT 'localhost:9200/_river/my_jdbc_river/_meta' -d '{
"type" : "jdbc",
"jdbc" : {
"url" : "jdbc:mysql://localhost:3306/test",
"user" : "root",
"password" : "",
"sql" : "select * from test.orders"
}
}'

In mysql the connection name is "Sanu" and the data base name is test.
Please help or reffer anything.

--
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/839f79d8-7b4b-4737-9310-ef0209d8d00e%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/839f79d8-7b4b-4737-9310-ef0209d8d00e%40googlegroups.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

--
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/CAGdPd5kFpYgZdQVGXk4ecJ0iLurZCbL1vTu1aHcuyNcZGnJpsA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Hi Vineeth,

Since i am in windows i dint do it through cygwin for executing shell
commands. But I downloades river 1.5 where there are two jar files and put
it into the plugins/jdbc folder in Elasticsearch. The folders were created
by me since they were not present. Then I
downloaded mysql-connector-java-5.0.8 jar and put it into river jdbc folder
along with the jars from the conectors lib folder. Please let me know if i
am missing anything.

I used Jorgs documentation for my mac and everything worked there but not
easy ride on windows.

Regards,
Sanu

On Monday, April 6, 2015 at 9:06:59 AM UTC+5:30, Sanu Vimal wrote:

Hi
Everything worked on a linux machine. Now i need to use the river jdbc
plugin in the windows but there is not much documentation or support. I
tried everything created the plugin folder with river jdbc in the jdbc
folder added all type of mysql connectors in the folder i also added the
jar file in the lib of Elasticsearch. I also added the jar files in the
class path of env variables. Still i get

[2015-04-05 22:49:12,568][ERROR][river.jdbc.SimpleRiverSource] while
opening
read connection: jdbc:mysql://localhost:3306/test No suitable driver found
for jdbc
:mysql://localhost:3306/test
java.sql.SQLException: No suitable driver found for
jdbc:mysql://localhost:3306/
test

I am using cygwin to eecute my river

curl -XPUT 'localhost:9200/_river/my_jdbc_river/_meta' -d '{
"type" : "jdbc",
"jdbc" : {
"url" : "jdbc:mysql://localhost:3306/test",
"user" : "root",
"password" : "",
"sql" : "select * from test.orders"
}
}'

In mysql the connection name is "Sanu" and the data base name is test.
Please help or reffer anything.

--
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/43f31512-ea5a-490b-aefc-7002975b86fb%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Hi any solution for the above issue. As i was researching more the issue
also could happen because you have two java versions but when i run the
java version in cmd o get only one

On Monday, April 6, 2015 at 9:06:59 AM UTC+5:30, Sanu Vimal wrote:

Hi
Everything worked on a linux machine. Now i need to use the river jdbc
plugin in the windows but there is not much documentation or support. I
tried everything created the plugin folder with river jdbc in the jdbc
folder added all type of mysql connectors in the folder i also added the
jar file in the lib of Elasticsearch. I also added the jar files in the
class path of env variables. Still i get

[2015-04-05 22:49:12,568][ERROR][river.jdbc.SimpleRiverSource] while
opening
read connection: jdbc:mysql://localhost:3306/test No suitable driver found
for jdbc
:mysql://localhost:3306/test
java.sql.SQLException: No suitable driver found for
jdbc:mysql://localhost:3306/
test

I am using cygwin to eecute my river

curl -XPUT 'localhost:9200/_river/my_jdbc_river/_meta' -d '{
"type" : "jdbc",
"jdbc" : {
"url" : "jdbc:mysql://localhost:3306/test",
"user" : "root",
"password" : "",
"sql" : "select * from test.orders"
}
}'

In mysql the connection name is "Sanu" and the data base name is test.
Please help or reffer anything.

--
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/b68518c3-29bc-405f-8509-a9fefa62452a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

If you have installed the JDBC plugin by the plugin tool with the
Elasticsearch user, it should have created the plugins/jdbc folder.

MySQL 5.0 has ended life since December, 2011. MySQL JDBC 5.0.8 is over
seven years old. I do not think it makes much sense to try old versions.
Please update and use a more recent driver.

Check also user privileges to access directories and file permissions.

Jörg

On Mon, Apr 6, 2015 at 8:05 AM, Sanu Vimal sanuvimal@gmail.com wrote:

Hi any solution for the above issue. As i was researching more the issue
also could happen because you have two java versions but when i run the
java version in cmd o get only one

On Monday, April 6, 2015 at 9:06:59 AM UTC+5:30, Sanu Vimal wrote:

Hi
Everything worked on a linux machine. Now i need to use the river jdbc
plugin in the windows but there is not much documentation or support. I
tried everything created the plugin folder with river jdbc in the jdbc
folder added all type of mysql connectors in the folder i also added the
jar file in the lib of Elasticsearch. I also added the jar files in the
class path of env variables. Still i get

[2015-04-05 22:49:12,568][ERROR][river.jdbc.SimpleRiverSource] while
opening
read connection: jdbc:mysql://localhost:3306/test No suitable driver
found for jdbc
:mysql://localhost:3306/test
java.sql.SQLException: No suitable driver found for
jdbc:mysql://localhost:3306/
test

I am using cygwin to eecute my river

curl -XPUT 'localhost:9200/_river/my_jdbc_river/_meta' -d '{
"type" : "jdbc",
"jdbc" : {
"url" : "jdbc:mysql://localhost:3306/test",
"user" : "root",
"password" : "",
"sql" : "select * from test.orders"
}
}'

In mysql the connection name is "Sanu" and the data base name is test.
Please help or reffer anything.

--
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/b68518c3-29bc-405f-8509-a9fefa62452a%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/b68518c3-29bc-405f-8509-a9fefa62452a%40googlegroups.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

--
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/CAKdsXoEQwoXgA6_56hxC_aOY%3DVgsK%2BXZ2UCgxJGbUyvRrL9RxA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Hi Jorg,

I have found what was the issue. I was just trying the POC on MySQL but the
real requirement is in oracle11g. I have installed through plugin.bat after
setting up ES_HOME in my system variable.

Thanks
Sanu

On Monday, April 6, 2015 at 9:06:59 AM UTC+5:30, Sanu Vimal wrote:

Hi
Everything worked on a linux machine. Now i need to use the river jdbc
plugin in the windows but there is not much documentation or support. I
tried everything created the plugin folder with river jdbc in the jdbc
folder added all type of mysql connectors in the folder i also added the
jar file in the lib of Elasticsearch. I also added the jar files in the
class path of env variables. Still i get

[2015-04-05 22:49:12,568][ERROR][river.jdbc.SimpleRiverSource] while
opening
read connection: jdbc:mysql://localhost:3306/test No suitable driver found
for jdbc
:mysql://localhost:3306/test
java.sql.SQLException: No suitable driver found for
jdbc:mysql://localhost:3306/
test

I am using cygwin to eecute my river

curl -XPUT 'localhost:9200/_river/my_jdbc_river/_meta' -d '{
"type" : "jdbc",
"jdbc" : {
"url" : "jdbc:mysql://localhost:3306/test",
"user" : "root",
"password" : "",
"sql" : "select * from test.orders"
}
}'

In mysql the connection name is "Sanu" and the data base name is test.
Please help or reffer anything.

--
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/939abc32-1a4d-4efd-a324-c8b32a7e1fec%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

As discussed elsewhere please avoid Rivers as they are deprecated for
removal.

On 6 April 2015 at 13:36, Sanu Vimal sanuvimal@gmail.com wrote:

Hi Jorg,

I have found what was the issue. I was just trying the POC on MySQL but
the real requirement is in oracle11g. I have installed through plugin.bat
after setting up ES_HOME in my system variable.

Thanks
Sanu

On Monday, April 6, 2015 at 9:06:59 AM UTC+5:30, Sanu Vimal wrote:

Hi
Everything worked on a linux machine. Now i need to use the river jdbc
plugin in the windows but there is not much documentation or support. I
tried everything created the plugin folder with river jdbc in the jdbc
folder added all type of mysql connectors in the folder i also added the
jar file in the lib of Elasticsearch. I also added the jar files in the
class path of env variables. Still i get

[2015-04-05 22:49:12,568][ERROR][river.jdbc.SimpleRiverSource] while
opening
read connection: jdbc:mysql://localhost:3306/test No suitable driver
found for jdbc
:mysql://localhost:3306/test
java.sql.SQLException: No suitable driver found for
jdbc:mysql://localhost:3306/
test

I am using cygwin to eecute my river

curl -XPUT 'localhost:9200/_river/my_jdbc_river/_meta' -d '{
"type" : "jdbc",
"jdbc" : {
"url" : "jdbc:mysql://localhost:3306/test",
"user" : "root",
"password" : "",
"sql" : "select * from test.orders"
}
}'

In mysql the connection name is "Sanu" and the data base name is test.
Please help or reffer anything.

--
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/939abc32-1a4d-4efd-a324-c8b32a7e1fec%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/939abc32-1a4d-4efd-a324-c8b32a7e1fec%40googlegroups.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

--
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/CAMH6%2BawFii%2BjkMramzHRPhAdr2GdqMQH%3DwH_hVO-qLqhWt%2BKjg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Please note, JDBC plugin is not only a river any more, it can also be used
as a standalone tool like Logstash.

Jörg

On Wed, Apr 8, 2015 at 10:58 AM, James Green james.mk.green@gmail.com
wrote:

As discussed elsewhere please avoid Rivers as they are deprecated for
removal.

On 6 April 2015 at 13:36, Sanu Vimal sanuvimal@gmail.com wrote:

Hi Jorg,

I have found what was the issue. I was just trying the POC on MySQL but
the real requirement is in oracle11g. I have installed through plugin.bat
after setting up ES_HOME in my system variable.

Thanks
Sanu

On Monday, April 6, 2015 at 9:06:59 AM UTC+5:30, Sanu Vimal wrote:

Hi
Everything worked on a linux machine. Now i need to use the river jdbc
plugin in the windows but there is not much documentation or support. I
tried everything created the plugin folder with river jdbc in the jdbc
folder added all type of mysql connectors in the folder i also added the
jar file in the lib of Elasticsearch. I also added the jar files in the
class path of env variables. Still i get

[2015-04-05 22:49:12,568][ERROR][river.jdbc.SimpleRiverSource] while
opening
read connection: jdbc:mysql://localhost:3306/test No suitable driver
found for jdbc
:mysql://localhost:3306/test
java.sql.SQLException: No suitable driver found for
jdbc:mysql://localhost:3306/
test

I am using cygwin to eecute my river

curl -XPUT 'localhost:9200/_river/my_jdbc_river/_meta' -d '{
"type" : "jdbc",
"jdbc" : {
"url" : "jdbc:mysql://localhost:3306/test",
"user" : "root",
"password" : "",
"sql" : "select * from test.orders"
}
}'

In mysql the connection name is "Sanu" and the data base name is test.
Please help or reffer anything.

--
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/939abc32-1a4d-4efd-a324-c8b32a7e1fec%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/939abc32-1a4d-4efd-a324-c8b32a7e1fec%40googlegroups.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

--
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/CAMH6%2BawFii%2BjkMramzHRPhAdr2GdqMQH%3DwH_hVO-qLqhWt%2BKjg%40mail.gmail.com
https://groups.google.com/d/msgid/elasticsearch/CAMH6%2BawFii%2BjkMramzHRPhAdr2GdqMQH%3DwH_hVO-qLqhWt%2BKjg%40mail.gmail.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

--
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/CAKdsXoFv%2Bv1MprhHRA8G6Gc1%2B%2BiBhvGTha3PuwGY%3Dccr9Rpsyg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.