# Logstash deleting records from Db Table after running logstash.conf file **URL:** \ **Category:** Logstash\ **Created:** [October 29, 2018, 9:13am UTC](https://discuss.elastic.co/t/logstash-deleting-records-from-db-table-after-running-logstash-conf-file/154405 "2018-10-29T09:13:11Z")\ **Posts on this page:** 1\ **Showing post:** 2
**Author:** ![balumurari1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/balumurari1/32/39203_2.png) [@balumurari1](https://discuss.elastic.co/u/balumurari1)\ **Post date:** [October 29, 2018, 11:46am UTC](https://discuss.elastic.co/t/logstash-deleting-records-from-db-table-after-running-logstash-conf-file/154405/2 "2018-10-29T11:46:45Z")
try this, hope this helps, change the details to OracleDB connection details, > [@Handling duplicates from SQL Dumps/json and API response in Logstash](https://discuss.elastic.co/t/handling-duplicates-from-sql-dumps-json-and-api-response-in-logstash/154351/3): > > use scheduler, so that it will update the data for every 1 minute as shown below, The input code is fine, in the output did you mention elasticsearch to get the result, Try this, input { jdbc { jdbc\_driver\_library =\> "xxxx\oracle-10g\ojdbc14.jar" jdbc\_driver\_class =\> "oracle.jdbc.driver.OracleDriver" jdbc\_connection\_string =\> "jdbc:oracle:thin:@localhost:1521:DATABASE" jdbc\_user =\> "ROMAINROM" jdbc\_password =\> "ROMAINROM" statement =\> "SELECT TOP 10 \* FROM TABLE" jdbc\_paging\_enabled =\>… --- _[View the full topic](https://discuss.elastic.co/t/logstash-deleting-records-from-db-table-after-running-logstash-conf-file/154405)._