Page History

Changing Default Datasource Settings

修改默认数据源设置

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 changes where necessary (anything from username, passwords. connection URLs, etc).
4. Save file and restart Joget.

Working with Datasource Profiles

1.   文件 (Joget安装目录中的 wflow 目录).
2. 使用文本编辑器打开.
3. 根据需要修改文件 (例如 username, passwords. 连接 URL等).
4. 保存文件，重启Joget.

使用Datasource Profiles文件切换数据库

如果您希望随时在不同的数据库之间切换，但又不想反复修改配置文件, 您可以利用多个数据源配置文件. 在您的Joget工作目录(/wflow), 默认有2个文件. app_datasource.properties 文件决定了当前有效的数据源配置文件, 您将可以看到另一个 If you're continually working with different datasource sets and don't want to keep commenting/uncommenting and/or renaming property files, you can make use of the profiles that are available. In your home directory, you'll (by default) find 2 files that deal with datasource settings. The app_datasource.properties file points to the current profile that should be used, and you'll see app_datasources-default.properties that should contain the details of your connection pools. To create a new profile, simply create a new properties file that is prefixed with  配置了数据库连接属性. 创建一个新的配置文件, 只要添加前缀 "app_datasources-". If our new datasource profile is called 例如我们新建一个数据源配置文件为 "mynewprofile" then we're looking at:我们将:

1. 在  wflow 创建一个名为 Create new file called app_datasources-mynewprofile.properties in your wflow directory 的文件yourdirectory (/home/myaccount in Linux and /Documents and Settings/myaccount in Windows).
2. Edit the file using a text editor and specify your connection settings. Save file when done.
3. 用文本编辑器修改数据库连接设置并保存.
4. 打开 Open app_datasources.properties and point your currentProfile to mynewprofile. Save file when donecurrentProfile指向mynewprofile并保存.
5. Restart Joget重启Joget.

Running on Other Databases

在其它数据库运行

Joget允许您使用默认MySQL以外的其它关系型数据库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:

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 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. 

提升表单/列表/用户界面/流程设计器元素数量限制

在Joget Workflow, 您所有的表单，列表，用户界面和流程设计都保存在数据库. 在设计中的元素数量会受到数据库字段类型的限制. 想提升限制, 您可以按以下方式实现. 

1. 提升 my.ini  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提升MySQL数据包大小限制,添加以下配置:

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提升列表设计限制; 运行以下SQL:

ALTER TABLE app_datalist CHANGE json json LONGTEXT;

5. Increase the limit of Userview Builder; run the following SQL提升用户界面设计限制; 运行以下SQL:

ALTER TABLE app_userview CHANGE json json LONGTEXT;

6. Increase the limit of Process Tool Plugin properties; run the following SQL提升流程工具和插件设计限制; 运行以下SQL:

ALTER TABLE app_package_activity_plugin CHANGE pluginProperties pluginProperties LONGTEXT;