<bean id="dataSource"
     class="org.springframework.jdbc.datasource.DriverManagerDataSource">
     <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
    <property name="url" value="jdbc:oracle:thin:@xxx.xxx.xxx.xxx:1521:orcl" />
    <property name="username" value="cba" />
     <property name="password" value="***" />
   </bean>

 <bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
     <property name="jndiName">
       <value>java:/ssoDS</value>
     </property>
   </bean>

<beans:bean id="userDetailsDao" class="infosky.ckg.sso.dao.impl.UserDetailsDaoImpl">
    <beans:property name="dataSource" ref="dataSource" />
     <!-- 登錄錯誤嘗試次數 -->
     <beans:property name="maxAttempts" value="5" />
</beans:bean> 

<!-- 連接池數據源配置 -->
  <bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
  <property name="jndiName">
   <value>us_edbev</value>
  </property>
 </bean>
 <!-- end 連接池數據源配置 -->
 
  <bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
    <!-- 配置Hibernate攔截器,自動填充數據的插入、更新時間 -->
    <property name="entityInterceptor" ref="entityInterceptor" />
    <property name="dataSource" ref="dataSource" />
    <property name="hibernateProperties">
      <value>
        <!-- 設置數據庫方言 -->
        hibernate.dialect=${hibernate.dialect}
        <!-- 設置自動創(chuàng)建|更新|驗證數據庫表結構
        hibernate.hbm2ddl.auto=update
         -->
        <!-- 輸出SQL語句到控制臺 -->
        hibernate.show_sql=true
        <!-- 格式化輸出到控制臺的SQL語句 -->
        hibernate.format_sql=${hibernate.format_sql}
        <!-- 是否開啟二級緩存 -->
        hibernate.cache.use_second_level_cache=false
        <!-- 配置二級緩存產品 -->
        hibernate.cache.provider_class=org.hibernate.cache.OSCacheProvider
        <!-- 是否開啟查詢緩存 -->
        hibernate.cache.use_query_cache=false
        <!-- 數據庫批量查詢數 -->
        hibernate.jdbc.fetch_size=50
        <!-- 數據庫批量更新數 -->
        hibernate.jdbc.batch_size=30
        hibernate.autoReconnect=true 
      </value>
    </property>

    <property name="annotatedClasses">
      <list>
      .....
        
      </list>
    </property>
  </bean>

  <!-- 緩存配置 -->
<!--  <oscache:config configLocation="classpath:oscache.properties" id="cacheProvider" />-->
<!--  <oscache:annotations providerId="cacheProvider">-->
<!--    <oscache:caching id="caching" cronExpression="0 1 * * *" refreshPeriod="86400" />-->
<!--    <oscache:flushing id="flushing" />-->
<!--  </oscache:annotations>-->
  
  <bean id="cacheManager" class="org.springmodules.cache.provider.oscache.OsCacheManagerFactoryBean">
    <property name="configLocation" value="classpath:oscache.properties" />
  </bean>
  
  <!-- 設置需要進行Spring注解掃描的類包 -->
  <context:component-scan base-package="cn.com.sinosoft" />
  <context:component-scan base-package="com.sinosoft" />

  <!-- 使用AspectJ方式配置AOP -->
  <aop:aspectj-autoproxy proxy-target-class="true" />
  <aop:config proxy-target-class="true" />

  <!-- 使用注解方式定義事務 -->
  <tx:annotation-driven proxy-target-class="true" transaction-manager="transactionManager" />

  <!-- 配置事務管理器 -->
  <bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
    <property name="sessionFactory" ref="sessionFactory" />
  </bean>

  <!-- 配置事務傳播特性 -->
  <tx:advice id="transactionAdvice" transaction-manager="transactionManager">
    <tx:attributes>
      <tx:method name="save*" propagation="REQUIRED" />
      <tx:method name="delete*" propagation="REQUIRED" />
      <tx:method name="update*" propagation="REQUIRED" />
      <tx:method name="get*" read-only="true" />
      <tx:method name="load*" read-only="true" />
      <tx:method name="find*" read-only="true" />
      <tx:method name="*" read-only="true" />
    </tx:attributes>
  </tx:advice>

  <!-- 配置哪些類的哪些方法參與事務 -->
  <aop:config>
    <aop:advisor pointcut="execution(* cn.com.sinosoft.service..*.*(..))" advice-ref="transactionAdvice" />
  </aop:config>

  <!-- 配置freemarkerManager -->
  <bean id="freemarkerManager" class="cn.com.sinosoft.util.FTLManager" />

  <!-- 配置JCaptcha驗證碼功能 -->
  <bean id="captchaService" class="com.octo.captcha.service.image.DefaultManageableImageCaptchaService">
    <property name="captchaEngine">
      <bean class="cn.com.sinosoft.common.JCaptchaEngine" />
    </property>
    <!-- 驗證碼過期時間 -->
    <property name="minGuarantedStorageDelayInSeconds" value="600" />
  </bean>