在仅使用ibatis时,多数据源简直就是梦魇,每多一个数据源就需要多一份sql-map-config配置文件。
采用spring的AbstractRoutingDataSourc
AbstractRoutingDataSourc
下面是一个完整的配置:
Xml代码
- <</span>beans
xmlns="http://www.springframework.org/schema/beans" -
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" -
xmlns:aop="http://www.springframework.org/schema/aop" -
xmlns:tx="http://www.springframework.org/schema/tx" -
xmlns:jee="http://www.springframework.org/schema/jee" -
xsi:schemaLocation=" -
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd -
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd -
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd -
http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-2.5.xsd"> -
-
-
-
<</span>jee:jndi-lookup id="ds0" jndi-name="jdbc/ds0"/> -
<</span>jee:jndi-lookup id="ds1" jndi-name="jdbc/ds1"/> -
<</span>jee:jndi-lookup id="ds2" jndi-name="jdbc/ds2"/> -
-
<</span>bean id="dataSource" class="com.xxx.xxx.util.DynamicDataSource"> -
<</span>property name="targetDataSources"> -
<</span>map key-type="java.lang.String"> -
<</span>entry key="0" value-ref="ds0"/> -
<</span>entry key="1" value-ref="ds1"/> -
<</span>entry key="2" value-ref="ds2"/> -
</</span>map> -
</</span>property> -
<</span>property name="defaultTargetDataSource" ref="1"/> -
</</span>bean> -
-
<</span>bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean"> -
<</span>property name="dataSource" ref="dataSource"/> -
<</span>property name="configLocation" value="classpath:com/xxx/xxx/dao/sqlmap/sql-map-config.xml"/> -
</</span>bean> -
<</span>bean id="testDAO" class="com.xxx.xxx.dao.impl.TestDAO"> -
<</span>property name="sqlMapClient" ref="sqlMapClient"/> -
</</span>bean> -
<</span>bean id="testService" class="com.xxx.xxx.service.impl.TestService"> -
<</span>property name="testDAO" ref="testDAO"/> -
</</span>bean> - </</span>beans>
其核心是DynamicDataSource,代码如下
Java代码
- package
com.xxx.xxx.util; -
- import
org.apache.log4j.Logger; - import
org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSourc e; -
- public
class DynamicDataSource extends AbstractRoutingDataSourc e { -
-
static Logger log = Logger.getLogger("DynamicDataSource"); -
@Override -
protected Object determineCurrentLookupKe y() { -
// TODO Auto-generated method stub -
return DbContextHolder.getDbType(); -
} -
- }
上下文DbContextHolder为一线程安全的ThreadLocal,如下
Java代码
- package
com.xxx.xxx.util; -
- public
class DbContextHolder { -
private static final ThreadLocal contextHolder = new ThreadLocal(); -
-
public static void setDbType(String dbType) { -
contextHolder.set(dbType); -
} -
-
public static String getDbType() { -
return (String) contextHolder.get(); -
} -
-
public static void clearDbType() { -
contextHolder.remove(); -
} - }
sql-map-config.xml如下
Xml代码