Uploaded image for project: 'Red Hat Data Grid'
  1. Red Hat Data Grid
  2. JDG-6687

[DOCS] SQL query store configuration section uses invalid cache configuration

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • RHDG 8.4.7 GA
    • None
    • Documentation
    • None

      Attempt to create cache distributed cache from SQL query store configuration section of Configuring Data Grid Caches will fail with: 

      CacheConfigurationException: ISPN008053: Delete and select queries do not have matching arguments. Delete was [name, name] and select was [name]

      Using SQL bellow in select-single instead of the existing one seems to fix the issue.

      SELECT t1.name, t1.picture, t1.sex, t1.birthdate, t1.accepted_tos, t2.street, t2.city, t2.zip FROM Person t1 JOIN Address t2 WHERE t1.name = :name AND t2.name = :name

            amehenda@redhat.com Ashwin Mehendale
            rhn-support-pdrobek Pavel Drobek
            Anna Manukyan Anna Manukyan
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: