[infinispan-issues] [JBoss JIRA] Commented: (ISPN-965) Query for loading some rows from CacheStore is not correct for HSQLDB 1.8.0.7

[Mircea Markus (JIRA)]

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

Mircea Markus commented on ISPN-965:
------------------------------------

TOP can be used for HASQL as well: http://hsqldb.org/doc/guide/ch09.html

> Query for loading some rows from CacheStore is not correct for HSQLDB 1.8.0.7
> -----------------------------------------------------------------------------
>
>                 Key: ISPN-965
>                 URL: https://issues.jboss.org/browse/ISPN-965
>             Project: Infinispan
>          Issue Type: Bug
>          Components: Loaders and Stores
>    Affects Versions: 4.2.0.Final
>         Environment: JBoss AS 5.1.0.GA
> HSQLDB 1.8.0.7
>            Reporter: Anatoliy Bazko
>            Assignee: Mircea Markus
>             Fix For: 5.0.0.CR3, 5.0.0.FINAL
>
>
> Loading data from CacheStore using method  public final Set<InternalCacheEntry> loadSome(int maxEntries) throws CacheLoaderException failed due to query 
> "SELECT %s, %s FROM %s LIMIT ?" is not correct for HSQLDB 1.8.0.7 since it required "ORDER BY" before "LIMIT"

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira