Details
-
Bug
-
Resolution: Won't Do
-
Major
-
None
-
9.0.0.Alpha4
-
None
-
Workaround Exists
-
Description
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:
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 '='
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).
Attachments
Issue Links
- relates to
-
JDG-578 Collation not set properly when data stored via Hot Rod when JdbcStringBasedStore is used with MariaDB
- Closed