Skip to end of metadata
Go to start of metadata

Environment:-

  • Both Joget DX 7 and MSSQL 2019 are installed in the same Windows 10 operating system.
  • Joget DX 7 uses "mssql-jdbc version 9.4.0.jre8" JDBC driver.

Steps:-

  1. We will need to first obtain the dll file needed for integrated authentication. Go to https://github.com/microsoft/mssql-jdbc, scroll down to "Download the DLLs" to obtain the link to Microsoft Download Center. At the point of writing, the link is https://docs.microsoft.com/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server. Download the zip by clicking on "Download Microsoft JDBC Driver 9.4 for SQL Server (zip)"
  2. Unzip, and find "sqljdbc_9.4\enu\auth\x64\mssql-jdbc_auth-9.4.0.x64.dll". Copy it and paste it in a location accessible by Joget, i.e. "C:\Joget-DX7-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.

    joget-start.bat
    @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: If your Joget server runs as Windows service, then you will need to launch tomcat8w.exe to configure JAVA_OPTS variable accordingly.

  4. Create a new datasource profile file inside the "wflow" folder.
    Here's sample content.

    app_datasource-mssql.properties
    workflowDriver=com.microsoft.sqlserver.jdbc.SQLServerDriver
    workflowUrl=jdbc\:sqlserver\://localhost\:1433;SelectMethod\=direct;DatabaseName\=jwdb;integratedSecurity\=true
    workflowPassword=
    workflowUser=sa

    Note: The value in "workflowUser" is not being used but it is a required field. You can key in any value here.

  5. Start Joget server and test.


  • No labels