# JDBC input plugin only works outside of pipeline - 6.4.2

**URL:** <https://discuss.elastic.co/t/jdbc-input-plugin-only-works-outside-of-pipeline-6-4-2/153074>\
**Category:** Logstash\
**Created:** [October 18, 2018, 9:25pm UTC](https://discuss.elastic.co/t/jdbc-input-plugin-only-works-outside-of-pipeline-6-4-2/153074 "2018-10-18T21:25:03Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![RenataBoodram](https://avatars.discourse-cdn.com/v4/letter/r/d6d6ee/32.png) [@RenataBoodram](https://discuss.elastic.co/u/RenataBoodram)\
**Post date:** [October 18, 2018, 9:25pm UTC](https://discuss.elastic.co/t/jdbc-input-plugin-only-works-outside-of-pipeline-6-4-2/153074/1 "2018-10-18T21:25:03Z")

</div>

**Please note:** I am able to run this configuration successfully in Logstash 6.4.2 using the command `logstash -f simple.conf` but not using pipelines.  
indent preformatted text by 4 spaces

- Version: 6.4.2

- Operating System: Ubuntu 16.04

- Config File (if you have sensitive info, please remove it):

- Sample Data:

- Steps to Reproduce:

1. Add the pipeline configuration to pipelines.yml (example below):

2. Update logstash.yml to set `log.level: error`

3. `service logstash start`

4. Check log messages to view the error.

**EDIT** :  
I found my own solution. I had to copy the db2jcc4.jar file to the location of JARs that Logstash will add to the `CLASSPATH` on startup.

1. Copied db2jcc4.jar to `/usr/share/logstash/logstash-core/lib/jars`
2. `chmod 644 db2jcc4.jar`
3. `chown <logstash user>:<logstash group> db2jcc4.jar`

---

<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 15, 2018, 9:25pm UTC](https://discuss.elastic.co/t/jdbc-input-plugin-only-works-outside-of-pipeline-6-4-2/153074/2 "2018-11-15T21:25:04Z")

</div>

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