Activiti-Explorer uses the SQL server database implementation method, activitiexplorer

Activiti-Explorer uses the SQL server database implementation method, activitiexplorer

How to enable Activiti-Explorer to use the SQL server database

The war file of Activiti-explorer downloaded from the official website uses the h2 memory database by default. If you want to use another database for persistence, such as SQL server, you need to make the following configuration.

1) modify the db. properties File

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

The content is as follows:

db=mssqljdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriverjdbc.url=jdbc:sqlserver://localhost:1433;databaseName=activiti jdbc.username=sajdbc.password=xxxx

2) download the SQL server jdbc driver from the Microsoft website;

Search for keywords on the search engine: SQL server jdbc driver

Find the connection on the official Microsoft website and I am using:

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

Download the jdbc driver package of sqlserver: sqljdbc_4.0.2206.100_enu.tar.gz

Copy sqljdbc4.jar to the libs path of Activiti-explorer:

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

3) check whether the SQL server TCP/IP connection mode is enabled.

Use SQL server configuration manager to open the TCP/IP connection of the instance, and then restart the SQL server service.

 

4) check whether the windows Firewall has been disabled or the SQL server port has been added to the special case;

5) use SQL server manangement studio to verify whether the TCP/IP mode of the current instance is enabled.

If the following method can be used for normal connection, it indicates that the SQL server TCP/IP connection method is successfully configured.

 

6) Create a database named activiti;

7) after all are OK, start tomcat, which can be started normally and accessedHttp: // localhost: 8080/activiti-explorerConnection

8) after tomcat is started normally, activiti-explorer will automatically create related tables for the activiti database and initialize the table content as follows.

9) finished

However, after I tried to import the bpmn file from external sources and deploy it, I found that if the bpmn file contains Chinese characters, all these Chinese characters will be garbled after being imported to the database, this problem has not been solved yet.

For a mysql database, the corresponding steps are similar. Download the mysql driver and modify db. properties as follows:

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

The above is to sort out the data of Activiti-Explorer using the SQL server database. We will continue to add relevant knowledge in the future. Thank you for your support for this site!