# \[logstash.pipeline\] A plugin had an unrecoverable error

**URL:** https://discuss.elastic.co/t/logstash-pipeline-a-plugin-had-an-unrecoverable-error/134627
**Category:** Logstash
**Created:** [June 5, 2018, 1:06pm UTC](https://discuss.elastic.co/t/logstash-pipeline-a-plugin-had-an-unrecoverable-error/134627 "2018-06-05T13:06:18Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![swastime](https://avatars.discourse-cdn.com/v4/letter/s/97f17d/32.png) [@swastime](https://discuss.elastic.co/u/swastime)
#### Post date: [June 5, 2018, 1:06pm UTC](https://discuss.elastic.co/t/logstash-pipeline-a-plugin-had-an-unrecoverable-error/134627/1 "2018-06-05T13:06:18Z")

</div>

Hi! I'm new to the ELK stack and I am trying to use the jdbc input plugin to put data from my derby database into kibana. I am using a windows computer and I have elasticsearch, kibana and logstash installed, I am using logstash version 6.2.4

I have looked up all the similar discussions but have not been able to fix my issue, I get two errors infinitely when I run logstash with the config file to connect to the database and query it,  
The errors are-

> Blockquote

**[ERROR][logstash.pipeline] A plugin had an unrecoverable error. Will restart this plugin**.  
Pipeline\_id:main  
Plugin: \<LogStash::Inputs::Jdbc jdbc\_connection\_string=\>"jdbc:derby://localhost:1527/file\_monitoring", jdbc\_user=\>"swasti", jdbc\_password=\>, jdbc\_validate\_connection=\>true, jdbc\_driver\_library=\>"C:\Program Files\Java\jdk1.8.0\_171\db\lib\derbyclient.jar", jdbc\_driver\_class=\>"org.apache.derby.jdbc.EmbeddedDriver", statement=\>"SELECT \* from APP.DAILY", id=\>"e556c5ecfe2a75d0c1e849839b9f830022b74d1eaab9c4cb493c868588a56ee9", enable\_metric=\>true, codec=\>\<LogStash::Codecs::Plain id=\>"plain\_0d005b53-d3d7-42c9-aa13-1ff613ed428e", enable\_metric=\>true, charset=\>"UTF-8"\>, jdbc\_paging\_enabled=\>false, jdbc\_page\_size=\>100000, jdbc\_validation\_timeout=\>3600, jdbc\_pool\_timeout=\>5, sql\_log\_level=\>"info", connection\_retry\_attempts=\>1, connection\_retry\_attempts\_wait\_time=\>0.5, parameters=\>{"sql\_last\_value"=\>1970-01-01 05:30:00 +0530}, last\_run\_metadata\_path=\>"C:\Users\a1h4z60o/.logstash\_jdbc\_last\_run", use\_column\_value=\>false, tracking\_column\_type=\>"numeric", clean\_run=\>false, record\_last\_run=\>true, lowercase\_column\_names=\>true\>

**Error: org.apache.derby.jdbc.EmbeddedDriver not loaded. Are you sure you've included the correct jdbc driver in :jdbc\_driver\_library?**  
Exception: LogStash::ConfigurationError  
Stack: C:/Users/a1h4z60o/logstash-6.2.4/vendor/bundle/jruby/2.3.0/gems/logstash-input-jdbc-4.3.9/lib/logstash/plugin\_mixins/jdbc.rb:162:in `open_jdbc_connection' C:/Users/a1h4z60o/logstash-6.2.4/vendor/bundle/jruby/2.3.0/gems/logstash-input-jdbc-4.3.9/lib/logstash/plugin_mixins/jdbc.rb:220:in `execute\_statement'  
C:/Users/a1h4z60o/logstash-6.2.4/vendor/bundle/jruby/2.3.0/gems/logstash-input-jdbc-4.3.9/lib/logstash/inputs/jdbc.rb:264:in `execute_query' C:/Users/a1h4z60o/logstash-6.2.4/vendor/bundle/jruby/2.3.0/gems/logstash-input-jdbc-4.3.9/lib/logstash/inputs/jdbc.rb:250:in `run'  
C:/Users/a1h4z60o/logstash-6.2.4/logstash-core/lib/logstash/pipeline.rb:514:in `inputworker' C:/Users/a1h4z60o/logstash-6.2.4/logstash-core/lib/logstash/pipeline.rb:507:in `block in start\_input'

My config file is:  
input { jdbc {  
jdbc\_connection\_string =\> "jdbc:derby://localhost:1527/file\_monitoring"  
jdbc\_user =\> "swasti"  
jdbc\_password=\>"airtel123"  
jdbc\_validate\_connection =\> true  
jdbc\_driver\_library =\> "C:\Program Files\Java\jdk1.8.0\_171\db\lib\derbyclient.jar"  
jdbc\_driver\_class =\> "org.apache.derby.jdbc.EmbeddedDriver"  
statement =\> "SELECT \* from APP.DAILY"  
} }  
output {  
stdout { codec =\> json\_lines }  
}

any help would be greatly appreciated!

P.S. I'm sorry for the sloppy formatting, this is my first post on the discussion forum 🙂

---

<div class="post-metadata">

### Author: ![guyboertje](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/guyboertje/32/31592_2.png) [@guyboertje](https://discuss.elastic.co/u/guyboertje)
#### Post date: [June 11, 2018, 8:41am UTC](https://discuss.elastic.co/t/logstash-pipeline-a-plugin-had-an-unrecoverable-error/134627/2 "2018-06-11T08:41:21Z")

</div>

> [@swastime](#):
>
> jdbc\_driver\_class =\> "org.apache.derby.jdbc.EmbeddedDriver"

You need to use the client driver. `org.apache.derby.jdbc.ClientDriver`

---

<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: [July 9, 2018, 8:41am UTC](https://discuss.elastic.co/t/logstash-pipeline-a-plugin-had-an-unrecoverable-error/134627/3 "2018-07-09T08:41:24Z")

</div>

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