use HikariCP

Raysmond · Raysmond · commit 88bcff689101 · 2018-01-21T10:42:34.000+08:00
diff --git a/build.gradle b/build.gradle
@@ -57,6 +57,8 @@ dependencies {
     compile "org.hibernate:hibernate-core:5.2.12.Final"
     compile "org.hibernate:hibernate-entitymanager:5.2.12.Final"
     compile "org.hibernate:hibernate-validator"
+    compile "com.zaxxer:HikariCP:2.7.6"
+
 
     // JSON
     compile 'com.fasterxml.jackson.core:jackson-databind:2.4.1.3'
diff --git a/src/main/java/com/raysmond/blog/admin/controllers/UserController.java b/src/main/java/com/raysmond/blog/admin/controllers/UserController.java
@@ -1,5 +1,6 @@
 package com.raysmond.blog.admin.controllers;
 
+import com.raysmond.blog.error.NotFoundException;
 import com.raysmond.blog.forms.UserForm;
 import com.raysmond.blog.models.User;
 import com.raysmond.blog.repositories.UserRepository;
@@ -44,7 +45,10 @@ public String profile(Model model) {
     @RequestMapping(value = "{userId:[0-9]+}", method = POST)
     public String update(@PathVariable Long userId, @Valid UserForm userForm, Errors errors, RedirectAttributes ra) {
         User user = userRepository.findOne(userId);
-        Assert.notNull(user);
+
+        if (null == user) {
+            throw new NotFoundException("User " + userId + " is not found.");
+        }
 
         if (errors.hasErrors()) {
             // do something
diff --git a/src/main/resources/application-dev.yml b/src/main/resources/application-dev.yml
@@ -16,11 +16,17 @@ spring:
         show-sql: true
 
     datasource:
-      driver-class-name: com.mysql.jdbc.Driver
-      url: jdbc:mysql://127.0.0.1/spring_blog_dev?useUnicode=true&characterEncoding=utf8&useSSL=false
-      username: root
-      password:
+        type: com.zaxxer.hikari.HikariDataSource
+        url: jdbc:mysql://127.0.0.1/spring_blog_dev?useUnicode=true&characterEncoding=utf8&useSSL=false
+        username: root
+        password:
 
+        hikari:
+            data-source-properties:
+                cachePrepStmts: true
+                prepStmtCacheSize: 250
+                prepStmtCacheSqlLimit: 2048
+                useServerPrepStmts: true
     redis:
       host: localhost
       port: 6379
diff --git a/src/main/resources/application-prod.yml b/src/main/resources/application-prod.yml
@@ -12,10 +12,17 @@ spring:
         show-sql: false
 
     datasource:
-      driver-class-name: com.mysql.jdbc.Driver
-      url: jdbc:mysql://127.0.0.1/spring_blog_prod?useUnicode=true&characterEncoding=utf8&useSSL=false
-      username: root
-      password:
+        type: com.zaxxer.hikari.HikariDataSource
+        url: jdbc:mysql://127.0.0.1/spring_blog_prod?useUnicode=true&characterEncoding=utf8&useSSL=false
+        username: root
+        password:
+
+        hikari:
+            data-source-properties:
+                cachePrepStmts: true
+                prepStmtCacheSize: 250
+                prepStmtCacheSqlLimit: 2048
+                useServerPrepStmts: true
 
     redis:
       host: localhost
