druid 配置

weixin_33674976

157人浏览 · 2017-09-14 17:43:00

weixin_33674976 · 2017-09-14 17:43:00 发布

2019独角兽企业重金招聘Python工程师标准>>>

druid-1.1.1.jar

dbconfig.properties

url:zeroDateTimeBehavior=convertToNull&amp;rewriteBatchedStatements=true&amp;autoReconnect=true&amp;failOverReadOnly=false&amp;useSSL=false
driverClassName:com.mysql.jdbc.Driver
username:ro
password:VAxbiQ
filters:stat,wall,log4j

urltem:jdbc:db2:/
driverClassNametem:com.ibm.db2.jcc.DB2Driver
usernameterm:
passwordtem:

initialSize:1
maxActive:50
minIdle:10
maxWait:60000
timeBetweenEvictionRunsMillis:60000
minEvictableIdleTimeMillis:300000
   
validationQuery:SELECT 'x'
validationQuerytem:select 1 from sysibm.sysdummy1
testWhileIdle:true
testOnBorrow:false
testOnReturn:false

maxOpenPreparedStatements:20
removeAbandoned:true
removeAbandonedTimeout:1800
logAbandoned:true

web.xml

<!-- 连接池 启用Web监控统计功能   start-->
	<filter>
		<filter-name>DruidWebStatFilter</filter-name>
		<filter-class>com.alibaba.druid.support.http.WebStatFilter</filter-class>
		<init-param>
			<param-name>exclusions</param-name>
			<param-value>*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*</param-value>
		</init-param>
		<init-param>
			<param-name>principalSessionName</param-name>
  			<param-value>userCode</param-value>
		</init-param>
		<init-param>
		    <param-name>profileEnable</param-name>
		    <param-value>true</param-value>
		</init-param>
	</filter>
	<filter-mapping>
		<filter-name>DruidWebStatFilter</filter-name>
		<url-pattern>/*</url-pattern>
	</filter-mapping>
	<servlet>  
	    <servlet-name>DruidStatView</servlet-name>  
	    <servlet-class>com.alibaba.druid.support.http.StatViewServlet</servlet-class>  
	    <init-param>  
		<!-- 允许清空统计数据 -->  
		<param-name>resetEnable</param-name>  
		<param-value>true</param-value>  
	    </init-param>  
	    <init-param>  
		<!-- 用户名 -->  
		<param-name>loginUsername</param-name>  
		<param-value>admin</param-value>  
	    </init-param>  
	    <init-param>  
		<!-- 密码 -->  
		<param-name>loginPassword</param-name>  
		<param-value>sj111</param-value>  
	    </init-param>  
	</servlet>  
	<servlet-mapping>  
	    <servlet-name>DruidStatView</servlet-name>  
	    <url-pattern>/druid/*</url-pattern>  
	</servlet-mapping>  
	<!-- 连接池 启用Web监控统计功能   end-->

applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:tx="http://www.springframework.org/schema/tx"
	xmlns:aop="http://www.springframework.org/schema/aop"
	xmlns:context="http://www.springframework.org/schema/context"    
	xsi:schemaLocation="http://www.springframework.org/schema/beans 
	http://www.springframework.org/schema/beans/spring-beans-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
	http://www.springframework.org/schema/context
	http://www.springframework.org/schema/context/spring-context-3.0.xsd">

	<!-- 采用注释的方式配置bean -->  
    <context:annotation-config />  
    <!-- 配置要扫描的包 -->  
    <context:component-scan base-package="com.icss.ah"></context:component-scan>  
    <!--proxy-target-class="true"强制使用cglib代理   如果为false则spring会自动选择-->  
    <aop:aspectj-autoproxy  proxy-target-class="true"/> 
	
	<!-- 配置数据源 -->
	
	<!--  <bean id="dataSource_wx" class="org.springframework.jndi.JndiObjectFactoryBean">
		<property name="jndiName" >
			<value>java:comp/env/jdbc/wx</value>
		</property>
	</bean>  -->
	
	
	<bean id="sqlSessionFactory_wx" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource_wx" />
		<property name="databaseIdProvider" ref="databaseIdProvider"/>
		<property name="configLocation" value="classpath:mybatis-config.xml"/>
		
	</bean>
	<!-- 配置SqlSessionTemplate -->  
    <bean id="sqlSessionTemplate_wx" class="org.mybatis.spring.SqlSessionTemplate">  
        <constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory_wx" />  
    </bean>
<!-- 第二个数据源  -->    
  <!--   <bean id="dataSource_temp" class="org.springframework.jndi.JndiObjectFactoryBean">
		<property name="jndiName" >
			<value>java:comp/env/jdbc/etmp</value>
		</property>
	</bean> -->
	
	<bean id="sqlSessionFactory_temp" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource_temp" />
		<property name="databaseIdProvider" ref="databaseIdProvider"/>
		<property name="configLocation" value="classpath:mybatis-configdb2.xml"/>
		
	</bean>
	<!-- 配置SqlSessionTemplate -->  
    <bean id="sqlSessionTemplate_temp" class="org.mybatis.spring.SqlSessionTemplate">  
        <constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory_temp" />  
    </bean>
    
      <!-- 阿里druid数据库连接池 -->
	<bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">  
		<property name="locations">  
			<list>  
                 <value>classpath:dbconfig.properties</value>  
            </list>  
        </property>  
	</bean> 
    <bean id="dataSource_wx" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="close">  
         <!-- 数据库基本信息配置 -->
         <property name="url" value="${url}" />  
         <property name="username" value="${username}" />  
         <property name="password" value="${password}" />  
         <property name="driverClassName" value="${driverClassName}" />  
         <property name="filters" value="${filters}" />  
         <property name="initialSize" value="${initialSize}" /><!-- 初始化连接数量 -->
         <property name="maxActive" value="${maxActive}" /><!-- 最大并发连接数 -->
         <property name="minIdle" value="${minIdle}" /><!-- 最小连接池数量 -->
         <property name="maxWait" value="${maxWait}" /><!-- 配置获取连接等待超时的时间 -->
         <property name="timeBetweenEvictionRunsMillis" value="${timeBetweenEvictionRunsMillis}" /><!-- Destroy线程会检测连接的间隔时间，如果连接空闲时间大于等于minEvictableIdleTimeMillis则关闭物理连接，testWhileIdle的判断依据 -->
         <property name="minEvictableIdleTimeMillis" value="${minEvictableIdleTimeMillis}" /><!-- 连接保持空闲而不被驱逐的最长时间 -->
         <property name="validationQuery" value="${validationQuery}" /><!-- 用来检测连接是否有效的sql，要求是一个查询语句，常用select 'x' -->
         <property name="testWhileIdle" value="${testWhileIdle}" /><!-- 建议配置为true，不影响性能，并且保证安全性。申请连接的时候检测，如果空闲时间大于timeBetweenEvictionRunsMillis，执行validationQuery检测连接是否有效 -->
         <property name="testOnBorrow" value="${testOnBorrow}" /><!-- 申请连接时执行validationQuery检测连接是否有效，做了这个配置会降低性能 -->
         <property name="testOnReturn" value="${testOnReturn}" /><!-- 归还连接时执行validationQuery检测连接是否有效，做了这个配置会降低性能。 -->
         <property name="maxOpenPreparedStatements" value="${maxOpenPreparedStatements}" /><!-- 连接保持空闲而不被驱逐的最长时间 -->
         <property name="removeAbandoned" value="${removeAbandoned}" /><!-- 是否打开removeAbandoned功能，排查程序中是否有连接未关闭用，平时关闭 -->
         <property name="removeAbandonedTimeout" value="${removeAbandonedTimeout}" /><!-- 1800秒，也就是30分钟 -->
         <property name="logAbandoned" value="${logAbandoned}" /><!-- 关闭abanded连接时输出错误日志 -->
	</bean>
	
	 <bean id="dataSource_temp" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="close">  
         <!-- 数据库基本信息配置 -->
         <property name="url" value="${urltem}" />  
         <property name="username" value="${usernameterm}" />  
         <property name="password" value="${passwordtem}" />  
         <property name="driverClassName" value="${driverClassNametem}" />  
         <property name="filters" value="${filters}" />  
         <property name="initialSize" value="${initialSize}" /><!-- 初始化连接数量 -->
         <property name="maxActive" value="${maxActive}" /><!-- 最大并发连接数 -->
         <property name="minIdle" value="${minIdle}" /><!-- 最小连接池数量 -->
         <property name="maxWait" value="${maxWait}" /><!-- 配置获取连接等待超时的时间 -->
         <property name="timeBetweenEvictionRunsMillis" value="${timeBetweenEvictionRunsMillis}" /><!-- Destroy线程会检测连接的间隔时间，如果连接空闲时间大于等于minEvictableIdleTimeMillis则关闭物理连接，testWhileIdle的判断依据 -->
         <property name="minEvictableIdleTimeMillis" value="${minEvictableIdleTimeMillis}" /><!-- 连接保持空闲而不被驱逐的最长时间 -->
         <property name="validationQuery" value="${validationQuerytem}" /><!-- 用来检测连接是否有效的sql，要求是一个查询语句，常用select 'x' -->
         <property name="testWhileIdle" value="${testWhileIdle}" /><!-- 建议配置为true，不影响性能，并且保证安全性。申请连接的时候检测，如果空闲时间大于timeBetweenEvictionRunsMillis，执行validationQuery检测连接是否有效 -->
         <property name="testOnBorrow" value="${testOnBorrow}" /><!-- 申请连接时执行validationQuery检测连接是否有效，做了这个配置会降低性能 -->
         <property name="testOnReturn" value="${testOnReturn}" /><!-- 归还连接时执行validationQuery检测连接是否有效，做了这个配置会降低性能。 -->
         <property name="maxOpenPreparedStatements" value="${maxOpenPreparedStatements}" /><!-- 连接保持空闲而不被驱逐的最长时间 -->
         <property name="removeAbandoned" value="${removeAbandoned}" /><!-- 是否打开removeAbandoned功能，排查程序中是否有连接未关闭用，平时关闭 -->
         <property name="removeAbandonedTimeout" value="${removeAbandonedTimeout}" /><!-- 1800秒，也就是30分钟 -->
         <property name="logAbandoned" value="${logAbandoned}" /><!-- 关闭abanded连接时输出错误日志 -->
	</bean>
    
    <!-- 配置支持多类型数据库 -->
	<bean id="vendorProperties" class="org.springframework.beans.factory.config.PropertiesFactoryBean">  
        <property name="properties">  
            <props>  
                <prop key="SQL Server">sqlserver</prop>
                <prop key="DB2">db2</prop>
                <prop key="Oracle">oracle</prop>
                <prop key="MySQL">mysql</prop>
                <prop key="H2">h2</prop>
            </props>  
        </property>  
    </bean>
    <bean id="databaseIdProvider" class="org.apache.ibatis.mapping.VendorDatabaseIdProvider"> 
    	<property name="properties" ref="vendorProperties"/>
	</bean>
	
	<!-- 事务相关控制 -->
	<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="dataSource_wx"/>
	</bean>
	
	<tx:advice id="txAdvice" transaction-manager="transactionManager">
		<tx:attributes>
			<tx:method name="*" propagation="REQUIRED"></tx:method>
			<tx:method name="find*" propagation="SUPPORTS"/>
			<tx:method name="list*" propagation="SUPPORTS"/>
			<tx:method name="get*" propagation="SUPPORTS"/>
			<tx:method name="select*" propagation="SUPPORTS"/>
		</tx:attributes>
	</tx:advice>
	
	
	<!-- 阿里druid spring监控配置 -->
	<bean id="druid-stat-interceptor" class="com.alibaba.druid.support.spring.stat.DruidStatInterceptor"></bean>
	<bean id="druid-stat-pointcut" class="org.springframework.aop.support.JdkRegexpMethodPointcut" scope="prototype">
		<property name="patterns">
			<list>
				<value>com.icss.ah.*.service.*</value>
			</list>
		</property>
	</bean>
	<aop:config>
		<aop:advisor advice-ref="druid-stat-interceptor" pointcut-ref="druid-stat-pointcut" />
	</aop:config>
	<!-- <aop:config proxy-target-class="true">
		<aop:pointcut id="beanPointcut"
			expression="execution(* com.icss.ah.*.service.*.*(..))" />
		<aop:advisor advice-ref="txAdvice" pointcut-ref="beanPointcut" />
	</aop:config> -->
	
</beans>

转载于:https://my.oschina.net/u/3053442/blog/1537493

乐奇 Rokid 开放社区

更多推荐

AR 智能眼镜并不是简单地在眼前放一块屏幕，而是把**摄像头、传感器、计算机视觉、空间定位、语音交互和云端服务**连接起来

乐奇 Rokid 开放社区

让界面替我“摇“一次：一个AR祈愿智能体的AIUI实践

乐奇 Rokid 开放社区

智能眼镜市场全景解析：从技术演进到产业格局

本文系统梳理智能眼镜市场，涵盖产品形态、技术演进、市场规模、产业链结构及竞争格局。指出智能眼镜正从音频交互向AR显示与空间计算演进，受AI大模型、供应链成熟与生态延伸驱动，呈现分层发展态势。虽面临场景刚需不足、续航重量矛盾与隐私挑战，但B端应用先行、AI原生设计与标准完善将推动行业迈向规模化渗透，未来需关注核心技术突破与真实使用数据。