Member since
08-14-2016
6
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
4172 | 08-16-2016 06:41 AM |
08-16-2016
06:41 AM
Hello, Thank you for the response, i am able to resolve this issue, there was issue in the connection string. Working String is like below. sqoop list-tables --driver com.informix.jdbc.IfxDriver --connect jdbc:informix-sqli://host:1534/fms:informixserver=cchsup --username xxx --password xxxx Thanks, Kanchan
... View more
08-14-2016
12:50 AM
Hello All, I am trying to connect to my informix database via sqoop with following command sqoop list-tables --driver com.informix.jdbc.IfxDriver --connect jdbc:informixsqli://DevIrisApp1:1534/fms:informixserver=cchsup --username xxx --password xxx I do have copied informix jdbc driver to my sqoop lib directory but still getting the following issue 16/08/14 00:27:09 INFO manager.SqlManager: Using default fetchSize of 1000 16/08/14 00:27:09 ERROR manager.SqlManager: Error reading database metadata: java.sql.SQLException: No suitable driver found for jdbc:informixsqli://DevIrisApp1:1534/fms:informixserver=cchsup java.sql.SQLException: No suitable driver found for jdbc:informixsqli://DevIrisApp1:1534/fms:informixserver=cchsup at java.sql.DriverManager.getConnection(DriverManager.java:635) at java.sql.DriverManager.getConnection(DriverManager.java:195) at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:801) at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52) at org.apache.sqoop.manager.SqlManager.listTables(SqlManager.java:463) at org.apache.sqoop.tool.ListTablesTool.run(ListTablesTool.java:49) at org.apache.sqoop.Sqoop.run(Sqoop.java:145) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) at org.apache.sqoop.Sqoop.main(Sqoop.java:238) Could not retrieve tables list from server 16/08/14 00:27:09 ERROR tool.ListTablesTool: manager.listTables() returned null Please help Thanks, Kanchan
... View more
Labels:
- Labels:
-
Apache Hadoop
-
Apache Sqoop