# Cassandra jdbc drive issue with logstash in docker **URL:** \ **Category:** Logstash\ **Tags:** docker\ **Created:** [September 25, 2024, 11:46am UTC](https://discuss.elastic.co/t/cassandra-jdbc-drive-issue-with-logstash-in-docker/367105 "2024-09-25T11:46:42Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![AmritMatti](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/amritmatti/32/137853_2.png) [@AmritMatti](https://discuss.elastic.co/u/AmritMatti)\ **Post date:** [September 25, 2024, 11:46am UTC](https://discuss.elastic.co/t/cassandra-jdbc-drive-issue-with-logstash-in-docker/367105/1 "2024-09-25T11:46:42Z")
Hi, I am running logsstash, elasticsearch, kibana in docker 8.15.0 and cassandra 5.0. I want to setup logstash input from cassandra with jdbc. I have downloaded jdbc drivers from [Cassandra JDBC Driver Download & Connectivity](https://dbschema.com/jdbc-driver/cassandra.html) below is my logstash pipeline conf file nput { jdbc { jdbc\_driver\_library =\> "/usr/share/logstash/logstash-core/lib/jars/cassandra-jdbc-driver.jar" jdbc\_driver\_class =\> "com.dbschema.CassandraJdbcDriver" jdbc\_connection\_string =\> "jdbc:cassandra://cassandra:9042/test\_qa" statement =\> "SELECT \* FROM test WHERE date = :sql\_last\_value" jdbc\_user =\> "cassandra" jdbc\_page\_size =\> 100 use\_column\_value =\> true tracking\_column =\> "date" schedule =\> "\* \* \* \* \*" jdbc\_validate\_connection =\> true } } output { stdout { codec =\> json\_lines } elasticsearch { hosts =\> ["[http://elasticsearch:9200](http://elasticsearch:9200)"] index =\> "test\_qa\_%{+YYYY\_MM\_dd}" } } and getting error logstash | [2024-09-25T11:23:36,841][ERROR][logstash.javapipeline][main] Pipeline error {:pipeline\_id=\>"main", :exception=\>#\. Are you sure you've included the correct jdbc driver in :jdbc\_driver\_library?\>, :backtrace=\>["/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/logstash-integration-jdbc-5.4.11/lib/logstash/plugin\_mixins/jdbc/common.rb:46:in `load_driver'", "/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/logstash-integration-jdbc-5.4.11/lib/logstash/inputs/jdbc.rb:307:in `register'", "/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/logstash-mixin-ecs\_compatibility\_support-1.3.0-java/lib/logstash/plugin\_mixins/ecs\_compatibility\_support/target\_check.rb:48:in `register'", "/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:237:in `block in register\_plugins'", "org/jruby/RubyArray.java:1981:in `each'", "/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:236:in `register\_plugins'", "/usr/share/logstash/logstash-core/lib/logstash/java\_pipeline.rb:395:in `start_inputs'", "/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:320:in `start\_workers'", "/usr/share/logstash/logstash-core/lib/logstash/java\_pipeline.rb:194:in `run'", "/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:146:in `block in start'"], "pipeline.sources"=\>["/usr/share/logstash/pipeline/logstash.conf"], :thread=\>"#\"} also tried with > **[GitHub - logstash-plugins/logstash-integration-jdbc: Logstash Integration Plugin for JDBC, including...](https://github.com/logstash-plugins/logstash-integration-jdbc)** > > Logstash Integration Plugin for JDBC, including Logstash Input and Filter Plugins and jdbc driver from datastax > **[Release 4.17.0 · apache/cassandra-java-driver](https://github.com/apache/cassandra-java-driver/releases/tag/4.17.0)** > > Java Driver for Apache Cassandra®. Contribute to apache/cassandra-java-driver development by creating an account on GitHub. and getting error logstash | [2024-09-25T11:31:45,631][ERROR][logstash.javapipeline][main] Pipeline error {:pipeline\_id=\>"main", :exception=\>#\. Are you sure you've included the correct jdbc driver in :jdbc\_driver\_library?\>, :backtrace=\>["/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/logstash-integration-jdbc-5.4.11/lib/logstash/plugin\_mixins/jdbc/common.rb:46:in `load_driver'", "/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/logstash-integration-jdbc-5.4.11/lib/logstash/inputs/jdbc.rb:307:in `register'", "/usr/share/logstash/vendor/bundle/jruby/3.1.0/gems/logstash-mixin-ecs\_compatibility\_support-1.3.0-java/lib/logstash/plugin\_mixins/ecs\_compatibility\_support/target\_check.rb:48:in `register'", "/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:237:in `block in register\_plugins'", "org/jruby/RubyArray.java:1981:in `each'", "/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:236:in `register\_plugins'", "/usr/share/logstash/logstash-core/lib/logstash/java\_pipeline.rb:395:in `start_inputs'", "/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:320:in `start\_workers'", "/usr/share/logstash/logstash-core/lib/logstash/java\_pipeline.rb:194:in `run'", "/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:146:in `block in start'"], "pipeline.sources"=\>["/usr/share/logstash/pipeline/logstash.conf"], :thread=\>"#\"} ---
**Author:** ![Alex\_Salgado-Elastic](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alex_salgado-elastic/32/103081_2.png) [@Alex\_Salgado-Elastic](https://discuss.elastic.co/u/Alex_Salgado-Elastic)\ **Post date:** [September 25, 2024, 12:26pm UTC](https://discuss.elastic.co/t/cassandra-jdbc-drive-issue-with-logstash-in-docker/367105/2 "2024-09-25T12:26:25Z")
Hi @AmritMatti , I assume you've already checked the steps below, right? 1. Use the correct driver class: For Cassandra 5.0, use `"com.datastax.oss.driver.api.core.CqlSession"`. 2. Mount the driver jar correctly: Ensure that the driver jar is correctly referenced in the Docker container using the `-v` mount in Docker. 3. Verify paths inside the container: Check if the driver is present in `/usr/share/logstash/logstash-core/lib/jars/`. ---
**Author:** ![AmritMatti](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/amritmatti/32/137853_2.png) [@AmritMatti](https://discuss.elastic.co/u/AmritMatti)\ **Post date:** [September 25, 2024, 1:33pm UTC](https://discuss.elastic.co/t/cassandra-jdbc-drive-issue-with-logstash-in-docker/367105/3 "2024-09-25T13:33:13Z")
Hi @Alex_Salgado-Elastic Thanks for response yes, I checked jar drivers location but not tried with this driver class. Can you please share which jar file do we have to use from [Release 4.17.0 · apache/cassandra-java-driver · GitHub](https://github.com/apache/cassandra-java-driver/releases/tag/4.17.0) When i extract this tar file there are many jar files there. May be i am not defining correct one in logstash.conf file