KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > apache > cayenne > dba > hsqldb > HSQLSelectTranslator


1 /*****************************************************************
2  * Licensed to the Apache Software Foundation (ASF) under one
3  * or more contributor license agreements. See the NOTICE file
4  * distributed with this work for additional information
5  * regarding copyright ownership. The ASF licenses this file
6  * to you under the Apache License, Version 2.0 (the
7  * "License"); you may not use this file except in compliance
8  * with the License. You may obtain a copy of the License at
9  *
10  * http://www.apache.org/licenses/LICENSE-2.0
11  *
12  * Unless required by applicable law or agreed to in writing,
13  * software distributed under the License is distributed on an
14  * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
15  * KIND, either express or implied. See the License for the
16  * specific language governing permissions and limitations
17  * under the License.
18  ****************************************************************/
19
20 package org.apache.cayenne.dba.hsqldb;
21
22 import org.apache.cayenne.access.trans.SelectTranslator;
23
24 /**
25  * @since 1.2
26  * @author Andrus Adamchik
27  */
28 class HSQLSelectTranslator extends SelectTranslator {
29
30     static final String JavaDoc SELECT_PREFIX = "SELECT";
31
32     public String JavaDoc createSqlString() throws Exception JavaDoc {
33         String JavaDoc sql = super.createSqlString();
34
35         // limit results
36 int limit = getQuery().getMetaData(getEntityResolver()).getFetchLimit();
37         if (limit > 0 && sql.startsWith(SELECT_PREFIX)) {
38             return SELECT_PREFIX
39                     + " TOP "
40                     + limit
41                     + sql.substring(SELECT_PREFIX.length());
42         }
43
44         return sql;
45     }
46 }
47
Popular Tags