# Logstash jdbc\_static types doesn't work (longtext, tinyint...)

**URL:** <https://discuss.elastic.co/t/logstash-jdbc-static-types-doesnt-work-longtext-tinyint/282497>\
**Category:** Logstash\
**Created:** [August 25, 2021, 2:31pm UTC](https://discuss.elastic.co/t/logstash-jdbc-static-types-doesnt-work-longtext-tinyint/282497 "2021-08-25T14:31:11Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Atesrin](https://avatars.discourse-cdn.com/v4/letter/a/e19b73/32.png) [@Atesrin](https://discuss.elastic.co/u/Atesrin)\
**Post date:** [August 25, 2021, 2:31pm UTC](https://discuss.elastic.co/t/logstash-jdbc-static-types-doesnt-work-longtext-tinyint/282497/1 "2021-08-25T14:31:11Z")

</div>

Hi,

I would like to know if there is some place where I can find some information about the accepted types for jdbc\_static ?  
From what I see on websites only "varchar" seems accepted, but I have some longtext, tinyint data to integrate and it's not working.

```auto
local_db_objects => [
       {
         name => "local_users"
         index_columns => ["id"]
         columns => [
           ["id", "INTEGER"],
           ["first_name", "varchar(255)"],
           ["last_name", "varchar(255)"],
           ["email", "varchar(255)"],
           ["champ1", "longtext"], -> not working
           ["champ2", "tinyint(1)"] -> also not working
         ]
       },

```

What can I do for these types ?

Thanks

---

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [August 25, 2021, 2:50pm UTC](https://discuss.elastic.co/t/logstash-jdbc-static-types-doesnt-work-longtext-tinyint/282497/2 "2021-08-25T14:50:18Z")

</div>

> [@Atesrin](#):
>
> I would like to know if there is some place where I can find some information about the accepted types for jdbc\_static ?

The filter [documentation](https://www.elastic.co/guide/en/logstash/current/plugins-filters-jdbc_static.html) says they are [Derby](https://db.apache.org/derby/docs/10.14/ref/crefsqlj31068.html) types. They are the types used for the in-memory Derby DB used to cache data, not the types in the source DB.

---

<div class="post-metadata">

**Author:** ![Atesrin](https://avatars.discourse-cdn.com/v4/letter/a/e19b73/32.png) [@Atesrin](https://discuss.elastic.co/u/Atesrin)\
**Post date:** [August 25, 2021, 2:58pm UTC](https://discuss.elastic.co/t/logstash-jdbc-static-types-doesnt-work-longtext-tinyint/282497/3 "2021-08-25T14:58:33Z")

</div>

Great ! thank you so much, I missed this precious information.  
That's perfect for me.

---

<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:** [September 22, 2021, 2:58pm UTC](https://discuss.elastic.co/t/logstash-jdbc-static-types-doesnt-work-longtext-tinyint/282497/4 "2021-09-22T14:58:48Z")

</div>

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