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