# "Unable to find driver class" when use jdbc\_driver\_library =\> "/home/ubuntu/ojdbc6.jar" after upgrade to Logstash 6.8.4

**URL:** <https://discuss.elastic.co/t/unable-to-find-driver-class-when-use-jdbc-driver-library-home-ubuntu-ojdbc6-jar-after-upgrade-to-logstash-6-8-4/205182>\
**Category:** Logstash\
**Created:** [October 25, 2019, 5:00am UTC](https://discuss.elastic.co/t/unable-to-find-driver-class-when-use-jdbc-driver-library-home-ubuntu-ojdbc6-jar-after-upgrade-to-logstash-6-8-4/205182 "2019-10-25T05:00:45Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jersey\_Zhang](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jersey_zhang/32/56573_2.png) [@Jersey\_Zhang](https://discuss.elastic.co/u/Jersey_Zhang)\
**Post date:** [October 25, 2019, 5:00am UTC](https://discuss.elastic.co/t/unable-to-find-driver-class-when-use-jdbc-driver-library-home-ubuntu-ojdbc6-jar-after-upgrade-to-logstash-6-8-4/205182/1 "2019-10-25T05:00:46Z")

</div>

The latest release of Logstash 6.8.4 with jdbc-input-plugin 4.3.16 give us following error in syslog

```auto
Oct 24 21:02:00 ip-10-40-0-99 logstash[15520]: 2172 job:
Oct 24 21:02:00 ip-10-40-0-99 logstash[15520]: 2172 Rufus::Scheduler::CronJob "*/1 * * * *" {}
Oct 24 21:02:00 ip-10-40-0-99 logstash[15520]: 2172 error:
Oct 24 21:02:00 ip-10-40-0-99 logstash[15520]: 2172 2172
Oct 24 21:02:00 ip-10-40-0-99 logstash[15520]: 2172 LogStash::PluginLoadingError
Oct 24 21:02:00 ip-10-40-0-99 logstash[15520]: 2172 Unable to find driver class via URLClassLoader in given driver jars: Java::oracle.jdbc.driver.OracleDriver and Java::oracle.jdbc.driver.OracleDriver
Oct 24 21:02:00 ip-10-40-0-99 logstash[15520]: 2172 /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-input-jdbc-4.3.16/lib/logstash/plugin_mixins/jdbc/jdbc.rb:181:in `open_jdbc_connection'
Oct 24 21:02:00 ip-10-40-0-99 logstash[15520]: 2172 /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-input-jdbc-4.3.16/lib/logstash/plugin_mixins/jdbc/jdbc.rb:253:in `execute_statement'
Oct 24 21:02:00 ip-10-40-0-99 logstash[15520]: 2172 /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-input-jdbc-4.3.16/lib/logstash/inputs/jdbc.rb:309:in `execute_query'
Oct 24 21:02:00 ip-10-40-0-99 logstash[15520]: 2172 /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-input-jdbc-4.3.16/lib/logstash/inputs/jdbc.rb:276:in `block in run'
Oct 24 21:02:00 ip-10-40-0-99 logstash[15520]: 2172 /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/rufus-scheduler-3.0.9/lib/rufus/scheduler/jobs.rb:234:in `do_call'
Oct 24 21:02:00 ip-10-40-0-99 logstash[15520]: 2172 /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/rufus-scheduler-3.0.9/lib/rufus/scheduler/jobs.rb:258:in `do_trigger'
Oct 24 21:02:00 ip-10-40-0-99 logstash[15520]: 2172 /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'
Oct 24 21:02:00 ip-10-40-0-99 logstash[15520]: 2172 /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'
Oct 24 21:02:00 ip-10-40-0-99 logstash[15520]: 2172 org/jruby/RubyKernel.java:1425:in `loop'
Oct 24 21:02:00 ip-10-40-0-99 logstash[15520]: 2172 /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'
Oct 24 21:02:00 ip-10-40-0-99 logstash[15520]: 2172 tz:
Oct 24 21:02:00 ip-10-40-0-99 logstash[15520]: 2172 ENV['TZ']:
Oct 24 21:02:00 ip-10-40-0-99 logstash[15520]: 2172 Time.now: 2019-10-24 21:02:00 +0900

```

our pipeline config looks like

```auto
        jdbc_driver_library => "/home/ubuntu/ojdbc6.jar"
        jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"

```

OS Info

```auto
$ lsb_release -a
No LSB modules are available.
Distributor ID:	Ubuntu
Description:	Ubuntu 16.04.5 LTS
Release:	16.04
Codename:	xenial

```

JDK info

```auto
$ java -version
java version "1.8.0_121"
Java(TM) SE Runtime Environment (build 1.8.0_121-b13)
Java HotSpot(TM) 64-Bit Server VM (build 25.121-b13, mixed mode)

```

**It was fine when running Logstash 6.8.2 and 6.8.3 with jdbc-input-plugin 4.3.13.**  
So I guess something wrong with the Driver loading modification for jdbc-input-plugin 4.3.14. and 4.3.15 release

A workaround for us is to not using jdbc\_driver\_library but place the ojdbc6.jar in logstash-core lib path

> install -C -m 644 -o logstash -g logstash /home/ubuntu/ojdbc6.jar /usr/share/logstash/logstash-core/lib/jars

---

<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:** [November 22, 2019, 5:00am UTC](https://discuss.elastic.co/t/unable-to-find-driver-class-when-use-jdbc-driver-library-home-ubuntu-ojdbc6-jar-after-upgrade-to-logstash-6-8-4/205182/2 "2019-11-22T05:00:53Z")

</div>

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