Hi Marcia, Did you try to specify the port number in the JDBC URL?
jdbc:db2://<server name>: <portnumber>/<database name> Regards, Douglas On Wed, Mar 15, 2017 at 10:16 AM, Marcia Hon <[email protected]> wrote: > I try the following: > > - sqoop import --driver com.ibm.db2.jcc.DB2Driver --connect > jdbc:db2://localhost/database?zeroDateTimeBehavior=convertToNull > --username username --password password --table schema.tablename > -hive-import -hive-table hive_sqoop1 --m 1 > > And the following is the error message: > > Warning: /usr/hdp/2.5.0.0-1245/accumulo does not exist! Accumulo imports > will fail. Please set $ACCUMULO_HOME to the root of your Accumulo > installation. find: failed to restore initial working directory: Permission > denied 17/03/14 21:09:00 INFO sqoop.Sqoop: Running Sqoop version: > 1.4.6.2.5.0.0-1245 17/03/14 21:09:00 WARN tool.BaseSqoopTool: Setting your > password on the command-line is insecure. Consider using -P instead. > 17/03/14 21:09:00 INFO tool.BaseSqoopTool: Using Hive-specific delimiters > for output. You can override 17/03/14 21:09:00 INFO tool.BaseSqoopTool: > delimiters with --fields-terminated-by, etc. 17/03/14 21:09:00 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. 17/03/14 21:09:00 INFO manager.SqlManager: Using default fetchSize of > 1000 17/03/14 21:09:00 INFO tool.CodeGenTool: Beginning code generation > 17/03/14 21:09:01 ERROR manager.SqlManager: Error executing statement: > com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: > [jcc][t4][2057][11264][4.11.77] The application server rejected > establishment of the connection. An attempt was made to access a database, > CAMH1?zeroDateTimeBehavior=convertToNull, which was either not found or > does not support transactions. ERRORCODE=-4499, SQLSTATE=08004 > com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: > [jcc][t4][2057][11264][4.11.77] The application server rejected > establishment of the connection. An attempt was made to access a database, > CAMH1?zeroDateTimeBehavior=convertToNull, which was either not found or > does not support transactions. ERRORCODE=-4499, SQLSTATE=08004 at > com.ibm.db2.jcc.am.gd.a(gd.java:319) at com.ibm.db2.jcc.am.gd.a(gd.java:365) > at com.ibm.db2.jcc.t4.ab.u(ab.java:1674) at > com.ibm.db2.jcc.t4.ab.n(ab.java:536) > at com.ibm.db2.jcc.t4.ab.a(ab.java:343) at > com.ibm.db2.jcc.t4.ab.a(ab.java:115) > at com.ibm.db2.jcc.t4.b.m(b.java:1242) at com.ibm.db2.jcc.t4.b.b(b.java:1113) > at com.ibm.db2.jcc.t4.b.d(b.java:696) at com.ibm.db2.jcc.t4.b.c(b.java:682) > at com.ibm.db2.jcc.t4.b.a(b.java:367) at > com.ibm.db2.jcc.t4.b.<init>(b.java:307) > at > com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:214) > at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:460) at > java.sql.DriverManager.getConnection(DriverManager.java:664) at > java.sql.DriverManager.getConnection(DriverManager.java:247) at > org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:904) > at > org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52) > at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:763) at > org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:786) at > org.apache.sqoop.manager.SqlManager.getColumnInfoForRawQuery(SqlManager.java:289) > at > org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:260) > at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:246) > at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:328) > at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1853) > at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1653) at > org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:107) at > org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:488) at > org.apache.sqoop.tool.ImportTool.run(ImportTool.java:615) at > org.apache.sqoop.Sqoop.run(Sqoop.java:147) at org.apache.hadoop.util. > ToolRunner.run(ToolRunner.java:76) at > org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183) > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:225) at > org.apache.sqoop.Sqoop.runTool(Sqoop.java:234) at > org.apache.sqoop.Sqoop.main(Sqoop.java:243) 17/03/14 21:09:01 ERROR > tool.ImportTool: Encountered IOException running import job: > java.io.IOException: No columns to generate for ClassWriter at > org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1659) at > org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:107) at > org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:488) at > org.apache.sqoop.tool.ImportTool.run(ImportTool.java:615) at > org.apache.sqoop.Sqoop.run(Sqoop.java:147) at org.apache.hadoop.util. > ToolRunner.run(ToolRunner.java:76) at > org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183) > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:225) at > org.apache.sqoop.Sqoop.runTool(Sqoop.java:234) at > org.apache.sqoop.Sqoop.main(Sqoop.java:243) > -- Visite: http://canseidesercowboy.wordpress.com/ Siga: @dougspadotto ou @excowboys ----- Frodo: "I wish none of this had happened." Gandalf: "So do all who live to see such times, but that is not for them to decide. All we have to decide is what to do with the time that is given to us." -- Lord of the Rings: The Fellowship of the Ring (2001)
