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
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 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 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
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
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
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.
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 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 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 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
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.