# Logstash jdbc plugin refresh new data **URL:** https://discuss.elastic.co/t/logstash-jdbc-plugin-refresh-new-data/35320 **Category:** Logstash **Created:** [November 23, 2015, 3:40pm UTC](https://discuss.elastic.co/t/logstash-jdbc-plugin-refresh-new-data/35320 "2015-11-23T15:40:41Z") **Posts on this page:** 3 **Page:** 1
### Author: ![Rishik\_Bahri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rishik_bahri/32/6110_2.png) [@Rishik\_Bahri](https://discuss.elastic.co/u/Rishik_Bahri) #### Post date: [November 23, 2015, 3:40pm UTC](https://discuss.elastic.co/t/logstash-jdbc-plugin-refresh-new-data/35320/1 "2015-11-23T15:40:41Z")
Hi, I am suing elasticsearch 1.7 with logstash 1.3 and trying to use Logstash to add new data added from an oracle database to a elasticsearch index. For this we are using the jdbc plugin but the refresh job doesnt seem to work. I am defining the following in my **config** file: schedule =\> "5 \* \* \* \*" last\_run\_metadata\_path =\> "/opt/logstash/bin/TIME/custom\_table.logstash\_jdbc\_last\_run" and the following in my **sql** to get the new data: select & from custom\_table WHERE TO\_TIMESTAMP(TO\_CHAR(TO\_TIMESTAMP\_TZ(LAST\_UPDATE\_DATE\_TIME,'DD-MONTH-YY HH:MI:SS.FF AM')AT TIME ZONE 'UTC', 'YYYY-MM-DD HH24:MI:SSXFF'), 'YYYY-MM-DD HH24:MI:SSXFF') \> :sql\_last\_start ---
### Author: ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm) #### Post date: [November 24, 2015, 3:57am UTC](https://discuss.elastic.co/t/logstash-jdbc-plugin-refresh-new-data/35320/2 "2015-11-24T03:57:45Z")
I don't believe the JDBC input will work with LS 1.3? ---
### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system) #### Post date: [July 6, 2017, 5:21am UTC](https://discuss.elastic.co/t/logstash-jdbc-plugin-refresh-new-data/35320/3 "2017-07-06T05:21:39Z")