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

    <context:property-placeholder location="classpath:jdbc.properties" />

    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">

        <!-- JDBC connection properties -->

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

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

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

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

        <!-- 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="1800000"></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.warehouse.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.warehouse.persistence" />

    </bean>

</beans>