Hi All
Does Logstash JDBC plugin ONLY support certain JDBC drivers - and that is fixed in code somehow.
Using an input configuration for Mysql - I get past an error relating to no suitable driver - but I am
trying to use a Progress openedge type 4 jdbc driver (We use same with our Java applications) and
I get no suitable driver.
So the below has the correct type 4 driver jar, correct Class name, correct URL.
It looks like either the plugin does not register the library or does not understand the jdbc_connection_string - regardless of what I do.
So I wondered if the plugin was actually coded to look for only specific types of jdbc URL etc.
e.g.
input {
jdbc {
id => "pro114"
jdbc_connection_string => "jdbc:datadirect:openedge://localhost:1111;databaseName=hr;EncryptionMethod=ssl;validateServerCertificate=true"
jdbc_user => "USER"
jdbc_password => "PASSWORD"
jdbc_driver_library => "/usr/share/logstash/jar/openedge.jar"
jdbc_driver_class => "com.ddtek.jdbc.openedge.OpenEdgeDriver"
#schedule => "*/1 * * * *"
statement => "SELECT * from pub.opgohead;"
}
}