在一个spring配置文件中同时配置hibernate和jdbc

维护legacy系统时,难免碰上同时使用hibernate和jdbc的情况,那么spring中
怎么配置呢?今天试用成功,贴出配置部分备忘:

<bean id="dataSource"
   class="org.springframework.jndi.JndiObjectFactoryBean">
   <property name="jndiName">
    <value>${JDBC_JNDI}</value>
   </property>
</bean>
<bean id="jdbcTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
   <property name="dataSource"><ref local="dataSource"/></property>
</bean>
<bean id="jdbcTransactionProxy"
   class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean"
   abstract="true">
   <property name="transactionManager">
    <ref bean="jdbcTransactionManager"/>
   </property>
   <property name="transactionAttributes">
    <props>
     <prop key="get*">PROPAGATION_REQUIRED,readOnly</prop>
     <prop key="find*">PROPAGATION_REQUIRED,readOnly</prop>
     <prop key="load*">PROPAGATION_REQUIRED,readOnly</prop>
     <prop key="modify*">PROPAGATION_REQUIRED</prop>
     <prop key="delete*">PROPAGATION_REQUIRED</prop>
     <prop key="add*">PROPAGATION_REQUIRED</prop>
    </props>
   </property>
</bean>
<bean id="sessionFactory"
   class="org.springframework.orm.hibernate.LocalSessionFactoryBean">
......
</bean>
<bean id="hibernateTransactionManager"
   class="org.springframework.orm.hibernate.HibernateTransactionManager">
   <property name="sessionFactory">
    <ref local="sessionFactory"/>
   </property>
</bean>
<bean id="hibernateTransactionProxy"
   class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean"
   abstract="true">
   <property name="transactionManager">
    <ref bean="transactionManager"/>
   </property>
   <property name="transactionAttributes">
    <props>
     <prop key="get*">PROPAGATION_REQUIRED,readOnly</prop>
     <prop key="find*">PROPAGATION_REQUIRED,readOnly</prop>
     <prop key="load*">PROPAGATION_REQUIRED,readOnly</prop>
     <prop key="modify*">PROPAGATION_REQUIRED</prop>
     <prop key="delete*">PROPAGATION_REQUIRED</prop>
     <prop key="add*">PROPAGATION_REQUIRED</prop>
    </props>
   </property>
</bean>

然后在service层分别引用就可以了.

private JdbcTemplate jdbcTemplate;

get ,set 方法省略