del-code nl-104 ol-104">
<bean id="uspaDataSource" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="${uspa.jdbc.driverClassName}" />
<property name="url" value="${uspa.jdbc.url}" />
<property name="username" value="${uspa.jdbc.username}" />
<property name="password" value="${uspa.jdbc.password}" />
<property name="initialSize" value="${uspa.jdbc.initialSize}"></property>
<property name="maxActive" value="${uspa.jdbc.maxActive}"></property>
<property name="maxIdle" value="${uspa.jdbc.maxIdle}"></property>
<property name="maxWait" value="${uspa.jdbc.maxWait}"></property>
<property name="defaultAutoCommit" value="${uspa.jdbc.defaultAutoCommit}"></property>
<property name="timeBetweenEvictionRunsMillis" value="${uspa.jdbc.timeBetweenEvictionRunsMillis}"></property>
<property name="minEvictableIdleTimeMillis" value="${uspa.jdbc.minEvictableIdleTimeMillis}" />
<property name="validationQuery" value="${uspa.jdbc.validationQuery}" />
<property name="testOnBorrow" value="${uspa.jdbc.testOnBorrow}" />
<property name="validationQueryTimeout" value="${uspa.jdbc.validationQueryTimeout}" />
</bean>
<bean id="sessionFactory"
class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
<property name="dataSource" ref="uspaDataSource"></property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">${uspa.hibernate.dialect}</prop>
<prop key="hibernate.show_sql">${uspa.hibernate.show_sql}</prop>
<prop key="hibernate.format_sql">${uspa.hibernate.format_sql}</prop>
<prop key="hibernate.current_session_context_class">
org.springframework.orm.hibernate4.SpringSessionContext
</prop>
<prop key="hibernate.autoReconnect">${uspa.hibernate.autoReconnect}</prop>
<prop key="hibernate.connection.autocommit">true</prop>
<prop key="hibernate.jdbc.batch_size">${uspa.hibernate.jdbc.batch_size}</prop>
<prop key="hibernate.jdbc.fetch_size">${uspa.hibernate.jdbc.fetch_size}</prop>
<!--<prop key="hibernate.hbm2ddl.auto">${uspa.hibernate.hbm2ddl.auto}</prop>-->
<prop key="hibernate.cache.use_second_level_cache">${uspa.hibernate.cache.use_second_level_cache}</prop>
</props>
</property>
<property name="packagesToScan">
<list>
<value>com.ai.aif.uspa.domain</value>
</list>
</property>
</bean>
<!-- redis -->
<bean id="poolConfig" class="redis.clients.jedis.JedisPoolConfig">
<property name="maxIdle" value="${redis.maxIdle}" />
<property name="minIdle" value="${redis.minIdle}" />
<property name="maxTotal" value="${redis.maxTotal}"/>
<property name="testOnBorrow" value="${redis.testOnBorrow}"/>
<property name="maxWaitMillis" value="${redis.maxWaitMillis}"/>
<property name="testOnReturn" value="${redis.testOnReturn}" />
</bean>
<bean id="jedisConnectionFactory" class="org.springframework.data.redis.connection.jedis.JedisConnectionFactory">
<property name="usePool" value="true"/>
<property name="hostName" value="${redis.host}" />
<property name="port" value="${redis.port}" />
<property name="timeout" value="${redis.timeout}" />
<property name="poolConfig" ref="poolConfig"/>
</bean>
<bean id="redisTemplate" class="org.springframework.data.redis.core.RedisTemplate">
<property name="connectionFactory" ref="jedisConnectionFactory"/>
<property name="keySerializer"><bean class="org.springframework.data.redis.serializer.StringRedisSerializer"/></property>
<property name="valueSerializer"><bean class="org.springframework.data.redis.serializer.JdkSerializationRedisSerializer"/></property>
</bean>
<!-- redis -->
<!-- swagger start -->
<!--
<mvc:resources mapping="swagger-ui.html" location="classpath:/META-INF/resources/" />
<mvc:resources mapping="/webjars/**"
location="classpath:/META-INF/resources/webjars/" />
-->
<!-- swagger end -->
</beans>