# River jdbc plugin install for windows-not working **URL:** \ **Category:** Elasticsearch\ **Created:** [April 6, 2015, 3:36am UTC](https://discuss.elastic.co/t/river-jdbc-plugin-install-for-windows-not-working/23103 "2015-04-06T03:36:58Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Sanu\_Vimal](https://avatars.discourse-cdn.com/v4/letter/s/9dc877/32.png) [@Sanu\_Vimal](https://discuss.elastic.co/u/Sanu_Vimal)\ **Post date:** [April 6, 2015, 3:36am UTC](https://discuss.elastic.co/t/river-jdbc-plugin-install-for-windows-not-working/23103/1 "2015-04-06T03:36:58Z")
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](mailto: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). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![vineeth\_mohan\_2](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vineeth_mohan_2/32/747_2.png) [@vineeth\_mohan\_2](https://discuss.elastic.co/u/vineeth_mohan_2)\ **Post date:** [April 6, 2015, 3:46am UTC](https://discuss.elastic.co/t/river-jdbc-plugin-install-for-windows-not-working/23103/2 "2015-04-06T03:46:07Z")
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](http://qbox.io) ( Elasticsearch service provider [http://qbox.io/](http://qbox.io/)) On Mon, Apr 6, 2015 at 9:06 AM, Sanu Vimal [sanuvimal@gmail.com](mailto: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](mailto: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) > [https://groups.google.com/d/msgid/elasticsearch/99bf4e67-cee8-4968-92ff-1cb9f34f4c92%40googlegroups.com?utm\_medium=email&utm\_source=footer](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](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](mailto: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](https://groups.google.com/d/msgid/elasticsearch/CAGdPd5%3Db5kKrB-48T72C%3D9OPKC6iTU3YsEEf7aQmjS1E8Q3zqA%40mail.gmail.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Sanu\_Vimal](https://avatars.discourse-cdn.com/v4/letter/s/9dc877/32.png) [@Sanu\_Vimal](https://discuss.elastic.co/u/Sanu_Vimal)\ **Post date:** [April 6, 2015, 4:03am UTC](https://discuss.elastic.co/t/river-jdbc-plugin-install-for-windows-not-working/23103/3 "2015-04-06T04:03:55Z")
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](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](mailto: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). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![vineeth\_mohan\_2](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vineeth_mohan_2/32/747_2.png) [@vineeth\_mohan\_2](https://discuss.elastic.co/u/vineeth_mohan_2)\ **Post date:** [April 6, 2015, 4:31am UTC](https://discuss.elastic.co/t/river-jdbc-plugin-install-for-windows-not-working/23103/4 "2015-04-06T04:31:52Z")
Hi Sanu , Didi you perform 3rd and fourth steps told here - > **[GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch](https://github.com/jprante/elasticsearch-jdbc)** > > JDBC importer for Elasticsearch. Contribute to jprante/elasticsearch-jdbc development by creating an account on GitHub. Thanks Vineeth On Mon, Apr 6, 2015 at 9:33 AM, Sanu Vimal [sanuvimal@gmail.com](mailto: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](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](mailto: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) > [https://groups.google.com/d/msgid/elasticsearch/839f79d8-7b4b-4737-9310-ef0209d8d00e%40googlegroups.com?utm\_medium=email&utm\_source=footer](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](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](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CAGdPd5kFpYgZdQVGXk4ecJ0iLurZCbL1vTu1aHcuyNcZGnJpsA%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAGdPd5kFpYgZdQVGXk4ecJ0iLurZCbL1vTu1aHcuyNcZGnJpsA%40mail.gmail.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Sanu\_Vimal](https://avatars.discourse-cdn.com/v4/letter/s/9dc877/32.png) [@Sanu\_Vimal](https://discuss.elastic.co/u/Sanu_Vimal)\ **Post date:** [April 6, 2015, 4:42am UTC](https://discuss.elastic.co/t/river-jdbc-plugin-install-for-windows-not-working/23103/5 "2015-04-06T04:42:13Z")
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](mailto: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](https://groups.google.com/d/msgid/elasticsearch/43f31512-ea5a-490b-aefc-7002975b86fb%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Sanu\_Vimal](https://avatars.discourse-cdn.com/v4/letter/s/9dc877/32.png) [@Sanu\_Vimal](https://discuss.elastic.co/u/Sanu_Vimal)\ **Post date:** [April 6, 2015, 6:05am UTC](https://discuss.elastic.co/t/river-jdbc-plugin-install-for-windows-not-working/23103/6 "2015-04-06T06:05:39Z")
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](mailto: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). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![jprante](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jprante/32/44941_2.png) [@jprante](https://discuss.elastic.co/u/jprante)\ **Post date:** [April 6, 2015, 8:15am UTC](https://discuss.elastic.co/t/river-jdbc-plugin-install-for-windows-not-working/23103/7 "2015-04-06T08:15:13Z")
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](mailto: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](mailto: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) > [https://groups.google.com/d/msgid/elasticsearch/b68518c3-29bc-405f-8509-a9fefa62452a%40googlegroups.com?utm\_medium=email&utm\_source=footer](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](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](mailto: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](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](https://groups.google.com/d/optout). ---
**Author:** ![Sanu\_Vimal](https://avatars.discourse-cdn.com/v4/letter/s/9dc877/32.png) [@Sanu\_Vimal](https://discuss.elastic.co/u/Sanu_Vimal)\ **Post date:** [April 6, 2015, 12:36pm UTC](https://discuss.elastic.co/t/river-jdbc-plugin-install-for-windows-not-working/23103/8 "2015-04-06T12:36:45Z")
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](mailto: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). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![jmkgreen](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jmkgreen/32/471_2.png) [@jmkgreen](https://discuss.elastic.co/u/jmkgreen)\ **Post date:** [April 8, 2015, 8:58am UTC](https://discuss.elastic.co/t/river-jdbc-plugin-install-for-windows-not-working/23103/9 "2015-04-08T08:58:20Z")
As discussed elsewhere please avoid Rivers as they are deprecated for removal. On 6 April 2015 at 13:36, Sanu Vimal [sanuvimal@gmail.com](mailto: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](mailto: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) > [https://groups.google.com/d/msgid/elasticsearch/939abc32-1a4d-4efd-a324-c8b32a7e1fec%40googlegroups.com?utm\_medium=email&utm\_source=footer](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](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](mailto: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). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![jprante](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jprante/32/44941_2.png) [@jprante](https://discuss.elastic.co/u/jprante)\ **Post date:** [April 8, 2015, 1:06pm UTC](https://discuss.elastic.co/t/river-jdbc-plugin-install-for-windows-not-working/23103/10 "2015-04-08T13:06:00Z")
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](mailto: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](mailto: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](mailto: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) > > [https://groups.google.com/d/msgid/elasticsearch/939abc32-1a4d-4efd-a324-c8b32a7e1fec%40googlegroups.com?utm\_medium=email&utm\_source=footer](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](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](mailto: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) > [https://groups.google.com/d/msgid/elasticsearch/CAMH6%2BawFii%2BjkMramzHRPhAdr2GdqMQH%3DwH\_hVO-qLqhWt%2BKjg%40mail.gmail.com?utm\_medium=email&utm\_source=footer](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](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](mailto: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](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](https://groups.google.com/d/optout). ---
**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:20am UTC](https://discuss.elastic.co/t/river-jdbc-plugin-install-for-windows-not-working/23103/11 "2017-07-06T00:20:52Z")