Repository: apache/incubator-shardingsphere (java)

Issue:
Upgrade several dependencies to jdk8 version
Since we upgrade project jdk version to jdk8, there several dependencies still are compatible packages with jdk7.
- hikariCP-java7:2.4.11  -> hikariCP:3.4.2, the latest release version.
- postgresql:42.2.5.jre7  -> postgresql:42.2.5, the java8 version of the origin.
- mssql:6.1.7.jre7-preview  -> mssql:6.1.7.jre8-preview, the java8 version of the origin.
- examples/docker, java7  -> java8

Cause consider compatibility, we just upgrade hikariCP to the latest version.

Pull request description:
upgrade dependencies to jdk8
Fixes #4907 .

Changes proposed in this pull request:
- Upgrade several dependencies to jdk8 version 


Patch:
diff --git a/encrypt-core/encrypt-core-rewrite/pom.xml b/encrypt-core/encrypt-core-rewrite/pom.xml
index 0f63298a1e5..692ecd2c61c 100644
--- a/encrypt-core/encrypt-core-rewrite/pom.xml
+++ b/encrypt-core/encrypt-core-rewrite/pom.xml
@@ -88,7 +88,7 @@
         </dependency>
         <dependency>
             <groupId>com.zaxxer</groupId>
-            <artifactId>HikariCP-java7</artifactId>
+            <artifactId>HikariCP</artifactId>
         </dependency>
     </dependencies>
 </project>
diff --git a/examples/docker/sharding-proxy/sharding/docker-compose.yml b/examples/docker/sharding-proxy/sharding/docker-compose.yml
index 017d9e21612..3618379eb1d 100644
--- a/examples/docker/sharding-proxy/sharding/docker-compose.yml
+++ b/examples/docker/sharding-proxy/sharding/docker-compose.yml
@@ -36,7 +36,7 @@ services:
 
   proxy:
     ## get more versions of proxy here : https://hub.docker.com/r/shardingsphere/sharding-proxy/tags
-    image: "shardingsphere/sharding-proxy:3.1.0"
+    image: "shardingsphere/sharding-proxy:4.0.1"
     container_name: sharding-sphere-proxy
     depends_on:
      - mysql
diff --git a/pom.xml b/pom.xml
index 65d95fdf07e..4ab7b5ef959 100644
--- a/pom.xml
+++ b/pom.xml
@@ -98,13 +98,13 @@
         <mockito.version>2.7.21</mockito.version>
         <logback.version>1.2.0</logback.version>
         
-        <hikari-cp.version>2.4.11</hikari-cp.version>
+        <hikari-cp.version>3.4.2</hikari-cp.version>
         <commons-dbcp2.version>2.2.0</commons-dbcp2.version>
         <commons-pool.version>1.6</commons-pool.version>
         <h2.version>1.4.196</h2.version>
         <mysql-connector-java.version>5.1.47</mysql-connector-java.version>
-        <postgresql.version>42.2.5.jre7</postgresql.version>
-        <mssql.version>6.1.7.jre7-preview</mssql.version>
+        <postgresql.version>42.2.5</postgresql.version>
+        <mssql.version>6.1.7.jre8-preview</mssql.version>
         <mariadb-java-client.version>2.4.2</mariadb-java-client.version>
 
         <!-- Plugin versions -->
@@ -406,7 +406,7 @@
             
             <dependency>
                 <groupId>com.zaxxer</groupId>
-                <artifactId>HikariCP-java7</artifactId>
+                <artifactId>HikariCP</artifactId>
                 <version>${hikari-cp.version}</version>
                 <scope>test</scope>
             </dependency>
diff --git a/shadow-core/shadow-core-rewrite/pom.xml b/shadow-core/shadow-core-rewrite/pom.xml
index 5faa01b4dcf..6ac2fcb8853 100644
--- a/shadow-core/shadow-core-rewrite/pom.xml
+++ b/shadow-core/shadow-core-rewrite/pom.xml
@@ -88,7 +88,7 @@
         </dependency>
         <dependency>
             <groupId>com.zaxxer</groupId>
