java.sql.SQLException: Could not rollback with auto-commit set on at > oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java: > 3988) at com.cloudera.sqoop.manager.OracleManager > $ConnCache.getConnection(OracleManager.java:179) at > com.cloudera.sqoop.manager.OracleManager.makeConnection(OracleManager.java: > 268) at > com.cloudera.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java: > 51) at > com.cloudera.sqoop.manager.OracleManager.getColumnNames(OracleManager.java: > 656) at > com.cloudera.sqoop.mapreduce.JdbcExportJob.configureOutputFormat(JdbcExportJob.java: > 84) at > com.cloudera.sqoop.mapreduce.ExportJobBase.runExport(ExportJobBase.java: > 331) at > com.cloudera.sqoop.manager.OracleManager.exportTable(OracleManager.java: > 375) at > com.cloudera.sqoop.tool.ExportTool.exportTable(ExportTool.java:73)

incubator-sqoop-user | arvind@cloudera.com | 6 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Re: [sqoop-user] sqoop-export

    incubator-sqoop-user | 6 years ago | arvind@cloudera.com
    java.sql.SQLException: Could not rollback with auto-commit set on at > oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java: > 3988) at com.cloudera.sqoop.manager.OracleManager > $ConnCache.getConnection(OracleManager.java:179) at > com.cloudera.sqoop.manager.OracleManager.makeConnection(OracleManager.java: > 268) at > com.cloudera.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java: > 51) at > com.cloudera.sqoop.manager.OracleManager.getColumnNames(OracleManager.java: > 656) at > com.cloudera.sqoop.mapreduce.JdbcExportJob.configureOutputFormat(JdbcExportJob.java: > 84) at > com.cloudera.sqoop.mapreduce.ExportJobBase.runExport(ExportJobBase.java: > 331) at > com.cloudera.sqoop.manager.OracleManager.exportTable(OracleManager.java: > 375) at > com.cloudera.sqoop.tool.ExportTool.exportTable(ExportTool.java:73)

    Root Cause Analysis

    1. java.sql.SQLException

      Could not rollback with auto-commit set on at > oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java: > 3988) at com.cloudera.sqoop.manager.OracleManager > $ConnCache.getConnection(OracleManager.java:179) at > com.cloudera.sqoop.manager.OracleManager.makeConnection(OracleManager.java: > 268) at > com.cloudera.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java: > 51) at > com.cloudera.sqoop.manager.OracleManager.getColumnNames(OracleManager.java: > 656) at > com.cloudera.sqoop.mapreduce.JdbcExportJob.configureOutputFormat(JdbcExportJob.java: > 84) at > com.cloudera.sqoop.mapreduce.ExportJobBase.runExport(ExportJobBase.java: > 331) at > com.cloudera.sqoop.manager.OracleManager.exportTable(OracleManager.java: > 375) at > com.cloudera.sqoop.tool.ExportTool.exportTable(ExportTool.java:73)

      at com.cloudera.sqoop.tool.ExportTool.run()
    2. com.cloudera.sqoop
      Sqoop.run
      1. com.cloudera.sqoop.tool.ExportTool.run(ExportTool.java:110)
      2. com.cloudera.sqoop.Sqoop.run(Sqoop.java:144)
      2 frames
    3. Hadoop
      ToolRunner.run
      1. org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
      1 frame
    4. com.cloudera.sqoop
      Sqoop.main
      1. com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180)
      2. com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:219)
      3. com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:228)
      4. com.cloudera.sqoop.Sqoop.main(Sqoop.java:237)
      4 frames