mybatis配置JDBCPool连接池,废话不说,直接上文。
1.创建一个自己的数据源工厂类实现 org.apache.ibatis.datasource.DataSourceFactory
添加属性
注意属性要用连接池提供的数据源对象:
org.apache.tomcat.jdbc.pool.DataSource dataSource;
/**
* JDBCPOOL的实现类
*
* @author Frank
* @date 2013-1-5 JDBCPoolDataSourceFactory.java
*/
public class JDBCPoolDataSourceFactory implements DataSourceFactory {
private static final String DRIVER_PROPERTY_PREFIX = "driver.";
private static final int DRIVER_PROPERTY_PREFIX_LENGTH = DRIVER_PROPERTY_PREFIX.length();
// 定义数据源
private DataSource dataSource;
/**
* 构造器
*/
public JDBCPoolDataSourceFactory() {
dataSource = new DataSource();
}
/**
* 获取JDBCPOOL数据源
*/
@Override
public DataSource getDataSource() {
return dataSource;
}
/**
* 对JDBCPOOL属性值进行设置
*/
@Override
public void setProperties(Properties properties) {
// 设置数据库驱动类名称
Properties driverProperties = new Properties();
MetaObject metaDataSource = MetaObject.forObject(dataSource);
for (Object key : properties.keySet()) {
String propertyName = ( String ) key;
if (propertyName.startsWith(DRIVER_PROPERTY_PREFIX)) {
String value = properties.getProperty(propertyName);
driverProperties.setProperty(propertyName.substring(DRIVER_PROPERTY_PREFIX_LENGTH), value);
} else if (metaDataSource.hasSetter(propertyName)) {
String value = ( String ) properties.get(propertyName);
Object convertedValue = convertValue(metaDataSource, propertyName, value);
metaDataSource.setValue(propertyName, convertedValue);
} else {
throw new DataSourceException("Unknown DataSource property: " + propertyName);
}
}
if (driverProperties.size() > 0) {
metaDataSource.setValue("driverProperties", driverProperties);
}
}
private Object convertValue(MetaObject metaDataSource, String propertyName, String value) {
Object convertedValue = value;
Class< ? > targetType = metaDataSource.getSetterType(propertyName);
if (targetType == Integer.class || targetType == int.class) {
convertedValue = Integer.valueOf(value);
} else if (targetType == Long.class || targetType == long.class) {
convertedValue = Long.valueOf(value);
} else if (targetType == Boolean.class || targetType == boolean.class) {
convertedValue = Boolean.valueOf(value);
}
return convertedValue;
}
2.完成mybatis数据源配置文件mybatis-config.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration> <environments default="development"> <environment id="development"> <transactionManager type="JDBC"/> <dataSource type="com.shdy.db.JDBCPoolDataSourceFactory"> <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/> <property name="url" value="jdbc:oracle:thin:@10.21.17.11:1521:XX"/> <property name="username" value="XXXX"/> <property name="password" value="XXXX"/> <property name="testWhileIdle" value="true" /> <property name="testOnBorrow" value="true" /> <property name="testOnReturn" value="false" /> <property name="validationQuery" value="SELECT 1 FROM SYSIBM.SYSDUMMY1" /> <property name="validationInterval" value="30000" /> <property name="timeBetweenEvictionRunsMillis" value="30000" /> <property name="maxActive" value="50" /> <property name="maxIdle" value="30" /> <property name="minIdle" value="10" /> <property name="maxWait" value="5000" /> <property name="initialSize" value="5" /> <property name="removeAbandonedTimeout" value="36000" /> <property name="removeAbandoned" value="true" /> <property name="logAbandoned" value="true" /> <property name="minEvictableIdleTimeMillis" value="30000" /> <property name="jmxEnabled" value="true" /> <property name="jdbcInterceptors" value="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer" /> </dataSource> </environment> </environments> <mappers> <mapper resource="com/shdy/db/sql/User.xml"/> </mappers> </configuration>
注意: <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>