<bean id="dataSource"
        class="org.apache.commons.dbcp.BasicDataSource"
        lazy-init="default" autowire="default" dependency-check="default">
        <property name="driverClassName">
            <value>com.mysql.jdbc.Driver</value>
        </property>
        <property name="url">
            <value>jdbc:mysql://${db.host}:${db.port}/${db.database}?zeroDateTimeBehavior=convertToNull&amp;rewriteBatchedStatements=true&amp;characterEncoding=utf-8&amp;autoReconnect=true</value>
        </property>
        <property name="username">
            <value>${db.username}</value>
        </property>
        <property name="password">
            <value>${db.password}</value>
        </property>

        <property name="initialSize" value="6"/>
        <property name="maxIdle" value="10" />
        <property name="maxActive" value="10" />
        <property name="defaultAutoCommit" value="false" />
    </bean>