Configure a Custom Database

Joget allows you to change the default datasource settings, work with multiple data source profiles, and run Joget on databases other than the default MySQL. Whether managing a single data source or multiple sets, this article will provide the steps to configure and optimize your Joget setup effectively.

Changing the default datasource settings

To modify Joget's default datasource settings, follow the steps below:

1. Locate your app_datasource-default.properties file in your wflow directory (/home/myaccount in Linux and /Documents and Settings/myaccount in Windows).
2. Open file using any text editor.
3. Make the necessary changes (usernames, passwords, or connection URLs).
4. Save the file and restart Joget.

Working with datasource profiles

If you're frequently working with different datasource sets and want to avoid the hassle of constantly commenting/uncommenting and renaming property files, you can use the available profiles. In your home directory, you'll typically find two files that manage datasource settings:

• The app_datasource.properties file points to the current profile that should be used.
• The app_datasources-default.properties file contains the details of your connection pools.

To create a new profile, follow the steps below:

1. Create a new file called app_datasources-mynewprofile.properties in your wflow directory (/home/myaccount in Linux and /Documents and Settings/myaccount in Windows)
2. Edit the file using a text editor and specify your connection settings.
3. Save the file when done.
4. Open app_datasources.properties and point your currentProfile to mynewprofile.
5. Save the file.
6. Restart Joget.

Running on other databases

Joget allows you to run on databases other than the default MySQL that comes with the bundle, such as:

• Enabling TCP/IP for MS SQL Server
• Preparing database on oracle
• Using Windows Authentication for Microsoft SQL Server

Enabling TCP/IP for MS SQL Server

To run Joget on MSSQL, you need to enable the TCP/IP ports. To do so, follow the steps below:

1. Open SQL Server Configuration Manager.
2. Go to SQL Server Network Configuration> Protocols for SQL Express.
3. Enable Named Pipes and TCP/IP.
   
4. Right-click on TCP/IP and select Properties
5. Go to the IP2 section, and set your local IP Address in IP Address.
6. Remove TCP Dynamic Ports value. 
   
7. Go to the IPAll section. 
8. Empty TCP Dynamic Ports value.
9. Set TCP Port value to 1433
   

10. Restart the server so the changes take effect.

11. Verify that the listener works through the command prompt by executing netstat -ao
    
    

12. Check which process instance is listening to the port by executing tasklist /fi "pid eq 4488"


Now, your MSSQL server can run with Joget. You can also set Windows authentication for it, see Using Windows Authentication for Microsoft SQL Server for more information.

Preparing database on oracle

To set up an Oracle database with Joget, follow the steps below:

1. Create a database schema in Oracle with the appropriate permissions and name it jwdb (or another preferred name).

   CREATE USER jwdb IDENTIFIED BY jwdb;
   GRANT connect, resource TO jwdb;
   GRANT create session TO jwdb;
   GRANT create table TO jwdb;
     
   GRANT UNLIMITED TABLESPACE TO jwdb;

2. Proceed with Set Up a Database.

After following the steps, your Oarracle database will be ready to use with Joget.

Increase the limit of items/elements in form/datalist/userview builder and process builder

In Joget Workflow, all your designed forms, datalists, userviews and also the process flows are stored in the database. The number of items/elements you can add to your builder is actually limited by the database column that stores the definition of your design. To increase the limit, you can do the following steps for each builder. 

1. Increase the max_allowed_packet setting in my.ini of MySQL for huge data. At the end of the my.ini file content, add this line:
   

   max_allowed_packet=32M

2. Increase the limit of Process Builder (Workflow Designer); run the following SQL:
   

   ALTER TABLE SHKXPDLData CHANGE XPDLContent XPDLContent LONGBLOB;
   ALTER TABLE SHKXPDLData CHANGE XPDLClassContent XPDLClassContent LONGBLOB;

3. Increase the limit of Form Builder; run the following SQL:
   

   ALTER TABLE app_form CHANGE json json LONGTEXT;

4. Increase the limit of Datalist Builder; run the following SQL:
   

   ALTER TABLE app_datalist CHANGE json json LONGTEXT;

5. Increase the limit of Userview Builder; run the following SQL:
   

   ALTER TABLE app_userview CHANGE json json LONGTEXT;

6. Increase the limit of Process Tool Plugin properties; run the following SQL:
   

   ALTER TABLE app_package_activity_plugin CHANGE pluginProperties pluginProperties LONGTEXT;

Joget DX on MySQL 8

Joget DX supports MySQL 8 database as Joget comes preinstalled with MariaDB drivers v2.5.0 to support MySQL 8 default caching_sha2_password authentication.