• Icon: Enhancement Enhancement
    • Resolution: Done
    • Icon: Major Major
    • 10.3
    • 8.12.9.6_3
    • Misc. Connectors
    • None

      Changed to enhancement

      When attempting to update a row that is in an excel source, an Unsupported Execution createUpdateExecution is thrown.

      Source file and log attached

        1. colors.xlsx
          5 kB
        2. error.log
          25 kB

            [TEIID-4864] Excel translator does not update document

            Added simple (non-bulk/non-batch) update support with simple file locking - noted in the docs that this is not transactional.

            Steven Hawkins added a comment - Added simple (non-bulk/non-batch) update support with simple file locking - noted in the docs that this is not transactional.

            Concurrent reads are supported because we are creating different workbooks for each thread. However updates would require a read/write lock. I'll see how quickly this can be done.

            Steven Hawkins added a comment - Concurrent reads are supported because we are creating different workbooks for each thread. However updates would require a read/write lock. I'll see how quickly this can be done.

            Excel translator does not support updates currently. It would be some what major enhancement to provide that. Most of times we have not seen users wanting to create/update Excel documents using Teiid. But surely you can convert this to an Enhancement request.

            Ramesh Reddy added a comment - Excel translator does not support updates currently. It would be some what major enhancement to provide that. Most of times we have not seen users wanting to create/update Excel documents using Teiid. But surely you can convert this to an Enhancement request.

              rhn-engineering-shawkins Steven Hawkins
              mechevarria Michael Echevarria (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: