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

Upsert does not work for MySQL

    XMLWordPrintable

Details

    Description

      ISPN-20, merged recently (thanks!), added "upsert" support for JDBC cache stores. The "upsert" SQL statement is database-type-dependent and the one for MySQL has a different "API" than the one for other database types - whereas all the others use the same number and order of placeholders as the equvalent INSERT statement, so that the same method can be used to update the INSERT, UPDATE and "upsert" statement, the MySQL one adds additional placeholders and the aforementioned method is no longer sufficient.

      The exception is:
      java.sql.SQLException: No value specified for parameter 4

      Attachments

        Activity

          People

            remerson@redhat.com Ryan Emerson
            ksobolewski_jira Krzysztof Sobolewski (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: