# Database stable connection

**URL:** <https://discuss.elastic.co/t/database-stable-connection/228808>\
**Category:** Logstash\
**Created:** [April 20, 2020, 8:24am UTC](https://discuss.elastic.co/t/database-stable-connection/228808 "2020-04-20T08:24:30Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jagan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jagan/32/42200_2.png) [@jagan](https://discuss.elastic.co/u/jagan)\
**Post date:** [April 20, 2020, 8:24am UTC](https://discuss.elastic.co/t/database-stable-connection/228808/1 "2020-04-20T08:24:30Z")

</div>

Hi guru's,  
when a kafka job is run i got the following erro:  
[ERROR][logstash.pipeline] er.PhysicalConnection.close(oracle/jdbc/driver/PhysicalConnection.java:2502)", "java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:498)", "org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(org/jruby/javasupport/JavaMethod.java:423)", "org.jruby.javasupport.JavaMethod.invokeDirect(org/jruby/javasupport/JavaMethod.java:290)", "apps.ccadmin.logstash6\_dot\_2.vendor.bundle.jruby.$2\_dot\_3\_dot\_0.gems.sequel\_minus\_5\_dot\_7\_dot\_1.lib.sequel.adapters.jdbc.disconnect\_connection(/apps/ccadmin/logstash6.2/vendor/bundle/jruby/2.3.0/gems/sequel-5.7.1/lib/sequel/adapters/jdbc.rb:220)", "apps.ccadmin.logstash6\_dot\_2.vendor.bundle.jruby.$2\_dot\_3\_dot\_0.gems.sequel\_minus\_5\_dot\_7\_dot\_1.lib.sequel.adapters.jdbc.RUBY$method$disconnect\_connection$0$ **VARARGS** (apps/ccadmin/logstash6\_dot\_2/vendor/bundle/jruby/$2\_dot\_3\_dot\_0/gems/sequel\_minus\_5\_dot\_7\_dot\_1/lib/sequel/adapters//apps/ccadmin/logstash6.2/vendor/bundle/jruby/2.3.0/gems/sequel-5.7.1/lib/sequel/adapters/jdbc.rb)", "apps.ccadmin.logstash\_minus\_6\_dot\_2\_dot\_4.vendor.bundle.jruby.$2\_dot\_3\_dot\_0.gems.sequel\_minus\_5\_dot\_7\_dot\_1.lib.sequel.connection\_pool.disconnect\_connection.......  
so here there is no specific time in connection failure.Once the connection fails all the waiting events will remain pending.  
The failure is happening at any time it can't be predicted (i.e like no peak time etc..)  
How should i handle for stable connection.Since there are many users existed so no database sided is handled. i need to handle in logstash script only.  
Here the oracle db is the source and ES is the target all the events comes via logstash.  
Please help me .  
Thanks in advance

Jagan

---

<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:** [May 18, 2020, 8:24am UTC](https://discuss.elastic.co/t/database-stable-connection/228808/2 "2020-05-18T08:24:31Z")

</div>

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