All Forums Connectivity
wmv 2 posts Joined 11/13
24 Nov 2013
Problem with server name

com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC 14.10.00.17] [Error 1000] [SQLState 08S01] Login failure for Connection to testServer Mon Nov 25 00:48:26 COT 2013 socket orig=testServer cid=3dc01d78 sess=0 java.net.UnknownHostException: testServer   at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)   at java.net.InetAddress$1.lookupAllHostAddr(Unknown Source)   at java.net.InetAddress.getAddressesFromNameService(Unkno wn Source)   at java.net.InetAddress.getAllByName0(Unknown Source)   at java.net.InetAddress.getAllByName(Unknown Source)   at java.net.InetAddress.getAllByName(Unknown Source)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.<init >(TDNetworkIOIF.java:185)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHos t(TDNetworkIOIF.java:284)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocket Connection(TDNetworkIOIF.java:133)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNet workIOIF.java:119)   at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.jav a:587)   at com.teradata.jdbc.jdbc.GenericLogonController.run(Gene ricLogonController.java:97)   at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.ja va:216)   at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6 _SQL_Connection.java:35)   at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.construct SQLConnection(JDK6ConnectionFactory.java:25)   at com.teradata.jdbc.jdbc.ConnectionFactory.createConnect ion(ConnectionFactory.java:179)   at com.teradata.jdbc.jdbc.ConnectionFactory.createConnect ion(ConnectionFactory.java:169)   at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java :232)   at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java: 158)   at com.teradata.datatools.dtp.connectivity.db.teradata.Te radataJDBCConnection.makeConnection(TeradataJDBCConnec tion.java:293)   at com.teradata.datatools.dtp.connectivity.db.teradata.Te radataJDBCConnection.createConnection(TeradataJDBCConn ection.java:121)   at org.eclipse.datatools.connectivity.DriverConnectionBas e.internalCreateConnection(DriverConnectionBase.java: 105)   at org.eclipse.datatools.connectivity.DriverConnectionBas e.open(DriverConnectionBase.java:54)   at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCCo nnection.open(JDBCConnection.java:73)   at com.teradata.datatools.dtp.connectivity.db.teradata.Te radataPingFactory.createConnection(TeradataPingFactory .java:36)   at org.eclipse.datatools.connectivity.internal.Connection FactoryProvider.createConnection(ConnectionFactoryProv ider.java:83)   at org.eclipse.datatools.connectivity.internal.Connection Profile.createConnection(ConnectionProfile.java:359)   at org.eclipse.datatools.connectivity.ui.PingJob.createTe stConnection(PingJob.java:76)   at org.eclipse.datatools.connectivity.ui.PingJob.run(Ping Job.java:59)   at org.eclipse.core.internal.jobs.Worker.run(Worker.java: 54)  

at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJ DBCException(ErrorFactory.java:93)

at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJ DBCException(ErrorFactory.java:68)

at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeIoJDBCE xception(ErrorFactory.java:206)

at com.teradata.jdbc.jdbc_4.util.ErrorAnalyzer.analyzeIoE rror(ErrorAnalyzer.java:61)

at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocket Connection(TDNetworkIOIF.java:140)

at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNet workIOIF.java:119)

at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.jav a:587)

at com.teradata.jdbc.jdbc.GenericLogonController.run(Gene ricLogonController.java:97)

at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.ja va:216)

at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6 _SQL_Connection.java:35)

at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.construct SQLConnection(JDK6ConnectionFactory.java:25)

at com.teradata.jdbc.jdbc.ConnectionFactory.createConnect ion(ConnectionFactory.java:179)

at com.teradata.jdbc.jdbc.ConnectionFactory.createConnect ion(ConnectionFactory.java:169)

at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java :232)

at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java: 158)

at com.teradata.datatools.dtp.connectivity.db.teradata.Te radataJDBCConnection.makeConnection(TeradataJDBCConnec tion.java:293)

at com.teradata.datatools.dtp.connectivity.db.teradata.Te radataJDBCConnection.createConnection(TeradataJDBCConn ection.java:121)

at org.eclipse.datatools.connectivity.DriverConnectionBas e.internalCreateConnection(DriverConnectionBase.java: 105)

at org.eclipse.datatools.connectivity.DriverConnectionBas e.open(DriverConnectionBase.java:54)

at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCCo nnection.open(JDBCConnection.java:73)

at com.teradata.datatools.dtp.connectivity.db.teradata.Te radataPingFactory.createConnection(TeradataPingFactory .java:36)

at org.eclipse.datatools.connectivity.internal.Connection FactoryProvider.createConnection(ConnectionFactoryProv ider.java:83)

at org.eclipse.datatools.connectivity.internal.Connection Profile.createConnection(ConnectionProfile.java:359)

at org.eclipse.datatools.connectivity.ui.PingJob.createTe stConnection(PingJob.java:76)

at org.eclipse.datatools.connectivity.ui.PingJob.run(Ping Job.java:59)

at org.eclipse.core.internal.jobs.Worker.run(Worker.java: 54)

Caused by: java.net.UnknownHostException: testServer

at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)

at java.net.InetAddress$1.lookupAllHostAddr(Unknown Source)

at java.net.InetAddress.getAddressesFromNameService(Unkno wn Source)

at java.net.InetAddress.getAllByName0(Unknown Source)

at java.net.InetAddress.getAllByName(Unknown Source)

at java.net.InetAddress.getAllByName(Unknown Source)

at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.<init >(TDNetworkIOIF.java:185)

at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHos t(TDNetworkIOIF.java:284)

at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocket Connection(TDNetworkIOIF.java:133)

 

 

 

 

I don't know what to do 

veehell 19 posts Joined 07/12
25 Nov 2013

Hi,
the main info from the java exception(s) is this:  Caused by: java.net.UnknownHostException: testServer
Which actually means, you are trying to reach server 'testServer' which is not reachable or/and the name cannot be resolved. 
So to fix this, you just need to add one entry to your 'hosts' file with correspond alias and ip. Then try re-connect (before trying jdbc ensure, you can ping, tracert and telnet your testServer on correspond ip/port).
This will work with direct network connection to you 'testServer'. If there is proxy/firewall between you and server, you possibly need to ask your network admin for some help.
 

cheers
-vh-

wmv 2 posts Joined 11/13
25 Nov 2013

Thank you!
 
but now there is another exception: java.io.IOException: Incomplete LAN message 
 
what change do i have to do to connect correctly? please.