Convert database connection pool to HIKARICP

HIKARICP claims to be the fastest, today to change over to try

1. Modify the configuration file

2. <!--Hikari Datasource--
4. <Bean id= "dataSource" class="Com.zaxxer.hikari.HikariDataSource" destroy-method= "Shutdown">
6. <property name= "driverclassname" value="${jdbc.driver}" /> <!--No need to specify, Unless the system does not automatically identify
8. <property name="Jdbcurl" value="${jdbc.url}" />
10. <property name="username" value="${jdbc.username}" />
12. <property name="password" value="${jdbc.password}" />
14. <!--configured to True when connecting to a read-only database, guaranteed security -
16. <property name="readOnly" value= "false" />
18. <!--The maximum length of time (in milliseconds) to wait for a connection pool to allocate a connection, a connection that exceeds the length of time that is not available SqlException, default: 30 Seconds--
20. <property name= "connectiontimeout" value="30000" />
22. <!--The maximum length of time (in milliseconds) for a connected idle state, and the timeout is released (retired), default: 10 minutes --
24. <property name= "idleTimeout" value="600000" />
26. <!--The lifetime of a connection (milliseconds), timed out and not being used is released (retired), default: 30 minutes, recommended setting is 30 seconds less than database timeout, refer to mysql wait_timeout parameter (show variables Like '%timeout% ';) --
28. <property name= "maxlifetime" value="1800000" />
30. <!--The maximum number of connections allowed in the connection pool. Default value: 10; Recommended formula: ((Core_count * 2) + effective_spindle_count)- -
32. <property name= "maximumpoolsize" value= " /> "
34. </Bean>

2. Load the jar package 

2. <dependency>
4. <groupId>com.zaxxer</groupId>
6. <artifactid>hikaricp</artifactid>
8. <version>2.4.6</version>
10. <scope>compile</scope>
12. </Dependency>

This is the end, but after the start error, and no connection on

3. Replace the Oracle package (the database is using Oracle)

2. <dependency>
4. <groupId>com.oracle</groupId>
6. <artifactid>ojdbc6</artifactid>
8. <version>${oracle.driver.version}</version>
10. <scope>runtime</scope>
12. </Dependency>

1. <oracle.driver.version>11.2.0.3</oracle.driver.version>

Used to be oracle14, use the Times wrong link is not on.

Convert database connection pool to HIKARICP