Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "how Activiti-Explorer uses sql server database". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

How to make Activiti-Explorer use sql server Database

The internal war file of Activiti-explorer downloaded from the official website uses H3 in-memory database by default. If you want to use other databases for persistence, such as sql server, you need to do the following configuration.

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=mssqljdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriverjdbc.url=jdbc:sqlserver://localhost:1433;databaseName=activiti jdbc.username=sajdbc.password=xxxx

2) download sql server's jdbc driver from Microsoft's official website

Just search for the keyword on the search engine: sql server jdbc driver

To find a connection to Microsoft's official website, I used:

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

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

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

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

3) confirm that the tcp/ip connection mode of sql server is turned on

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

4) confirm that the windows firewall is turned off, or the port of sql server 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 you can connect normally by using the following method, it means that the TCP/IP connection mode of sql server is configured successfully.

6) create a database named activiti

7) after all ok, start tomcat, you can start normally, and you can access the http://localhost:8080/activiti-explorer connection

8) after tomcat starts normally, activiti-explorer automatically creates relevant tables for the activiti database and initializes the contents of the tables, as shown below.

9) over

However, after trying to import the bpmn file from the outside and deploy it, I found that if there is Chinese inside the bpmn file, all these Chinese will show garbled codes after they are imported into the database. This problem has not been solved for the time being.

If it is a mysql database, the corresponding steps are similar. Download the mysql driver and modify the content of db.properties as follows:

This is the end of db=mysqljdbc.driver=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql://localhost:3306/activityjdbc.username=rootjdbc.password=123456 's "how to use the sql server database with Activiti-Explorer". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.