spring结合mybatis多数据源
spring 中以配置多个数据源，利用mybatis实现sql语句
现在取出一个数据库，执行sql语句没有问题，但取出第二个时，不能执行sql语句了，提示java.sql.Connection - xxx Connection Closed怎么办
我的配置文件如下：
<bean id="ds1" class="org.springframework.jdbc.datasource.DriverManagerDataSource" >
<property name="driverClassName">
<value>com.mysql.jdbc.Driver</value>
</property>
<property name="url">
<value>jdbc:MYSQL://127.0.0.1:3306/MYGPS_SY?characterEncoding=utf8</value>
</property>
<property name="username">
<value>root</value>
</property>
<property name="password">
<value>root</value>
</property>
</bean>
<bean id="ds2" class="org.springframework.jdbc.datasource.DriverManagerDataSource" >
<property name="driverClassName">
<value>com.mysql.jdbc.Driver</value>
</property>
<property name="url">
<value>jdbc:MYSQL://127.0.0.1:3306/MYGPS_AS?characterEncoding=utf8</value>
</property>
<property name="username">
<value>root</value>
</property>
<property name="password">
<value>root</value>
</property>
</bean>
<!-- 数据管理 -->
<bean id="transactionmanager1" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="ds1"/>
</bean>
<bean id="s1" class="org.mybatis.spring.SqlSessionFactoryBean" >
<property name="mapperLocations" value="classpath:gpsData/transform/dao/GpsDao.xml" ></property>
<property name="dataSource" ref="ds1"/>
</bean>
<bean id="gpsdao1" class="org.mybatis.spring.MapperFactoryBean">
<property name="mapperInterface" value="gpsData.transform.dao.GpsDao"/>
<property name="SqlSessionFactory" ref="s1"/>
</bean>
<bean id="transactionmanager2" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="ds2"/>
</bean>
<bean id="sqlsessionfactory2" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="mapperLocations" value="classpath:gpsData/transform/dao/GpsDao.xml" ></property>
<property name="dataSource" ref="ds2"/>
</bean>
<bean id="gpsdao2" class="org.mybatis.spring.MapperFactoryBean">
<property name="mapperInterface" value="gpsData.transform.dao.GpsDao"/>
<property name="SqlSessionFactory" ref="sqlsessionfactory2"/>
</bean>
GpsDao gpsdao1=(GpsDao) context.getBean("gpsdao1");
GpsDao gpsdao2 =(GpsDao) context.getBean("gpsdao2");
Target target2=(Target)gpsdao1.getTarget();
gpsdao2.insertTarget(target2);
执行到insertTarget时就不行了
这是mybatis的mapper配置文件
<select id="getTarget" parameterType="java.lang.String" resultType="gpsData.transform.action.Target">
SELECT T_TargetID as t_targetID,T_ParentID as t_parentID FROM t_target
</select>
<insert id="insertTarget" parameterType="gpsData.transform.action.Target" >
insert into t_target (T_TargetID ,T_ParentID ) values (#{t_targetID} ,#{t_parentID})
</insert>
------解决方案--------------------
以前ibatis都是用#t_targetID#，mybatis改成#{t_targetID}了？没看出来什么问题
[解决办法]
使用 spring的 AbstractRoutingDataSource
你看官方的资料.
