Hi
I using oracle database and performing DML operation using logstash. But getting syntax error in query.
input{
jdbc {
jdbc_driver_library => "{jdbc_path}"
jdbc_driver_class => "{oracle_driver}"
jdbc_connection_string => "{jdbc_url}"
jdbc_user => "{jdbc_username}"
jdbc_password => "{jdbc_password}"
statement => "Update Sch.Table1 Set TASK_STATUS_CD = 'SUCCESSFUL' WHERE FOLDER_NM = 'Search_Service11'; Commit"
#statement_filepath => "{delta_query}"
schedule => "{set_job}"
#jdbc_paging_enabled => true
#jdbc_page_size => 10000
}
}
output {
elasticsearch {
hosts => ["{elk_host}"]
index => "${search_index}"
document_id => "%{pers_rowid_object}"
}
stdout {
codec => rubydebug
}
Your help will be most appreciated.