[
https://issues.jboss.org/browse/ISPN-3618?page=com.atlassian.jira.plugin....
]
Martin Gencur commented on ISPN-3618:
-------------------------------------
The solution/workaround could be to convert the UTF-8 data to UCS-2 which is supported by
MS SQL server, but only if MS SQL server is used. Otherwise UTF-8 could remain.
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