CODEWITHSUNDEEP
oracle-databaseelasticsearchkibanaojdbclogstash-jdbc
Emre Sts
Emre Sts

Reputation: 95

Logstash Oracle JDBC (Failed to load ojdbc8.jar)

I configure logstash connection for oracle but not working.

Error: failed to load c:\ojdbc8.jar

Do you have any solution for this situation?

input {
  jdbc {
    jdbc_connection_string => "jdbc:oracle:thin:@192.168.10.10:1521/TESTDB"
    jdbc_user => "SCOTT"
    jdbc_password => "TIGER"
    #jdbc_validate_connection => true
    jdbc_driver_library => "C:\ojdbc8.jar"
    jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
    statement => "SELECT * FROM SALES_DATA_SAMPLE"

 }
}

output {
  elasticsearch {
    index => "salesdata"
    document_type => "salesdata"
    document_id => "%{uid}"
    hosts => "localhost:9200"
  }
}

Upvotes: 2

Views: 3226

Answers (1)

Shrikant Wandhare
Shrikant Wandhare

Reputation: 2971

It's just a work around. Just copy the driver Jar file to /logstash-core/lib/jars/ directory.

Upvotes: 8

Related Questions