# Jdbc input plugin with scheduler opens 96 extra connections to Oracle

**URL:** <https://discuss.elastic.co/t/jdbc-input-plugin-with-scheduler-opens-96-extra-connections-to-oracle/71009>\
**Category:** Logstash\
**Created:** [January 10, 2017, 1:25am UTC](https://discuss.elastic.co/t/jdbc-input-plugin-with-scheduler-opens-96-extra-connections-to-oracle/71009 "2017-01-10T01:25:34Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![iti](https://avatars.discourse-cdn.com/v4/letter/i/b19c9b/32.png) [@iti](https://discuss.elastic.co/u/iti)\
**Post date:** [January 10, 2017, 1:25am UTC](https://discuss.elastic.co/t/jdbc-input-plugin-with-scheduler-opens-96-extra-connections-to-oracle/71009/1 "2017-01-10T01:25:34Z")

</div>

I am using ES 5.1.1 LS 5.1.1 and logstash-input-jdbc (4.1.3)

With the following input config:  
input {  
jdbc {  
# Oracle jdbc connection string to Oracle database  
jdbc\_connection\_string =\> "jdbc:oracle:thin:@//host:port/sid"  
# The user we wish to execute our statement as  
jdbc\_user =\> "user"  
jdbc\_password=\> "password"  
# The path to our downloaded jdbc driver  
jdbc\_driver\_library =\> "path/lib/ojdbc7.jar"  
# The name of the driver class for Oracle  
jdbc\_driver\_class =\> "Java::oracle.jdbc.driver.OracleDriver"  
jdbc\_validate\_connection =\> true  
# our query  
statement =\> "select \* from es\_etl\_log where status='N'"  
type =\> "es\_etl\_start"  
schedule =\> "\* \* \* \* \*"  
}  
}

I got 97 connections to the Oracle DB after starting LS. If I comment out the "schedule", then there is only 1 connection.  
Is there any solution to this?  
Thanks

---

<div class="post-metadata">

**Author:** ![iti](https://avatars.discourse-cdn.com/v4/letter/i/b19c9b/32.png) [@iti](https://discuss.elastic.co/u/iti)\
**Post date:** [January 10, 2017, 8:59pm UTC](https://discuss.elastic.co/t/jdbc-input-plugin-with-scheduler-opens-96-extra-connections-to-oracle/71009/2 "2017-01-10T20:59:22Z")

</div>

Problem solved.

The problem is not the input plugin, but the jdbc output plugin.  
Defaul maximumPoolSize actually is 24. Not 5 as the doc says.

I have 1 JDBC input and 4 JDBC outputs, so 1 + 24\*4=97.  
In my case, I do not need pooling since there is only 1 user.

Set:  
maximumPoolSize =\>1

---

<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:** [February 7, 2017, 8:59pm UTC](https://discuss.elastic.co/t/jdbc-input-plugin-with-scheduler-opens-96-extra-connections-to-oracle/71009/3 "2017-02-07T20:59:36Z")

</div>

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