SSH+连接池配置多数据库

最新推荐文章于 2023-06-27 09:18:06 发布

weixin_34417635

最新推荐文章于 2023-06-27 09:18:06 发布

阅读量117

点赞数

文章标签：运维数据库

原文链接：https://my.oschina.net/u/1159401/blog/309903

版权

2019独角兽企业重金招聘Python工程师标准>>>

ssh框架下使用2种数据库来操作。一种是oracle，一种是sqlserver

下面是具体配置：

1、applicationContext-common.xml

<?xml version="1.0" encoding="UTF-8"?>
<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"
	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">
	<bean id="sessionFactory"
		class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="configLocation">
			<value>classpath:hibernate.cfg.xml</value>
		</property>
	</bean>
	<bean id="transactionManager"
		class="org.springframework.orm.hibernate3.HibernateTransactionManager">
		<property name="sessionFactory" ref="sessionFactory"></property>
	</bean>
	<tx:advice id="txAdvice" transaction-manager="transactionManager">
		<tx:attributes>
			<tx:method name="register*" propagation="REQUIRED"
				rollback-for="exception" />
			<tx:method name="save*" propagation="REQUIRED"
				rollback-for="exception" />
			<tx:method name="add*" propagation="REQUIRED"
				rollback-for="exception" />
			<tx:method name="del*" propagation="REQUIRED"
				rollback-for="exception" />
			<tx:method name="insert*" propagation="REQUIRED"
				rollback-for="exception" />
			<tx:method name="update*" propagation="REQUIRED"
				rollback-for="exception" />
			<tx:method name="modify*" propagation="REQUIRED"
				rollback-for="exception" />
			<tx:method name="attach*" propagation="REQUIRED"
				rollback-for="exception" />
			<tx:method name="exec*" propagation="REQUIRED"
				rollback-for="exception" />
			<tx:method name="check*" propagation="REQUIRED"
				rollback-for="exception" />
			<tx:method name="approve*" propagation="REQUIRED"
				rollback-for="exception" />
			<tx:method name="process*" propagation="REQUIRED"
				rollback-for="exception" />
			<tx:method name="init*" propagation="REQUIRED"
				rollback-for="exception" />
			<tx:method name="*" read-only="true" />
		</tx:attributes>
	</tx:a<mce:script type="text/javascript" src="http://hi.images.csdn.net/js/blog/tiny_mce/themes/advanced/langs/zh.js" mce_src="http://hi.images.csdn.net/js/blog/tiny_mce/themes/advanced/langs/zh.js"></mce:script><mce:script type="text/javascript" src="http://hi.images.csdn.net/js/blog/tiny_mce/plugins/syntaxhl/langs/zh.js" mce_src="http://hi.images.csdn.net/js/blog/tiny_mce/plugins/syntaxhl/langs/zh.js"></mce:script>dvice>
	<aop:config>
		<!-- 基本信息 -->
		<aop:advisor advice-ref="txAdvice"
			pointcut="execution(* cn.common.sys.service..*.*(..))" />	
	</aop:config>
	<!-- sqlserver配置 -->
	<bean id="sessionFactory_sqlserver"
		class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="configLocation">
			<value>classpath:faxHibernate.cfg.xml</value>
		</property>
	</bean>
	<bean id="transactionManager_sqlserver"
		class="org.springframework.orm.hibernate3.HibernateTransactionManager">
		<property name="sessionFactory"
			ref="sessionFactory_sqlserver">
		</property>
	</bean>
	<tx:advice id="txAdvice_sqlserver"
		transaction-manager="transactionManager_sqlserver">
		<tx:attributes>
			<tx:method name="register*" propagation="REQUIRED"
				rollback-for="exception" />
			<tx:method name="save*" propagation="REQUIRED"
				rollback-for="exception" />
			<tx:method name="add*" propagation="REQUIRED"
				rollback-for="exception" />
			<tx:method name="del*" propagation="REQUIRED"
				rollback-for="exception" />
			<tx:method name="insert*" propagation="REQUIRED"
				rollback-for="exception" />
			<tx:method name="update*" propagation="REQUIRED"
				rollback-for="exception" />
			<tx:method name="modify*" propagation="REQUIRED"
				rollback-for="exception" />
			<tx:method name="attach*" propagation="REQUIRED"
				rollback-for="exception" />
			<tx:method name="exec*" propagation="REQUIRED"
				rollback-for="exception" />
			<tx:method name="check*" propagation="REQUIRED"
				rollback-for="exception" />
			<tx:method name="approve*" propagation="REQUIRED"
				rollback-for="exception" />
			<tx:method name="process*" propagation="REQUIRED"
				rollback-for="exception" />
			<tx:method name="init*" propagation="REQUIRED"
				rollback-for="exception" />
			<tx:method name="*" read-only="true" />
		</tx:attributes>
	</tx:advice>
	<aop:config>
		<!-- 传真管理 -->
		<aop:advisor advice-ref="txAdvice_sqlserver"
			pointcut="execution(* cn.common.faxserver.service..*.*(..))" />
	</aop:config>
