[
https://issues.jboss.org/browse/ISPN-3618?page=com.atlassian.jira.plugin....
]
Martin Gencur commented on ISPN-3618:
-------------------------------------
Yeah, the Microsoft SQL server does not seem to support UTF-8. It means that for
string-based cache stores only "String" can be used as a key. The other types
(coverted with Key2StringMapper) cannot. AFAIK, it also means that string-based cache
store cannot be used at all if data is stored via HotRod. That's because HotRod does
not send plain strings.
Cannot retrieve evicted entries from Microsoft SQL Server
2012/2008R2
---------------------------------------------------------------------
Key: ISPN-3618
URL:
https://issues.jboss.org/browse/ISPN-3618
Project: Infinispan
Issue Type: Bug
Components: Loaders and Stores, Server
Affects Versions: 6.0.0.CR1
Reporter: Jakub Markos
Assignee: Mircea Markus
Attachments: server_mssql2012_mysql55.log.zip
When using this configuration:
{code:xml}
<local-cache name="default" start="EAGER"
batching="false">
<locking isolation="READ_COMMITTED" acquire-timeout="20000"
concurrency-level="500" striping="false" />
<transaction mode="NONE" />
<eviction strategy="LRU" max-entries="2"/>
<string-keyed-jdbc-store name="defaultStoreName"
datasource="java:jboss/datasources/JdbcDS" passivation="false"
preload="true" purge="false">
<string-keyed-table prefix="EDG_STRING">
<id-column name="id" type="VARCHAR(255)"/>
<data-column name="datum" type="VARBINARY(1000)"/>
<timestamp-column name="version" type="BIGINT"/>
</string-keyed-table>
</string-keyed-jdbc-store>
</local-cache>
{code}
and running this code:
{code}
RemoteCache<Object, Object> cache = new RemoteCacheManager(conf).getCache();
cache.clear();
cache.put(new Double(10), new Double(10));
cache.put(new Double(20), new Double(20));
cache.put(new Double(30), new Double(30)); // key 10 is evicted
System.out.println(cache.get(new Double(10)));
System.out.println(cache.get(new Double(20)));
System.out.println(cache.get(new Double(30)));
{code}
output:
{quote}
null
20.0
30.0
{quote}
Attached are logs for mssql2012 and mysql55 (where it works).
--
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