# Logstash jdbc - Exception Access Violation jvm.dll **URL:** \ **Category:** Logstash\ **Created:** [May 18, 2017, 10:00am UTC](https://discuss.elastic.co/t/logstash-jdbc-exception-access-violation-jvm-dll/86224 "2017-05-18T10:00:44Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Alexis\_HONORAT](https://avatars.discourse-cdn.com/v4/letter/a/e79b87/32.png) [@Alexis\_HONORAT](https://discuss.elastic.co/u/Alexis_HONORAT)\ **Post date:** [May 18, 2017, 10:00am UTC](https://discuss.elastic.co/t/logstash-jdbc-exception-access-violation-jvm-dll/86224/1 "2017-05-18T10:00:44Z")
Hello, I'm very new to all this Elasticsearch and logstash stuff. I'm trying to import my SQLServer Database to Elastic Search, and i don't understand well how Logstash work. I found that's i need to use the jdbc plugin. So i tried something like this : > ``` > input { > jdbc { > jdbc_driver_library => "C:\Users\ **** \Documents\sqljdbc_6.0\enu\jre8\sqljdbc42.jar" > jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver" > jdbc_connection_string => "jdbc:sqlserver://127.0.0.1:61672;databasename=[DB];integratedSecurity=true;" > jdbc_user => " ****" > jdbc_password => " ****" > statement => "SELECT * FROM [DB].Tables" > } > } > filter { > } > output { > elasticsearch { > hosts => "localhost" > index => "index" > document_type => "document" > document_id => "%{id}" > } > stdout { codec => rubydebug } > } > > ``` I'm using Jdk 8, elasticsearch 5.4.0 and logstash 5.4.0 But i get the following Error : > ``` > # > # A fatal error has been detected by the Java Runtime Environment: > # > # EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x000000006c1af2f5, pid=10552, tid=0x0000000000001380 > # > # JRE version: Java(TM) SE Runtime Environment (8.0_131-b11) (build 1.8.0_131-b11) > # Java VM: Java HotSpot(TM) 64-Bit Server VM (25.131-b11 mixed mode windows-amd64 compressed oops) > # Problematic frame: > # V [jvm.dll+0x13f2f5] > # > # Failed to write core dump. Minidumps are not enabled by default on client versions of Windows > # > # An error report file with more information is saved as: > # C:\Users\lxi\Documents\BigData\logstash-5.4.0\hs_err_pid10552.log > # > # If you would like to submit a bug report, please visit: > # http://bugreport.java.com/bugreport/crash.jsp > # > > ``` after some logstash logs : > ``` > Could not find log4j2 configuration at path /Users/***/Documents/logstash-5.4.0/config/log4j2.properties. Using default config which logs to console > 11:29:20.802 [main] WARN logstash.runner - --config.debug was specified, but log.level was not set to 'debug'! No config info will be logged. > 11:29:21.822 [[main]-pipeline-manager] INFO logstash.outputs.elasticsearch - Elasticsearch pool URLs updated {:changes=>{:removed=>[], :added=>[http://localhost:9200/]}} > 11:29:21.824 [[main]-pipeline-manager] INFO logstash.outputs.elasticsearch - Running health check to see if an Elasticsearch connection is working {:healthcheck_url=>http://localhost:9200/, :path=>"/"} > 11:29:21.974 [[main]-pipeline-manager] WARN logstash.outputs.elasticsearch - Restored connection to ES instance {:url=>#} > 11:29:21.976 [[main]-pipeline-manager] INFO logstash.outputs.elasticsearch - Using mapping template from {:path=>nil} > 11:29:22.273 [[main]-pipeline-manager] INFO logstash.outputs.elasticsearch - Attempting to install template {:manage_template=>{"template"=>"logstash-*", "version"=>50001, "settings"=>{"index.refresh_interval"=>"5s"}, "mappings"=>{"_default_"=>{"_all"=>{"enabled"=>true, > "norms"=>false}, "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"}}}}}], "properties"=>{"@timestamp"=>{"type"=>"date", "include_in_all"=>false}, "@version"=>{"type"=>"keyword", "include_in_all"=>false}, "geoip"=>{"dynamic"=>true, "properties"=>{"ip"=>{"type"=>"ip"}, "location"=>{"type"=>"geo_po > int"}, "latitude"=>{"type"=>"half_float"}, "longitude"=>{"type"=>"half_float"}}}}}}}} > 11:29:22.282 [[main]-pipeline-manager] INFO logstash.outputs.elasticsearch - New Elasticsearch output {:class=>"LogStash::Outputs::ElasticSearch", :hosts=>[#]} > 11:29:22.287 [[main]-pipeline-manager] INFO logstash.pipeline - Starting pipeline {"id"=>"main", "pipeline.workers"=>4, "pipeline.batch.size"=>125, "pipeline.batch.delay"=>5, "pipeline.max_inflight"=>500} > > ``` Looks like a compatibility problem with jvm.dll but i don't know so much in Java or logstash. I don't know if this is the good topic to post. Thanks in advance. ---
**Author:** ![guyboertje](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/guyboertje/32/31592_2.png) [@guyboertje](https://discuss.elastic.co/u/guyboertje)\ **Post date:** [May 19, 2017, 3:11pm UTC](https://discuss.elastic.co/t/logstash-jdbc-exception-access-violation-jvm-dll/86224/2 "2017-05-19T15:11:06Z")
With MSSQL Server integrated security you need to make sure that java can find sqljdbc\_auth.dll See section 'Connecting with Integrated Authentication On Windows': [https://docs.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url](https://docs.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url) If you can't copy the sqljdbc\_auth.dll then use LS\_JAVA\_OPTS to set the `-Djava.library.path=C:\Microsoft JDBC Driver 4.0 for SQL Server\sqljdbc_\enu\auth\x86` ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [June 16, 2017, 3:11pm UTC](https://discuss.elastic.co/t/logstash-jdbc-exception-access-violation-jvm-dll/86224/3 "2017-06-16T15:11:24Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.