I use Mybatis 3.0.6,
and I got this Exception:
org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.sql.SQLException: Io
Exception: Software caused connection abort: recv failed
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### Cause: java.sql.SQLException: Io Exception: Software caused
connection abort: recv failed
My config like this:
<dataSource type="POOLED">
<property name="driver" value="${JDBC.Driver}" />
<property name="url" value="${JDBC.Url}" />
<property name="username" value="${JDBC.UserName}" />
<property name="password" value="${JDBC.UserPassword}" />
<property name="poolMaximumActiveConnections" value="20"/>
<property name="poolMaximumIdleConnections" value="10"/>
<property name="poolMaximumCheckoutTime" value="30000"/>
<property name="poolTimeToWait" value="30000"/>
<property name="poolPingEnabled" value="true"/>
<property name="poolPingQuery" value="select 1 from dual"/>
<property name="poolPingConnectionsNotUsedFor" value="5"/>
</dataSource>
and the connection status of the remote database is not very good,
how can I avoid the above exception occurs?
Locked