-            <artifactId>HikariCP-java7</artifactId>
+            <artifactId>HikariCP</artifactId>
         </dependency>
     </dependencies>
 </project>
diff --git a/sharding-core/database-time-service/pom.xml b/sharding-core/database-time-service/pom.xml
index c15180bedef..1955bb85757 100644
--- a/sharding-core/database-time-service/pom.xml
+++ b/sharding-core/database-time-service/pom.xml
@@ -35,7 +35,7 @@
         
         <dependency>
             <groupId>com.zaxxer</groupId>
-            <artifactId>HikariCP-java7</artifactId>
+            <artifactId>HikariCP</artifactId>
             <scope>test</scope>
         </dependency>
         <dependency>
diff --git a/sharding-core/sharding-core-common/pom.xml b/sharding-core/sharding-core-common/pom.xml
index 04b8e835262..345d01e04d7 100644
--- a/sharding-core/sharding-core-common/pom.xml
+++ b/sharding-core/sharding-core-common/pom.xml
@@ -68,7 +68,7 @@
         </dependency>
         <dependency>
             <groupId>com.zaxxer</groupId>
-            <artifactId>HikariCP-java7</artifactId>
+            <artifactId>HikariCP</artifactId>
         </dependency>
     </dependencies>
 </project>
diff --git a/sharding-core/sharding-core-rewrite/pom.xml b/sharding-core/sharding-core-rewrite/pom.xml
index 8f2468d3acb..e47c414535d 100644
--- a/sharding-core/sharding-core-rewrite/pom.xml
+++ b/sharding-core/sharding-core-rewrite/pom.xml
@@ -86,7 +86,7 @@
         </dependency>
         <dependency>
             <groupId>com.zaxxer</groupId>
-            <artifactId>HikariCP-java7</artifactId>
+            <artifactId>HikariCP</artifactId>
         </dependency>
     </dependencies>
 </project>
diff --git a/sharding-core/sharding-core-route/pom.xml b/sharding-core/sharding-core-route/pom.xml
index f0c28c90d68..0e4fe746c59 100644
--- a/sharding-core/sharding-core-route/pom.xml
+++ b/sharding-core/sharding-core-route/pom.xml
@@ -76,7 +76,7 @@
         </dependency>
         <dependency>
             <groupId>com.zaxxer</groupId>
-            <artifactId>HikariCP-java7</artifactId>
+            <artifactId>HikariCP</artifactId>
         </dependency>
     </dependencies>
 </project>
diff --git a/sharding-distribution/sharding-proxy-distribution/pom.xml b/sharding-distribution/sharding-proxy-distribution/pom.xml
index d50726e6690..6dd44386a85 100644
--- a/sharding-distribution/sharding-proxy-distribution/pom.xml
+++ b/sharding-distribution/sharding-proxy-distribution/pom.xml
@@ -35,7 +35,7 @@
         
         <dependency>
             <groupId>com.zaxxer</groupId>
-            <artifactId>HikariCP-java7</artifactId>
+            <artifactId>HikariCP</artifactId>
             <scope>compile</scope>
         </dependency>
         
diff --git a/sharding-distribution/sharding-proxy-distribution/src/main/docker/Dockerfile b/sharding-distribution/sharding-proxy-distribution/src/main/docker/Dockerfile
index c45dc0ffce1..4da4267f9c1 100644
--- a/sharding-distribution/sharding-proxy-distribution/src/main/docker/Dockerfile
+++ b/sharding-distribution/sharding-proxy-distribution/src/main/docker/Dockerfile
@@ -15,7 +15,7 @@
 # limitations under the License.
 #
 
-FROM java:7
+FROM java:8
 MAINTAINER ShardingSphere "dev@shardingsphere.incubator.apache.org"
 
 ENV CURRENT_VERSION 5.0.0-RC1
