# DatabaseConnectionError with oracle BBDD

**URL:** <https://discuss.elastic.co/t/databaseconnectionerror-with-oracle-bbdd/55038>\
**Category:** Logstash\
**Created:** [July 8, 2016, 10:29am UTC](https://discuss.elastic.co/t/databaseconnectionerror-with-oracle-bbdd/55038 "2016-07-08T10:29:22Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jjgil](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@jjgil](https://discuss.elastic.co/u/jjgil)\
**Post date:** [July 8, 2016, 10:29am UTC](https://discuss.elastic.co/t/databaseconnectionerror-with-oracle-bbdd/55038/1 "2016-07-08T10:29:22Z")

</div>

Dears!

I'm new to EKL and I have a problem trying to connect to an Oracle database.  
My code:

> input {  
> jdbc{  
> jdbc\_driver\_library =\> "C:\EKL\logstash\vendor\jar\jdbc\ojdbc6.jar"  
> jdbc\_driver\_class =\> "Java::oracle.jdbc.driver.OracleDriver"  
> #ORACLE jdbc connection string to our database, ORACLE jdbc:oracle:thin:@hostname:PORT/SERVICE  
> jdbc\_connection\_string =\> "jdbc:oracle:thin:@\srv:1521:service"  
> jdbc\_user =\> "user"  
> jdbc\_password =\> "password"  
> jdbc\_validate\_connection =\> true  
> #Query  
> statement =\> "select \* from users"  
> #optional extras I use  
> type =\> "Database"  
> # tags =\> ["awesome", "import"]  
> }  
> }

> filter {
> 
> }

> output {  
> elasticsearch {  
> hosts =\> ["localhost:9200"]  
> index =\> "contacts"  
> document\_type =\> "contact"  
> document\_id =\> "%{uid}"  
> }  
> stdout {  
> codec =\> rubydebug  
> }  
> }

Error:

> ←[31mPipeline aborted due to error {  
> \*\ ***:exception=\>#\<Sequel::DatabaseConnectionError: Java::JavaSql::SQLRecoverableException: Error de E/S: The Network Adapter could not establish the connection\>,**  
> :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:606)",  
> "RUBY.connect(C:/EKL/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.33.0/lib/sequel/adapters/jdbc.rb:222)",  
> "RUBY.make\_new(C:/EKL/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.33.0/lib/sequel/connection\_pool.rb:103)",  
> "RUBY.make\_new(C:/EKL/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.33.0/lib/sequel/connection\_pool/threaded.rb:224)",  
> "RUBY.available(C:/EKL/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.33.0/lib/sequel/connection\_pool/threaded.rb:197)",  
> "RUBY.\_acquire(C:/EKL/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.33.0/lib/sequel/connection\_pool/threaded.rb:133)",  
> "RUBY.acquire(C:/EKL/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.33.0/lib/sequel/connection\_pool/threaded.rb:147)",  
> "RUBY.sync(C:/EKL/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.33.0/lib/sequel/connection\_pool/threaded.rb:265)",  
> "org.jruby.ext.thread.Mutex.synchronize(org/jruby/ext/thread/Mutex.java:149)",  
> "RUBY.sync(C:/EKL/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.33.0/lib/sequel/connection\_pool/threaded.rb:265)",  
> "RUBY.acquire(C:/EKL/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.33.0/lib/sequel/connection\_pool/threaded.rb:146)",  
> "RUBY.acquire(C:/EKL/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.33.0/lib/sequel/extensions/connection\_validator.rb:90)",  
> "RUBY.hold(C:/EKL/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.33.0/lib/sequel/connection\_pool/threaded.rb:104)",  
> "RUBY.synchronize(C:/EKL/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.33.0/lib/sequel/database/connecting.rb:256)",  
> "RUBY.test\_connection(C:/EKL/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.33.0/lib/sequel/database/connecting.rb:266)",  
> "RUBY.prepare\_jdbc\_connection(C:/EKL/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-3.0.2/lib/logstash/plugin\_mixins/jdbc.rb:170)", "RUBY.register(C:/EKL/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-3.0.2/lib/logstash/inputs/jdbc.rb:167)",  
> "RUBY.start\_inputs(C:/EKL/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/pipeline.rb:330)",  
> "org.jruby.RubyArray.each(org/jruby/RubyArray.java:1613)",  
> "RUBY.start\_inputs(C:/EKL/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/pipeline.rb:329)",  
> "RUBY.start\_workers(C:/EKL/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/pipeline.rb:180)",  
> "RUBY.run(C:/EKL/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/pipeline.rb:136)",  
> "RUBY.start\_pipeline(C:/EKL/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/agent.rb:465)",  
> "java.lang.Thread.run(java/lang/Thread.java:745)"], :level=\>:error}←[0m  
> stopping pipeline {:id=\>"main"  
> }  
> The signal HUP is in use by the JVM and will not work correctly on this platform

I did --configtest and tells me OK.  
The data that are putting this well.  
You might be missing me something more to connect to the database?

Thanks in advance

---

<div class="post-metadata">

**Author:** ![jjgil](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@jjgil](https://discuss.elastic.co/u/jjgil)\
**Post date:** [July 14, 2016, 12:04pm UTC](https://discuss.elastic.co/t/databaseconnectionerror-with-oracle-bbdd/55038/2 "2016-07-14T12:04:29Z")

</div>

none? anybody? ☹

---

<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:** [July 6, 2017, 4:48am UTC](https://discuss.elastic.co/t/databaseconnectionerror-with-oracle-bbdd/55038/3 "2017-07-06T04:48:04Z")

</div>