# Logstash doesn't apply my ES Template when I upload data

**URL:** https://discuss.elastic.co/t/logstash-doesnt-apply-my-es-template-when-i-upload-data/153813
**Category:** Logstash
**Created:** [October 24, 2018, 1:37pm UTC](https://discuss.elastic.co/t/logstash-doesnt-apply-my-es-template-when-i-upload-data/153813 "2018-10-24T13:37:04Z")
**Posts on this page:** 1
**Showing post:** 6

<div class="post-metadata">

### 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 25, 2018, 7:30am UTC](https://discuss.elastic.co/t/logstash-doesnt-apply-my-es-template-when-i-upload-data/153813/6 "2018-10-25T07:30:56Z")

</div>

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 =\> "true"  
jdbc\_page\_size =\> "50000"  
}

}

output{  
elasticsearch { codec =\> json hosts =\> ["localhost:9200"] index =\> "index9" }  
stdout { codec =\> rubydebug }  
}

---

_[View the full topic](https://discuss.elastic.co/t/logstash-doesnt-apply-my-es-template-when-i-upload-data/153813)._