InformixDialect : Informix support offset but the InformixDialect uses max for limit ------------------------------------------------------------------------------------- Key: HHH-2362 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2362 Project: Hibernate3 Type: Improvement Components: query-hql Environment: Informix 10 Reporter: Adrian Mitev Priority: Minor This is the code in the current version of the InformixDialect: public boolean useMaxForLimit() { return true; } public boolean supportsLimitOffset() { return false; } public String getLimitString(String querySelect, int offset, int limit) { if (offset>0) throw new UnsupportedOperationException("informix has no offset"); return new StringBuffer( querySelect.length()+8 ).append(querySelect).insert( querySelect.toLowerCase().indexOf( "select" ) + 6, " first " + limit ).toString(); } But Informix supports offset ("skip"). Here is the code that should be replaced in the InformixDialect in order to use that informix feature: public boolean useMaxForLimit() { return false; } public boolean supportsLimitOffset() { return true; } public String getLimitString(String querySelect, int offset, int limit) { StringBuffer limitString = new StringBuffer(20); limitString.append((offset > 0) ? " skip " + offset : ""); limitString.append((limit > 0) ? " first " + limit : ""); return new StringBuffer(querySelect.length() + 8).append(querySelect).insert(querySelect.toLowerCase().indexOf("select") + 6, limitString.toString()).toString(); } -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira