# JDBC input parameters add quotes to query

**URL:** <https://discuss.elastic.co/t/jdbc-input-parameters-add-quotes-to-query/270271>\
**Category:** Logstash\
**Created:** [April 15, 2021, 3:32pm UTC](https://discuss.elastic.co/t/jdbc-input-parameters-add-quotes-to-query/270271 "2021-04-15T15:32:48Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mlnusd](https://avatars.discourse-cdn.com/v4/letter/m/9de0a6/32.png) [@mlnusd](https://discuss.elastic.co/u/mlnusd)\
**Post date:** [April 15, 2021, 3:32pm UTC](https://discuss.elastic.co/t/jdbc-input-parameters-add-quotes-to-query/270271/1 "2021-04-15T15:32:48Z")

</div>

I'm trying to use jdbc input filter to query Oracle DB and to template a schema name. My statement looks like this:

`select count(1) from :schema.my_table`

And my logstash config is like this:

```
input {
   [...connection attributes...]
    jdbc {
        statement => "select count(1) from :schema.my_table"
        parameters => {"schema" => "my_schema"}
    }
}

```

And the the resulting query going to Oracle is like this:

`select count(1) from 'my_schema'.my_table`

So it adds a single quotes to my parameters making my query to fail with "ORA-00903: invalid table name".

How do I get rid of single qoutes added by logstash? Or, at least, to replace it with double quotes instead?

---

<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 13, 2021, 3:32pm UTC](https://discuss.elastic.co/t/jdbc-input-parameters-add-quotes-to-query/270271/2 "2021-05-13T15:32:53Z")

</div>

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