Troubleshoot JDBC with the stack, which indicates RDBMS crash or down:
D:\anuguraju\anuguraju\GeoSpatial\TestEnv>java -Xms256m -Xmx1024m -classpath .;tdgssconfig.jar;terajdbc4.jar;tdgeospatial.jar; com.teradata.geo.TDGeoExport -l hyvm111/ab,ab -s ab -t customers -f "ESRI Shapefile" point -o D:\anuguraju\anuguraju\GeoSpatial\TestEnv\geodata -n customers Coordinate System defaulting to NAD83. WARNING: There is data in the directory D:\ANUGURAJU\ANUGURAJU\GEOSPATIAL\TESTEN V\GEODATA which was specified. If you continue, and there is pre-existing data for layer CUSTOMERS, all data for that layer will be OVERWRITTEN. Would you like to continue? [y,n] y Logon = hyvm111/ab,**** DatabaseName = AB Table Name = CUSTOMERS Export to = D:\ANUGURAJU\ANUGURAJU\GEOSPATIAL\TESTENV\GEODATA\CUSTOMERS File Format = ESRI Shapefile Shape Type = POINT Only 1 Type = FALSE ------------------------------------------- connecting to hyvm111 ...2014-01-07.14:26:10.963 TERAJDBC4 ERROR [main] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@1dff3a2 Connection to hyvm111 Tue Jan 07 14:2 6:10 IST 2014 socket orig=hyvm111 cid=8f4fb3 sess=0 java.net.SocketTimeoutException: connect timed out at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:529) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$ConnectThread.run(TDNetworkIOIF.java:968)com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC 14.00.00.01] [Error 1277] [SQLState 08S01] Login timeout for Connection to hyvm111 Tue Jan 07 14:26:10 IST 2014 socket orig=hyvm111 cid=8f4fb3 sess=0 java.net.SocketTimeoutException: connect timed out at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:529) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$ConnectThread.run(TDNetworkIOIF.java:968) at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:93) at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:68) at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeIoJDBCException(ErrorFactory.java:206) at com.teradata.jdbc.jdbc_4.util.ErrorAnalyzer.analyzeIoError(ErrorAnalyzer.java:61) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:137) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNetworkIOIF.java:116) at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.java:579) at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:94) at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:208) at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:30) at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructConnection(JDK6ConnectionFactory.java:22) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:130) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:120) at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:220) at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:153) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at com.teradata.geo.TDGeoExport.makeConnection(TDGeoExport.java:709) at com.teradata.geo.TDGeoExport.main(TDGeoExport.java:736) Caused by: java.net.SocketTimeoutException: connect timed out at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:529) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$ConnectThread.run(TDNetworkIOIF.java:968) Connecting to database failed. =========================================== Data exporting failed!
The following figure shows a stack trace in which a user does not exist on the database.
Stack Trace Example