Tested and recommended database settings for RHDG String-keyed-jdbc-store persistence

Solution Verified - Updated -


  • What column types are recommended for persistence with string-keyed-jdbc-store?
  • The cache can not load entries from a string-keyed-jdbc-store using MYSQL with data type BINARY. (Note the ERROR can be slightly different based on the version or configuration)
ERROR [org.infinispan.interceptors.impl.InvocationContextInterceptor] ISPN000136: Error executing command GetKeyValueCommand on Cache 'db', writing keys [] org.infinispan.persistence.spi.PersistenceException: I/O error while unmarshalling from stream
    at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.unmarshall(JdbcStringBasedStore.java:777)
Caused by: protostream.com.google.protobuf.InvalidProtocolBufferException: Protocol message contained an invalid tag (zero).
    at protostream.com.google.protobuf.InvalidProtocolBufferException.invalidTag(InvalidProtocolBufferException.java:105)
  • The cache can not store entries to a string-keyed-jdbc-store. (Note the ERROR can be slightly different based on the database)
ERROR [org.infinispan.server.hotrod.BaseRequestProcessor] ISPN005003: Exception reported org.infinispan.persistence.spi.PersistenceException: Error while storing string key to database; key: 'WrappedByteArray[\J05\t\e\s\t\1 (7 bytes)]'
    at org.infinispan.persistence.jdbc.common.impl.BaseJdbcStore.lambda$write$4(BaseJdbcStore.java:149)
Caused by: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'DATA_COLUMN' at row 1
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:104)


  • Red Hat Data Grid (RHDG)
    • 8.x

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content