While testing a remote data center today, we had some network connectivity issues. We twiddled our thumbs while waiting for connections to throw an exception due to a network block. <\/p>\n
I found the setLoginTimeout() method on the DriverManager class. You can use it as show below:<\/p>\n
\r\nimport java.sql.*;\r\n\r\npublic class checkConn {\r\n public static void main(String[] args) {\r\n try {\r\n Class.forName(\"oracle.jdbc.driver.OracleDriver\");\r\n System.out.println(DriverManager.getLoginTimeout());\r\n DriverManager.setLoginTimeout(20);\r\n System.out.println(DriverManager.getLoginTimeout());\r\n Connection conn = DriverManager.getConnection(\"jdbc:oracle:thin:@oh2xpwcdg01:2484\/hidden.service.domain\",\r\n args[0],\r\n args[1]);\r\n ResultSet rst = conn.createStatement().executeQuery(\"select sysdate, to_char ( sysdate, 'DD-MON-YYYY') from dual\");\r\n if (rst.next()) {\r\n System.out.println(rst.getDate(1) + \" \" + rst.getString(1));\r\n }\r\n }\r\n catch(Exception e) {\r\n e.printStackTrace();\r\n }\r\n }\r\n}\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"While testing a remote data center today, we had some network connectivity issues. We twiddled our thumbs while waiting for connections to throw an exception due to a network block. I found the setLoginTimeout() method on the DriverManager class. You…<\/p>\n