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

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 ONE Support launchpad (Login required).

Search for additional results

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