# Logstash JDBC Input Issue - Single Quotes

**URL:** <https://discuss.elastic.co/t/logstash-jdbc-input-issue-single-quotes/360882>\
**Category:** Logstash\
**Tags:** jdbc\
**Created:** [June 5, 2024, 8:00pm UTC](https://discuss.elastic.co/t/logstash-jdbc-input-issue-single-quotes/360882 "2024-06-05T20:00:59Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![OscarFilho](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/oscarfilho/32/109740_2.png) [@OscarFilho](https://discuss.elastic.co/u/OscarFilho)\
**Post date:** [June 5, 2024, 8:00pm UTC](https://discuss.elastic.co/t/logstash-jdbc-input-issue-single-quotes/360882/1 "2024-06-05T20:00:59Z")

</div>

I'm using a JDBC input plugin (for sql server connection) in my logstash and having a issue on statement.

The error displayed is:

```auto
Java::ComMicrosoftSqlserverJdbc::SQLServerException: Incorrect syntax near 'ATUALIZADO\'.: SELECT TOP (1) count(*) AS [COUNT] FROM (SELECT CASE WHEN datediff("DAY",last_successful_load,getdate()) = 0 THEN \'ATUALIZADO\' ELSE \'ERRO\' END AS "status" FROM [analytics].[status]) AS [T1]

```

My config on logstash is the follows:

```auto
jdbc {
    jdbc_driver_library => "/opt/jdbc_drivers/sqljdbc_12.6/ptb/jars/mssql-jdbc-12.6.1.jre11.jar" 
    jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
    jdbc_connection_string => "jdbc:sqlserver://teste-xxx.database.windows.net:1433;databaseName=xxx_xCO" 
    jdbc_user => "user_xxx" 
    jdbc_password => "pass_xxx" 
    jdbc_paging_enabled => true
    tracking_column => "unix_ts_in_secs"
    use_column_value => true
    tracking_column_type => "numeric"
    schedule => "* */1 * * * *"
    statement => 'SELECT CASE WHEN datediff("DAY",last_successful_load,getdate()) = 0 THEN \'ATUALIZADO\' ELSE \'ERRO\' END AS "status" FROM [analytics].[status]'
    tags => "xxx"
  }

```

I'm not sure if the single quotes are being escaped.  
When i run the sql on the management studio with only single quotes (not escapes) it works successful.

Can anyone help me with that?

---

<div class="post-metadata">

**Author:** ![Alex\_Salgado-Elastic](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alex_salgado-elastic/32/103081_2.png) [@Alex\_Salgado-Elastic](https://discuss.elastic.co/u/Alex_Salgado-Elastic)\
**Post date:** [June 7, 2024, 7:58pm UTC](https://discuss.elastic.co/t/logstash-jdbc-input-issue-single-quotes/360882/2 "2024-06-07T19:58:18Z")

</div>

> [@OscarFilho](#):
>
> ```auto
> statement => 'SELECT CASE WHEN datediff("DAY",last_successful_load,getdate()) = 0 THEN \'ATUALIZADO\' ELSE \'ERRO\' END AS "status" FROM [analytics].[status]'
> 
> ```

Could you try it?

statement =\> ".... 'ATUALIZADO' ELSE 'ERRO' END AS `status` FROM analytics.status;"

---

<div class="post-metadata">

**Author:** ![OscarFilho](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/oscarfilho/32/109740_2.png) [@OscarFilho](https://discuss.elastic.co/u/OscarFilho)\
**Post date:** [June 9, 2024, 6:09pm UTC](https://discuss.elastic.co/t/logstash-jdbc-input-issue-single-quotes/360882/3 "2024-06-09T18:09:43Z")

</div>

Tks for help attempt, but it not works.  
I solve this adjusting the yml file logstash.yml and uncomment this line:

`config.support_escapes: true`

This works fine.