[infinispan-issues] [JBoss JIRA] (ISPN-3680) Inconsistent way to use the column id in the JdbcBinaryCacheStore

[Nicolas Filotto (JIRA)]

Nicolas Filotto created ISPN-3680:
-------------------------------------

             Summary: Inconsistent way to use the column id in the JdbcBinaryCacheStore
                 Key: ISPN-3680
                 URL: https://issues.jboss.org/browse/ISPN-3680
             Project: Infinispan
          Issue Type: Bug
          Components: Loaders and Stores
    Affects Versions: 6.0.0.CR1, 5.3.0.Final, 5.2.7.Final
            Reporter: Nicolas Filotto
            Assignee: Mircea Markus


I met some issues with (at least) H2 and JdbcBinaryCacheStore that prevent to modify a value in the cache store which is quite annoying. After a deeper look, I realized that it was due to the method {{JdbcBinaryCacheStore.loadBucket(Integer keyHashCode)}} that uses {{setInt}} instead of {{setString}} like in updateBucket and insertBucket to set the id as parameter to the query. With HSQLDB and MySQL, it works normally but with H2, the result of the query is always empty so it always tries to add a new entry which of course fails because of the integrity constraint on the primary key (aka the id).

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira