Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. We will need to first obtain the "mssql-jdbc_auth-9.4.0.x64.dll" file needed for integrated authentication.
    Since Joget DX 7.0.24, MSSQL JDBC driver version 9.4.0.jre8 is shipped by default, therefore it is advisable to use the dll file of the same version.
    Download from the direct link https://github.com/microsoft/mssql-jdbc/releases/download/v9.4.0/mssql-jdbc_auth.zip
  2. Unzip, and find "x64\mssql-jdbc_auth-9.4.0.x64.dll". Place it into a location accessible by Joget, i.e. "C:\Joget-DX7DX8-Enterprise\wflow\library"
  3. Edit "joget-start.bat" and append "-Djava.library.path=./wflow/library" into JAVA_OPTS.

    Your joget-start.bat may look like this now. (Line 12)
    Please take note that line "-javaagent:./wflow/glowroot/glowroot.jar" must be placed at the end too.

    Code Block
    languagebash
    titlejoget-start.bat
    linenumberstrue
    @ECHO OFF
    
    REM Start MariaDB
    ECHO == Starting MariaDB ==
    ECHO.
    CALL .\mariadb-start.bat
    ECHO.
    
    REM Start Tomcat
    set JAVA_HOME=.\jre11.0.2
    set CATALINA_HOME=.\apache-tomcat-8.5.65
    set JAVA_OPTS=-Xmx768M -Dwflow.home=./wflow/ -javaagent:./wflow/aspectjweaver-1.8.5.jar -Djava.library.path=./wflow/library -javaagent:./wflow/glowroot/glowroot.jar
    REM set JAVA_OPTS=-XX:MaxPermSize=128m -Xmx1024M -Xdebug -Xnoagent -Djava.compiler=NONE -Xrunjdwp:transport=dt_socket,suspend=n,server=y,address=5115 -Dwflow.home=./wflow/ -javaagent:./wflow/aspectjweaver-1.8.5.jar -javaagent:./wflow/glowroot/glowroot.jar
    ECHO == Starting Tomcat from %CATALINA_HOME% ==
    ECHO.
    %CATALINA_HOME%\bin\catalina.bat run
    Note
    iconfalse
    Note: If your Joget server runs as Windows service, then you will need to launch tomcat8w.exe to configure JAVA_OPTS variable accordingly.
  4. Initialize your mssql database instance with Joget's base tables.
    Navigate and import the file

    here to

    in the specified directory below into your database, using your database client of choice: 

    Info
    iconfalse
    <Your Joget folder>\apache-tomcat-<version number>\webapps\jw\WEB-INF\classes\setup\sql\jwdb-mssql.sql
  5. Create a new datasource profile file inside the "wflow" folder.
    Here's sample content.

    Code Block
    languagebash
    titleapp_datasource-mssql.properties
    linenumberstrue
    workflowDriver=com.microsoft.sqlserver.jdbc.SQLServerDriver
    workflowUrl=jdbc\:sqlserver\://localhost\:1433;SelectMethod\=direct;DatabaseName\=jwdb;integratedSecurity\=true
    workflowPassword=
    workflowUser=sa
    Note
    iconfalse
    Note: The value in "workflowUser" is not being used but it is a required field.
    You can
    Simply key in any value here.
  6. Change your datasource to point to your new profile. 
    inside the same folder, open "app_datasource.properties" and edit the line "currentProfile=default" to "currentProfile=mssql" or "currentProfile=<name>" where <name> is the name you used for your newly created datasource profile above.

  7. Start Joget server and test.

...