sun.jdbc.odbc.JdbcOdbcBatchUpdateException: [Microsoft][ODBC Excel Driver] Operation must use an updateable query.

Oracle Community | 2809871 | 2 years ago
  1. 0

    Oracle Data Integrator- ODI

    Oracle Community | 2 years ago | 2809871
    sun.jdbc.odbc.JdbcOdbcBatchUpdateException: [Microsoft][ODBC Excel Driver] Operation must use an updateable query.
  2. 0

    ODI error: Executing Interface

    Oracle Community | 7 years ago | Varun Kaushal
    sun.jdbc.odbc.JdbcOdbcBatchUpdateException: [Microsoft][ODBC Excel Driver] Operation must use an updateable query.
  3. 0

    Error in loading data from Oracle 10g to Excel

    Oracle Community | 4 years ago | 954808
    sun.jdbc.odbc.JdbcOdbcBatchUpdateException: [Microsoft][ODBC Excel Driver] Operation must use an updateable query.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Update exception

    Oracle Community | 8 years ago | 630556
    sun.jdbc.odbc.JdbcOdbcBatchUpdateException: [Microsoft][ODBC Microsoft Access Dr iver] Too few parameters. Expected 7.
  6. 0

    Batch Insert in Java - JDBC Batch Insert Query using JDBC

    viralpatel.net | 4 months ago
    sun.jdbc.odbc.JdbcOdbcBatchUpdateException: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near ‘)’.

    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. sun.jdbc.odbc.JdbcOdbcBatchUpdateException

      [Microsoft][ODBC Excel Driver] Operation must use an updateable query.

      at sun.jdbc.odbc.JdbcOdbcPreparedStatement.emulateExecuteBatch()
    2. sun.jdbc.odbc
      JdbcOdbcStatement.executeBatch
      1. sun.jdbc.odbc.JdbcOdbcPreparedStatement.emulateExecuteBatch(JdbcOdbcPreparedStatement.java:2164)
      2. sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeBatchUpdate(JdbcOdbcPreparedStatement.java:1782)
      3. sun.jdbc.odbc.JdbcOdbcStatement.executeBatch(JdbcOdbcStatement.java:911)
      3 frames
    3. oracle.odi.runtime
      DataMovementTaskExecutionHandler.handleTask
      1. oracle.odi.runtime.agent.execution.sql.SQLCommand.end(SQLCommand.java:268)
      2. oracle.odi.runtime.agent.execution.sql.SQLExecutor.endExecution(SQLExecutor.java:156)
      3. oracle.odi.runtime.agent.execution.sql.SQLExecutor.endExecution(SQLExecutor.java:1)
      4. oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:113)
      4 frames
    4. com.sunopsis.dwg
      SnpSession.treatSession
      1. com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)
      2. com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
      3. com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)
      4. com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)
      5. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)
      5 frames
    5. oracle.odi.runtime
      StartSessRequestProcessor$2.doAction
      1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)
      1 frame
    6. oracle.odi.core
      DwgObjectTemplate.execute
      1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
      1 frame
    7. oracle.odi.runtime
      DefaultAgentTaskExecutor$2.run
      1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)
      2. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)
      3. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)
      4. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
      5. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
      5 frames
    8. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:744)
      1 frame