Coldfusion 2016 JDBC Connection To Oracle
Connection to oracle database times out until i remote into the server running coldfusion.
I’m setting up a new coldfusion 2016 standard server on windows server 2016. I have successfully created a datasource that points to an oracle database using the oracle jdbc driver. The datasource validates, and a coldfusion application that uses that datasource works most of the time. The problem arises after many hours or non-use (this is a server that is not in production yet). Usually in the morning i access the coldfusion application and i get an error that the connection to the database has timed out. If I remote into the server where coldfusion is installed, the application immediately starts working again, using the datasource without any issues. When I say I remote into the server, I am doing nothing else. I simply log into the server. I am not accessing coldfusion administrator or anything else on the server. Any ideas as to what might be going on here?