# My input JDBC conf is not working .... \[org.logstash.execution.PeriodicFlush\]\[main\] Pushing flush onto pipeline.\]

**URL:** <https://discuss.elastic.co/t/my-input-jdbc-conf-is-not-working-org-logstash-execution-periodicflush-main-pushing-flush-onto-pipeline/212184>\
**Category:** Logstash\
**Created:** [December 17, 2019, 3:16pm UTC](https://discuss.elastic.co/t/my-input-jdbc-conf-is-not-working-org-logstash-execution-periodicflush-main-pushing-flush-onto-pipeline/212184 "2019-12-17T15:16:23Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Haalanam](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/haalanam/32/58782_2.png) [@Haalanam](https://discuss.elastic.co/u/Haalanam)\
**Post date:** [December 17, 2019, 3:16pm UTC](https://discuss.elastic.co/t/my-input-jdbc-conf-is-not-working-org-logstash-execution-periodicflush-main-pushing-flush-onto-pipeline/212184/1 "2019-12-17T15:16:23Z")

</div>

I cannot manage to get data into my es instance.

This is what input jdbc looks like 🙂

```
 jdbc {
        type => "B"
        jdbc_connection_string => "jdbc:oracle:thin:@//fff.ff.ff.f:1521/fff"
        jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
        jdbc_user => "fff"
        jdbc_password => "ffff"
        statement => "select update_date from i_log order by insert_date desc"
        use_column_value => true
        tracking_column => "update_date"
        jdbc_paging_enabled => "true"
        jdbc_page_size => "50000"
        tracking_column_type => "numeric"
        schedule => "0 * * * *"
        clean_run => true
        last_run_metadata_path => "/data/application/.logstash_jdbc_last_run"
}

```

I heavily suspect that about Java configuration but dont kno how to fix this.

---

<div class="post-metadata">

**Author:** ![Haalanam](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/haalanam/32/58782_2.png) [@Haalanam](https://discuss.elastic.co/u/Haalanam)\
**Post date:** [December 17, 2019, 3:19pm UTC](https://discuss.elastic.co/t/my-input-jdbc-conf-is-not-working-org-logstash-execution-periodicflush-main-pushing-flush-onto-pipeline/212184/2 "2019-12-17T15:19:33Z")

</div>

This is the output from my java version

```
-bash-4.2$ java -version
openjdk version "1.8.0_222"
OpenJDK Runtime Environment (Zulu 8.40.0.25-CA-linux64) (build 1.8.0_222-b10)
OpenJDK 64-Bit Server VM (Zulu 8.40.0.25-CA-linux64) (build 25.222-b10, mixed mode)

```

and the java Home Command gives ::

`/data/application/logstash-7.5.0/jre`

---

<div class="post-metadata">

**Author:** ![ITIC](https://avatars.discourse-cdn.com/v4/letter/i/90ced4/32.png) [@ITIC](https://discuss.elastic.co/u/ITIC)\
**Post date:** [December 18, 2019, 7:10am UTC](https://discuss.elastic.co/t/my-input-jdbc-conf-is-not-working-org-logstash-execution-periodicflush-main-pushing-flush-onto-pipeline/212184/3 "2019-12-18T07:10:34Z")

</div>

Hi

What is the output you get when you run this config?

You have not configured the "`jdbc_driver_library`" parameter. Don't know if it's mandatory, you might want to check that out.

Hope this helps

---

<div class="post-metadata">

**Author:** ![Haalanam](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/haalanam/32/58782_2.png) [@Haalanam](https://discuss.elastic.co/u/Haalanam)\
**Post date:** [December 18, 2019, 1:51pm UTC](https://discuss.elastic.co/t/my-input-jdbc-conf-is-not-working-org-logstash-execution-periodicflush-main-pushing-flush-onto-pipeline/212184/4 "2019-12-18T13:51:57Z")

</div>

Thanks for your reply.

I could solve the issue and it was about the ope java version i was using....  
The openjdk version "1.8.0\_222" is not working with logstash 7.5.  
I downloaded now the version 11 and it works.

---

<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:** [January 15, 2020, 1:52pm UTC](https://discuss.elastic.co/t/my-input-jdbc-conf-is-not-working-org-logstash-execution-periodicflush-main-pushing-flush-onto-pipeline/212184/5 "2020-01-15T13:52:20Z")

</div>

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