[
https://issues.jboss.org/browse/ISPN-6743?page=com.atlassian.jira.plugin....
]
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)