Logstash deleting records from Db Table after running logstash.conf file

Elastic Stack Logstash
1

HI all,
I am using ORACLE Db in my case.

I have created a sample table with user_id and names as the only 2 columns in them.

I inserted some 2 records with these values([(1,"sam"),(2,"smith") and so on ]).
I try to execute the logstash.conf file with this structure

input {
    jdbc {
        jdbc_connection_string => "jdbc:oracle:thin:@host:port/XE"
        jdbc_user => "username"
	jdbc_password => "password"
        jdbc_driver_library => "/home/tomadm/JatinSandbox/KibanaDbTry/ojdbc7.jar"
        jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
	#jdbc_validate_connection => true
        statement => "select * from metable"
    }

}
output {
    stdout { codec => json_lines }
	elasticsearch {
	index => "batchre"
	hosts => "http://my_ip:port"
	document_type => "Batchdoc"
	}
}

Now after I run this conf file. I see the table in database is rendered empty.
Can anyone suggest what could be the error?

2

try this, hope this helps, change the details to OracleDB connection details,

3

Logstash is not emptying your database table. You should look elsewhere.

4

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