<bean id="calMysqlDataSource" class="org.apache.tomcat.jdbc.pool.DataSource"> <property name="driverClassName" value="${jdbc.driver}" /> <property name="url" value="${jdbc.url}" /> <property name="username" value="${jdbc.user}" /> <property name="password" value="${jdbc.password}" /> <property name="validationQuery" value="${jdbc.validationQuery}" /> <property name="maxActive" value="200" /> <property name="maxIdle" value="20" /> <property name="minIdle" value="20"/> <property name="maxWait" value="10000" /> <property name="testOnBorrow" value="true" /> <property name="testWhileIdle" value="true" /> <property name="removeAbandoned" value="true" /> <property name="removeAbandonedTimeout" value="120" /> <property name="defaultAutoCommit" value="false" /> </bean> <!-- 引入配置文件 --> <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="location" value="classpath:jdbc.properties" /> </bean>
Tomcat jdbc-pool数据库连接池出错:
Could not get JDBC Connection; nested exception is org.apache.tomcat.jdbc.pool.PoolExhaustedException: [XNIO-2task-6] Timeout: Pool empty. Unable to fetch a connection in 30 seconds, none available[size:100; busy:100; idle:0; lastwait:30000
<span style="color:#008080">出现以上错误通常是配置文件的编写出现错误,调整配置文件即可,可以参考一下配置文件:</span>