You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@empire-db.apache.org by "Francis De Brabandere (JIRA)" <em...@incubator.apache.org> on 2013/10/19 19:49:42 UTC
[jira] [Assigned] (EMPIREDB-196) Implement limitRows and skipRows
for H2 database
[ https://issues.apache.org/jira/browse/EMPIREDB-196?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Francis De Brabandere reassigned EMPIREDB-196:
----------------------------------------------
Assignee: Rainer Döbele
> 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
> 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)