Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Sqoop to Informix connection issue

avatar
Explorer

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

1 ACCEPTED SOLUTION

avatar
Explorer

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 solution in original post

3 REPLIES 3

avatar
Mentor
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?

avatar
Explorer

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

avatar
New Contributor

Hi, 

 

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

 

Thanks