English 中文(简体)
2008年4月3日
原标题:Spring 3 + MyBatis 3

How to create multiple connection databases in spring 3 and mybatis 3. I need to connect to MySQL and Oracle at once. Can you help me?

问题回答

每一数据库都需要1台SqlSessionFactory。

<bean id="db1SqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    <property name="configLocation" value="classpath:sqlmap1.xml"/>
    <property name="dataSource" ref="db1datasource"/>
</bean>

<bean id="db2SqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    <property name="configLocation" value="classpath:sqlmap2.xml"/>
    <property name="dataSource" ref="db2datasource"/>
</bean>

<bean id="db1SqlSession" class="org.mybatis.spring.SqlSessionTemplate">
    <qualifier value="db1" />
    <constructor-arg index="0" ref="db1SqlSessionFactory" />
</bean>


<bean id="db2SqlSession" class="org.mybatis.spring.SqlSessionTemplate">
    <qualifier value="db2" />
    <constructor-arg index="0" ref="db2SqlSessionFactory" />
</bean>




相关问题
Spring Properties File

Hi have this j2ee web application developed using spring framework. I have a problem with rendering mnessages in nihongo characters from the properties file. I tried converting the file to ascii using ...

Logging a global ID in multiple components

I have a system which contains multiple applications connected together using JMS and Spring Integration. Messages get sent along a chain of applications. [App A] -> [App B] -> [App C] We set a ...

Java Library Size

If I m given two Java Libraries in Jar format, 1 having no bells and whistles, and the other having lots of them that will mostly go unused.... my question is: How will the larger, mostly unused ...

How to get the Array Class for a given Class in Java?

I have a Class variable that holds a certain type and I need to get a variable that holds the corresponding array class. The best I could come up with is this: Class arrayOfFooClass = java.lang....

SQLite , Derby vs file system

I m working on a Java desktop application that reads and writes from/to different files. I think a better solution would be to replace the file system by a SQLite database. How hard is it to migrate ...

热门标签