# How to save 'sql\_last\_value' in between reading pages in jdbc-input plugin?

**URL:** <https://discuss.elastic.co/t/how-to-save-sql-last-value-in-between-reading-pages-in-jdbc-input-plugin/192558>\
**Category:** Logstash\
**Created:** [July 28, 2019, 10:19am UTC](https://discuss.elastic.co/t/how-to-save-sql-last-value-in-between-reading-pages-in-jdbc-input-plugin/192558 "2019-07-28T10:19:33Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mahmoud1468](https://avatars.discourse-cdn.com/v4/letter/m/c37758/32.png) [@mahmoud1468](https://discuss.elastic.co/u/mahmoud1468)\
**Post date:** [July 28, 2019, 10:19am UTC](https://discuss.elastic.co/t/how-to-save-sql-last-value-in-between-reading-pages-in-jdbc-input-plugin/192558/1 "2019-07-28T10:19:33Z")

</div>

Hi,

I have enabled paging ("jdbc\_paging\_enabled" =\> true) in "JDBC-INPUT" plugin in a Logstash pipeline.  
I would like to save 'sql\_last\_value' at the end of each page instead of the whole query.  
Is there any way to do that?

I am running this plugin to read a database having over a hundred millions of records and it is most likely that the PC or Logstash service shuts down, e.g. because of electricity cut or etc, before the query has already finished, though many pages have been fetched and they are done.

Thanks in advance  
Mojtaba

---

<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:** [August 25, 2019, 10:19am UTC](https://discuss.elastic.co/t/how-to-save-sql-last-value-in-between-reading-pages-in-jdbc-input-plugin/192558/2 "2019-08-25T10:19:36Z")

</div>

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