# Using MySql database instead of H2!

**URL:** <https://community.ofelia.com/t/using-mysql-database-instead-of-h2/11032>\
**Category:** Q&A\
**Tags:** bonita-runtime\
**Created:** [5 December 2021 08:58 UTC](https://community.ofelia.com/t/using-mysql-database-instead-of-h2/11032 "2021-12-05T08:58:02Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![naaman.fallouh](https://avatars.discourse-cdn.com/v4/letter/n/a9adbd/32.png) [@naaman.fallouh](https://community.ofelia.com/u/naaman.fallouh)\
**Post date:** [5 December 2021 08:58 UTC](https://community.ofelia.com/t/using-mysql-database-instead-of-h2/11032/1 "2021-12-05T08:58:02Z")

</div>

Hi,

I'm new to Bonitasoft and needs my installation to use local Mysql server instead of default H2, Here is what I did so far:

1. Downloaded the **Bonita 2021.2** from here:&nbsp;https://www.bonitasoft.com/downloads and install it,
2. I created two databases:&nbsp; **bonita** and **business\_data** ,
3. I modified the file:&nbsp;_BonitaStudioCommunity-2021.2-u0/workspace/tomcat/setup/database.properties to use those databases_,
4. I also modified the file: _BonitaStudioCommunity-2021.2-u0/workspace/server\_configuration/conf/Catalina/localhost/bonita.xml&nbsp;to use those databases_,
5. and run the studio and **create a test BDM and deployed it** but couldn't see the effect in the MySql databases!

Is there another place or settings I should modify to make this works?

Best regards,

&nbsp;

---

<div class="post-metadata">

**Author:** ![naaman.fallouh](https://avatars.discourse-cdn.com/v4/letter/n/a9adbd/32.png) [@naaman.fallouh](https://community.ofelia.com/u/naaman.fallouh)\
**Post date:** [6 December 2021 12:38 UTC](https://community.ofelia.com/t/using-mysql-database-instead-of-h2/11032/2 "2021-12-06T12:38:11Z")

</div>

Hi,

I'm facing the following error i the log&nbsp;when starting the BonitaStudio and when trying to deploy a test BDM.

```
**06-Dec-2021 14:26:20.911 ERROR [http-nio-8080-exec-8] org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentImpl.sequenceInformationList Could not fetch the SequenceInformation from the database** _java.sql.SQLSyntaxErrorException: Unknown table 'SEQUENCES' in information\_schema at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ...._
```

What's wrong with my setup? Any help please!

Regards,

---

<div class="post-metadata">

**Author:** ![emmanuel.duchastenie](https://dub1.discourse-cdn.com/flex013/user_avatar/community.ofelia.com/emmanuel.duchastenie/32/723_2.png) [@emmanuel.duchastenie](https://community.ofelia.com/u/emmanuel.duchastenie)\
**Post date:** [5 October 2023 11:39 UTC](https://community.ofelia.com/t/using-mysql-database-instead-of-h2/11032/3 "2023-10-05T11:39:03Z")

</div>

Hi,

For now, only the Bonita Tomcat bundle (that you use in production or equivalent) can be configured to point to a&nbsp; **MySQL** &nbsp;database.

The Bonita Studio (used to develop) can only use&nbsp; **H2**.

I hope this clarifies what is supported in which environment.

Regards,  
Emmanuel