# JDBC Library Logstash 7.0.0 **URL:** \ **Category:** Logstash\ **Created:** [April 24, 2019, 5:11pm UTC](https://discuss.elastic.co/t/jdbc-library-logstash-7-0-0/178304 "2019-04-24T17:11:56Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Carlos\_Rojas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/carlos_rojas/32/44753_2.png) [@Carlos\_Rojas](https://discuss.elastic.co/u/Carlos_Rojas)\ **Post date:** [April 24, 2019, 5:11pm UTC](https://discuss.elastic.co/t/jdbc-library-logstash-7-0-0/178304/1 "2019-04-24T17:11:56Z")
HI, i'm using logstash-input-jdbc, and this is installed correctly > Step 3/4 : RUN logstash-plugin install logstash-input-jdbc > ---\> Running in 3fd593a57661 > Validating logstash-input-jdbc > Installing logstash-input-jdbc > Installation successful > ---\> ded53e175008 After that, i configure my pipeline and copy the lib jdbc { jdbc\_driver\_library =\> "/usr/share/logstash/lib/ext/ojdbc6.jar" jdbc\_driver\_class =\> "Java::oracle.jdbc.OracleDriver" jdbc\_connection\_string =\> "jdbc:oracle:thin:@10.0.0.119:1521:oradb" jdbc\_user =\> "ICBSBAVV\_EC78" jdbc\_password =\> "ICBSBAVV\_EC78" statement =\> "select ID, DATA from FM\_FILE\_LOB where ID \>:sql\_last\_value and IS\_GENERATED = 1" use\_column\_value =\> true tracking\_column =\> id schedule =\> "\*/5 \* \* \* \* \*" last\_run\_metadata\_path =\> "/home/litr0x/docker/docker-nrtp-icbs/jdbc\_last\_run/metadata" } I check, the lib/plugin inside the machine is ok: ![error](https://us1.discourse-cdn.com/elastic/original/3X/4/c/4c7b65b0ff99d6b351d211ad364aae0e9a891b2e.jpeg) but the errors still ocurrs: logstash\_1 | 2076 LogStash::ConfigurationError logstash\_1 | 2076 Java::oracle.jdbc.OracleDriver not loaded. Are you sure you've included the correct jdbc driver in :jdbc\_driver\_library? logstash\_1 | 2076 /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' logstash_1 | 2076 /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' logstash\_1 | 2076 /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' logstash_1 | 2076 /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' logstash\_1 | 2076 /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/rufus-scheduler-3.0.9/lib/rufus/scheduler/jobs.rb:234:in `do_call' logstash_1 | 2076 /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/rufus-scheduler-3.0.9/lib/rufus/scheduler/jobs.rb:258:in `do\_trigger' logstash\_1 | 2076 /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' logstash_1 | 2076 /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' logstash\_1 | 2076 org/jruby/RubyKernel.java:1411:in `loop' logstash_1 | 2076 /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' logstash\_1 | 2076 tz: ---
**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\ **Post date:** [April 24, 2019, 6:44pm UTC](https://discuss.elastic.co/t/jdbc-library-logstash-7-0-0/178304/2 "2019-04-24T18:44:46Z")
Does this help?... ``` sudo chmod o+r /usr/share/logstash/lib/ext/ojdbc6.jar ``` ---
**Author:** ![Carlos\_Rojas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/carlos_rojas/32/44753_2.png) [@Carlos\_Rojas](https://discuss.elastic.co/u/Carlos_Rojas)\ **Post date:** [April 24, 2019, 6:56pm UTC](https://discuss.elastic.co/t/jdbc-library-logstash-7-0-0/178304/3 "2019-04-24T18:56:26Z")
Hi Badger the lib have 777.. ---
**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\ **Post date:** [April 24, 2019, 6:57pm UTC](https://discuss.elastic.co/t/jdbc-library-logstash-7-0-0/178304/4 "2019-04-24T18:57:11Z")
Your image shows it has mode 771. ---
**Author:** ![Carlos\_Rojas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/carlos_rojas/32/44753_2.png) [@Carlos\_Rojas](https://discuss.elastic.co/u/Carlos_Rojas)\ **Post date:** [April 24, 2019, 6:58pm UTC](https://discuss.elastic.co/t/jdbc-library-logstash-7-0-0/178304/5 "2019-04-24T18:58:40Z")
today now 777 sorry, for my mistake ---
**Author:** ![Carlos\_Rojas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/carlos_rojas/32/44753_2.png) [@Carlos\_Rojas](https://discuss.elastic.co/u/Carlos_Rojas)\ **Post date:** [April 24, 2019, 6:59pm UTC](https://discuss.elastic.co/t/jdbc-library-logstash-7-0-0/178304/6 "2019-04-24T18:59:14Z")
-rwxrwxrwx 1 litr0x litr0x 2714189 abr 23 11:23 ojdbc6.jar ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [May 22, 2019, 7:02pm UTC](https://discuss.elastic.co/t/jdbc-library-logstash-7-0-0/178304/7 "2019-05-22T19:02:54Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.