用到Spring的jdbc时 org.springframework.jdbc.datasource.DriverManagerDataSource, 发现频繁访问数据库时(数据导入)候出现连接中断。
Apache连接池解决:
http://commons.apache.org/proper/commons-dbcp/download_dbcp.cgi
<dependency groupid="commons-pool" artifactid="commons-pool" version="1.6"/>
<dependency groupid="commons-dbcp" artifactid="commons-dbcp" version="1.4"/>
Apache连接池解决:
http://commons.apache.org/proper/commons-dbcp/download_dbcp.cgi
<!-- 数据源配置,使用应用内的DBCP数据库连接池 -->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<!-- Connection Info -->
<property name="driverClassName" value="${datasource.driverClassName}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
<!-- Connection Pooling Info -->
<property name="initialSize" value="5" />
<property name="maxActive" value="100" />
<property name="maxIdle" value="30" />
<property name="maxWait" value="1000" />
<property name="poolPreparedStatements" value="true" />
<property name="defaultAutoCommit" value="false" />
</bean>
<dependency groupid="commons-pool" artifactid="commons-pool" version="1.6"/>
<dependency groupid="commons-dbcp" artifactid="commons-dbcp" version="1.4"/>