# \[Logstash.filters.jdbc.readwritedatabase\]- No current connection **URL:** \ **Category:** Logstash\ **Created:** [July 23, 2018, 3:33am UTC](https://discuss.elastic.co/t/logstash-filters-jdbc-readwritedatabase-no-current-connection/141068 "2018-07-23T03:33:38Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![wm1994](https://avatars.discourse-cdn.com/v4/letter/w/e79b87/32.png) [@wm1994](https://discuss.elastic.co/u/wm1994)\ **Post date:** [July 23, 2018, 3:33am UTC](https://discuss.elastic.co/t/logstash-filters-jdbc-readwritedatabase-no-current-connection/141068/1 "2018-07-23T03:33:38Z")
Hello, I'm trying to set up a logstash 6.2.1 pipeline that does an enrichment lookup via the jdbc\_static plugin. But I got an error like this: [2018-07-23 05:39:26.291] [ERROR] [[main]-pipeline-manager] [logstash.filters.jdbc.readwritedatabase] - Exception when filling lookup db from loader query results, original exception: Java::JavaSql::SQLNonTransientConnectionException, original message: No current connection. {:backtrace=\>["org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(org/apache/derby/impl/jdbc/SQLExceptionFactory)", "org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(org/apache/derby/impl/jdbc/SQLExceptionFactory)", "org.apache.derby.impl.jdbc.Util.generateCsSQLException(org/apache/derby/impl/jdbc/Util)", "org.apache.derby.impl.jdbc.Util.generateCsSQLException(org/apache/derby/impl/jdbc/Util)", "org.apache.derby.impl.jdbc.Util.noCurrentConnection(org/apache/derby/impl/jdbc/Util)", "org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(org/apache/derby/impl/jdbc/EmbedConnection)", "org.apache.derby.impl.jdbc.EmbedConnection.setAutoCommit(org/apache/derby/impl/jdbc/EmbedConnection)", "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)", "usr.local.logstash\_minus\_6\_dot\_2\_dot\_1.vendor.bundle.jruby.$2\_dot\_3\_dot\_0.gems.sequel\_minus\_5\_dot\_4\_dot\_0.lib.sequel.adapters.jdbc.transactions.remove\_transaction(/usr/local/logstash-6.2.1/vendor/bundle/jruby/2.3.0/gems/sequel-5.4.0/lib/sequel/adapters/jdbc/transactions.rb:84)", "usr.local.logstash\_minus\_6\_dot\_2\_dot\_1.vendor.bundle.jruby.$2\_dot\_3\_dot\_0.gems.sequel\_minus\_5\_dot\_4\_dot\_0.lib.sequel.adapters.jdbc.transactions.RUBY$method$remove\_transaction$0$ **VARARGS** (usr/local/logstash\_minus\_6\_dot\_2\_dot\_1/vendor/bundle/jruby/$2\_dot\_3\_dot\_0/gems/sequel\_minus\_5\_dot\_4\_dot\_0/lib/sequel/adapters/jdbc//usr/local/logstash-6.2.1/vendor/bundle/jruby/2.3.0/gems/sequel-5.4.0/lib/sequel/adapters/jdbc/transactions.rb)", "usr.local.logstash\_minus\_6\_dot\_2\_dot\_1.vendor.bundle.jruby.$2\_dot\_3\_dot\_0.gems.sequel\_minus\_5\_dot\_4\_dot\_0.lib.sequel.database.transactions.\_transaction(/usr/local/logstash-6.2.1/vendor/bundle/jruby/2.3.0/gems/sequel-5.4.0/lib/sequel/database/transactions.rb:228)", "usr.local.logstash\_minus\_6\_dot\_2\_dot\_1.vendor.bundle.jruby.$2\_dot\_3\_dot\_0.gems.sequel\_minus\_5\_dot\_4\_dot\_0.lib.sequel.database.transactions.block in transaction(/usr/local/logstash-6.2.1/vendor/bundle/jruby/2.3.0/gems/sequel-5.4.0/lib/sequel/database/transactions.rb:179)", "usr.local.logstash\_minus\_6\_dot\_2\_dot\_1.vendor.bundle.jruby.$2\_dot\_3\_dot\_0.gems.sequel\_minus\_5\_dot\_4\_dot\_0.lib.sequel.connection\_pool.threaded.hold(/usr/local/logstash-6.2.1/vendor/bundle/jruby/2.3.0/gems/sequel-5.4.0/lib/sequel/connection\_pool/threaded.rb:91)", "usr.local.logstash\_minus\_6\_dot\_2\_dot\_1.vendor.bundle.jruby.$2\_dot\_3\_dot\_0.gems.sequel\_minus\_5\_dot\_4\_dot\_0.lib.sequel.database.connecting.synchronize(/usr/local/logstash-6.2.1/vendor/bundle/jruby/2.3.0/gems/sequel-5.4.0/lib/sequel/database/connecting.rb:269)"]} And what's the root cause? Any suggestion will be appreciate.Thanks. ---
**Author:** ![guyboertje](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/guyboertje/32/31592_2.png) [@guyboertje](https://discuss.elastic.co/u/guyboertje)\ **Post date:** [July 23, 2018, 10:33am UTC](https://discuss.elastic.co/t/logstash-filters-jdbc-readwritedatabase-no-current-connection/141068/2 "2018-07-23T10:33:18Z")
When to you get the error? Once at startup? After running for some time? ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [August 20, 2018, 10:33am UTC](https://discuss.elastic.co/t/logstash-filters-jdbc-readwritedatabase-no-current-connection/141068/3 "2018-08-20T10:33:21Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.