# How can i install jdbc\_streaming filter plugin

**URL:** <https://discuss.elastic.co/t/how-can-i-install-jdbc-streaming-filter-plugin/97526>\
**Category:** Logstash\
**Created:** [August 18, 2017, 8:10am UTC](https://discuss.elastic.co/t/how-can-i-install-jdbc-streaming-filter-plugin/97526 "2017-08-18T08:10:28Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![LiangxiongZhu](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/liangxiongzhu/32/21249_2.png) [@LiangxiongZhu](https://discuss.elastic.co/u/LiangxiongZhu)\
**Post date:** [August 18, 2017, 8:10am UTC](https://discuss.elastic.co/t/how-can-i-install-jdbc-streaming-filter-plugin/97526/1 "2017-08-18T08:10:28Z")

</div>

i want to use jdbc\_streaming filter plugin, but i get error, "Cannot create pipeline" reason: Couldn't find any filter plugin named 'jdbc\_streaming'.  
then i tried logstash-plugin install jdbc\_streaming. the result of Validating jdbc\_streaming is Plugin jdbc\_streaming does not exists.

i am using  
windows 10,  
logstash 5.5.1  
and here is my logstash config file

# this configuration file is used to test jdbc\_streaming filter plugin

input {

jdbc {#role  
jdbc\_driver\_library =\> "mssql-jdbc-6.2.1.jre8.jar"  
jdbc\_driver\_class =\> "Java::com.microsoft.sqlserver.jdbc.SQLServerDriver"  
jdbc\_connection\_string =\> "jdbc:sqlserver://dbip:dbport;database=dbname;Application Name=logstash-role"  
jdbc\_user=\>"sa"  
jdbc\_password=\>"yes i am password"  
schedule =\> "0 \* \* \* \* \*"  
lowercase\_column\_names=\>false  
last\_run\_metadata\_path=\>"C:\ElastiscSearch\logstash\ias-conf\last-run-role.txt"  
tracking\_column=\>"PersonId"  
use\_column\_value=\>true   
statement=\>"select top 10 \* from dbo.Tp\_Person where PersonId\>:last\_sql\_value order by PersonId ASC"   
record\_last\_run=\>"true"  
sql\_log\_level=\>"warn"  
type=\>"person"  
}

}

filter{  
jdbc\_streaming {  
jdbc\_driver\_library =\> "mssql-jdbc-6.2.1.jre8.jar"  
jdbc\_driver\_class =\> "Java::com.microsoft.sqlserver.jdbc.SQLServerDriver"  
jdbc\_connection\_string =\> "jdbc:sqlserver://jdbc:sqlserver://dbip:dbport;database=dbname;Application Name=logstash-role"  
jdbc\_user=\>"sa"  
jdbc\_password=\>"yes i am password"  
statement =\> "select \* from dbo.tr\_role where PersonId=:PersonId"  
parameters =\> { "PersonId" =\> "%{PersonId}"}  
target =\> "Roles"  
}  
}

output {  
stdout { codec =\> json }  
file {  
path =\> ["C:\ElastiscSearch\logstash\ias-output\jdbc-log.txt"]  
codec =\> json\_lines  
}   
}

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [August 18, 2017, 8:59am UTC](https://discuss.elastic.co/t/how-can-i-install-jdbc-streaming-filter-plugin/97526/2 "2017-08-18T08:59:53Z")

</div>

> then i tried logstash-plugin install jdbc\_streaming

That's the wrong command. The full name of the plugin to install is logstash-filter-jdbc\_streaming. See [Working with plugins | Logstash Reference [8.11] | Elastic](https://www.elastic.co/guide/en/logstash/current/working-with-plugins.html#installing-plugins).

---

<div class="post-metadata">

**Author:** ![LiangxiongZhu](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/liangxiongzhu/32/21249_2.png) [@LiangxiongZhu](https://discuss.elastic.co/u/LiangxiongZhu)\
**Post date:** [August 18, 2017, 1:09pm UTC](https://discuss.elastic.co/t/how-can-i-install-jdbc-streaming-filter-plugin/97526/3 "2017-08-18T13:09:06Z")

</div>

thanks. this plugin is installed successfully after i use its full name.

---

<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:** [September 15, 2017, 1:09pm UTC](https://discuss.elastic.co/t/how-can-i-install-jdbc-streaming-filter-plugin/97526/4 "2017-09-15T13:09:18Z")

</div>

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