MySQL Database for EF

Using MySQL DB instead of Derby DB

To use MySQL instead of Derby, please follow these steps:

  1. To install and configure the DB , please follow the documentation at
    Note: If you do not know how to setup MySQL, please check:
  2. Download the respective JBDC connector for your Linux distro at
    • Extract the file and copy the jar file to $EF_ROOT/[version]/enginframe/WEBAPP/WEB-INF/lib/
      Remeber to change $EF_ROOT to enginframe base path. And [version] to your EnginFrame version.
      Note: If you installed the .deb or .rpm, probably the jar will be stored in:
  3. Edit the $EF_ROOT/conf/enginframe.conf DERBY_CONFIGURED:
  4. Edit the file $EF_ROOT/conf/enginframe/server.conf and set the following parameters:
  5. Restart the EnginFrame
    systemctl restart enginframe
  6. Then check the systemd logs:
    journalctl -u enginframe.service

Important: If you created a database with character set different of latin1, you need to fix that:

You can review this configuration with the command below (check character_set_database):

MariaDB [EnginFrameDB]> show variables like 'char%';
| Variable_name            | Value                      |
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | latin1                     |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |

Using MariaDB over Derby

You can follow the same MySQL procedure.

To setup MariaDB, you can download and install with this script (for any Linux distro):

curl -LsS | sudo bash