[infinispan-issues] [JBoss JIRA] (ISPN-3618) Cannot retrieve evicted entries from Microsoft SQL Server 2012/2008R2

[Jakub Markos (JIRA)]

    [ https://issues.jboss.org/browse/ISPN-3618?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12823632#comment-12823632 ] 

Jakub Markos commented on ISPN-3618:
------------------------------------

The encoding is SQL_Latin1_General_CP1_CI_AS . Microsoft SQL servers don't even support UTF-8.
                
> 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