Uploaded image for project: 'Infinispan'
  1. Infinispan
  2. ISPN-7250

ORA-00928: missing SELECT keyword when inserting entry with Oracle cache store

This issue belongs to an archived project. You can view it, but you can't modify it. Learn more

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 9.0.0.Final
    • 9.0.0.Final
    • Loaders and Stores
    • None

      Tested with Oracle 11g express edition

      Example of query currently sent to Oracle:

      MERGE INTO "ISPN_cache" USING (VALUES ('Az4s','030',1)) AS tmp (datum, version, id) ON (datum = tmp.datum) WHEN MATCHED THEN UPDATE SET version = tmp.version, id = tmp.id WHEN NOT MATCHED THEN INSERT (datum, version, id) VALUES (tmp.datum, tmp.version, tmp.id)
      

      which does not seem valid

              gfernand@redhat.com Gustavo Fernandes (Inactive)
              gfernand@redhat.com Gustavo Fernandes (Inactive)
              Archiver:
              rhn-support-adongare Amol Dongare

                Created:
                Updated:
                Resolved:
                Archived: