67,513
社区成员
发帖
与我相关
我的任务
分享
<bean id="druidDataSource" class="com.alibaba.druid.pool.DruidDataSource"
init-method="init" destroy-method="close">
<property name="url" value="#{config.getValue('dataSource.url')}" />
<property name="username" value="#{config.getValue('dataSource.username')}" />
<property name="password" value="#{config.getValue('dataSource.password')}" />
<property name="driverClassName" value="#{config.getValue('dataSource.driverClassName')}" />
<property name="validationQuery" value="#{config.getValue('dataSource.validationQuery')}"></property>
<property name="initialSize" value="1" />
<property name="maxActive" value="3" />
<property name="minIdle" value="1" />
<property name="maxIdle" value="3" />
<property name="maxWait" value="100000" />
<property name="removeAbandoned" value="true"></property>
<property name="testOnBorrow" value="true"></property>
<property name="removeAbandonedTimeout" value="3"></property>
<property name="logAbandoned" value="true"></property>
<property name="poolPreparedStatements" value="false"></property>
<property name="testWhileIdle" value="true"></property>
<property name="testOnReturn" value="false"></property>
<property name="exceptionSorter">
<bean class="com.alibaba.druid.pool.vendor.MySqlExceptionSorter"></bean>
</property>
<property name="filters" value="stat" />
<property name="connectionProperties" value="druid.stat.slowSqlMillis=100" />
</bean>
@Test
public void testAbd2() throws Exception {
new Thread(new Runnable() {
@Override
public void run() {
try {
c1 = druidDataSource.getConnection();
c1.setAutoCommit(false);
c2 = druidDataSource.getConnection();
c2.setAutoCommit(false);
System.out.println("创建时间:" + new Date(System.currentTimeMillis()));
c1.commit();
c2.commit();
} catch (Exception e) {
e.printStackTrace();
}
}
}).start();
while(true){
System.out.println(new Date(System.currentTimeMillis()));
System.out.println(c1);
System.out.println(c2);
System.out.println("MaxActive:" + druidDataSource.getMaxActive());
System.out.println("ActiveCount:" + druidDataSource.getActiveCount());
Thread.sleep(10000);
}
}