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.gr...@gmail.com>
wrote:
> As discussed elsewhere please avoid Rivers as they are deprecated for
> removal.
>
> On 6 April 2015 at 13:36, Sanu Vimal <sanuvi...@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 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
>> <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.
>>
>
> --
> 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/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>
> .
>
> 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/CAKdsXoFv%2Bv1MprhHRA8G6Gc1%2B%2BiBhvGTha3PuwGY%3Dccr9Rpsyg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
