# Logstash not loading jdbc\_driver\_class

**URL:** <https://discuss.elastic.co/t/logstash-not-loading-jdbc-driver-class/177661>\
**Category:** Logstash\
**Created:** [April 19, 2019, 7:01pm UTC](https://discuss.elastic.co/t/logstash-not-loading-jdbc-driver-class/177661 "2019-04-19T19:01:11Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dede\_Pessu](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dede_pessu/32/44473_2.png) [@Dede\_Pessu](https://discuss.elastic.co/u/Dede_Pessu)\
**Post date:** [April 19, 2019, 7:01pm UTC](https://discuss.elastic.co/t/logstash-not-loading-jdbc-driver-class/177661/1 "2019-04-19T19:01:11Z")

</div>

-I have the following configuration in my jdbc pipeline

```auto
   input {
     jdbc {
       jdbc_driver_library => "/usr/share/logstash/mysql-connector-java-5.1.46.jar"
       jdbc_driver_class => "com.mysql.jdbc.Driver"
       jdbc_connection_string => "jdbc:mysql://<some_ip>:<some_port>/<some_database>?useSSL=false"
       jdbc_user => "<some_username>"
       jdbc_password => "<some_password>"
       schedule => "* * * * *"
       statement => "SELECT * FROM <Table_name> WHERE id > :sql_last_value"
       use_column_value => true
       tracking_column => "id"
     }
   }

```

-And in my local vm its confirmed that the driver is in the correct location

```auto
[root@<local_vm> ~]# cd /usr/share/logstash/
[root@<local_vm> logstash]# find mysql-connector-java-5.1.46.jar
mysql-connector-java-5.1.46.jar
[root@<local_vm> logstash]#

```

-But i keep getting this error for some reason when i tail my 'logstash-stderr.log' file even though my config file is pointing at the correct path for the mysql connector driver.

```auto
2026 rufus-scheduler intercepted an error:
  2026 job:
  2026 Rufus::Scheduler::CronJob "* * * * *" {}
  2026 error:
  2026 2026
  2026 LogStash::ConfigurationError
  2026 com.mysql.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
  2026 /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-input-jdbc-4.3.13/lib/logstash/plugin_mixins/jdbc/jdbc.rb:163:in `open_jdbc_connection'
  2026 /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-input-jdbc-4.3.13/lib/logstash/plugin_mixins/jdbc/jdbc.rb:221:in `execute_statement'
  2026 /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-input-jdbc-4.3.13/lib/logstash/inputs/jdbc.rb:277:in `execute_query'
  2026 /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-input-jdbc-4.3.13/lib/logstash/inputs/jdbc.rb:258:in `block in run'
  2026 /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/rufus-scheduler-3.0.9/lib/rufus/scheduler/jobs.rb:234:in `do_call'
  2026 /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/rufus-scheduler-3.0.9/lib/rufus/scheduler/jobs.rb:258:in `do_trigger'
  2026 /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/rufus-scheduler-3.0.9/lib/rufus/scheduler/jobs.rb:300:in `block in start_work_thread'
  2026 /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/rufus-scheduler-3.0.9/lib/rufus/scheduler/jobs.rb:299:in `block in start_work_thread'
  2026 org/jruby/RubyKernel.java:1411:in `loop'
  2026 /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/rufus-scheduler-3.0.9/lib/rufus/scheduler/jobs.rb:289:in `block in start_work_thread'

```

-Any thoughts, possible solutions for this?

---

<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 17, 2019, 7:01pm UTC](https://discuss.elastic.co/t/logstash-not-loading-jdbc-driver-class/177661/2 "2019-05-17T19:01:16Z")

</div>

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