I am using ES 5.1.1 LS 5.1.1 and logstash-input-jdbc (4.1.3)
With the following input config:
input {
jdbc {
# Oracle jdbc connection string to Oracle database
jdbc_connection_string => "jdbc:oracle:thin:@//host:port/sid"
# The user we wish to execute our statement as
jdbc_user => "user"
jdbc_password=> "password"
# The path to our downloaded jdbc driver
jdbc_driver_library => "path/lib/ojdbc7.jar"
# The name of the driver class for Oracle
jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
jdbc_validate_connection => true
# our query
statement => "select * from es_etl_log where status='N'"
type => "es_etl_start"
schedule => "* * * * *"
}
}
I got 97 connections to the Oracle DB after starting LS. If I comment out the "schedule", then there is only 1 connection.
Is there any solution to this?
Thanks