# Logstash jdbc plugin for mssql crashes

**URL:** <https://discuss.elastic.co/t/logstash-jdbc-plugin-for-mssql-crashes/119644>\
**Category:** Logstash\
**Created:** [February 13, 2018, 1:19pm UTC](https://discuss.elastic.co/t/logstash-jdbc-plugin-for-mssql-crashes/119644 "2018-02-13T13:19:23Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jtkkex](https://avatars.discourse-cdn.com/v4/letter/j/f07891/32.png) [@jtkkex](https://discuss.elastic.co/u/jtkkex)\
**Post date:** [February 13, 2018, 1:19pm UTC](https://discuss.elastic.co/t/logstash-jdbc-plugin-for-mssql-crashes/119644/1 "2018-02-13T13:19:23Z")

</div>

hi,

I have a problem. I try to use jdbc plugin for connecting to a remote MS SQL server. For some reason, the input plugin just crashes/stops without any debugging info. Debugging is configured in the logstash.yml file and other plugins debug nicely.

I have tried with the driver from Microsoft, both versions 6.0 and 4.2, but both produce the same result. I have no idea on what to try next, as I don't get any error messages.

logstash version: 5.6.7

Here the configuration snippet:

```
input {
      jdbc {
           jdbc_driver_library => "/etc/logstash/driver/sqljdbc_4.2/enu/jre8/sqljdbc42.jar"
           jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
           jdbc_connection_string => "jdbc:sqlserver://myserver:1433;databaseName=mydatabase"
           jdbc_user => "myuser"
           jdbc_password => "mypass"
           jdbc_validate_connection => true
           statement => "SELECT * FROM mytable"
           sql_log_level => "debug"
           schedule => "* * * * *"
           connection_retry_attempts_wait_time => 60
           connection_retry_attempts => 99999999
           jdbc_fetch_size => 50000
           last_run_metadata_path => ".logstash_jdbc_last_run"
  }
}

```

My java version:

```
java version "1.8.0_161"
Java(TM) SE Runtime Environment (build 1.8.0_161-b12)
Java HotSpot(TM) 64-Bit Server VM (build 25.161-b12, mixed mode)
```

---

<div class="post-metadata">

**Author:** ![jtkkex](https://avatars.discourse-cdn.com/v4/letter/j/f07891/32.png) [@jtkkex](https://discuss.elastic.co/u/jtkkex)\
**Post date:** [February 13, 2018, 1:42pm UTC](https://discuss.elastic.co/t/logstash-jdbc-plugin-for-mssql-crashes/119644/2 "2018-02-13T13:42:16Z")

</div>

I noticed an error in the driver file path. So sorry about the unnecessary post - now I get a real error message and can get forward.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [March 13, 2018, 1:42pm UTC](https://discuss.elastic.co/t/logstash-jdbc-plugin-for-mssql-crashes/119644/3 "2018-03-13T13:42:25Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.