# Jdbc-streaming plugin seems not working

**URL:** <https://discuss.elastic.co/t/jdbc-streaming-plugin-seems-not-working/85530>\
**Category:** Logstash\
**Created:** [May 12, 2017, 9:27am UTC](https://discuss.elastic.co/t/jdbc-streaming-plugin-seems-not-working/85530 "2017-05-12T09:27:47Z")\
**Posts on this page:** 5\
**Page:** 3

<div class="post-metadata">

**Author:** ![nano](https://avatars.discourse-cdn.com/v4/letter/n/dec6dc/32.png) [@nano](https://discuss.elastic.co/u/nano)\
**Post date:** [May 19, 2017, 9:56am UTC](https://discuss.elastic.co/t/jdbc-streaming-plugin-seems-not-working/85530/43 "2017-05-19T09:56:01Z")

</div>

jdbc\_streaming {  
jdbc\_driver\_library =\> ".............."  
jdbc\_driver\_class =\> "................."  
jdbc\_connection\_string =\> "............."  
jdbc\_user =\> "........"  
jdbc\_password =\> "........"  
statement =\> "SELECT `field5` From database2 where field4 =:..."  
parameters =\> {...=\>"field2"}  
target =\> "code"  
use\_cache =\> "true"  
cache\_expiration =\> "5"  
cache\_size =\> "100"

}  
i make this configuration but still confused about field2val

---

<div class="post-metadata">

**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, 9:59am UTC](https://discuss.elastic.co/t/jdbc-streaming-plugin-seems-not-working/85530/44 "2017-05-19T09:59:26Z")

</div>

Yes you can not use the word `field2val` in the query string. But you still have to provide a parameters mapping - this is because we do not "parse" the query string to extract the possible field names to use.  
Consider this:

```auto
statement => "select field5 from database2 where field 4 = :field2 and field6 LIKE :like3"
parameters => {"field2" => "field2", "like3" => "%{[field3]}%" }

```

---

<div class="post-metadata">

**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, 10:06am UTC](https://discuss.elastic.co/t/jdbc-streaming-plugin-seems-not-working/85530/45 "2017-05-19T10:06:00Z")

</div>

This thread from @Vittorio has been hijacked by @Dror_Bletter and @nano (chaps, in future start a new discussion and link back to this one)

@Dror_Bletter  
Please start a new discussion about your useragent trouble so we can better help you with that. Then we can move back to the jdbc streaming trouble.

---

<div class="post-metadata">

**Author:** ![Dror\_Bletter](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dror_bletter/32/18339_2.png) [@Dror\_Bletter](https://discuss.elastic.co/u/Dror_Bletter)\
**Post date:** [May 24, 2017, 10:19am UTC](https://discuss.elastic.co/t/jdbc-streaming-plugin-seems-not-working/85530/47 "2017-05-24T10:19:08Z")

</div>

Hi!

FYI -  
I solved the problem by placing the jdbc\_streaming in the right place in the logstash configuration (and not on top).

Thanks for all your help!

---

<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:** [June 21, 2017, 10:20am UTC](https://discuss.elastic.co/t/jdbc-streaming-plugin-seems-not-working/85530/48 "2017-06-21T10:20:10Z")

</div>

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

[Previous page](https://discuss.elastic.co/t/jdbc-streaming-plugin-seems-not-working/85530.md?page=2)