Hi
i have 20 sql query, 2 query in each jdbc.conf file
my question is
how many sessions will jdbc open with DB to execute the query ?
will open one session and execute 10 query or one session for each query ?
my conf file
input {
jdbc {
jdbc_driver_library => "/opt/ojdbc7.jar"
jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
jdbc_connection_string => "jdbc:oracle:thin:@*:*/*"
jdbc_user => "*"
jdbc_password => "*"
schedule => "* * * * *"
statement => "select * from my table"
}
##############################################
input {
jdbc {
jdbc_driver_library => "/opt/ojdbc7.jar"
jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
jdbc_connection_string => "jdbc:oracle:thin:@*/*"
jdbc_user => "*"
jdbc_password => "*"
schedule => "* * * * *"
statement => "select * from my table"
}
}
}
filter {
uuid {
target => "uuid"
overwrite => true
}
}
output {stdout { codec => rubydebug }
elasticsearch { hosts => ["http://localhost:9200"]
data_stream => "true"
data_stream_type => "logs"
document_id => "%{uuid}"
user => "*"
password => "*"
}
}
thanks