在代码中修改了数据源配置。

jeesun · jeesun · commit 17fe05247735 · 2017-04-12T21:23:46.000+08:00
diff --git a/src/main/java/com/simon/config/DataSourceConfig.java b/src/main/java/com/simon/config/DataSourceConfig.java
@@ -1,5 +1,6 @@
 package com.simon.config;
 
+import com.alibaba.druid.pool.DruidDataSource;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.context.annotation.Bean;
 import org.springframework.context.annotation.Configuration;
@@ -9,6 +10,7 @@
 
 import javax.sql.DataSource;
 
+
 /**
  * Created by simon on 2017/2/20.
  */
@@ -18,12 +20,21 @@ public class DataSourceConfig {
     private Environment env;
 
     @Bean
-    public DataSource dataSource() {
-        DriverManagerDataSource dataSource = new DriverManagerDataSource();
+    public DruidDataSource dataSource() {
+//        DriverManagerDataSource dataSource = new DriverManagerDataSource();
+        DruidDataSource dataSource = new DruidDataSource();
         dataSource.setDriverClassName(env.getProperty("spring.datasource.driver-class-name"));
         dataSource.setUrl(env.getProperty("spring.datasource.url"));
         dataSource.setUsername(env.getProperty("spring.datasource.username"));
         dataSource.setPassword(env.getProperty("spring.datasource.password"));
+        dataSource.setMaxActive(20);
+        dataSource.setInitialSize(1);
+        dataSource.setMaxWait(60000);
+        dataSource.setMinIdle(3);
+        dataSource.setRemoveAbandoned(true);
+        dataSource.setRemoveAbandonedTimeout(180);
+        dataSource.setConnectionProperties("clientEncoding=UTF-8");
+        dataSource.setTestWhileIdle(false);
         return dataSource;
     }
 
diff --git a/src/main/java/com/simon/config/OAuthSecurityConfig.java b/src/main/java/com/simon/config/OAuthSecurityConfig.java
@@ -1,5 +1,6 @@
 package com.simon.config;
 
+import com.alibaba.druid.pool.DruidDataSource;
 import com.netflix.discovery.converters.Auto;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.context.annotation.Bean;
@@ -30,7 +31,7 @@ public class OAuthSecurityConfig extends AuthorizationServerConfigurerAdapter {
     private UserDetailsService userDetailsService;
 
     @Autowired
-    private DataSource dataSource;
+    private DruidDataSource dataSource;
 
     @Override
     public void configure(ClientDetailsServiceConfigurer clients) throws Exception {
diff --git a/src/main/java/com/simon/config/ServerSecurityConfig.java b/src/main/java/com/simon/config/ServerSecurityConfig.java
@@ -1,5 +1,6 @@
 package com.simon.config;
 
+import com.alibaba.druid.pool.DruidDataSource;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.context.annotation.Bean;
 import org.springframework.context.annotation.Configuration;
@@ -21,7 +22,7 @@
 @Configuration
 public class ServerSecurityConfig extends WebSecurityConfigurerAdapter {
     @Autowired
-    private DataSource dataSource;
+    private DruidDataSource dataSource;
 
     @Override
     @Bean
