<?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:p="http://www.springframework.org/schema/p" xmlns:context="http://www.springframework.org/schema/context"
xmlns:jee="http://www.springframework.org/schema/jee" 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/context http://www.springframework.org/schema/context/spring-context-2.5.xsd
http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-2.5.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd">
<!-- DataSource for Production -->
<!--
<bean id="dataSource" class="org.springframework.jndi.Jndiobjectfactorybean">
<property name="jndiName"><value>jdbc/asomDS</value></property>
</bean>

<bean id="cmsDataSource" class="org.springframework.jndi.Jndiobjectfactorybean">
<property name="jndiName"><value>jdbc/asomCmsDS</value></property>
</bean>
-->

<!-- DataSource for Development -->

<!-- Hibernate SessionFactory -->

<!-- Transaction manager for a single JDBC DataSource -->
<bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory"><ref bean="sessionFactory"/></property>
</bean>

<!-- Transaction attribute for a single JDBC DataSource -->
<bean id="txAttributes" class="org.springframework.transaction.interceptor.NameMatchTransactionAttributeSource">
<property name="properties">
<value>
get*=PROPAGATION_required,readOnly
load*=PROPAGATION_required,readOnly
find*=PROPAGATION_required,readOnly
list*=PROPAGATION_required,readOnly
*=PROPAGATION_required
</value>
</property>
</bean>

<!-- POJO Service Interceptor -->
<bean id="mainTransactionInterceptor" class="org.springframework.transaction.interceptor.TransactionInterceptor">
<property name="transactionManager">
<ref bean="transactionManager" />
</property>
<property name="transactionAttributeSource">
<ref bean="txAttributes" />
</property>
</bean>

<!-- Service Proxy Creator [ Spring Auto Proxy Creator ] -->
<bean id="myServiceAutoProxyCreator" class="org.springframework.aop.framework.autoproxy.BeanNameAutoProxyCreator">
<property name="beanNames">
<value>*Service</value>
</property>
<property name="interceptorNames">
<list>
<value>mainTransactionInterceptor</value>
</list>
</property>
</bean>

<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionfactorybean">
<property name="dataSource"><ref local="dataSource"/></property>
<property name="mappingLocations">
<list>
<value>classpath:/cn/gov/cma/cnn/entity/*.hbm.xml</value>

<!-- <value>classpath:/cn/gov/cma/cnn/entity/Bas*.hbm.xml</value>-->
</list>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.OracleDialect</prop>
<prop key="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</prop>
<prop key="hibernate.query.factory_class">org.hibernate.hql.ast.ASTQueryTranslatorFactory</prop>
<prop key="hibernate.hbm2ddl.auto">update</prop>
<prop key="hibernate.show_sql">false</prop>
<prop key="hibernate.max_fetch_depth">4</prop>
</props>
</property>
</bean>

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">

<property name="driverClassName"><value>oracle.jdbc.OracleDriver</value></property>

<!--

<property name="url" value="jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=61.4.184.114)(PORT=2521))(CONNECT_DATA=(SERVICE_NAME=pwspdb)))" />
<property name="url" value="jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.148.31.32)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = gdyj)(INSTANCE_NAME = gdyj2)))" />
-->
<!--
<property name="url" value="jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.31.130)(PORT=2521))(CONNECT_DATA=(SERVICE_NAME=pwspdb)))" />
-->
<!-- <property name="url"><value>jdbc:oracle:thin:@localhost:1521:PWSDB</value></property>
<property name="username"><value>PRODUCTSYS</value></property>
<property name="password"><value>PRODUCTSYS</value></property>
-->
<!--
<property name="username"><value>system</value></property>
<property name="password"><value>orasystem</value></property>
-->
<property name="url" value="jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=10.12.10.111)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=cipaspd.css.com)))" />
<property name="username" value="hwt" />
<property name="password" value="hwt" />
</bean>

<bean id="placeholderConfig" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="locations"> <list> <value>/WEB-INF/spring/myQuartzConfig.properties</value> </list> </property> </bean> <import resource="applicationContext-monitorService.xml"/> <import resource="applicationContext_MonitorResult_quartz.xml"/> <import resource="applicationContext_MonitorHistoryResult_quartz.xml"/> <import resource="applicationContext_quartz.xml"/> <import resource="cn/gov/cma/cnn/dcm/monitor/applicationContext-monitor.xml"/> </beans>