| Table of Contents |
|---|
Changing Default Datasource Settings
- Stop tomcat server.
- Locate your app_datasource-default.properties file in your wflow directory (/home/myaccount in Linux and /Documents and Settings/myaccount in Windows).
- Open file using any text editor.
- Make changes where necessary (anything from username, passwords. connection URLs, etc).
- Save file and restart Joget.
Note: Connecting to an existing database will not affect that database data. Joget will just create the db connection values and save it into the .properties file.
Working with Datasource Profiles
...
Joget also allows you to run on databases apart from the default MySQL that comes with the bundle. For information on how to make those connections, refer to the resources below:
| Children Display |
|---|
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 in to your builder /designer is actually limited by the database column that store the definition of your design. To increase the limit, you can do the following steps for each builder/designer.
| Note |
|---|
Below The steps outlined below are applied applicable to MySQL database only. Please refer to consult your database administrator for the necessary step for others database. steps pertaining to other databases. |
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 the this line below:
| Code Block |
|---|
max_allowed_packet=32M |
2. Increase the limit of Process Builder (Workflow Designer, ); run the following SQL:
| Code Block |
|---|
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:
| Code Block |
|---|
ALTER TABLE app_form CHANGE json json LONGTEXT; |
4. Increase the limit of Datalist Builder, ; run the following SQL:
| Code Block |
|---|
ALTER TABLE app_datalist CHANGE json json LONGTEXT; |
5. Increase the limit of Userview Builder, ; run the following SQL:
| Code Block |
|---|
ALTER TABLE app_userview CHANGE json json LONGTEXT; |
6. Increase the limit of Process Tool Plugin properties; run the following SQL:
| Code Block |
|---|
ALTER TABLE app_package_activity_plugin CHANGE pluginProperties pluginProperties LONGTEXT; |