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:
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: