Page History

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. English
   We will need to first obtain the "mssql-jdbc_auth-9.4.0.x64.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)"

   . 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 "sqljdbc_9.4\enu\auth\x64\mssql-jdbc_auth-9.4.0.x64.dll". Copy it and paste it in Place it into 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. (Line 12)
   Please take note that line "-javaagent:./wflow/glowroot/glowroot.jar" must be placed at the end too.

   Code Block
   language bash title joget-start.bat linenumbers true
   @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.

   Code Block
   language bash title app_datasource-mssql.properties linenumbers true
   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.

...