myBatis连接超时问题

mybatis 有时一段时间没有对数据库（sql server）进行操作，在对数据库操作时，会报错。

在网上查到 的是要在 mybatis 的配置文件里加上

<property name="poolPingEnabled" value="true"/>
<property name="poolPingQuery" value="select 1"/>




整体如下：







   < environment  id = "development" >

             < transactionManager  type = "jdbc"  />

             < dataSource  type = "POOLED" >

                 < property  name = "driver"  value = "com.sql.jdbc.Driver"  />

                 < property  name = "url"  value = "jdbc:sql://localhost:1433/kpi?autoReconnect=true"  />

                 < property  name = "username"  value = "sql"  />

                 < property  name = "password"  value = "sql"  />

              < property  name = "poolPingEnabled"  value = "true" />

              < property   name = "poolPingQuery"   value = "select 1" />

                 < property  name = "poolPingConnectionsNotUsedFor"  value = "3600000" />

             </ dataSource >

</ environment >