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 | 5 years ago
  1. 0

    Re: [sqoop-user] sqoop-export

    incubator-sqoop-user | 5 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)
  2. 0

    Re: Problem with Oracle JDBC driver and Sqoop compatibility

    apache.org | 1 year ago
    java.sql.SQLException: Could not rollback with auto-commit set on at > > > > > oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:4510) at > > > > > org.apache.sqoop.manager.OracleManager$ConnCache.getConnection(OracleManager.java:190) at > > > > > org.apache.sqoop.manager.OracleManager.makeConnection(OracleManager.java:283) at > > > > > org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52) at > > > > > org.apache.sqoop.manager.OracleManager.getColumnNames(OracleManager.java:725) at > > > > > org.apache.sqoop.mapreduce.DataDrivenImportJob.configureInputFormat(DataDrivenImportJob.java:165) at > > > > > org.apache.sqoop.mapreduce.ImportJobBase.runImport(ImportJobBase.java:203) at > > > org.apache.sqoop.manager.SqlManager.importTable(SqlManager.java:465) at > > > > > org.apache.sqoop.manager.OracleManager.importTable(OracleManager.java:380) at > > org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:403)
  3. 0

    Re: Problem with Oracle JDBC driver and Sqoop compatibility

    apache.org | 1 year ago
    java.sql.SQLException: Could not rollback with auto-commit set on at > > > > > oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:4510) at > > > > > org.apache.sqoop.manager.OracleManager.listDatabases(OracleManager.java:615) at > > > org.apache.sqoop.tool.ListDatabasesTool.run(ListDatabasesTool.java:49)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Re: Problem with Oracle JDBC driver and Sqoop compatibility

    apache.org | 1 year ago
    java.sql.SQLException: Could not commit with auto-commit set on at > > > > > oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:4443) at > > > > > oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:4490) at > > > > > org.apache.sqoop.manager.OracleManager.listDatabases(OracleManager.java:612) at > > > org.apache.sqoop.tool.ListDatabasesTool.run(ListDatabasesTool.java:49)
  6. 0

    H2 Database - Issue with c3p0 when using h2-1.3.161.

    nabble.com | 11 months ago
    java.sql.SQLException: Connections could not be acquired from the >>> underlying database! at >>> com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106) at >>> >> com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnec >> tion(C >> 3P0PooledConnectionPool.java: >>> 529) at >>> >> com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(Ab >> stract >> PoolBackedDataSource.java: >>> 128) at >>> >> org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0Conn >> ection >> Provider.java: >>> 78) at >>> >> org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper. >> prepar >> e(SuppliedConnectionProviderConnectionHelper.java: >>> 51) at >> org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java: >>> 168) at >>> org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java: >>> 375) at >>> org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java: >>> 1872) at >>> >> com.callidus.db.HibernateSessionFactory.<clinit>(HibernateSessionFacto >> ry.jav >> a: >>> 68)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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