database jdbc jar registration doesn't work

I need to register a Teradata JDBC driver to get access to the data.

I followed the instruictions to register the jars but in the Jar List folder all buttoms beside the Cancel buttom are inactive (see attachement) -> I can't register the jars.

Any idea how to overcome this?


Unless you're using a different database plugin of which I'm not aware, the DB config is in Preferences -> KNIME -> Databases (you're in the wrong settings according to your screenshot).




I am trying to also access Teradata and I am getting the following error (I have the debug flag on):

RROR Database Reader      0:1        Execute failed: java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC] [Error 1000] [SQLState 08S01] Login failure for Connection to Mon Jan 18 11:09:29 AEDT 2016 socket cid=34674aa9 sess=0   at Method)   at$2.lookupAllHostAddr(   at   at   at   at   at$Lookup.<init>(   at   at   at<init>(   at com.teradata.jdbc.jdbc.GenericTeradataConnection.getIO(   at   at com.teradata.jdbc.jdbc_4.TDSession.<init>(   at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(   at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructSQLConnection(   at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(   at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(   at com.teradata.jdbc.TeraDriver.doConnect(   at com.teradata.jdbc.TeraDriver.connect(   at org.knime.core.node.port.database.DatabaseWrappedDriver.connect(   at org.knime.core.node.port.database.DatabaseConnectionSettings$   at org.knime.core.node.port.database.DatabaseConnectionSettings$   at org.knime.core.util.ThreadUtils$CallableWithContextImpl.callWithContext(   at org.knime.core.util.ThreadUtils$   at   at java.util.concurrent.ThreadPoolExecutor.runWorker(   at java.util.concurrent.ThreadPoolExecutor$   at  

====== end =====

Couple of questions:

1. Teradata comes with the JDBC driver (Terajdbc4.jar) file but also has the tdgssconfig.jar, which I am not sure what to do? if you are writting java code, it says that is a way of assigning classpath= etc. but what do I do in KNIME?

2. What does the error message mean?




PS. Loving version 3.1



Hi Tom,

any additional jars (e.g. tdgssconfig.jar) that the jdbc driver requires need to be copied into the <KNIME INSTALL>jre/lib/ext folder.

The error message indicates that KNIME can not connect to the specified host (see UnknownHostException). Please make sure that you can connect the db server and that the required db ports aren't blocked by any firewall.