Servlet.service() for servlet [dispatcher] in context with path [/testws] threw exception [Request processing failed; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Closed Connection] with root cause
java.sql.SQLException: Closed Connection 

<?xml version="1.0" encoding="UTF-8"?>
<Context antiJARLocking="true" path="/test">
    <Resource name="jdbc/connect" 
              auth="Container" 
              connectionCachingEnabled="true" 
              factory="oracle.jdbc.pool.OracleDataSourceFactory" 
              password="testpassword" 
              type="oracle.jdbc.pool.OracleDataSource" 
              url="jdbc:oracle:thin:@192.168.1.1:1521:test" 
              user="testuser"
              
              testOnBorrow="true"
              testWhileIdle="true"
              timeBetweenEvictionRunsMillis="100000"
              queryTimeout="10000"
              validationQuery="select 1 from dual"
              validationQueryTimeout="2"
              initialSize="15"
              maxActive="15"
              maxIdle="15"
        />
</Context>    

...testOnBorrow="true"
              testWhileIdle="true"
              timeBetweenEvictionRunsMillis="100000"
              queryTimeout="10000"
              validationQuery="select 1 from dual"
              validationQueryTimeout="2"
              initialSize="15"
              maxActive="15"
              maxIdle="15"...

<jee:jndi-lookup  id="testpool" jndi-name="jdbc/test" />
    <bean id="dao" class="com.libs.dao.Dao">
        <property name="dataSource" ref="testpool"/>
        <property name="rowMaper" ref="daoRowMaper"/>
    </bean>

<Resource 
... 
connectionCacheProperties=”{MaxStatementsLimit=0, MinLimit=0, InitialLimit=0, ValidateConnection=true, ConnectionWaitTimeout=600, MaxLimit=10000}” 
...
 />

<Resource 
... 
connectionCacheProperties=”{MaxStatementsLimit=0, MinLimit=0, InitialLimit=0, ValidateConnection=true, ConnectionWaitTimeout=600, MaxLimit=10000}” 
...
 />

<Resource 
... 
connectionCacheProperties=”{MaxStatementsLimit=0, MinLimit=0, InitialLimit=0, ValidateConnection=true, ConnectionWaitTimeout=600, MaxLimit=10000}” 
...
 />

...
connectionCachingEnabled="true"
...

...
connectionCachingEnabled="true"
...

connectionCacheProperties="MinLimit=1, MaxLimit=5, InitialLimit=1, AbandonedConnectionTimeout=300, ValidateConnection=true, TimeToLiveTimeout=300, InactivityTimeout=300, removeAbandoned=true, removeAbandonedTimeout=60, logAbandoned=true"