Error Connecting to Database

Hi

I am getting the following error while connecting to teradata database. I have put the database driver to jre/lib/ext and registered at prefereances --> databases.

ERROR Database Connector   0:3        Execute failed: Could not create connection to database: 10.92.XXX.XX:1025: invalid IPv6 address

Please help to resolve this error. thank you.

Complete Error:

ERROR Database Reader      0:2        Execute failed: java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 14.10.00.44] [Error 1000] [SQLState 08S01] Login failure for Connection to 10.92.XXX.XX:1025 Fri Oct 21 14:07:12 SGT 2016 socket orig=10.92.139.27:1025 cid=28b0620 sess=0 java.net.UnknownHostException: 10.92.XXX.XX:1025: invalid IPv6 address  at java.net.InetAddress.getAllByName(InetAddress.java:1169)  at java.net.InetAddress.getAllByName(InetAddress.java:1126)  at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.<init>(TDNetworkIOIF.java:202)  at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:302)  at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:150)  at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNetworkIOIF.java:136)  at com.teradata.jdbc.jdbc.GenericTeradataConnection.getIO(GenericTeradataConnection.java:118)  at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:98)  at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:205)  at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:35)  at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructSQLConnection(JDK6ConnectionFactory.java:25)  at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:179)  at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:169)  at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:232)  at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:158)  at org.knime.core.node.port.database.DatabaseWrappedDriver.connect(DatabaseWrappedDriver.java:81)  at org.knime.core.node.port.database.connection.CachedConnectionFactory.createConnection(CachedConnectionFactory.java:266)  at org.knime.core.node.port.database.connection.CachedConnectionFactory$1.call(CachedConnectionFactory.java:209)  at org.knime.core.node.port.database.connection.CachedConnectionFactory$1.call(CachedConnectionFactory.java:1)  at org.knime.core.util.ThreadUtils$CallableWithContextImpl.callWithContext(ThreadUtils.java:344)  at org.knime.core.util.ThreadUtils$CallableWithContext.call(ThreadUtils.java:244)  at java.util.concurrent.FutureTask.run(FutureTask.java:266)  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)  at java.lang.Thread.run(Thread.java:745)

I believe the port number is making your IPv4 address look like a malformed IPv6 address. Try to remove the port number from 10.92.XXX.XX:1025 and see whether this solves the issue. In other words, use 10.92.XXX.XX only.

Cheers,
Marco.

Dear Marco,

What a perfect catch!
Thank you so much for the help. It worked fine.

Thanks and Regards
Prasanna Hebballi