# JDBC Oracle table to Elastic through logstash

**URL:** <https://discuss.elastic.co/t/jdbc-oracle-table-to-elastic-through-logstash/253338>\
**Category:** Logstash\
**Created:** [October 26, 2020, 4:07pm UTC](https://discuss.elastic.co/t/jdbc-oracle-table-to-elastic-through-logstash/253338 "2020-10-26T16:07:48Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gopal\_Chauhan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gopal_chauhan/32/51033_2.png) [@Gopal\_Chauhan](https://discuss.elastic.co/u/Gopal_Chauhan)\
**Post date:** [October 26, 2020, 4:07pm UTC](https://discuss.elastic.co/t/jdbc-oracle-table-to-elastic-through-logstash/253338/1 "2020-10-26T16:07:48Z")

</div>

Hi ,

I am trying to get oracle table data into Elastic through logstash (version 6.2, windows). I have created a pipe line. Added pipeline id into logstash.yml file and restarting logstash service. Pipeline is starting and seeing my sql query as info in logs and then pipeline terminated. Index get generated in Elastic but no data is in index. Not sure what is the issue?

```auto
input
 {
   jdbc
    {     
      jdbc_driver_library => "D:\elasticsearch\jars\ojdbc7.jar"
      jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"     
      jdbc_connection_string => "jdbc:oracle:thin:@<servername>:1521:<sid>"      
      jdbc_user => "userid"
      jdbc_password => " *****"
      statement => "select * from <schema.tablename>"      
    }
 }
 filter
 {
 }
 output
  {
    elasticsearch 
     {
      hosts => "https://<elasticserver>:9200/"
      index => "tempindex-%{+YYYY.MM}"
      document_type => "temp"
      user => <user>
      password => " *****"
      ssl => true
      ssl_certificate_verification => true
      cacert => "<.pem path>"
    }
  }

Logs
[2020-10-26T11:50:36,372][INFO][logstash.pipeline] Pipeline started successfully {:pipeline_id=>"oracledata", :thread=>"#<Thread:0x66e32381 sleep>"}
[2020-10-26T11:50:36,373][INFO][logstash.agent] Pipelines running {:count=>2, :pipelines=>["otherpipline", "oracledata"]}
[2020-10-26T11:50:36,817][INFO][logstash.inputs.jdbc] (0.053214s) select * from <schema.table>
[2020-10-26T11:50:43,361][INFO][logstash.pipeline] Pipeline has terminated {:pipeline_id=>"oracledata", :thread=>"#<Thread:0x66e32381 run>"}

```

---

<div class="post-metadata">

**Author:** ![Wolfram\_Haussig](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wolfram_haussig/32/70528_2.png) [@Wolfram\_Haussig](https://discuss.elastic.co/u/Wolfram_Haussig)\
**Post date:** [October 28, 2020, 11:41am UTC](https://discuss.elastic.co/t/jdbc-oracle-table-to-elastic-through-logstash/253338/2 "2020-10-28T11:41:27Z")

</div>

Hi,

Maybe it is a mapping conflict? Have you already checked if the [dead-letter-queue](https://www.elastic.co/guide/en/logstash/6.2/dead-letter-queues.html) is enabled - maybe the data is sent there?

Best regards  
Wolfram

---

<div class="post-metadata">

**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\
**Post date:** [October 28, 2020, 12:24pm UTC](https://discuss.elastic.co/t/jdbc-oracle-table-to-elastic-through-logstash/253338/3 "2020-10-28T12:24:30Z")

</div>

can you run this on command line to check if any thing is display on standard out?

---

<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 25, 2020, 12:24pm UTC](https://discuss.elastic.co/t/jdbc-oracle-table-to-elastic-through-logstash/253338/4 "2020-11-25T12:24:36Z")

</div>

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