Activiti-explorer using the SQL Server database implementation method _mssql

How to get Activiti-explorer to use a SQL Server database

The Activiti-explorer War file, downloaded from the official website, uses the H2 memory database by default, and if you want to use a different database for persistence, such as SQL Server, you need to configure the following.

1) Modify Db.properties file

Path:C:\apache-tomcat-7.0.64\webapps\activiti-explorer\WEB-INF\classes\db.properties

The contents are as follows:

Db=mssql
jdbc.driver=com.microsoft.sqlserver.jdbc.sqlserverdriver
jdbc.url=jdbc:sqlserver://localhost : 1433;databasename=activiti 
Jdbc.username=sa
jdbc.password=xxxx

2 to download the JDBC driver of SQL Server from Microsoft website;

Just search the search engine for keywords: SQL Server JDBC Driver

To find a connection to Microsoft website, I use the following:

Https://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx

Download SQL Server's JDBC Driver Compression pack: sqljdbc_4.0.2206.100_enu.tar.gz

Then copy the Sqljdbc4.jar to the Libs path of the Activiti-explorer:

C:\apache-tomcat-7.0.64\webapps\activiti-explorer\WEB-INF\lib

3 Confirm that SQL Server's TCP/IP connection is turned on

Use SQL Server Configuration Manager to open the TCP/IP connection for the instance, and then restart the SQL Server service.

4 Confirm that Windows Firewall has been shut down or that the port of SQL Server has been added to the exception;

5 Use SQL Server Manangement Studio to verify that the current instance's TCP/IP mode is turned on.

Use the following method if you can connect properly, the SQL Server TCP/IP connection configuration is successful

6 Create a database named Activiti;

7 After all OK, start Tomcat, you can start normally, and you can access Http://localhost:8080/activiti-explorer Connection

8 after Tomcat starts normally, Activiti-explorer automatically creates the related tables for the Activiti database and initializes the contents of the table as follows.

9) finished

But I'm trying. After importing BPMN files from the outside and deploying them, it is found that if there is Chinese in the BPMN file, all of these Chinese will be garbled after being imported into the database, and the problem is not resolved.

If it is a MySQL database, the corresponding steps are similar, download MySQL driver, modify the contents of Db.properties as follows:

Db=mysql
jdbc.driver=com.mysql.jdbc.driver
jdbc.url=jdbc:mysql://localhost:3306/activity
Jdbc.username=root
jdbc.password=123456

The above is the use of SQL Server database Activiti-explorer data collation, follow-up continue to supplement the relevant knowledge, thank you for your support for this site!