前往小程序,Get更优阅读体验!
立即前往
首页
学习
活动
专区
工具
TVP
发布
社区首页 >专栏 >Spring boot · 链接池配置

Spring boot · 链接池配置

作者头像
netkiller old
发布2018-03-05 17:17:44
8640
发布2018-03-05 17:17:44
举报
文章被收录于专栏:Netkiller

本文节选自《Netkiller Java 手札》

http://www.netkiller.cn/java/spring/boot/index.html

10.16. Connection and Statement Pooling

注意:下面的实例仅限 Spring boot 1.3.0.RELEASE

10.16.1. org.apache.tomcat.jdbc.pool.DataSource

默认连接池,可以忽略配置

代码语言:javascript
复制
spring.datasource.type = org.apache.tomcat.jdbc.pool.DataSource			

10.16.2. druid

pom.xml

代码语言:javascript
复制
		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>druid</artifactId>
			<version>1.0.24</version>
		</dependency>			

application.properties

代码语言:javascript
复制
			spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.initialSize=5
spring.datasource.minIdle=5
spring.datasource.maxActive=20
spring.datasource.maxWait=60000
spring.datasource.timeBetweenEvictionRunsMillis=60000 
spring.datasource.minEvictableIdleTimeMillis=300000
spring.datasource.validationQuery=SELECT 1 FROM DUAL
spring.datasource.testWhileIdle=true
spring.datasource.testOnBorrow=false
spring.datasource.testOnReturn=false 
spring.datasource.poolPreparedStatements=true
spring.datasource.maxPoolPreparedStatementPerConnectionSize=20
spring.datasource.filters=stat,wall,log4j
spring.datasource.connectionProperties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
#spring.datasource.useGlobalDataSourceStat=true		

spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://192.168.6.1:3306/test
spring.datasource.username=inf
spring.datasource.password=inf
spring.jpa.database=MYSQL			

10.16.3. c3p0 - JDBC3 Connection and Statement Pooling

pom.xml

代码语言:javascript
复制
		<dependency>
		    <groupId>org.hibernate</groupId>
		    <artifactId>hibernate-c3p0</artifactId>
		    <version>4.3.6.Final</version>
		</dependency>
		<dependency>
		    <groupId>c3p0</groupId>
		    <artifactId>c3p0</artifactId>
		    <version>0.9.1.2</version>
		</dependency>			

application.properties

代码语言:javascript
复制
			spring.datasource.type=com.mchange.v2.c3p0.ComboPooledDataSource			

10.16.4. dbcp2

代码语言:javascript
复制
			spring.datasource.type = org.apache.commons.dbcp2.BasicDataSource			

10.16.5. bonecp

代码语言:javascript
复制
			spring.datasource.type = com.jolbox.bonecp.BoneCPDataSource		

10.16.6. dbcp2

代码语言:javascript
复制
			spring.datasource.type = org.apache.commons.dbcp2.BasicDataSource			
本文参与 腾讯云自媒体同步曝光计划,分享自微信公众号。
原始发表:2016-09-03,如有侵权请联系 cloudcommunity@tencent.com 删除

本文分享自 Netkiller 微信公众号,前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

本文参与 腾讯云自媒体同步曝光计划  ,欢迎热爱写作的你一起参与!

评论
登录后参与评论
0 条评论
热度
最新
推荐阅读
目录
  • 10.16. Connection and Statement Pooling
    • 10.16.1. org.apache.tomcat.jdbc.pool.DataSource
      • 10.16.2. druid
        • 10.16.3. c3p0 - JDBC3 Connection and Statement Pooling
          • 10.16.4. dbcp2
            • 10.16.5. bonecp
              • 10.16.6. dbcp2
              领券
              问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档