Abnormal:
Cause:java.sql.SQLException:Io exception:connection Reset
Problem reason: Configuring connection pooling issues
Solve:
A, such as (JNDI)
<Resourcename= "Jnditest"Auth= "Container"type= "Javax.sql.DataSource"Filters= "Stat"Factory= "Com.alibaba.druid.pool.DruidDataSourceFactory"InitialSize= "Ten"maxactive= "$"Minidle= " the"maxwait= "300000"Timebetweenevictionrunsmillis= "60000"Validationquery= "Select 1 from Dual"Driverclassname= "Oracle.jdbc.OracleDriver"Testonborrow= "false"Testwhileidle= "true"Testonreturn= "false"removeabandoned= "true"Removeabandonedtimeout= "1800"poolpreparedstatements= "false"PassWord="******"URL="******"/> </Context>
b, such as (Project DataSource)
<!--Configure initialization size, minimum, maximum -< Propertyname= "InitialSize"value= "5" />< Propertyname= "Minidle"value= "5" />< Propertyname= "Maxactive"value= " the" /><!--Configure the time to get the connection wait timeout -< Propertyname= "Maxwait"value= "60000" /><!--How often the configuration interval is detected to detect idle connections that need to be closed, in milliseconds -< Propertyname= "Timebetweenevictionrunsmillis"value= "60000" /><!--configures the minimum lifetime of a connection in a pool, in milliseconds -< Propertyname= "Minevictableidletimemillis"value= "300000" />< Propertyname= "Validationquery"value= "Select ' X '" />< Propertyname= "Testwhileidle"value= "true" />< Propertyname= "Testonborrow"value= "false" />< Propertyname= "Testonreturn"value= "false" /><!--turn on the removeabandoned feature -< Propertyname= "removeabandoned"value= "true" />< Propertyname= "Removeabandonedtimeout"value= "1800" /> <!--1800 seconds, that's 30 minutes. -< Propertyname= "logabandoned"value= "true" /> <!--output error log when abanded connection is closed -<!--open Pscache, and specify the size of Pscache on each connection, MySQL does not use -< Propertyname= "Poolpreparedstatements"value= "false" /><!--Configuring filters for monitoring statistics interception -< Propertyname= "Filters"value= "Stat" />
Io exception:connection Reset