# Jdbcstreaming logstash filter plugin - parameters option is not working

**URL:** <https://discuss.elastic.co/t/jdbcstreaming-logstash-filter-plugin-parameters-option-is-not-working/178149>\
**Category:** Logstash\
**Created:** [April 24, 2019, 4:52am UTC](https://discuss.elastic.co/t/jdbcstreaming-logstash-filter-plugin-parameters-option-is-not-working/178149 "2019-04-24T04:52:40Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gomathi\_Meena](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gomathi_meena/32/43086_2.png) [@Gomathi\_Meena](https://discuss.elastic.co/u/Gomathi_Meena)\
**Post date:** [April 24, 2019, 4:52am UTC](https://discuss.elastic.co/t/jdbcstreaming-logstash-filter-plugin-parameters-option-is-not-working/178149/1 "2019-04-24T04:52:41Z")

</div>

Hi ,  
I have a data in MySQL .So using Jdbc\_streaming filter i can able to filter and parse to elastic search. While configuring the options for Jdbc\_streaming filter , **parameters option** is not working for me . What was the mistake i did in the config file ??  
Here the config for the filter plugin :

```
    jdbc_streaming {
    jdbc_connection_string => "jdbc:mysql://localhost:3306/smack" 
    jdbc_user => "root"
    jdbc_password => "smack"
    jdbc_driver_library => "/home/gomathi/Downloads/com.mysql.jdbc_5.1.5.jar"
    jdbc_driver_class => "com.mysql.jdbc.Driver"
    statement => "SELECT * FROM student where rollnumber = :Rollnumber"
    parameters => {"Rollnumber" => 130}
    target => "target"
    }

```

**output:**

output with empty target and tagged as defaultused

```
{
          "tags" => [
        [0] "_jdbcstreamingdefaultsused"
    ],
      "@version" => "1",
    "@timestamp" => 2019-04-24T04:57:44.376Z,
        "target" => [
        [0] {}
    ]
}

```

**platform :**  
os : ubuntu 18.04  
logstash\_version : 6.7.1

**Thanks in advance.**

---

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [April 24, 2019, 2:13pm UTC](https://discuss.elastic.co/t/jdbcstreaming-logstash-filter-plugin-parameters-option-is-not-working/178149/2 "2019-04-24T14:13:54Z")

</div>

That is telling you the query returned an empty result set. That does not mean that the parameters option is not working.

---

<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:** [May 22, 2019, 2:13pm UTC](https://discuss.elastic.co/t/jdbcstreaming-logstash-filter-plugin-parameters-option-is-not-working/178149/3 "2019-05-22T14:13:58Z")

</div>

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