A non-SQL error occurred while requesting a connection from JDBC_DSN.
Timed out trying to establish connection
Error [jrpp-nnnn] - Error Executing Database Query.Timed out trying to establish connection The specific sequence of files included or processed is: \filepath\index.cfm, line: nn
I have seen errors as above when using JDBC Microsoft SQL database connections (I do not use Oracle). It turned out the CF Java was having heap size or garbage collection problems. Once the CF Java problems were resolved via some JVM tuning the JDBC errors did not re-occur.
Thanks Carl, I am going to try Oracle 11g R1 client and see if that makes a difference.