DB2Dialect.java |
1 /** 2 * Copyright (c) 2000-2009 Liferay, Inc. All rights reserved. 3 * 4 * Permission is hereby granted, free of charge, to any person obtaining a copy 5 * of this software and associated documentation files (the "Software"), to deal 6 * in the Software without restriction, including without limitation the rights 7 * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell 8 * copies of the Software, and to permit persons to whom the Software is 9 * furnished to do so, subject to the following conditions: 10 * 11 * The above copyright notice and this permission notice shall be included in 12 * all copies or substantial portions of the Software. 13 * 14 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR 15 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, 16 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE 17 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER 18 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, 19 * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE 20 * SOFTWARE. 21 */ 22 23 package com.liferay.portal.dao.orm.hibernate; 24 25 /** 26 * <a href="DB2Dialect.java.html"><b><i>View Source</i></b></a> 27 * 28 * @author Shepherd Ching 29 * @author Jian Cao 30 * 31 */ 32 public class DB2Dialect extends org.hibernate.dialect.DB2Dialect { 33 34 public String getLimitString(String sql, boolean hasOffset) { 35 if (!sql.startsWith("(")) { 36 return super.getLimitString(sql, hasOffset); 37 } 38 39 StringBuilder sb = new StringBuilder(); 40 41 sb.append("select cursor1.* from ("); 42 sb.append("select rownumber() over() as rownumber_, cursor2.* from ("); 43 sb.append(sql); 44 sb.append(") as cursor2) as cursor1 where rownumber_"); 45 46 if (hasOffset) { 47 sb.append(" between ? + 1 and ?"); 48 } 49 else { 50 sb.append(" <= ?"); 51 } 52 53 return sb.toString(); 54 } 55 56 }