DB sessions | logstash

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

The inputs are independent from each other, so if you have 20 jdbc inputs, it will be 20 connections to your database.

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