SAP Knowledge Base Article - Preview

2468687 - "no dbjdbc16 in java.library.path" when executing sqoop import into - SAP IQ

Symptom

When executing sqoop import command against SAP IQ , you could get the following error:

$ sqoop import --verbose --driver "com.sybase.jdbc4.jdbc.SybDriver" --connect jdbc:sybase:Tds:<host>:<port> --username <user> -P <password> --query  "select * from test where \$CONDITIONS" --target-dir /tmp/sybtst -m 1

Warning: /opt/cloudera/parcels/CDH-5.10.1-1.cdh5.10.1.p0.10/bin/../lib/sqoop/../accumulo does not exist! Accumulo imports will fail.

Please set $ACCUMULO_HOME to the root of your Accumulo installation.

INFO sqoop.Sqoop: Running Sqoop version: 1.4.6-cdh5.10.1

DEBUG tool.BaseSqoopTool: Enabled debug logging.
Enter password:

DEBUG sqoop.ConnFactory: Loaded manager factory: org.apache.sqoop.manager.oracle.OraOopManagerFactory

DEBUG sqoop.ConnFactory: Loaded manager factory: com.cloudera.sqoop.manager.DefaultManagerFactory

WARN sqoop.ConnFactory: Parameter --driver is set to an explicit driver however appropriate connection manager is not being set (via --connection-manager).
Sqoop is going to fall back to org.apache.sqoop.manager.GenericJdbcManager. Please specify explicitly which connection manager should be used next time.

INFO manager.SqlManager: Using default fetchSize of 1000

INFO tool.CodeGenTool: Beginning code generation

DEBUG manager.SqlManager: Execute getColumnInfoRawQuery : select * from test where  (1 = 0)

DEBUG manager.SqlManager: No connection paramenters specified. Using regular API for making connection.

Exception in thread "main" java.lang.UnsatisfiedLinkError: no dbjdbc16 in java.library.path

        at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1886)

        at java.lang.Runtime.loadLibrary0(Runtime.java:849)

        at java.lang.System.loadLibrary(System.java:1088)

        at sybase.jdbc4.sqlanywhere.IDriver.try_load(IDriver.java:483)

        at sybase.jdbc4.sqlanywhere.IDriver.<clinit>(IDriver.java:421)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)

        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

        at java.lang.reflect.Constructor.newInstance(Constructor.java:526)

        at java.lang.Class.newInstance(Class.java:374)

        at java.util.ServiceLoader$LazyIterator.next(ServiceLoader.java:373)
 
      ....


Read more...

Environment

  • SAP IQ 16 SP 11 PL 07
  • Hadoop 2.6.0 (Cloudera)
  • Sqoop 1.4.6

Product

SAP IQ 16.0

Keywords

Hive , Sybase , hortonworks , cloudera , import , export , list-files , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.