Return-Path: X-Original-To: apmail-empire-db-commits-archive@www.apache.org Delivered-To: apmail-empire-db-commits-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id C191E10463 for ; Sat, 19 Oct 2013 17:49:58 +0000 (UTC) Received: (qmail 77968 invoked by uid 500); 19 Oct 2013 17:49:50 -0000 Delivered-To: apmail-empire-db-commits-archive@empire-db.apache.org Received: (qmail 77922 invoked by uid 500); 19 Oct 2013 17:49:46 -0000 Mailing-List: contact commits-help@empire-db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: empire-db-dev@empire-db.apache.org Delivered-To: mailing list commits@empire-db.apache.org Received: (qmail 77878 invoked by uid 500); 19 Oct 2013 17:49:43 -0000 Delivered-To: apmail-incubator-empire-db-commits@incubator.apache.org Received: (qmail 77837 invoked by uid 99); 19 Oct 2013 17:49:42 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 19 Oct 2013 17:49:42 +0000 Date: Sat, 19 Oct 2013 17:49:42 +0000 (UTC) From: "Francis De Brabandere (JIRA)" To: empire-db-commits@incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Assigned] (EMPIREDB-196) Implement limitRows and skipRows for H2 database MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/EMPIREDB-196?page=3Dcom.atlass= ian.jira.plugin.system.issuetabpanels:all-tabpanel ] Francis De Brabandere reassigned EMPIREDB-196: ---------------------------------------------- Assignee: Rainer D=C3=B6bele > Implement limitRows and skipRows for H2 database=20 > ------------------------------------------------- > > 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=C3=B6bele > 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 applicat= ions. > @Override > public void getSelect(StringBuilder buf) > { // Prepares statement > =09super.getSelect(buf); > // add limit and offset > if (limit>=3D0) > { buf.append("\r\nLIMIT "); > buf.append(String.valueOf(limit)); > // Offset > if (skip>=3D0)=20 > { buf.append(" OFFSET "); > buf.append(String.valueOf(skip)); > } =20 > } > } -- This message was sent by Atlassian JIRA (v6.1#6144)