[infinispan-issues] [JBoss JIRA] (ISPN-7209) Collation not set properly data stored via Hot Rod when JdbcStringBasedStore is used with MariaDB

[Jiří Holuša (JIRA)]

Jiří Holuša created ISPN-7209:
---------------------------------

             Summary: Collation not set properly data stored via Hot Rod when JdbcStringBasedStore is used with MariaDB
                 Key: ISPN-7209
                 URL: https://issues.jboss.org/browse/ISPN-7209
             Project: Infinispan
          Issue Type: Bug
          Components: Loaders and Stores
    Affects Versions: 9.0.0.Alpha4
            Reporter: Jiří Holuša


Given following scenario:
1) store entry to ISPN server via Hot Rod (e.g. with RemoteCache)
2) have the server configured to use JdbcStringBasedStore
3) used database is MariaDB 10

Following exception is thrown:
{code}
ERROR [org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore] (HotRodServerHandler-3-2) ISPN008024: Error while storing string key to database; key: '9A09AJAAAAAAAAA==': java.sql.BatchUpdateException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
{code}

Note that his doesn't happen when stored via, for example, Memcached client. Also this issue doesn't appear in library mode, doesn't appear in any with any other database (including MySQL, which is very similar to MariaDB).



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)