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

        <property name="targetDataSource">

            <bean id="mainDataSource" class="com.jolbox.bonecp.BoneCPDataSource" destroy-method="close">

                <property name="driverClass" value="${jdbc.driver}" />

                <property name="jdbcUrl" value="${jdbc.url}" />

                <property name="username" value="${jdbc.username}"/>

                <property name="password" value="${jdbc.password}"/>

               <!--  检查数据库连接池中空闲连接的间隔时间(分) 默认：240 -->

                <property name="idleConnectionTestPeriodInMinutes" value="1"/>

                <!-- 连接池中未使用的链接最大存活时间(分) 默认：240 -->

                <property name="idleMaxAgeInMinutes" value="4"/>

                <!-- 每个分区最大的连接数 -->

                <property name="maxConnectionsPerPartition" value="20"/>

                <!-- 每个分区最小的连接数 -->

                <property name="minConnectionsPerPartition" value="2"/>

                <!-- 分区数 默认值：2，最小值：1 -->

                <property name="partitionCount" value="3"/>

               <!--  连接数不够时，每次创建的新链接个数 默认值：2 -->

                <property name="acquireIncrement" value="2"/>

                <!-- Statement实例缓存个数 默认值：0 -->

                <property name="statementsCacheSize" value="50"/>

                <!-- 每个分区释放链接助理进程的数量 默认值：3 -->

                <property name="releaseHelperThreads" value="3"/>

               </bean>

        </property>

    </bean>

<!-- 配置SessionFactory -->

    <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">

        <property name="dataSource" ref="dataSource"></property>

        <property name="configLocation" value="classpath:hibernate.cfg.xml"></property>

        <property name="entityCacheStrategies">

            <props>

                <prop key="com.astasys.dms.coeus.audit.LogEntry">read-only</prop>

                <prop key="com.astasys.dms.coeus.domainobjects.HierarchicalNode">read-write</prop>

                <prop key="com.astasys.dms.coeus.roles.RoleExecutor">read-write</prop>

            </props>

        </property>

        <property name="collectionCacheStrategies">

            <props>

                <prop key="com.astasys.dms.coeus.domainobjects.HierarchicalNode.descriptions">read-write</prop>

                <prop key="com.astasys.dms.coeus.domainobjects.propertyprofile.PropertyProfileTemplate.propertyDescriptors">read-write</prop>

            </props>

        </property>

        <property name="hibernateProperties">

            <props>

                <prop key="hibernate.dialect">${jdbc.dialect}</prop>

                <prop key="identityGenerationDisableString"></prop>

                <prop key="hibernate.show_sql">false</prop>

                <prop key="hibernate.jdbc.batch_size">20</prop>

                <prop key="hibernate.max_fetch_depth">3</prop>

                <prop key="hibernate.bytecode.use_reflection_optimizer">true</prop>

                <prop key="hibernate.cache.use_query_cache">true</prop>

                <prop key="hibernate.cache.use_second_level_cache">true</prop>

                <prop key="net.sf.ehcache.configurationResourceName">/ehcache.xml</prop>

                <prop key="hibernate.query.substitutions">true '1', false '0'</prop>

                <prop key="hibernate.cache.region.factory_class">net.sf.ehcache.hibernate.EhCacheRegionFactory</prop>

                <prop key="hibernate.connection.isolation">1</prop>

            </props>

        </property>

        <property name="mappingResources">

            <list>

                <value>TypeTable.hbm.xml</value>

                <value>RolePlayer.hbm.xml</value>

                <value>Message.hbm.xml</value>

                <value>Email.hbm.xml</value>

                <value>PropertyProfile.hbm.xml</value>

                <value>AuditTrail.hbm.xml</value>

                <value>OCRNightJob.hbm.xml</value>

                <value>OCRLogging.hbm.xml</value>

                <value>Announcement.hbm.xml</value>

                <value>RelatedSearch.hbm.xml</value>

                <value>NotificationGroup.hbm.xml</value>

                <value>DocumentWorkflow.hbm.xml</value>

                <value>Forum.hbm.xml</value>

                <value>Lifecycle.hbm.xml</value>

                <value>MailboxImport.hbm.xml</value>

                <value>LicenseUsageMonthlyReport.hbm.xml</value>

            </list>

        </property>

        <property name="entityInterceptor">

            <bean class="com.astasys.dms.coeus.interceptors.NodeInterceptor" />

        </property>

    </bean>

<tx:advice transaction-manager="defaultHibernateTx" id="txAdvice">

        <tx:attributes>

            <tx:method name="find*" read-only="false"/>

            <tx:method name="add*" rollback-for="Exception"/>

        </tx:attributes>

    </tx:advice>

    <aop:config>

        <aop:pointcut expression="execution(* com.astasys.transaction.service.*.*(..))" id="txpointcut"/>

        <aop:advisor advice-ref="txAdvice" pointcut-ref="txpointcut"/>

    </aop:config>