The Cassandra Java Driver is not a JDBC driver. Jörg
On Fri, Jun 13, 2014 at 11:11 AM, Abhishek Mukherjee <4271...@gmail.com> wrote: > Checking the Elasticsearch log files I found this. > > No suitable driver found for jdbc:cassandra:// > 192.168.1.103:9160/transactionlogdb > at java.sql.DriverManager.getConnection(DriverManager.java:689) > at java.sql.DriverManager.getConnection(DriverManager.java:247) > at > org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.getConnectionForReading(SimpleRiverSource.java:133) > at > org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.execute(SimpleRiverSource.java:271) > > However I have placed all the necessary jar files for the driver in > $ES_HOME/plugins/jdbc. Please advice. > > Kind Regards > Abhishek > > > On Friday, June 13, 2014 1:43:45 PM UTC+5:30, Abhishek Mukherjee wrote: >> >> Hi Everyone, >> >> I am trying to move data from Cassandra to Elasticsearch. Initially I >> tried the cassandra-river at https://github.com/eBay/cassandra-river. >> However I got timed out error which I suspect was originating from the >> Hector API. I posted a question on ths thread https://groups.google.com/ >> forum/#!searchin/elasticsearch/cassandra/elasticsearch/4oDbkqK3GVA/ >> W9WLK4SS2MEJ. >> >> Moving on I thought of using the JDBC-river at >> https://github.com/jprante/elasticsearch-river-jdbc with a java driver >> for cassandra. I followed the mysql example and modified it for cassandra. >> I created the river using as follows: >> >> curl -XPUT '192.168.1.103:9200/_river/my_jdbc_river/_meta' -d '{ >> > "type" : "jdbc", >> > "jdbc" : { >> > "url" : "jdbc:cassandra://192.168.1.105:9160/transactionlogdb", >> >> > "cql" : "select * from logs" >> >> > } >> > }' >> >> >> {"_index":"_river","_type":"my_jdbc_river","_id":"_meta"," >> _version":1,"created":true} >> >> However I don't find any documents being created on the jdbc index. Am I >> missing something? Any help or tips is very much appreciated. Thanks is >> advance. >> >> Kind Regards, >> Abhishek Mukherjee >> > -- > 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/a5dc2bf7-2380-4425-893a-a44e587ba9ce%40googlegroups.com > <https://groups.google.com/d/msgid/elasticsearch/a5dc2bf7-2380-4425-893a-a44e587ba9ce%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/CAKdsXoGf1GjB8MSefx6ZC1OYD0b6Xf%3DKX%2BpDHcYe7cvZVmeyJg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.