# Jdbc\_streaming filter parameters not working

**URL:** <https://discuss.elastic.co/t/jdbc-streaming-filter-parameters-not-working/147814>\
**Category:** Logstash\
**Created:** [September 8, 2018, 12:29pm UTC](https://discuss.elastic.co/t/jdbc-streaming-filter-parameters-not-working/147814 "2018-09-08T12:29:38Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Muhammed\_Aboobacker](https://avatars.discourse-cdn.com/v4/letter/m/cdc98d/32.png) [@Muhammed\_Aboobacker](https://discuss.elastic.co/u/Muhammed_Aboobacker)\
**Post date:** [September 8, 2018, 12:29pm UTC](https://discuss.elastic.co/t/jdbc-streaming-filter-parameters-not-working/147814/1 "2018-09-08T12:29:39Z")

</div>

Hi I am unable to use jdbc\_streaming filter parameters in the query.

```
	jdbc_streaming {
		jdbc_driver_library => "/home/titech/Desktop/jar/mysql-connector-java-5.1.46.jar"
		jdbc_driver_class => "com.mysql.jdbc.Driver"
		jdbc_connection_string => "jdbc:mysql://localhost:3306/sys"
		jdbc_user => "root"
		jdbc_password => "titech!@#"
		parameters => { "auditId" => 26}
		statement => "SELECT * FROM sys.rcyc_audit where audit_id= :auditId ;" 		
		target => "port_update_audit_id"
	}

```

Actual value for auditId is coming from event but since it was not working, for debugging, I hardcoded the value 26, even then it is not taking the value.

when I run the sql query `"SELECT * FROM sys.rcyc_audit where audit_id=26;"` directly it is working.  
but when I use parameter it throws exceptions `[0] "_jdbcstreamingdefaultsused"`

Please advice.

---

<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:** [October 6, 2018, 12:29pm UTC](https://discuss.elastic.co/t/jdbc-streaming-filter-parameters-not-working/147814/2 "2018-10-06T12:29:44Z")

</div>

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