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

Source: Internet
Author: User

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!

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.