# My JDBC SQL statement have both single (') and double (") quote, how do i supply it in JDBC input plugin?

**URL:** <https://discuss.elastic.co/t/my-jdbc-sql-statement-have-both-single-and-double-quote-how-do-i-supply-it-in-jdbc-input-plugin/118396>\
**Category:** Logstash\
**Created:** [February 5, 2018, 7:20am UTC](https://discuss.elastic.co/t/my-jdbc-sql-statement-have-both-single-and-double-quote-how-do-i-supply-it-in-jdbc-input-plugin/118396 "2018-02-05T07:20:55Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Somnath\_Pal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/somnath_pal/32/11420_2.png) [@Somnath\_Pal](https://discuss.elastic.co/u/Somnath_Pal)\
**Post date:** [February 5, 2018, 7:20am UTC](https://discuss.elastic.co/t/my-jdbc-sql-statement-have-both-single-and-double-quote-how-do-i-supply-it-in-jdbc-input-plugin/118396/1 "2018-02-05T07:20:55Z")

</div>

**My input looks like**

input {  
jdbc {  
jdbc\_connection\_string =\> "jdbc:redshift://infa-iidiq-cluster-qa1.ctd4xsffelb3.us-west-2.redshift.amazonaws.com:5439/iidiqdatabase"  
jdbc\_user =\> ""  
jdbc\_password =\> ""  
jdbc\_validate\_connection =\> true  
jdbc\_driver\_library =\> "RedshiftJDBC42-1.2.10.1009.jar"  
jdbc\_driver\_class =\> "com.amazon.redshift.jdbc42.Driver"  
schedule =\> "\*/3 \* \* \* \*"  
statement =\> 'SELECT log\_entry\_id, CASE WHEN task\_status = 'SUCCESS' THEN 'INFO' WHEN task\_status = 'FAILED' THEN 'ERROR' WHEN task\_status = 'WARNINGS' THEN 'WARN' END AS "log\_level", 'activity' AS "log\_type" FROM xyz.abc WHERE tracking\_col \>:sql\_last\_value ORDER BY tracking\_col ASC'  
use\_column\_value =\> true  
tracking\_column =\> tracking\_col  
last\_run\_metadata\_path =\> "metadata/logstash\_jdbc\_last\_run"  
}  
}

But due to usage of both " and ' plugin throwing error.

**My SQL statement**  
SELECT log\_entry\_id,  
CASE  
WHEN task\_status = 'SUCCESS'  
THEN 'INFO'  
WHEN task\_status = 'FAILED'  
THEN 'ERROR'  
WHEN task\_status = 'WARNINGS'  
THEN 'WARN'  
END AS "log\_level",  
'activity' AS "log\_type"  
FROM xyz.abc  
WHERE tracking\_col \>:sql\_last\_value  
ORDER BY tracking\_col ASC

Any help will be appreciated.

---

<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:** [February 5, 2018, 7:37am UTC](https://discuss.elastic.co/t/my-jdbc-sql-statement-have-both-single-and-double-quote-how-do-i-supply-it-in-jdbc-input-plugin/118396/2 "2018-02-05T07:37:27Z")

</div>

Do you really need to mix single and double quotes in this case? Anyway, Logstash fairly recently introduced escape sequence support for the pipeline config files but it must be explicitly enabled. See [https://www.elastic.co/guide/en/logstash/current/configuration-file-structure.html#\_escape\_sequences](https://www.elastic.co/guide/en/logstash/current/configuration-file-structure.html#_escape_sequences).

---

<div class="post-metadata">

**Author:** ![Somnath\_Pal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/somnath_pal/32/11420_2.png) [@Somnath\_Pal](https://discuss.elastic.co/u/Somnath_Pal)\
**Post date:** [February 5, 2018, 10:05am UTC](https://discuss.elastic.co/t/my-jdbc-sql-statement-have-both-single-and-double-quote-how-do-i-supply-it-in-jdbc-input-plugin/118396/3 "2018-02-05T10:05:26Z")

</div>

Thanks for the quick solution, let me try and validate

---

<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:** [March 5, 2018, 10:05am UTC](https://discuss.elastic.co/t/my-jdbc-sql-statement-have-both-single-and-double-quote-how-do-i-supply-it-in-jdbc-input-plugin/118396/4 "2018-03-05T10:05:49Z")

</div>

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