Unable to create a connection using the jdbc:teradata://10.65.140.250/DATABASE=rts_dev

Connectivity
Enthusiast

Unable to create a connection using the jdbc:teradata://10.65.140.250/DATABASE=rts_dev

HI Team,

Here is the log file for connectivity through JDBC application from Application server to TD server on linux.

16-Oct-2013 09:57:01IST Unable to create a connection using the jdbc:teradata://10.65.140.050/DATABASE=rts_dev,TMODE=ANSI,CHARSET=UTF16 URL with dbc username because of the following error: [Teradata JDBC Driver] [TeraJDBC 1

16-Oct-2013 09:57:01IST 4.00.00.00] [Error 1000] [SQLState 08S01] Login failure for Packet receive Wed Oct 16 09:57:01 IST 2013 socket orig=10.65.142.204 local=0.0.0.0/0.0.0.0:33409 remote=/10.65.142.204:1025 keepalive=unava

16-Oct-2013 09:57:01IST ilable nodelay=unavailable receive=unavailable send=unavailable linger=unavailable traffic=unavailable concurrent=3 contimeout=10000 conwait=1000 connecttime=6 connecttotaltime=8 connectattempts=1 con

16-Oct-2013 09:57:01IST nectfailures=0 failurecache={} cid=10fd7411 sess=20662 java.io.IOException: Incomplete LAN message header: read 0 bytes at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.read(TDNetworkIOIF.java:659) at c

16-Oct-2013 09:57:01IST om.teradata.jdbc.jdbc_4.io.TDPacketStream.readStream(TDPacketStream.java:818) at com.teradata.jdbc.jdbc.GenericEncryptContextState.action(GenericEncryptContextState.java:119) at com.teradata.jdbc.jd

16-Oct-2013 09:57:01IST bc.GenericLogonController.run(GenericLogonController.java:120) at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:212) at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connecti

16-Oct-2013 09:57:01IST on.java:30) at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructConnection(JDK6ConnectionFactory.java:22) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:130

16-Oct-2013 09:57:01IST ) 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(Ter

16-Oct-2013 09:57:01IST aDriver.java:153) at java.sql.DriverManager.getConnection(DriverManager.java:579) at java.sql.DriverManager.getConnection(DriverManager.java:221) at com.applimation.jdbc.JdbcTemplateFactory$AMDataS

16-Oct-2013 09:57:01IST ource.createConnection(JdbcTemplateFactory.java:620) at com.applimation.jdbc.JdbcTemplateFactory$AMDataSource.getConnection(JdbcTemplateFactory.java:611) at com.applimation.jdbc.JdbcTemplateFactory.

16-Oct-2013 09:57:01IST createJdbcTemplate(JdbcTemplateFactory.java:421) at com.applimation.jdbc.JdbcTemplateFactory.createJdbcTemplate(JdbcTemplateFactory.java:487) at com.applimation.jdbc.JdbcTemplateFactory.getJdbcTempl

16-Oct-2013 09:57:01IST ateForStaging(JdbcTemplateFactory.java:515) at com.applimation.archive.dao.impl.AbstractArchiveEngineDAOImpl.getJdbcTemplateForStaging(AbstractArchiveEngineDAOImpl.java:244) at com.applimation.archi

16-Oct-2013 09:57:01IST ve.dao.impl.InsertIntoDestinationTableDAOImpl.copyTableToDestination(InsertIntoDestinationTableDAOImpl.java:167) at com.applimation.archive.services.thread.CopyToDestinationThread.run(CopyToDestinati

16-Oct-2013 09:57:01IST onThread.java:130) at com.applimation.services.thread.AMThreadQueueManager$AMThreadQueueElement.run(AMThreadQueueManager.java:503) at java.lang.Thread.run(Thread.java:722)

16-Oct-2013 09:57:01IST com.applimation.jdbc.JdbcTemplateFactory.createJdbcTemplate(JdbcTemplateFactory.java:446)

16-Oct-2013 09:57:01IST com.applimation.jdbc.JdbcTemplateFactory.createJdbcTemplate(JdbcTemplateFactory.java:487)

16-Oct-2013 09:57:01IST com.applimation.jdbc.JdbcTemplateFactory.getJdbcTemplateForStaging(JdbcTemplateFactory.java:515)

16-Oct-2013 09:57:01IST com.applimation.archive.dao.impl.AbstractArchiveEngineDAOImpl.getJdbcTemplateForStaging(AbstractArchiveEngineDAOImpl.java:244)

16-Oct-2013 09:57:01IST com.applimation.archive.dao.impl.InsertIntoDestinationTableDAOImpl.copyTableToDestination(InsertIntoDestinationTableDAOImpl.java:167)

16-Oct-2013 09:57:01IST com.applimation.archive.services.thread.CopyToDestinationThread.run(CopyToDestinationThread.java:130)

16-Oct-2013 09:57:01IST com.applimation.services.thread.AMThreadQueueManager$AMThreadQueueElement.run(AMThreadQueueManager.java:503)

16-Oct-2013 09:57:01IST java.lang.Thread.run(Thread.java:722)

Can you pelase help me on this ?

My id : vvdrmca@gmail.com

THanks in advance

1 REPLY
Teradata Employee

Re: Unable to create a connection using the jdbc:teradata://10.65.140.250/DATABASE=rts_dev

Is your Java program running on a Linux machine? If so, then you may have encountered the "Slow Logon on Linux" problem. The problem, and workarounds, are documented in the Teradata JDBC Driver User Guide located here on Developer Exchange:

http://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_5.html#CHDDACIH