java.sql.SQLException: Timed out trying to establish connection". It looks weird that a timeout may have happened since the error will always be thrown immediately. Therefor I suppose there is another root cause for failing to establish the connection. Any ideas out there? Please note that we simulated connection establishment with a console application aside coldfusion but using the same jvm and jdbc driver successfully. it does therefore not seem to be a jvm or driver or oci.dll related issue. data source settings : Driver Class : oracle.jdbc.driver.OracleDriver JDBC URL (using tnsnames.ora) : jdbc:oracle:oci:@<theName> JDBC URL (using ip, port, service) : jdbc:oracle:oci:@//<IP>:1521/<SID> error message : Connection verification failed for data source: theName java.sql.SQLException: Timed out trying to establish connection The root cause was that: java.sql.SQLException: Timed out trying to establish connection environment : ojdbc6 driver lives in a directory known to coldfusion oci.dll lives in a directory known to the system path variable, verified by sysinternals processexplorer on the coldfusion service for the JDBC URL (using tnsnames.ora), the directory containing tnsnames.ora is known as a system variable TNS_ADMIN, verified by sysinternals processexplorer on the coldfusion service along with tnsnames.ora there is a sqlnet.ora file comprising settings to switch on data encryption Stacktrace: A non-SQL error occurred while requesting a connection from "datasource-name here". Timed out trying to establish connection Exception in thread "Thread-2120" java.lang.UnsatisfiedLinkError: no ocijdbc11 in java.library.path

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Stack Overflow by thomas42
, 1 year ago
? Please note that we simulated connection establishment with a console application aside coldfusion but using the same jvm and jdbc driver successfully. it does therefore not seem to be a jvm or driver or oci.dll related issue. data source settings
via Oracle Community by 452974, 1 year ago
Problems with loading native library/missing methods: Can't find library ttJdbc (libttJdbc.so or .so) in sun.boot.library.path or java.library.path sun.boot.library.path=/usr/java14/jre/bin java.library.path=/usr/java14/jre/bin:/usr/java14/jre/bin/classic:/usr/java14/jre/bin:/opt/tt/TimesTen/tt70/lib:/opt/tt/TimesTen/tt70/lib/libttJdbc.so:/usr/lib
java.sql.SQLException: Timed out trying to establish connection". It looks weird that a timeout may have happened since the error will always be thrown immediately. Therefor I suppose there is another root cause for failing to establish the connection. Any ideas out there? Please note that we simulated connection establishment with a console application aside coldfusion but using the same jvm and jdbc driver successfully. it does therefore not seem to be a jvm or driver or oci.dll related issue. data source settings : Driver Class : oracle.jdbc.driver.OracleDriver JDBC URL (using tnsnames.ora) : jdbc:oracle:oci:@<theName> JDBC URL (using ip, port, service) : jdbc:oracle:oci:@//<IP>:1521/<SID> error message : Connection verification failed for data source: theName java.sql.SQLException: Timed out trying to establish connection The root cause was that: java.sql.SQLException: Timed out trying to establish connection environment : ojdbc6 driver lives in a directory known to coldfusion oci.dll lives in a directory known to the system path variable, verified by sysinternals processexplorer on the coldfusion service for the JDBC URL (using tnsnames.ora), the directory containing tnsnames.ora is known as a system variable TNS_ADMIN, verified by sysinternals processexplorer on the coldfusion service along with tnsnames.ora there is a sqlnet.ora file comprising settings to switch on data encryption Stacktrace: A non-SQL error occurred while requesting a connection from "datasource-name here". Timed out trying to establish connection Exception in thread "Thread-2120" java.lang.UnsatisfiedLinkError: no ocijdbc11 in java.library.path
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1860)
at java.lang.Runtime.loadLibrary0(Runtime.java:845)
at java.lang.System.loadLibrary(System.java:1084)
at oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:3560)
at oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java:3556)
at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:269)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:553)
at oracle.jdbc.driver.T2CConnection.(T2CConnection.java:165)
at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:53)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)
at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:614)
at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67)
at java.lang.Thread.run(Thread.java:722)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.