Loading SQL Server data using Logstash

Elastic Stack Logstash
2

Hello Sunil,

I am using Oracle instead of SQL Server but the config should be similar, so here is my working configuration:

input {
	jdbc {
		jdbc_driver_library => "/home/tomcat/logstash/ojdbc6-12.1.0.2.jar"
		jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
		jdbc_connection_string => "..."
		jdbc_user => "..."
		jdbc_password => "..."
		jdbc_validate_connection => true
		schedule => "* * * * *"
		statement => "..."
		tracking_column => "id"
		use_column_value => true
		last_run_metadata_path => "..."
	}
}

As you see, I have used the full path in jdbc_driver_library and the jdbc_driver_class is prefixed with Java:: as described here:

Per Error: oracle.jdbc.driver.OracleDriver not loaded. · Issue #43 · logstash-plugins/logstash-input-jdbc · GitHub, prepending Java:: to the driver class may be required if it appears that the driver is not being loaded correctly despite relevant jar(s) being provided by either via the jdbc_driver_library setting or being placed in the Logstash Java classpath. This is known to be the case for the Oracle JDBC driver (ojdbc6.jar), where the correct jdbc_driver_class is "Java::oracle.jdbc.driver.OracleDriver" , and may also be the case for other JDBC drivers.

Can you try that?

Best regards
Wolfram

1 Like