Hello,
I fail to connect my logstash v5.6.0 to an Oracle 12c database. I tried both ojdbc6.jar and ojdbc7.jar
I checked that the jdbc_driver_class is Java::oracle.jdbc.driver.OracleDriver (with uppercase "J")
I am running on a CentOS 7.3.1611
Here is the jdbc input config:
jdbc {
jdbc_driver_library => "ojdbc7.jar"
jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
jdbc_connection_string => "jdbc:oracle:thin:@//stardb:1521/GLX"
jdbc_user => "usr"
jdbc_password => "pwd"
schedule => "* * * * *"
statement => "select sysdate from dual"
last_run_metadata_path => "jdbc_metadata.data"
type => "glx_audit"
}
And an extract of the log files:
Sep 24 20:14:00 JLD logstash: 218952 Java::oracle.jdbc.driver.OracleDriver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
Sep 24 20:14:00 JLD logstash: 218952 /usr/share/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-4.2.4/lib/logstash/plugin_mixins/jdbc.rb:157:in `open_jdbc_connection'
Can someone help on this issue?
Many thanks