The JDBC plugin can not find the JDBC driver jar.
Put a driver jar into the plugins/jdbc folder, and check for permissions.
Do not add "all types of mysql connectors" - this will not work. Just put
exactly one driver in there.
Jörg
On Mon, Apr 6, 2015 at 5:34 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.
>
> On Friday, March 27, 2015 at 6:28:37 PM UTC+5:30, Sanu Vimal wrote:
>>
>> Hi
>>
>> Please get me some solution to connect elastic search to my table data in
>> mysql.
>> I have installed the river jdbc plugin and have put in the mysql jar file
>> within the plugin /jdbc folder.
>> I do not know how to proceed from there. I am using a mac os.
>> I am relatively new to Kibana so please help
>>
>> Thanks,
>> Sanu
>>
> --
> 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/37299ce1-be71-40a2-9a10-d7b3a74da239%40googlegroups.com
> <https://groups.google.com/d/msgid/elasticsearch/37299ce1-be71-40a2-9a10-d7b3a74da239%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/CAKdsXoHH%2Bde%3Dji4F4o9rSKgi%3D2hsGrL0S%3D9JTeNqyHqxAGrDqQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
