# Logstash JDBC Oracle

**URL:** <https://discuss.elastic.co/t/logstash-jdbc-oracle/193846>\
**Category:** Logstash\
**Created:** [August 5, 2019, 4:21pm UTC](https://discuss.elastic.co/t/logstash-jdbc-oracle/193846 "2019-08-05T16:21:42Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Adriano\_F](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/adriano_f/32/45433_2.png) [@Adriano\_F](https://discuss.elastic.co/u/Adriano_F)\
**Post date:** [August 5, 2019, 4:21pm UTC](https://discuss.elastic.co/t/logstash-jdbc-oracle/193846/1 "2019-08-05T16:21:42Z")

</div>

Boa tarde,  
estou tentando utilizar o logstash com JDBC acessando oracle

input {  
jdbc {  
jdbc\_validate\_connection =\> true  
jdbc\_connection\_string =\> "jdbc:oracle:thin:@vms-dbs-01:1521/nladm"  
jdbc\_user =\> "nladm"  
jdbc\_password =\> "?????"  
jdbc\_driver\_library =\> "C:\adm\Elastic\logstash\config\ojdbc6.jar"  
jdbc\_driver\_class =\> "java::oracle.jdbc.driver.OracleDriver"  
statement =\> "SELECT sysdate from dual"  
#statement\_filepath =\> "C:\adm\Elastic\logstash\jdbc\cs\_01.sql"  
schedule =\> "\* \* \* \* \*"  
}  
}  
output {  
stdout { codec =\> rubydebug  
}

# elasticsearch { index =\> "cs-01-index"

# }

}

Ao iniciar o servico ocorre a mensagem abaixo  
Alguem ja passou por este problema?  
Obrigado

Ja conferei a localização do driver e esta correta.

[2019-08-05T10:35:00,809][ERROR][logstash.inputs.jdbc] Failed to load C:\adm\Elastic\logstash\jdbc\ojdbc7.jar {:exception=\>#\<TypeError: failed to coerce jdk.internal.loader.ClassLoaders$AppClassLoader to java.net.URLClassLoader\>}

---

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [August 5, 2019, 4:34pm UTC](https://discuss.elastic.co/t/logstash-jdbc-oracle/193846/2 "2019-08-05T16:34:32Z")

</div>

See [here](https://github.com/logstash-plugins/logstash-filter-jdbc_static/issues/47#issuecomment-496602951).

---

<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:** [September 2, 2019, 4:34pm UTC](https://discuss.elastic.co/t/logstash-jdbc-oracle/193846/3 "2019-09-02T16:34:34Z")

</div>

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