[infinispan-issues] [JBoss JIRA] (ISPN-6743) Upsert does not work for MySQL

[Krzysztof Sobolewski (JIRA)]

     [ https://issues.jboss.org/browse/ISPN-6743?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Krzysztof Sobolewski updated ISPN-6743:
---------------------------------------
    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 2

  was: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.



> Upsert does not work for MySQL
> ------------------------------
>
>                 Key: ISPN-6743
>                 URL: https://issues.jboss.org/browse/ISPN-6743
>             Project: Infinispan
>          Issue Type: Bug
>          Components: Loaders and Stores
>    Affects Versions: 9.0.0.Alpha2
>            Reporter: Krzysztof Sobolewski
>
> 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 2



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)