Hello,
This information is regarding configuration of Knowledge Exchange using Tomcat as the application server when connecting to SQL databases. To avoid Database connection loss after a long run of the Tomcat service you can make a couple of changes to your server configuration. One way to address this is to add parameters to the KEServer.xml file (as shown in example 1 below) and the other way is to set weekly Tomcat service restarts.
1) So, you should add:
testOnborrow="true" testWhileIdle="true" testOnReturn="true"
See below KEServer.xml as an example:
<?xml version="1.0" encoding="UTF-8"?>
I have attached a KEServer.xml file that you can keep as a hardcopy example.
Thanks,
Matt Michael
---
Note: Some information in this post has been hidden to protect privacy.
