ApplicationContext.xml

<?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>