# Logstash Error while configuring the JDBC connection

**URL:** <https://discuss.elastic.co/t/logstash-error-while-configuring-the-jdbc-connection/254036>\
**Category:** Logstash\
**Created:** [November 2, 2020, 1:57pm UTC](https://discuss.elastic.co/t/logstash-error-while-configuring-the-jdbc-connection/254036 "2020-11-02T13:57:32Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kannan\_Rajendran](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kannan_rajendran/32/78272_2.png) [@Kannan\_Rajendran](https://discuss.elastic.co/u/Kannan_Rajendran)\
**Post date:** [November 2, 2020, 1:57pm UTC](https://discuss.elastic.co/t/logstash-error-while-configuring-the-jdbc-connection/254036/1 "2020-11-02T13:57:32Z")

</div>

Hi , When i try to connect the JDBC connection and test the logstash conf file i'm getting the below error. i have tried the some forum solution but nothing worked.

[logstash.runner] The given configuration is invalid. Reason: Expected one of [\t\r\n], "#", "{", "}" at line 1, column 439 (byte 43 [database\_name] AS "tabaseName=qa-co-38;user=_ **;password=** _\*\*\*\*\*\*".jar"

also attached the logstash conf information

input {  
jdbc {  
jdbc\_driver\_library =\> "C:\Program Files (x86)\Microsoft JDBC driver 4.2\sqljdbc\_4.2\enu\jre8sqljdbc42.jar"  
jdbc\_driver\_class =\> "com.microsoft.sqlserver.jdbc.SQLServerDriver"  
jdbc\_connection\_string =\> "jdbc:sqlserver://localhost;databaseName=qa-co-38;user=_**;password=\*\*\*\*\*\*\*"  
jdbc\_user =\> "**_"  
jdbc\_password =\> "\*\*\*\*\*\*_"  
schedule =\> "_ \* \* \* \*"  
statement =\> " SELECT \* FROM [dbo].[srv\_event]"   
}  
}

filter {  
}  
output {  
elasticsearch {  
hosts =\> ["localhost:9200"]  
index =\> "SQL DB Check"  
}  
stdout { codec =\> rubydebug }  
}

please help me on this.

---

<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:** [November 30, 2020, 1:57pm UTC](https://discuss.elastic.co/t/logstash-error-while-configuring-the-jdbc-connection/254036/2 "2020-11-30T13:57:48Z")

</div>

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