If you're running into problems every so often where users are unable to login or can't seem to connect  to the database through Contour you may be losing connection to the database. The implementation below forces the database to refresh its connection and should ensure the connection no longer closes.

Stop Tomcat Service 1st

Edit [%tomcat%]\webapps\contour\WEB-INF\contour-data.xml

Find:

<bean id="dataSource"

                                class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">

</bean>

Replace with:

<bean id="dataSource"

                                class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">

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

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

</bean>

Start Tomcat Service