001/* 
002 * JKNIV, whinstone one contract to access your database.
003 * 
004 * Copyright (C) 2017, the original author or authors.
005 *
006 * This library is free software; you can redistribute it and/or
007 * modify it under the terms of the GNU Lesser General Public
008 * License as published by the Free Software Foundation; either
009 * version 2.1 of the License.
010 * 
011 * This library is distributed in the hope that it will be useful,
012 * but WITHOUT ANY WARRANTY; without even the implied warranty of
013 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
014 * Lesser General Public License for more details.
015 * 
016 * You should have received a copy of the GNU Lesser General Public
017 * License along with this library; if not, write to the Free Software Foundation, Inc., 
018 * 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
019 */
020package net.sf.jkniv.whinstone.jdbc.dialect;
021
022import net.sf.jkniv.sqlegance.dialect.SqlFeatureFactory;
023import net.sf.jkniv.sqlegance.dialect.SqlFeatureSupport;
024
025/**
026 * Dialect to Derby version 10.7
027 * 
028 * <p>
029 *  Limit clause:
030 *   <code>select name from author OFFSET 5 ROWS FETCH NEXT 10 ROWS ONLY</code>
031 * </p>
032 * 
033 * <ul>
034 *  <li>Supports limits? true</li>
035 *  <li>Supports limit off set? true</li>
036 *  <li>Supports rownum? true</li>
037 * </ul>
038 * 
039 * @author Alisson Gomes
040 * @since 0.6.0
041 */
042public class Derby10o7Dialect extends Derby10o4Dialect
043{
044    public Derby10o7Dialect()
045    {
046        super();
047        addFeature(SqlFeatureFactory.newInstance(SqlFeatureSupport.LIMIT, true));
048        addFeature(SqlFeatureFactory.newInstance(SqlFeatureSupport.LIMIT_OFF_SET, true));
049        addFeature(SqlFeatureFactory.newInstance(SqlFeatureSupport.ROWNUM, true));
050    }
051    
052    @Override
053    public String getSqlPatternPaging()
054    {
055        return "%1$s offset %3$s rows fetch next %2$s rows only";
056    }
057    
058
059}