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

Oracle Community | 2809871 | 2 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

    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 | 6 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