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

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

1) Modify the Db.properties file path: C:\apache-tomcat-7.0.64\webapps\activiti-explorer\WEB-INF\classes\db.properties content is as follows:

db=mssqljdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriverjdbc.url=jdbc:sqlserver:  jdbc.username= sajdbc.password =xxxx 

2) Download the JDBC driver for SQL Server from Microsoft website; just search the search engine for keywords: SQL Server JDBC driver find the Microsoft website connection, I am using: https://msdn.microsoft.com/en-us/ sqlserver/aa937724.aspx Download the JDBC Driver Compression pack for SQL Server: sqljdbc_4.0.2206.100_enu.tar.gz and then Sqljdbc4.jar Copy the Libs path to Activiti-explorer: C:\APACHE-TOMCAT-7.0.64\WEBAPPS\ACTIVITI-EXPLORER\WEB-INF\LIB3) to confirm the tcp/of SQL Server 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) Verify that Windows Firewall is turned off, or that the port of SQL Server has been added to a special case, 5) Use SQL Server Manangement Studio to verify that the TCP/IP mode of the current instance is turned on. Use the following method if the connection can be normal, it means that the TCP/IP connection mode of SQL Server is configured successfully 6) Create a database named Activiti, 7) After OK, start Tomcat, can start normally, and 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 the BPMN file externally and deploying it, it is found that if there is Chinese in the BPMN file, all of these Chinese characters will be garbled after being imported into the database, and this problem is not solved yet.

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

db=mysqljdbc.driver=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql://localhost:3306/ Activityjdbc.username=rootjdbc.password=123456

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