# Logstash unable to query Database

**URL:** <https://discuss.elastic.co/t/logstash-unable-to-query-database/208677>\
**Category:** Logstash\
**Tags:** docker\
**Created:** [November 20, 2019, 10:36am UTC](https://discuss.elastic.co/t/logstash-unable-to-query-database/208677 "2019-11-20T10:36:28Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![bharath.krishn2](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bharath.krishn2/32/130240_2.png) [@bharath.krishn2](https://discuss.elastic.co/u/bharath.krishn2)\
**Post date:** [November 20, 2019, 10:36am UTC](https://discuss.elastic.co/t/logstash-unable-to-query-database/208677/1 "2019-11-20T10:36:28Z")

</div>

I'm using jbdc filter in logstash to pull the records. I'm getting the below error in the logstash logs.

[2019-11-20T12:22:01,666][WARN][logstash.inputs.jdbc] Exception when executing JDBC query {:exception=\>#\<Sequel::DatabaseError: Java::JavaSql::SQLException: Stream has already been closed\>}

Below is my input config:  
jdbc {

```
    jdbc_connection_string => "jdbc:oracle:thin:@//XXXX:1531/XXXX"
    jdbc_user => "XXXXXX"
    jdbc_password => "XXXXX"
    jdbc_validate_connection => true
    jdbc_driver_library => "/etc/logstash/conf.d/ojdbc7-12.1.0.2.jar"
    jdbc_driver_class =>"Java::oracle.jdbc.driver.OracleDriver"
    schedule => "* * * * *"
    statement => "select * from table WHERE INITIATION_TIME > :sql_last_value ORDER by INITIATION_TIME"
    use_column_value => true
    tracking_column => "initiation_time"
    tracking_column_type => "timestamp"
    last_run_metadata_path => "/etc/logstash/conf.d/.logstash_jdbc_last_run"
  }

```

The same input config for Dev DB connection is working. But when I change the DB details to Testing environment, I'm getting the above error.

P.S: A single error is printed. There is no log stacktrace.

---

<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:** [December 18, 2019, 10:36am UTC](https://discuss.elastic.co/t/logstash-unable-to-query-database/208677/2 "2019-12-18T10:36:29Z")

</div>

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