# Logstash oracle db jdbc plugin eeror

**URL:** https://discuss.elastic.co/t/logstash-oracle-db-jdbc-plugin-eeror/300225
**Category:** Logstash
**Created:** [March 21, 2022, 3:53pm UTC](https://discuss.elastic.co/t/logstash-oracle-db-jdbc-plugin-eeror/300225 "2022-03-21T15:53:48Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Hamza\_Shakeel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hamza_shakeel/32/103313_2.png) [@Hamza\_Shakeel](https://discuss.elastic.co/u/Hamza_Shakeel)
#### Post date: [March 21, 2022, 3:53pm UTC](https://discuss.elastic.co/t/logstash-oracle-db-jdbc-plugin-eeror/300225/1 "2022-03-21T15:53:48Z")

</div>

I am getting the following error :

Failed to execute action {:action=\>LogStash::PipelineAction::Create/pipeline\_id:main, :exception=\>"LogStash::ConfigurationError", :message=\>"Expected one of [\t\r\n], "#", [A-Za-z0-9\_-], '"', "'", [A-Za-z\_], "-", [0-9], "[", "{" at line 4, column 12 (byte 31) after input {\r\njdbc \r\n{\r\njdbc\_user=\>", :backtrace=\>["C:/HAMZA\_OFFICE/LOGSTSH/logstash\_files/logstashww/logstash-core/lib/logstash/compiler.rb:32:in `compile_imperative'", "org/logstash/execution/AbstractPipelineExt.java:189:in `initialize'", "org/logstash/execution/JavaBasePipelineExt.java:72:in `initialize'", "C:/HAMZA_OFFICE/LOGSTSH/logstash_files/logstashww/logstash-core/lib/logstash/java_pipeline.rb:47:in `initialize'", "C:/HAMZA\_OFFICE/LOGSTSH/logstash\_files/logstashww/logstash-core/lib/logstash/pipeline\_action/create.rb:50:in `execute'", "C:/HAMZA_OFFICE/LOGSTSH/logstash_files/logstashww/logstash-core/lib/logstash/agent.rb:376:in `block in converge\_state'"]}  
[2022-03-21T18:56:23,799][INFO][logstash.runner] Logstash shut down.

This is my Config File ;

input {  
jdbc  
{  
jdbc\_driver\_library =\> “C:\HAMZA\_OFFICE\LOGSTSH\logstash\_files\logstashww\logstash-core\lib\jars\ojdbc6.jar”  
jdbc\_driver\_class =\> “Java::oracle.jdbc.OracleDriver”  
jdbc\_connection\_string=\>“system@[//localhost:1521/orcl](https://localhost:1521/orcl)"  
jdbc\_user=\>“system”  
jdbc\_password =\> “orcl”  
statement =\> “select \* from employee”  
}  
}

output {  
stdout { codec =\> rubydebug }  
Elasticsearch {  
hosts =\> ["[http://localhost:9200](http://localhost:9200)"]  
index =\> "oracleinde"  
}  
}

---

<div class="post-metadata">

### Author: ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)
#### Post date: [March 21, 2022, 5:16pm UTC](https://discuss.elastic.co/t/logstash-oracle-db-jdbc-plugin-eeror/300225/2 "2022-03-21T17:16:44Z")

</div>

> [@Hamza\_Shakeel](#):
>
> :message=\>"Expected one of [\t\r\n], "#", [A-Za-z0-9\_-], '"', "'", [A-Za-z\_], "-", [0-9], "[", "{" at line 4, column 12 (byte 31) after input {\r\njdbc \r\n{\r\njdbc\_user=\>"

That does not match the config file that you posted. It is

```auto
input {
jdbc 
{
jdbc_user=>

```

The most likely explanation would be an unquoted username that contains punctuation or other special characters.

---

<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: [April 18, 2022, 5:17pm UTC](https://discuss.elastic.co/t/logstash-oracle-db-jdbc-plugin-eeror/300225/3 "2022-04-18T17:17:07Z")

</div>

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