Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

JDBC Connection issue in NIFI on connecting to Teradata

Solved Go to solution
Highlighted

JDBC Connection issue in NIFI on connecting to Teradata

Hi Team,

I am facing the below issue while connecting Teradata from Nifi in processor "ExecuteSQL".

Error Message:

ExecuteSQL[id=db7852a7-015a-1000] Unable to execute SQL select query sel * from Table where Field1 = 'ABC' due to org.apache.nifi.processor.exception.ProcessException: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory ([Teradata JDBC Driver] [TeraJDBC 15.10.00.26] [Error 1000] [SQLState 08S01] Login failure for Connection to DATABASE Fri Mar 17 05:31:33 EDT 2017 socket orig=DATABASE cid=6829814b sess=0 java.net.UnknownHostException: DATABASE at java.net.InetAddress.getAllByName0(InetAddress.java:1280) at java.net.InetAddress.getAllByName(InetAddress.java:1192) at java.net.InetAddress.getAllByName(InetAddress.java:1126) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.doLookup(TDNetworkIOIF.java:221) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.getAddresses(TDNetworkIOIF.java:259) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:367) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:154) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNetworkIOIF.java:140) at com.teradata.jdbc.jdbc.GenericTeradataConnection.getIO(GenericTeradataConnection.java:127) at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:99) at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:209) at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:35)

Please let me know how to resolve this and proceed further.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: JDBC Connection issue in NIFI on connecting to Teradata

Hi @Gowthaman Jayachandran,

It looks like the JDBC URL you defined in the controller service is not correct and the host cannot be reached from the NiFi servers. What did you configure in the controller service:

13711-screen-shot-2017-03-17-at-123951-pm.png

I believe this URL should be something like:

jdbc:teradata://<host>:<port>/<DatabaseName>

Hope this helps.

View solution in original post

4 REPLIES 4
Highlighted

Re: JDBC Connection issue in NIFI on connecting to Teradata

Hi @Gowthaman Jayachandran,

It looks like the JDBC URL you defined in the controller service is not correct and the host cannot be reached from the NiFi servers. What did you configure in the controller service:

13711-screen-shot-2017-03-17-at-123951-pm.png

I believe this URL should be something like:

jdbc:teradata://<host>:<port>/<DatabaseName>

Hope this helps.

View solution in original post

Re: JDBC Connection issue in NIFI on connecting to Teradata

Hi @Pierre Villard, Thanks for your prompt response. Eventhough i have modified the URL as per your suggestion, it is throwing the same error. Below are the changes.

DB Connection URL: jdbc:teradata://DATABASE:1025/COTAINER_NAME

Database Driver Class Name: com.teradata.jdbc.TeraDriver

Please let me know how to proceed on it.

Highlighted

Re: JDBC Connection issue in NIFI on connecting to Teradata

In that case, what you call DATABASE (the server where your teradata is installed) must be reachable from all the NiFi nodes on port 1025. You can check if this working using the following command:

telnet DATABASE 1025

If it is not working then it is a network related issue: you need to allow communication between NiFi nodes and the database.

Highlighted

Re: JDBC Connection issue in NIFI on connecting to Teradata

@Pierre Villard,

Thanks for your quick response and help. I have changed my host and port to correct one. Now i can able to connect. Appreciate your help.

Don't have an account?
Coming from Hortonworks? Activate your account here