Error: Unable to find driver class via URLClassLoader in given driver jars

Elastic Stack Logstash
1

Hello,
I am trying run config file using logstash. It is giving below error:

Error: Unable to find driver class via URLClassLoader in given driver jars:
Java::oracle.jdbc.driver.OracleDriver and Java::oracle.jdbc.driver.OracleDriver
Exception: LogStash::PluginLoadingError

My logstash config file look like:

input {
jdbc {
jdbc_driver_library => "E:\oracle\product\12.2.0\client_1\jdbc\ojdbc8.jar"
jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
jdbc_connection_string => "connection_string_with_hostname_and_password"
jdbc_user => "username"
jdbc_password => "******"
jdbc_fetch_size => "10000"
statement_filepath => "path for sql file statement"
last_run_metadata_path => "E:/usr/share/logstash/last_run_metadata/.query.sql"
}
}
filter{
mutate{
convert=> {
contentid=>"string"
}
}
}
output{
elasticsearch {
hosts => "localhost:9200"
index => "new_database"
}
}

Regards,
Priyanka

2

I had similar issue, but with postgres driver. I moved driver to $LOGSTASH_HOME/logstash-core/lib/jars and commented out jdbc_driver_library

3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.