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