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.AnsiDialect; 023import net.sf.jkniv.sqlegance.dialect.SqlFeatureFactory; 024import net.sf.jkniv.sqlegance.dialect.SqlFeatureSupport; 025 026/** 027 * Dialect to Derby version 10.4 028 * 029 * <ul> 030 * <li>Supports limits? false</li> 031 * <li>Supports limit off set? false</li> 032 * <li>Supports rownum? true</li> 033 * </ul> 034 * 035 * @author Alisson Gomes 036 * @since 0.6.0 037 */ 038public class Derby10o4Dialect extends AnsiDialect 039{ 040 public Derby10o4Dialect() 041 { 042 super(); 043 addFeature(SqlFeatureFactory.newInstance(SqlFeatureSupport.LIMIT, false)); 044 addFeature(SqlFeatureFactory.newInstance(SqlFeatureSupport.LIMIT_OFF_SET, false)); 045 addFeature(SqlFeatureFactory.newInstance(SqlFeatureSupport.ROWNUM, true)); 046 } 047}