Spring、HikariCP、Mybatis、Oracle 配置HikariCP数据库连接池

来源：互联网发布：led字幕软件编辑：程序博客网时间：2024/05/17 18:27

spring配置文件里，配置HikariCP数据库连接池

<bean id="hikariConfig" class="com.zaxxer.hikari.HikariConfig">    <property name="poolName" value="springHikariCP" />    <property name="connectionTestQuery" value="SELECT 1" />    <property name="dataSourceClassName" value="${hibernate.dataSourceClassName}" />    <property name="maximumPoolSize" value="${hibernate.hikari.maximumPoolSize}" />    <property name="idleTimeout" value="${hibernate.hikari.idleTimeout}" />    <property name="dataSourceProperties">        <props>            <prop key="url">${dataSource.url}</prop>            <prop key="user">${dataSource.username}</prop>            <prop key="password">${dataSource.password}</prop>        </props>    </property></bean>

<bean id="dataSource" class="com.zaxxer.hikari.HikariDataSource" destroy-method="close">    <constructor-arg ref="hikariConfig" /></bean>

HikariCP配置数据库信息

<bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">    <property name="locations">        <list>            <value>classpath:hibernate.properties</value>        </list>    </property></bean>

各个软件版本：
Obs.: the versions are
log4j: 1.2.16
springframework: 3.1.4.RELEASE
HikariCP: 1.4.0

数据库配置文件
Properties file (hibernate.properties):

hibernate.dataSourceClassName=oracle.jdbc.pool.OracleDataSourcehibernate.hikari.maximumPoolSize=10hibernate.hikari.idleTimeout=30000dataSource.url=jdbc:oracle:thin:@localhost:1521:xedataSource.username=admindataSource.password=

参照：https://stackoverflow.com/questions/23172643/how-to-set-up-datasource-with-spring-for-hikaricp

阅读全文

0 0