<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
<!-- ========================= RESOURCE DEFINITIONS ========================= -->
<!-- 定义DataSource -->
<!--
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName"><value>java:comp/env/jdbc/jpetstore</value></property>
</bean>
-->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close" singleton="true">
<property name="driverClassName">
<value>oracle.jdbc.driver.OracleDriver</value>
</property>
<property name="url">
<value>jdbc:oracle:thin:@192.168.0.186:1521:project</value>
</property>
<property name="username">
<value>DCPM</value>
</property>
<property name="password">
<value>DCPM</value>
</property>
</bean>
<!-- jbpm -->
<bean id="placeholderConfig" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="location">
<!-- 数据库连接配置文件 -->
<value>WEB-INF/classes/initSystem.properties</value>
</property>
</bean>
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource">
<ref bean="dataSource"/>
</property>
</bean>
<!-- jbpm end -->
<!-- 定义hibernate的SessionFactory -->
<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="mappingDirectoryLocations">
<list>
<value>classpath:cn/com/sgcc/data</value>
</list>
</property>
<property name="dataSource">
<ref local="dataSource"/>
</property>
<property name="hibernateProperties">
<props>
<!-- 定义数据库特征 -->
<prop key="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</prop>
<prop key="hibernate.cglib.use_reflection_optimizer">true</prop>
<!-- 定义hibernate特征 -->
<prop key="hibernate.max_fetch_depth">2</prop>
<prop key="hibernate.default_batch_fetch_size">10</prop>
<prop key="hibernate.cache.use_second_level_cache">false</prop>
<prop key="hibernate.cache.use_query_cache">false</prop>
<!-- <prop key="hibernate.query.factory_class">org.hibernate.hql.classic.ClassicQueryTranslatorFactory
</prop>
-->
<!-- 定义JDBC特征 -->
<prop key="hibernate.jdbc.fetch_size">50</prop>
<prop key="hibernate.jdbc.batch_size">8</prop>
<!--
<prop key="connection.useUnicode">true</prop>
<prop key="hibernate.connection.defaultNChar">true</prop>
<prop key="connection.characterEncoding">UTF-8</prop>
-->
<!-- 定义是否自动更新数据库schema,开发测试时使用,正式发行版本设为false -->
<prop key="hibernate.show_sql">false</prop>
</props>
</property>
<!-- 定义是否自动更新数据库schema,开发测试时使用,正式发行版本设为false -->
<property name="schemaUpdate">
<value>false</value>
</property>
<!-- 使用spring+hibernate处理oracle BLOB -->
<property name="lobHandler">
<ref bean="oracleLobHandler" />
</property>
</bean>
<!-- 使用spring+hibernate处理oracle BLOB-->
<bean id="nativeJdbcExtractor" class="org.springframework.jdbc.support.nativejdbc.CommonsDbcpNativeJdbcExtractor" lazy-init="true"/>
<bean id="oracleLobHandler" class="org.springframework.jdbc.support.lob.OracleLobHandler" lazy-init="true">
<property name="nativeJdbcExtractor">
<ref bean="nativeJdbcExtractor" />
</property>
</bean>
<!-- 完毕-->
<!-- 如果需要使用分布式数据库,则使用JtaTransactionManager替换HibernateTransactionManager -->
<!--
<bean id="transactionManager" class="org.springframework.transaction.jta.JtaTransactionManager"/>
-->
<bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory">
<ref local="sessionFactory"/>
</property>
<property name="nestedTransactionAllowed">
<value>true</value>
</property>
</bean>
<!-- 应用相关系统参数设定
<bean id="applicationSetup" class="com.creation.setup.ApplicationSetup" singleton="true">-->
<!-- 设定Hibernate查询的时候是否需要缓存结果,开发测试置为false,发行版本置为true
<property name="queryCacheable">
<value>true</value>
</property>
</bean>
-->
<bean id="transactionAdvice" class="org.springframework.transaction.interceptor.TransactionInterceptor">
<property name="transactionManager">
<ref bean="transactionManager"/>
</property>
<property name="transactionAttributes">
<props>
<prop key="get*">PROPAGATION_NEVER,readOnly</prop>
<prop key="find*">PROPAGATION_NEVER,readOnly</prop>
<prop key="save*">PROPAGATION_REQUIRED</prop>
<prop key="del*">PROPAGATION_REQUIRED</prop>
</props>
</property>
</bean>
<bean id="transactionAdvisor" class="org.springframework.aop.support.DefaultPointcutAdvisor">
<property name="advice">
<ref local="transactionAdvice"/>
</property>
<property name="pointcut">
<bean class="org.springframework.aop.support.Perl5RegexpMethodPointcut">
<property name="patterns">
<list>
<value>.*List</value>
<value>.*find.*</value>
<value>.*save.*</value>
<value>.*del.*</value>
</list>
</property>
</bean>
</property>
</bean>
</beans>
ApplicationContext.xml
最新推荐文章于 2019-03-07 09:41:15 发布