diff --git a/sharding-distribution/sharding-scaling-distribution/pom.xml b/sharding-distribution/sharding-scaling-distribution/pom.xml
index 0c5884f36f8..89c0a3252d3 100644
--- a/sharding-distribution/sharding-scaling-distribution/pom.xml
+++ b/sharding-distribution/sharding-scaling-distribution/pom.xml
@@ -34,7 +34,7 @@
         </dependency>
         <dependency>
             <groupId>com.zaxxer</groupId>
-            <artifactId>HikariCP-java7</artifactId>
+            <artifactId>HikariCP</artifactId>
             <scope>compile</scope>
         </dependency>
     </dependencies>
diff --git a/sharding-jdbc/sharding-jdbc-core/pom.xml b/sharding-jdbc/sharding-jdbc-core/pom.xml
index 9d840b30e6d..2139c7591e1 100644
--- a/sharding-jdbc/sharding-jdbc-core/pom.xml
+++ b/sharding-jdbc/sharding-jdbc-core/pom.xml
@@ -46,7 +46,7 @@
         
         <dependency>
             <groupId>com.zaxxer</groupId>
-            <artifactId>HikariCP-java7</artifactId>
+            <artifactId>HikariCP</artifactId>
         </dependency>
         <dependency>
             <groupId>org.apache.commons</groupId>
diff --git a/sharding-jdbc/sharding-jdbc-orchestration/pom.xml b/sharding-jdbc/sharding-jdbc-orchestration/pom.xml
index 632ecfea739..4bc870b5bf4 100644
--- a/sharding-jdbc/sharding-jdbc-orchestration/pom.xml
+++ b/sharding-jdbc/sharding-jdbc-orchestration/pom.xml
@@ -63,7 +63,7 @@
         </dependency>
         <dependency>
             <groupId>com.zaxxer</groupId>
-            <artifactId>HikariCP-java7</artifactId>
+            <artifactId>HikariCP</artifactId>
         </dependency>
         <dependency>
             <groupId>org.apache.commons</groupId>
diff --git a/sharding-proxy/sharding-proxy-backend/pom.xml b/sharding-proxy/sharding-proxy-backend/pom.xml
index d17b63ff0ad..515ce9d05ee 100644
--- a/sharding-proxy/sharding-proxy-backend/pom.xml
+++ b/sharding-proxy/sharding-proxy-backend/pom.xml
@@ -45,7 +45,7 @@
         
         <dependency>
             <groupId>com.zaxxer</groupId>
-            <artifactId>HikariCP-java7</artifactId>
+            <artifactId>HikariCP</artifactId>
             <scope>compile</scope>
         </dependency>
         
diff --git a/sharding-proxy/sharding-proxy-bootstrap/pom.xml b/sharding-proxy/sharding-proxy-bootstrap/pom.xml
index e2d298a3f3c..177140830a8 100644
--- a/sharding-proxy/sharding-proxy-bootstrap/pom.xml
+++ b/sharding-proxy/sharding-proxy-bootstrap/pom.xml
@@ -84,7 +84,7 @@
         </dependency>
         <dependency>
             <groupId>com.zaxxer</groupId>
-            <artifactId>HikariCP-java7</artifactId>
+            <artifactId>HikariCP</artifactId>
             <scope>compile</scope>
         </dependency>
         <dependency>
diff --git a/sharding-proxy/sharding-proxy-common/pom.xml b/sharding-proxy/sharding-proxy-common/pom.xml
index a892bc11529..08d54d1e759 100644
--- a/sharding-proxy/sharding-proxy-common/pom.xml
+++ b/sharding-proxy/sharding-proxy-common/pom.xml
@@ -49,7 +49,7 @@
         </dependency>
         <dependency>
             <groupId>com.zaxxer</groupId>
-            <artifactId>HikariCP-java7</artifactId>
+            <artifactId>HikariCP</artifactId>
             <scope>compile</scope>
         </dependency>
     </dependencies>