</beans>

2、faxHibernate.cfg.xml

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<!-- Generated by MyEclipse Hibernate Tools.                   -->
<hibernate-configuration>
	<session-factory>
		<property name="hibernate.proxool.xml">faxProxool.xml</property>
		<property name="hibernate.proxool.pool_alias">FaxDBPool</property>
		<property name="hibernate.connection.provider_class">
			org.hibernate.connection.ProxoolConnectionProvider
		</property>
		
		<property name="hibernate.format_sql">true</property>
		<property name="hibernate.show_sql">true</property>
		<property name="hibernate.jdbc.batch_size">0</property>
		<property name="hibernate.jdbc.fetch_size">20</property>
		<property name="hibernate.jdbc.use_streams_for_binary">
			true
		</property>
		<property name="default_schema">dbo</property>
		<!-- 传真收发 -->
		<mapping
			resource="cn/common/faxserver/po/TdbiFaxIn.hbm.xml" />
		<mapping
			resource="cn/common/faxserver/po/TdbiFaxOut.hbm.xml" />
	</session-factory>
</hibernate-configuration>

faxProxool.xml

<?xml version='1.0' encoding='UTF-8'?>
<something-else-entirely>
	<proxool>
		<alias>FaxDBPool</alias>
		<driver-url>jdbc:sqlserver://192.168.0.99:1433;databaseName=trafax</driver-url>
		<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
		<driver-properties>
			<property name="user" value="faxOp" />
			<property name="password" value="faxOp" />
			<property name="autoReconnect" value="true" /> 
		</driver-properties>
		<house-keeping-sleep-time>90000</house-keeping-sleep-time>
		<house-keeping-test-sql>select getdate()</house-keeping-test-sql> 
		<prototype-count>5</prototype-count>
		<maximum-connection-count>100</maximum-connection-count>
		<minimum-connection-count>5</minimum-connection-count>
	</proxool>
</something-else-entirely>

3、hibernate.cfg.xml

<!DOCTYPE hibernate-configuration PUBLIC
	"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
	"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
	<session-factory>
			<property name="hibernate.proxool.xml">Proxool.xml</property>
			<property name="hibernate.proxool.pool_alias">MYPool</property>
			<property name="hibernate.connection.provider_class">
			org.hibernate.connection.ProxoolConnectionProvider
			</property>
			<property name="hibernate.format_sql">true</property>
			<property name="hibernate.show_sql">true</property>
			<property name="hibernate.jdbc.batch_size">0</property>
			<property name="hibernate.jdbc.fetch_size">20</property>
			<property name="hibernate.jdbc.use_streams_for_binary">
			true
			</property>
		
		<property name="dialect">
			org.hibernate.dialect.Oracle9Dialect
		</property>
		<mapping resource="cn/finefuture/cqwater/basetask/po/CallTOndutyperson.hbm.xml" />
	</session-factory>
</hibernate-configuration>

Proxool.xml

<?xml version='1.0' encoding='UTF-8'?>
<something-else-entirely>
	<proxool>
		<alias>MYPool</alias>
		<driver-url>
			jdbc:oracle:thin:@192.168.0.99:1521:orcl
		</driver-url>
		<driver-class>
			oracle.jdbc.driver.OracleDriver
		</driver-class>
		<driver-properties>
			<property name="user" value="cqwater" />
			<property name="password" value="cqwater" />
			<property name="autoReconnect" value="true" />
		</driver-properties>
		<house-keeping-sleep-time>90000</house-keeping-sleep-time>
		<prototype-count>5</prototype-count>
		<maximum-connection-count>100</maximum-connection-count>
		<minimum-connection-count>5</minimum-connection-count>
	</proxool>
</something-else-entirely>

4、applicationContext-daos.xml在dao引入相应的sessionFactory就行了

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">
	<bean id="customerDAO"
		class="cn.common.platform.dao.impl.CustomerDAOImpl">
		<property name="sessionFactory" ref="sessionFactory"></property>
	</bean>
	<!-- 发送传真dao -->
	<bean id="tdbiFaxOutDAO"
		class="cn.common.faxserver.dao.impl.TdbiFaxOutDAOImpl">
		<property name="sessionFactory"
			ref="sessionFactory_sqlserver">
		</property>
	</bean>
	<!-- 接收传真dao -->
	<bean id="tdbiFaxInDAO"
		class="cn.common.faxserver.dao.impl.TdbiFaxInDAOImpl">
		<property name="sessionFactory"
			ref="sessionFactory_sqlserver">
		</property>
	</bean>
</beans>

转载于:https://my.oschina.net/u/1159401/blog/309903