@c95mbq - It is a bit unclear to me if the above errors are related to the stripped-down configuration file or another configuration file (before stripping-down the information).
- Let's do one test. Use the following configuration:
input {
jdbc {
jdbc_driver_library => "E:\Oracle\client64\product\12.1.0\client_1\jdbc\lib\ojdbc6.jar"
jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
jdbc_connection_string => "jdbc:oracle:thin:@5oracle.mydomain.net:1521/prod.WORLD"
jdbc_user => "USERNAME"
jdbc_password => "PASSWORD"
jdbc_validate_connection => true
jdbc_paging_enabled => true
jdbc_page_size => "100000"
statement => "select o.order_id as id, o.status as status, to_char(o.updt_dt_tm, 'dd/mm/yyyy hh24:mi') as UPDT_DT_TM from orders o where o.order_id = 105994115.000000;"
}
}
output {
stdout { }
}
and run logstash --debug -f e:\logstash-7.1.1\bin\ncv.conf
. If you observe a similar error, please share the entire debug logs with us.
-
I assume that the
statement
is a valid SQL statement. Please check that this statement executes successfully against your database. -
Please also share the
logstash.yml
file and the JVM version you are using.
Thank you.