diff --git a/sharding-scaling/sharding-scaling-bootstrap/pom.xml b/sharding-scaling/sharding-scaling-bootstrap/pom.xml
index f230112e57a..bf8a5d1df97 100644
--- a/sharding-scaling/sharding-scaling-bootstrap/pom.xml
+++ b/sharding-scaling/sharding-scaling-bootstrap/pom.xml
@@ -72,7 +72,7 @@
         
         <dependency>
             <groupId>com.zaxxer</groupId>
-            <artifactId>HikariCP-java7</artifactId>
+            <artifactId>HikariCP</artifactId>
             <scope>compile</scope>
         </dependency>
         
diff --git a/sharding-scaling/sharding-scaling-core/pom.xml b/sharding-scaling/sharding-scaling-core/pom.xml
index 13c0b596312..f1c79a6c29d 100644
--- a/sharding-scaling/sharding-scaling-core/pom.xml
+++ b/sharding-scaling/sharding-scaling-core/pom.xml
@@ -41,7 +41,7 @@
         </dependency>
         <dependency>
             <groupId>com.zaxxer</groupId>
-            <artifactId>HikariCP-java7</artifactId>
+            <artifactId>HikariCP</artifactId>
             <scope>compile</scope>
         </dependency>
         
diff --git a/sharding-spring/pom.xml b/sharding-spring/pom.xml
index 829963aff24..4c1b3014d32 100644
--- a/sharding-spring/pom.xml
+++ b/sharding-spring/pom.xml
@@ -36,7 +36,7 @@
     <dependencies>
         <dependency>
             <groupId>com.zaxxer</groupId>
-            <artifactId>HikariCP-java7</artifactId>
+            <artifactId>HikariCP</artifactId>
         </dependency>
         <dependency>
             <groupId>org.apache.commons</groupId>
diff --git a/sharding-transaction/sharding-transaction-2pc/sharding-transaction-xa/sharding-transaction-xa-core/pom.xml b/sharding-transaction/sharding-transaction-2pc/sharding-transaction-xa/sharding-transaction-xa-core/pom.xml
index a69cdd6f87f..797cc99d018 100644
--- a/sharding-transaction/sharding-transaction-2pc/sharding-transaction-xa/sharding-transaction-xa-core/pom.xml
+++ b/sharding-transaction/sharding-transaction-2pc/sharding-transaction-xa/sharding-transaction-xa-core/pom.xml
@@ -53,7 +53,7 @@
         
         <dependency>
             <groupId>com.zaxxer</groupId>
-            <artifactId>HikariCP-java7</artifactId>
+            <artifactId>HikariCP</artifactId>
         </dependency>
         <dependency>
             <groupId>org.apache.commons</groupId>
diff --git a/shardingsphere-underlying/shardingsphere-common/pom.xml b/shardingsphere-underlying/shardingsphere-common/pom.xml
index 9d0892e1281..98044f5132b 100644
--- a/shardingsphere-underlying/shardingsphere-common/pom.xml
+++ b/shardingsphere-underlying/shardingsphere-common/pom.xml
@@ -60,7 +60,7 @@
         </dependency>
         <dependency>
             <groupId>com.zaxxer</groupId>
-            <artifactId>HikariCP-java7</artifactId>
+            <artifactId>HikariCP</artifactId>
         </dependency>
         <dependency>
             <groupId>org.apache.commons</groupId>


Test patch:
diff --git a/sharding-integration-test/sharding-jdbc-test/pom.xml b/sharding-integration-test/sharding-jdbc-test/pom.xml
index f2244c92c6f..e2b84549679 100644
--- a/sharding-integration-test/sharding-jdbc-test/pom.xml
+++ b/sharding-integration-test/sharding-jdbc-test/pom.xml
@@ -42,7 +42,7 @@
     
         <dependency>
             <groupId>com.zaxxer</groupId>
-            <artifactId>HikariCP-java7</artifactId>
+            <artifactId>HikariCP</artifactId>
         </dependency>
         <dependency>
             <groupId>org.apache.commons</groupId>