Sqoop to Informix connection issue

[#1]

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

[#2]

Have you placed all the requisite JDBC jars required to connect to Informix
under /var/lib/sqoop/ on the host you are trying to invoke this command on?

[#3 · Accepted solution]

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

[#4]

Hi, 

I am trying to download thesqoop informix jdbc/odbc driver . Can you please help me from where I can download that jar.

Thanks