RE:Oracle DB for JDBC Plugin in Logstash

[naveen_K.N]

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

[naveen_K.N]

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