You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Current »

修改默认数据源设置

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

使用Datasource Profiles文件切换数据库

如果您希望随时在不同的数据库之间切换，但又不想反复修改配置文件, 您可以利用多个数据源配置文件. 在您的Joget工作目录(/wflow), 默认有2个文件. app_datasource.properties 文件决定了当前有效的数据源配置文件, 您将可以看到另一个 app_datasources-default.properties 配置了数据库连接属性. 创建一个新的配置文件, 只要添加前缀 "app_datasources-". 例如我们新建一个数据源配置文件为 "mynewprofile" 我们将:

  1. 在  wflow 创建一个名为 app_datasources-mynewprofile.properties 的文件yourdirectory (/home/myaccount in Linux and /Documents and Settings/myaccount in Windows).
  2. 用文本编辑器修改数据库连接设置并保存.
  3. 打开 app_datasources.properties currentProfile指向mynewprofile并保存.
  4. 重启Joget.

在其它数据库运行

Joget允许您使用默认MySQL以外的其它关系型数据库:

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. 

The steps outlined below are applicable to MySQL database only. Please consult your database administrator for 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 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;
  • No labels