I am using logstash-7.4.0 , jdk-11.0.5 and Microsoft JDBC Driver 7.4 for SQL Server.
I am getting an jdbc connection issue . Any idea ?
batch.delay"=>50, "pipeline.max_inflight"=>500, :thread=>"#<Thread:0x2dcedb2a run>"}
[2019-10-21T15:52:48,968][INFO ][logstash.outputs.elasticsearch][main] Attempting to install template {:manage_template=>{"index_patterns"=>"logstash-", "version"=>60001, "settings"=>{"index.refresh_interval"=>"5s", "number_of_shards"=>1}, "mappings"=>{"dynamic_templates"=>[{"message_field"=>{"path_match"=>"message", "match_mapping_type"=>"string", "mapping"=>{"type"=>"text", "norms"=>false}}}, {"string_fields"=>{"match"=>"", "match_mapping_type"=>"string", "mapping"=>{"type"=>"text", "norms"=>false, "fields"=>{"keyword"=>{"type"=>"keyword", "ignore_above"=>256}}}}}], "properties"=>{"@timestamp"=>{"type"=>"date"}, "@version"=>{"type"=>"keyword"}, "geoip"=>{"dynamic"=>true, "properties"=>{"ip"=>{"type"=>"ip"}, "location"=>{"type"=>"geo_point"}, "latitude"=>{"type"=>"half_float"}, "longitude"=>{"type"=>"half_float"}}}}}}}
[2019-10-21T15:52:49,321][INFO ][logstash.javapipeline ][main] Pipeline started {"pipeline.id"=>"main"}
[2019-10-21T15:52:49,422][INFO ][logstash.agent ] Pipelines running {:count=>1, :running_pipelines=>[:main], :non_running_pipelines=>}
[2019-10-21T15:52:49,988][INFO ][logstash.agent ] Successfully started Logstash API endpoint {:port=>9600}
[2019-10-21T15:52:50,109][ERROR][logstash.inputs.jdbc ][main] Failed to load C:\Program Files\sqljdbc_7.4\enu\mssql-jdbc-7.4.1.jre8.jar {:exception=>#<TypeError: failed to coerce jdk.internal.loader.ClassLoaders$AppClassLoader to java.net.URLClassLoader>}
[2019-10-21T15:52:50,180][ERROR][logstash.javapipeline ][main] A plugin had an unrecoverable error. Will restart this plugin.
Pipeline_id:main
Plugin: <LogStash::Inputs::Jdbc jdbc_user=>"ess", jdbc_password=>, statement=>"SELECT * FROM [UsersDB].dbo.[Employee]", jdbc_driver_library=>"C:\Program Files\sqljdbc_7.4\enu\mssql-jdbc-7.4.1.jre8.jar", jdbc_connection_string=>"jdbc:sqlserver://TLTTVMLT123\SQLEXPRESS;user=ess;password=admin123*;", id=>"b9d05cd015a29052bcfc052e5878dcf2e65fe1cb6aa0dbdf98ae9d6ece8bb8bf", jdbc_driver_class=>"com.microsoft.sqlserver.jdbc.SQLServerDriver", enable_metric=>true, codec=><LogStash::Codecs::Plain id=>"plain_9cf811ba-2763-49c1-be3e-af4fa039eece", enable_metric=>true, charset=>"UTF-8">, jdbc_paging_enabled=>false, jdbc_page_size=>100000, jdbc_validate_connection=>false, jdbc_validation_timeout=>3600, jdbc_pool_timeout=>5, sql_log_level=>"info", connection_retry_attempts=>1, connection_retry_attempts_wait_time=>0.5, parameters=>{"sql_last_value"=>1970-01-01 00:00:00 UTC}, last_run_metadata_path=>"C:\Users\User/.logstash_jdbc_last_run", use_column_value=>false, tracking_column_type=>"numeric", clean_run=>false, record_last_run=>true, lowercase_column_names=>true>
Error: com.microsoft.sqlserver.jdbc.SQLServerDriver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
Exception: LogStash::ConfigurationError
Stack: C:/Users/User/Downloads/logstash-7.4.0/logstash-7.4.0/vendor/bundle/jruby/2.5.0/gems/logstash-input-jdbc-4.3.13/lib/logstash/plugin_mixins/jdbc/jdbc.rb:163:in open_jdbc_connection' C:/Users/User/Downloads/logstash-7.4.0/logstash-7.4.0/vendor/bundle/jruby/2.5.0/gems/logstash-input-jdbc-4.3.13/lib/logstash/plugin_mixins/jdbc/jdbc.rb:221:inexecute_statement'
C:/Users/User/Downloads/logstash-7.4.0/logstash-7.4.0/vendor/bundle/jruby/2.5.0/gems/logstash-input-jdbc-4.3.13/lib/logstash/inputs/jdbc.rb:277:in execute_query' C:/Users/User/Downloads/logstash-7.4.0/logstash-7.4.0/vendor/bundle/jruby/2.5.0/gems/logstash-input-jdbc-4.3.13/lib/logstash/inputs/jdbc.rb:263:inrun'
C:/Users/User/Downloads/logstash-7.4.0/logstash-7.4.0/logstash-core/lib/logstash/java_pipeline.rb:314:in inputworker' C:/Users/User/Downloads/logstash-7.4.0/logstash-7.4.0/logstash-core/lib/logstash/java_pipeline.rb:306:inblock in start_input'
[2019-10-21T15:52:51,206][ERROR][logstash.inputs.jdbc ][main] Failed to load C:\Program Files\sqljdbc_7.4\enu\mssql-jdbc-7.4.1.jre8.jar {:exception=>#<TypeError: failed to coerce jdk.internal.loader.ClassLoaders$AppClassLoader to java.net.URLClassLoader>}