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

Compare with Current View Page History

« Previous Version 2 Next »

We have tested Joget Workflow v3 with Microsoft SQL Server 2005. However, if you have found any issue, please feel free to [inform the community through forum discussion|FORUM:Running Joget Workflow with SQL Server].
# Create a database in SQL Server, name it as jwdb (or other preferred database name).
# Make sure that you grant the intended database user with sufficient access to "jwdb".
# Download jwdb_mssql.sql, and load this SQL file to "jwdb". This will populate all necessary Joget Workflow table structure into "jwdb".

  1. In joget-installation-directory/wflow/, create a new datasource profile file - app_datasource-mssql.properties
  2. Open to edit joget-installation-directory/wflow/datasource-mssql.properties in text editor, and insert contents as shown in Figure 1 below. You may need to edit the configurations (such as datasource URL, database user/password) according to your environment.
  3. Open to edit joget-installation-directory/wflow/app_datasource.properties in text editor, and change the content to as shown in Figure 2 below. This is to activate the datasource profile named "mssql".
  4. Restart Joget Workflow server.

Figure 1: Datasource Profile Configurations

workflowDriver=com.microsoft.sqlserver.jdbc.SQLServerDriver
workflowUrl=jdbc\:sqlserver\://host\:1433;DatabaseName\=jwdb;SelectMethod\=cursor
workflowUser=username
workflowPassword=password

You may need to change the datasource URL, database user, and database user's password accordingly.

Figure 2: datasource.properties

currentProfile=mssql

Enabling TCP/IP on Microsoft SQL Server 2005

In order to connect to the Microsoft SQL Server remotely (such as JDBC datasource), TCP/IP needs to be enabled. This is disabled by default on Microsoft SQL Server 2005 Express edition. TCP/IP may also be manually disabled on other editions of Microsoft SQL Server 2005.

To enable TCP/IP on Microsoft SQL Server 2005:

  1. From the Microsoft SQL Server 2005 -> Configuration Tools, open the 'Microsoft SQL Server Configuration Manager'.
  2. Expand ‘SQL Server 2005 Network Configuration’, and then click ‘Protocols for <Instance Name>’.  <Instance Name> is the name of the database instance used by Joget Workflow.
  3. Right-click ‘TCP/IP’ and then click ‘Enable’. The icon for the protocol will change to show that the protocol is enabled.
  • No labels