# How to use the jdbc\_static plugin?

**URL:** <https://discuss.elastic.co/t/how-to-use-the-jdbc-static-plugin/164355>\
**Category:** Logstash\
**Created:** [January 15, 2019, 6:47pm UTC](https://discuss.elastic.co/t/how-to-use-the-jdbc-static-plugin/164355 "2019-01-15T18:47:46Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![roblopes](https://avatars.discourse-cdn.com/v4/letter/r/b77776/32.png) [@roblopes](https://discuss.elastic.co/u/roblopes)\
**Post date:** [January 15, 2019, 6:47pm UTC](https://discuss.elastic.co/t/how-to-use-the-jdbc-static-plugin/164355/1 "2019-01-15T18:47:46Z")

</div>

Hi,

I did some tests with the jdbc\_static plugin, and it is working fine, however it is not 100% clear to me how to use it in my pipelines.

Adding the jdbc\_static block with loaders, local\_db\_objects and local\_lookups in the configuration that will consume the lookup data, will not it load the memory every time a log/message arrives? That would be bad.

I'm assuming that the plugin is smart enough to load the data into memory when the first log/message is sent to the pipeline, and the following logs/messages won't load again, just consuming from memory. When the configured loader\_schedule time is reached, then it will l load the data.

Is that right?

Thanks,  
Rob

---

<div class="post-metadata">

**Author:** ![yaauie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yaauie/32/23363_2.png) [@yaauie](https://discuss.elastic.co/u/yaauie)\
**Post date:** [January 15, 2019, 9:13pm UTC](https://discuss.elastic.co/t/how-to-use-the-jdbc-static-plugin/164355/2 "2019-01-15T21:13:52Z")

</div>

The answers to all of those questions (and more) is available in the plugin's documentation:

> This filter works by fetching data from a remote database, caching it in a local, in-memory [Apache Derby](https://db.apache.org/derby/manuals/#docs_10.14) database, and using lookups to enrich events with data cached in the local database. You can set up the filter to load the remote data once (for static data), or you can schedule remote loading to run periodically (for data that needs to be refreshed).
> 
> -- [JDBC Static Filter Documentation](https://www.elastic.co/guide/en/logstash/current/plugins-filters-jdbc_static.html#_description_122)

---

<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:** [February 12, 2019, 9:26pm UTC](https://discuss.elastic.co/t/how-to-use-the-jdbc-static-plugin/164355/3 "2019-02-12T21:26:30Z")

</div>

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