# Connect logstash with Cassandra and send data to Elastic

**URL:** <https://discuss.elastic.co/t/connect-logstash-with-cassandra-and-send-data-to-elastic/82912>\
**Category:** Logstash\
**Created:** [April 19, 2017, 3:50pm UTC](https://discuss.elastic.co/t/connect-logstash-with-cassandra-and-send-data-to-elastic/82912 "2017-04-19T15:50:28Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Prashant\_Agrawal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/prashant_agrawal/32/74982_2.png) [@Prashant\_Agrawal](https://discuss.elastic.co/u/Prashant_Agrawal)\
**Post date:** [April 19, 2017, 3:50pm UTC](https://discuss.elastic.co/t/connect-logstash-with-cassandra-and-send-data-to-elastic/82912/1 "2017-04-19T15:50:28Z")

</div>

Hi Team :  
I am trying to import data from Cassandra to Elastic using logstash jdbc , but I am getting an error as `org.apache.cassandra.cql.jdbc.CassandraDriver not loaded.` where as I added the jar and class path as below:

```auto
jdbc {
jdbc_connection_string => "jdbc:cassandra://localhost:9042"
jdbc_user => ""
jdbc_password => ""
jdbc_driver_library => "/root/cassandra-jdbc-1.2.5.jar"
jdbc_driver_class => "org.apache.cassandra.cql.jdbc.CassandraDriver"
statement => "SELECT * FROM keyspace.table"
}
}

output {
stdout {
codec => rubydebug
}
}
 

```

I have downloaded the `cassandra-jdbc-1.2.5.jar` from [http://www.java2s.com/Code/Jar/c/Downloadcassandrajdbc125jar.htm](http://www.java2s.com/Code/Jar/c/Downloadcassandrajdbc125jar.htm), which does have `org.apache.cassandra.cql.jdbc.CassandraDriver` as I checked by jar xf jar\_name.

Full Exception :  
`[2017-04-18T16:44:06,709][ERROR][logstash.agent] Pipeline aborted due to error {:exception=>#<LogStash::ConfigurationError: org.apache.cassandra.cql.jdbc.CassandraDriver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?>, :backtrace=>["/usr/share/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-4.1.3/lib/logstash/plugin_mixins/jdbc.rb:157:in `prepare_jdbc_connection'", "/usr/share/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-4.1.3/lib/logstash/inputs/jdbc.rb:191:in `register'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:257:in `register_plugin'",`

So is there anything I am doing wrong, if someone have any idea please let me know`

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [April 20, 2017, 4:55am UTC](https://discuss.elastic.co/t/connect-logstash-with-cassandra-and-send-data-to-elastic/82912/2 "2017-04-20T04:55:32Z")

</div>

Can the Logstash user read that jdbc file?

---

<div class="post-metadata">

**Author:** ![Prashant\_Agrawal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/prashant_agrawal/32/74982_2.png) [@Prashant\_Agrawal](https://discuss.elastic.co/u/Prashant_Agrawal)\
**Post date:** [April 22, 2017, 11:21am UTC](https://discuss.elastic.co/t/connect-logstash-with-cassandra-and-send-data-to-elastic/82912/3 "2017-04-22T11:21:36Z")

</div>

Yes, it can , I even tried giving the 777 permission to jdbc jar file.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [May 20, 2017, 11:28am UTC](https://discuss.elastic.co/t/connect-logstash-with-cassandra-and-send-data-to-elastic/82912/4 "2017-05-20T11:28:53Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.