# Jdbc\_streaming statement using a field from input?
**URL:** https://discuss.elastic.co/t/jdbc-streaming-statement-using-a-field-from-input/312537
**Category:** Logstash
**Created:** [August 21, 2022, 2:55am UTC](https://discuss.elastic.co/t/jdbc-streaming-statement-using-a-field-from-input/312537 "2022-08-21T02:55:34Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@deep08](https://discuss.elastic.co/u/deep08)
#### Post date: [August 21, 2022, 2:55am UTC](https://discuss.elastic.co/t/jdbc-streaming-statement-using-a-field-from-input/312537/1 "2022-08-21T02:55:34Z")
Hello ,
I have a jdbc\_streaming filter and I want to pass statement as a field value from input . I tried different ways to inject field value in statement but always seeing
_"exception":"Java::JavaSql::SQLSyntaxErrorException: ORA-00900: invalid SQL statement\n"_
filter {
jdbc\_streaming {
jdbc\_driver\_library =\> "C:/Software/ojdbc8-21.5.0.0.jar"
jdbc\_driver\_class =\> "Java::oracle.jdbc.driverOracleDriver"
jdbc\_connection\_string =\> "jdbc:oracle:thin:@[//00.0.00.000:1521/DV1](https://00.0.00.000:1521/DV1)"
jdbc\_user =\> "DB"
jdbc\_password =\> "pass"
statement =\> ":str"
parameters =\> { "str" =\> "myQuery"}
target =\> "terminal\_map"
default\_hash =\> {
terminal\_map =\> ""
}
}
}
Also tried : statement =\> ["[myQuery]"] , statement =\> ["myQuery"]
SQL query is valid but looks like I am not able to place it in statement tag..
Any help is greatly appreciated!
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [September 18, 2022, 2:56am UTC](https://discuss.elastic.co/t/jdbc-streaming-statement-using-a-field-from-input/312537/2 "2022-09-18T02:56:34Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.