# Error input jdbc **URL:** https://discuss.elastic.co/t/error-input-jdbc/61603 **Category:** Logstash **Created:** [September 27, 2016, 12:27pm UTC](https://discuss.elastic.co/t/error-input-jdbc/61603 "2016-09-27T12:27:06Z") **Posts on this page:** 5 **Page:** 1
### Author: ![axil\_76](https://avatars.discourse-cdn.com/v4/letter/a/e68b1a/32.png) [@axil\_76](https://discuss.elastic.co/u/axil_76) #### Post date: [September 27, 2016, 12:27pm UTC](https://discuss.elastic.co/t/error-input-jdbc/61603/1 "2016-09-27T12:27:06Z")
Hello, I configured as input logstash jdbc and when do I start logstash I have an error message and I can not find the error my logstash config ``` input { jdbc { jdbc_driver_library => "/oracle/client/11.2.0.4.0/jdbc/lib/ojdbc6.jar" jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver" jdbc_connection_string => "jdbc:oracle:thin:@//test:1521/test" jdbc_validate_connection => true jdbc_user => "test" jdbc_password => "test" statement => "SELECT * FROM V$ACTIVE_SESSION_HISTORY WHERE SAMPLE_TIME > :sql_last_value" last_run_metadata_path => "/tmp/logstash-oratest-test.lastrun" record_last_run => true sql_log_level => "debug" schedule => "*/2 * * * *" } } {:timestamp=>"2016-09-27T14:21:32.521000+0200", :message=>"Pipeline aborted due to error", :exception=>"Sequel::DatabaseConnectionError", :backtrace=>["oracle.jdbc.driver.T4CConnection.logon(oracle/jdbc/driver/T4CConnection.java:489)", "oracle.jdbc.driver.PhysicalConnection.(oracle/jdbc/driver/PhysicalConnection.java:553)", "oracle.jdbc.driver.T4CConnection.(oracle/jdbc/driver/T4CConnection.java:254)", "oracle.jdbc.driver.T4CDriverExtension.getConnection(oracle/jdbc/driver/T4CDriverExtension.java:32)", "oracle.jdbc.driver.OracleDriver.connect(oracle/jdbc/driver/OracleDriver.java:528)", "java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:483)", "RUBY.connect(/opt/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.37.0/lib/sequel/adapters/jdbc.rb:222)", "RUBY.make_new(/opt/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.37.0/lib/sequel/connection_pool.rb:116)", "RUBY.make_new(/opt/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.37.0/lib/sequel/connection_pool/threaded.rb:228)", "RUBY.available(/opt/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.37.0/lib/sequel/connection_pool/threaded.rb:201)", "RUBY._acquire(/opt/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.37.0/lib/sequel/connection_pool/threaded.rb:137)", "RUBY.acquire(/opt/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.37.0/lib/sequel/connection_pool/threaded.rb:151)", "RUBY.sync(/opt/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.37.0/lib/sequel/connection_pool/threaded.rb:282)", "org.jruby.ext.thread.Mutex.synchronize(org/jruby/ext/thread/Mutex.java:149)", "RUBY.sync(/opt/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.37.0/lib/sequel/connection_pool/threaded.rb:282)", "RUBY.acquire(/opt/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.37.0/lib/sequel/connection_pool/threaded.rb:150)", "RUBY.acquire(/opt/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.37.0/lib/sequel/extensions/connection_validator.rb:98)", "RUBY.hold(/opt/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.37.0/lib/sequel/connection_pool/threaded.rb:106)", "RUBY.synchronize(/opt/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.37.0/lib/sequel/database/connecting.rb:256)", "RUBY.test_connection(/opt/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.37.0/lib/sequel/database/connecting.rb:266)", "RUBY.prepare_jdbc_connection(/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-3.1.0/lib/logstash/plugin_mixins/jdbc.rb:173)", "RUBY.register(/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-3.1.0/lib/logstash/inputs/jdbc.rb:187)", "RUBY.start_inputs(/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.4.0-java/lib/logstash/pipeline.rb:330)", "org.jruby.RubyArray.each(org/jruby/RubyArray.java:1613)", "RUBY.start_inputs(/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.4.0-java/lib/logstash/pipeline.rb:329)", "RUBY.start_workers(/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.4.0-java/lib/logstash/pipeline.rb:180)", "RUBY.run(/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.4.0-java/lib/logstash/pipeline.rb:136)", "RUBY.start_pipeline(/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.4.0-java/lib/logstash/agent.rb:491)", "java.lang.Thread.run(java/lang/Thread.java:745)"], :level=>:error} {:timestamp=>"2016-09-27T14:21:35.528000+0200", :message=>"stopping pipeline", :id=>"main"} {:timestamp=>"2016-09-27T14:21:35.529000+0200", :message=>"Closing inputs", :level=>:info} {:timestamp=>"2016-09-27T14:21:35.530000+0200", :message=>"Closed inputs", :level=>:info} ``` ---
### Author: ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck) #### Post date: [September 27, 2016, 12:31pm UTC](https://discuss.elastic.co/t/error-input-jdbc/61603/2 "2016-09-27T12:31:39Z")
This is Logstash 2.4 isn't it? There's a bug in Logstash 2.4 that hides the interesting parts of many error messages. Could you temporarily downgrade to 2.3 and try again? That should give you more clues. ---
### Author: ![axil\_76](https://avatars.discourse-cdn.com/v4/letter/a/e68b1a/32.png) [@axil\_76](https://discuss.elastic.co/u/axil_76) #### Post date: [September 27, 2016, 1:29pm UTC](https://discuss.elastic.co/t/error-input-jdbc/61603/3 "2016-09-27T13:29:36Z")
I can try to logstash version 5? ---
### Author: ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck) #### Post date: [September 27, 2016, 1:32pm UTC](https://discuss.elastic.co/t/error-input-jdbc/61603/4 "2016-09-27T13:32:00Z")
Sure, you can always try. ---
### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system) #### Post date: [July 6, 2017, 4:36am UTC](https://discuss.elastic.co/t/error-input-jdbc/61603/5 "2017-07-06T04:36:39Z")