Hi all,
We have a logstash pipeline which is configured to collect data from Vertica Analytic v9.0.1-20190201 (https://www.vertica.com/)... it all worked well with the logstash version 7.4. with the configureation
jdbc {
jdbc_validate_connection => true
jdbc_connection_string => "jdbc:vertica://xx.xx.xx.xx:5433/myDB"
jdbc_user => "xxxx"
jdbc_password => "xxxx"
jdbc_driver_library => "/opt/vertica/java/lib/vertica-jdbc-9.3.0-0.jar"
jdbc_driver_class => "com.vertica.jdbc.Driver"
statement => "SELECT * FROM FOO WHERE event_start > TIMESTAMPADD (n, -15, CURRENT_TIMESTAMP);"
}
But since we upgraded to version 7.5 we are getting errors:
Unable to find driver class via URLClassLoader in given driver jcom.vertica.jdbc.Driver and com.vertica.jdbc.Driver
Any Idea how can we solve this?