# Support for embedded databases

**URL:** <https://forum.keycloak.org/t/support-for-embedded-databases/9143>\
**Category:** Configuring the server\
**Tags:** database\
**Created:** [May 20, 2021, 5:17am UTC](https://forum.keycloak.org/t/support-for-embedded-databases/9143 "2021-05-20T05:17:37Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mallikarjun](https://avatars.discourse-cdn.com/v4/letter/m/7993a0/32.png) [@Mallikarjun](https://forum.keycloak.org/u/Mallikarjun)\
**Post date:** [May 20, 2021, 5:17am UTC](https://forum.keycloak.org/t/support-for-embedded-databases/9143/1 "2021-05-20T05:17:37Z")

</div>

Does keycloak support embedded databases like Apache Derby or hsqldb?

---

<div class="post-metadata">

**Author:** ![xgp](https://yyz2.discourse-cdn.com/free1/user_avatar/forum.keycloak.org/xgp/32/2589_2.png) [@xgp](https://forum.keycloak.org/u/xgp)\
**Post date:** [May 20, 2021, 3:53pm UTC](https://forum.keycloak.org/t/support-for-embedded-databases/9143/2 "2021-05-20T15:53:35Z")

</div>

hsqldb is the default. If you run it without a database configuration, it automatically uses hsqldb.

---

<div class="post-metadata">

**Author:** ![Mallikarjun](https://avatars.discourse-cdn.com/v4/letter/m/7993a0/32.png) [@Mallikarjun](https://forum.keycloak.org/u/Mallikarjun)\
**Post date:** [May 20, 2021, 4:55pm UTC](https://forum.keycloak.org/t/support-for-embedded-databases/9143/3 "2021-05-20T16:55:23Z")

</div>

I think the default database is H2, not hsqldb.

---

<div class="post-metadata">

**Author:** ![xgp](https://yyz2.discourse-cdn.com/free1/user_avatar/forum.keycloak.org/xgp/32/2589_2.png) [@xgp](https://forum.keycloak.org/u/xgp)\
**Post date:** [May 20, 2021, 5:14pm UTC](https://forum.keycloak.org/t/support-for-embedded-databases/9143/4 "2021-05-20T17:14:01Z")

</div>

My mistake. I always confuse the two because of the overlapping history.

hsqldb doesn’t look to be supported by default, but there is a step-by-step guide for setting up a JDBC data source here:

[https://www.keycloak.org/docs/latest/server\_installation/#\_database](https://www.keycloak.org/docs/latest/server_installation/#_database)

---

<div class="post-metadata">

**Author:** ![Mallikarjun](https://avatars.discourse-cdn.com/v4/letter/m/7993a0/32.png) [@Mallikarjun](https://forum.keycloak.org/u/Mallikarjun)\
**Post date:** [May 20, 2021, 5:22pm UTC](https://forum.keycloak.org/t/support-for-embedded-databases/9143/5 "2021-05-20T17:22:52Z")

</div>

I followed the instructions to integrate keycloak with Apache Derby, I ran into db upgrade issues.  
I found this comment in line 107. So I wanted to check with community if there are some know limitations that prevents integration with Apache Derby

 ![image](https://global.discourse-cdn.com/free1/uploads/keycloak/original/2X/6/6a2a9e96b0519f6fdcf4b99abffec95602161487.png)

> <https://github.com/keycloak/keycloak/blob/main/model/jpa/src/main/java/org/keycloak/connections/jpa/updater/liquibase/lock/CustomLockService.java>