# RE:Oracle DB for JDBC Plugin in Logstash

**URL:** <https://discuss.elastic.co/t/re-oracle-db-for-jdbc-plugin-in-logstash/124746>\
**Category:** Logstash\
**Created:** [March 20, 2018, 11:35am UTC](https://discuss.elastic.co/t/re-oracle-db-for-jdbc-plugin-in-logstash/124746 "2018-03-20T11:35:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![naveen\_K.N](https://avatars.discourse-cdn.com/v4/letter/n/8e8cbc/32.png) [@naveen\_K.N](https://discuss.elastic.co/u/naveen_K.N)\
**Post date:** [March 20, 2018, 11:35am UTC](https://discuss.elastic.co/t/re-oracle-db-for-jdbc-plugin-in-logstash/124746/1 "2018-03-20T11:35:48Z")

</div>

Hello Elastic Team,

im facing issue in connectivity to Oracle 12C DB using JDBC input Plugin available in Logstash,

let me know the syntax for connection string, driver class and jar can be used for Oracle 12C.

i have coded it like this:

input {  
jdbc {  
jdbc\_driver\_library =\> "/is/appl/webMethods\_Scripts/SAGMonitoring/jars/ojdbc8.jar"  
jdbc\_driver\_class =\> "oracle.jdbc.driver.OracleDriver"  
jdbc\_connection\_string =\> "jdbc:wm:oracle://monmwbb02db.mp.local:1527/monmwqas"  
jdbc\_user =\> "\*\*\*\*\*\*_"  
jdbc\_password =\> "\*\*\*\*\*\*\*\*"  
 #parameters =\> { "favorite\_artist" =\> "%" }  
schedule =\> "_ \* \* \* \*"  
statement =\> "SELECT \* FROM webm101\_is.songs WHERE timestamp \> DATE\_SUB(now(), INTERVAL 1 MINUTE)"

}  
}

let me if any corrections required??

Thanks& regards,  
Naveena

---

<div class="post-metadata">

**Author:** ![naveen\_K.N](https://avatars.discourse-cdn.com/v4/letter/n/8e8cbc/32.png) [@naveen\_K.N](https://discuss.elastic.co/u/naveen_K.N)\
**Post date:** [March 21, 2018, 6:49am UTC](https://discuss.elastic.co/t/re-oracle-db-for-jdbc-plugin-in-logstash/124746/2 "2018-03-21T06:49:43Z")

</div>

Hi ELK Team,

i have configuration file with following code:

> input {  
> jdbc {  
> jdbc\_driver\_library =\> "file://C:/Users/nakn/Downloads/logstash-6.2.3/data/ojdbc8.jar"  
> jdbc\_driver\_class =\> "Java::oracle.jdbc.driver.OracleDriver"  
> jdbc\_connection\_string =\> "jdbc:wm:oracle://localhost:1521;serviceName=XE"  
> jdbc\_user =\> "system"  
> jdbc\_password =\> "nakn"  
> parameters =\> { "favorite\_artist" =\> "sudeep" }  
> schedule =\> "\* \* \* \* \*"  
> statement =\> "SELECT \* from songs where FAVORITE\_ARTIST = :favorite\_artist"  
> }  
> }

so when i tried to run in command prompt using command:  
bin\>logstash -f file://C:/Users/nakn/Downloads/logstash-6.2.3/config/oracle.conf

logstash is started and pipeline is working fine but getting " rufus:: scheduler:: cronjob \* \* \* \* \* " Error

and No suitable driver found for connecting to database.

i have placed ojdbc8.jar in logstash/data for Oracle 11g Express Edition.  
any help to solve this issue will be appreciated!

thanks

---

<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:** [April 18, 2018, 6:49am UTC](https://discuss.elastic.co/t/re-oracle-db-for-jdbc-plugin-in-logstash/124746/3 "2018-04-18T06:49:52Z")

</div>

Closed on April 18, 2018, 6:49am UTC

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