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 <sanuvi...@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 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+unsubscr...@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+unsubscr...@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.
