# Full Scan in BD with jdbc

**URL:** <https://discuss.elastic.co/t/full-scan-in-bd-with-jdbc/161594>\
**Category:** Logstash\
**Created:** [December 19, 2018, 9:00pm UTC](https://discuss.elastic.co/t/full-scan-in-bd-with-jdbc/161594 "2018-12-19T21:00:41Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ISABEL\_CRISTINA\_L](https://avatars.discourse-cdn.com/v4/letter/i/d2c977/32.png) [@ISABEL\_CRISTINA\_L](https://discuss.elastic.co/u/ISABEL_CRISTINA_L)\
**Post date:** [December 19, 2018, 9:00pm UTC](https://discuss.elastic.co/t/full-scan-in-bd-with-jdbc/161594/1 "2018-12-19T21:00:41Z")

</div>

Hello.

I require your support with the following:

Through a database oracle from logstash, however it has not been possible to define a filter so that I do not make a complete scan to the database, you can indicate in favor how I can correct this topic.

input {  
jdbc {  
jdbc\_driver\_library =\> "/datos/jdbc/ojdbc6.jar"  
jdbc\_driver\_class =\> "Java::oracle.jdbc.driver.OracleDriver"  
jdbc\_connection\_string =\> "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS\_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XX.XX)(PORT=1521)))(CONNECT\_DATA=(SERVICE\_NAME=DEV11G)))"  
jdbc\_user =\> "XXX"  
jdbc\_password =\> "XXX"  
type =\> "Database"  
#statement\_filepath =\> "/datos/logstash/query/sim.sql"  
statement =\> " select id, TRANSACTION\_TYPE, msisdn, plu\_chip, imsi, sale\_type, plan\_id, FIRST\_DATE, LAST\_DATE, ID\_PROVIDER, STATUS, VENDOR\_CHANNEL\_ID from activator.transactions "

```
    use_column_value => true
    tracking_column => "id"
    tags => ["activador", "SIM"]
    schedule => "* * * * * *"
}

```

}

output {  
stdout { codec =\> rubydebug }  
#elasticsearch {  
# hosts =\> ["XX.XX.XX)

thanks for your help

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [January 16, 2019, 9:09pm UTC](https://discuss.elastic.co/t/full-scan-in-bd-with-jdbc/161594/2 "2019-01-16T21:09:43Z")

</div>

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