public DerbyPagingQueryProviderTests() { pagingQueryProvider = new DerbyPagingQueryProvider(); }
@Override protected String getOverSubstituteClauseEnd() { return " ) AS " + getOrderedQueryAlias(); }
@Override protected String getOverSubstituteClauseStart() { return " FROM (SELECT " + getSelectClause(); }
@Override public void init(DataSource dataSource) throws Exception { super.init(dataSource); String version = JdbcUtils.extractDatabaseMetaData(dataSource, "getDatabaseProductVersion").toString(); if (!isDerbyVersionSupported(version)) { throw new InvalidDataAccessResourceUsageException("Apache Derby version " + version + " is not supported by this class, Only version " + MINIMAL_DERBY_VERSION + " or later is supported"); } }
@Override public void init(DataSource dataSource) throws Exception { super.init(dataSource); String version = JdbcUtils.extractDatabaseMetaData(dataSource, "getDatabaseProductVersion").toString(); if (!isDerbyVersionSupported(version)) { throw new InvalidDataAccessResourceUsageException("Apache Derby version " + version + " is not supported by this class, Only version " + MINIMAL_DERBY_VERSION + " or later is supported"); } }
case DERBY: provider = new DerbyPagingQueryProvider(); break; case DB2: case DB2VSE:
@Override protected String getOverSubstituteClauseStart() { return " FROM (SELECT " + getSelectClause(); }
@Override protected String getOverSubstituteClauseEnd() { return " ) AS " + getOrderedQueryAlias(); }
case DERBY: provider = new DerbyPagingQueryProvider(); break; case DB2: case DB2VSE: