Subversion Repositories SmartDukaan

<?xml version="1.0" encoding="UTF-8"?>
<!-- Copyright 2010 The myBatis Team Licensed under the Apache License, Version 
        2.0 (the "License"); you may not use this file except in compliance with 
        the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 
        Unless required by applicable law or agreed to in writing, software distributed 
        under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES 
        OR CONDITIONS OF ANY KIND, either express or implied. See the License for 
        the specific language governing permissions and limitations under the License. -->

<beans xmlns="http://www.springframework.org/schema/beans"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xmlns:aop="http://www.springframework.org/schema/aop"
        xmlns:tx="http://www.springframework.org/schema/tx"
        xmlns:jdbc="http://www.springframework.org/schema/jdbc"
        xmlns:context="http://www.springframework.org/schema/context"
        xsi:schemaLocation="
     http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd
     http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
     http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-3.0.xsd
     http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
     http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd">

        <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
                <!-- JDBC connection properties -->
                <property name="driverClassName" value="com.mysql.jdbc.Driver" />
                <property name="url" value="#{systemProperties['dbHost']}" />
                <property name="username" value="root" />
                <property name="password" value="shop2020" />

                <!-- Pool size related properties -->
                <!-- The initial number of connections that are created when the pool is 
                        started. -->
                <property name="initialSize" value="2" />

                <!-- The maximum number of active connections that can be allocated from 
                        this pool at the same time, or negative for no limit. -->
                <property name="maxActive" value="16" />

                <!-- The maximum number of milliseconds that the pool will wait (when there 
                        are no available connections) for a connection to be returned before throwing 
                        an exception, or -1 to wait indefinitely. -->
                <property name="maxWait" value="10000" />

                <!-- The SQL query that will be used to validate connections from this 
                        pool before returning them to the caller. If specified, this query MUST be 
                        an SQL SELECT statement that returns at least one row. -->
                <property name="validationQuery" value="SELECT 1" />

                <!-- The indication of whether objects will be validated before being borrowed 
                        from the pool. If the object fails to validate, it will be dropped from the 
                        pool, and we will attempt to borrow another. -->
                <property name="testOnBorrow" value="false" />

                <!-- The indication of whether objects will be validated by the idle object 
                        evictor (if any). If an object fails to validate, it will be dropped from 
                        the pool. -->
                <property name="testWhileIdle" value="true" />

                <!-- The minimum amount of time an object may sit idle in the pool before 
                        it is eligable for eviction by the idle object evictor. Setting it to 2 hours. -->
                <property name="minEvictableIdleTimeMillis" value="7200000" />

                <!-- The number of milliseconds to sleep between runs of the idle object 
                        evictor thread. When non-positive, no idle object evictor thread will be 
                        run. Setting it to 15 minutes. -->
                <property name="timeBetweenEvictionRunsMillis" value="900000"></property>

                <!-- Properties to prevent DB resource leaks -->
                <!-- Flag to remove abandoned connections if they exceed the removeAbandonedTimout. 
                        If set to true a connection is considered abandoned and eligible for removal 
                        if it has been idle longer than the removeAbandonedTimeout. Setting this 
                        to true can recover db connections from poorly written applications which 
                        fail to close a connection. -->
                <property name="removeAbandoned" value="true" />

                <!-- Timeout in seconds before an abandoned connection can be removed. -->
                <property name="removeAbandonedTimeout" value="300" />

                <!-- Flag to log stack traces for application code which abandoned a Statement 
                        or Connection. Logging of abandoned Statements and Connections adds overhead 
                        for every Connection open or new Statement because a stack trace has to be 
                        generated -->
                <property name="logAbandoned" value="true" />
        </bean>

        <!-- transaction manager, use JtaTransactionManager for global tx -->
        <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
                <property name="dataSource" ref="dataSource" />
        </bean>

        <!-- enable component scanning (beware that this does not enable mapper 
                scanning!) -->
        <context:component-scan base-package="in.shop2020.user.handler" />

        <!-- enable autowire -->
        <context:annotation-config />

        <!-- enable transaction demarcation with annotations -->
        <tx:annotation-driven />

        <!-- define the SqlSessionFactory, notice that configLocation is not needed 
                when you use MapperFactoryBean -->
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
                <property name="dataSource" ref="dataSource" />
                <property name="configLocation" value="classpath:mybatis-config.xml" />
        </bean>

        <!-- scan for mappers and let them be autowired -->
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
                <property name="basePackage" value="in.shop2020.user.persistence" />
        </bean>
</beans>