Hi all,
 
We are currently deploying a Cisco Contact Center solution
based on UCCE and CVP (both version 8.5).
It includes a number of Call Studio applications that
require querying business data in an AS/400 system.
 
We configured the VXML Tomcat server with the jt400.jar
library and the following JNDI data source:
 
    <Resource auth="Container"
                               
name="jdbc/as400test"
                               
url="jdbc:as400://<server ip>/ALPHAMB"
                               
driverClassName="com.ibm.as400.access.AS400JDBCDriver"
                               
type="javax.sql.DataSource"
                               
username="<omitted>"
                               
password="<omitted>"
                               
maxActive="4"
                               
maxIdle="2"
                               
maxWait="5000"
                               
removeAbandoned="true"
                               
removeAbandonedTimeout="300"
                               
validationQuery="SELECT 1 FROM SYSIBM.SYSDUMMY1"
                               
validationQueryTimeout="5"
                               
testOnBorrow="true"
                               
testWhileIdle="true"
                               
/>
 
The problem:
Every morning (and after every long period of inactivity)
our first call always times out on the database connection.
The actual timeout we experience is a VXML fetch timeout
(after 20 seconds). Meaning the VXML server is still busy trying to query the
data.
The second calls always goes through successfully (and very
fast).

 

So although we configured the parameters to have a
connection pool available, the underlying system does not seem to maintain it.

 
Anyone with experience on this particular situation?
Any recommendations on how to further debug this?
 
Thx!
Koen