Logstash input jdbc

Elastic Stack Logstash
1

file: contacts-index-logstash.conf

input {
jdbc {
jdbc_connection_string => "jdbc:oracle:thin:@//192.168.54.74:1521/od6oracle"
jdbc_user => "od6oracle"
jdbc_password => "od6oracle"
jdbc_validate_connection => true
jdbc_driver_library => "C:\Users\vikas.saini\Desktop\easy search\ojdbc7.jar"
jdbc_driver_class => "java::oracle.jdbc.OracleDriver"
statement => "SELECT * from PDBDOCUMENT"
}
}
output {
elasticsearch {
index => "contacts"
document_type => "contact"
document_id => "%{uid}"
hosts => "127.0.0.1:9200"
}
}

my conf file .i am using LS 2.0.0
and i am having following error
Error: java::oracle.jdbc.OracleDriver not loaded. Are you sure you've included
the correct jdbc driver in :jdbc_driver_library?
You may be interested in the '--configtest' flag which you can
use to validate logstash's configuration before you choose
to restart a running system.

2

This was reported several time, so the doc was updated at https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html#plugins-inputs-jdbc-jdbc_driver_class

[quote]
If you are using the Oracle JDBC driver (ojdbc6.jar) the correct jdbc_driver_class is "Java::oracle.jdbc.driver.OracleDriver"[/quote]

I suppose the uppercase J is important here

3

thankyou so much :slight_smile:

4

thanks !