empire-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Francis De Brabandere (JIRA)" <empire-db-...@incubator.apache.org>
Subject [jira] [Reopened] (EMPIREDB-196) Implement limitRows and skipRows for H2 database
Date Sat, 19 Oct 2013 17:51:42 GMT

     [ https://issues.apache.org/jira/browse/EMPIREDB-196?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Francis De Brabandere reopened EMPIREDB-196:
--------------------------------------------


> Implement limitRows and skipRows for H2 database 
> -------------------------------------------------
>
>                 Key: EMPIREDB-196
>                 URL: https://issues.apache.org/jira/browse/EMPIREDB-196
>             Project: Empire-DB
>          Issue Type: Improvement
>          Components: Core
>    Affects Versions: empire-db-2.4.2
>            Reporter: Bimal Manukonda
>            Assignee: Rainer Döbele
>             Fix For: empire-db-2.4.3
>
>         Attachments: DBDatabaseDriverH2.java
>
>
> Currently, limitRows and skipRows is not implemented for H2 database.
> This would be needed if we were to have paginated data source in applications.
>            @Override
>             public void getSelect(StringBuilder buf)
>             {   // Prepares statement
>             	super.getSelect(buf);
>                 // add limit and offset
>                 if (limit>=0)
>                 {   buf.append("\r\nLIMIT ");
>                     buf.append(String.valueOf(limit));
>                     // Offset
>                     if (skip>=0) 
>                     {   buf.append(" OFFSET ");
>                         buf.append(String.valueOf(skip));
>                     }    
>                 }
>             }



--
This message was sent by Atlassian JIRA
(v6.1#6144)

Mime
View raw message