[hibernate-issues] [Hibernate-JIRA] Created: (HHH-2362) InformixDialect : Informix support offset but the InformixDialect uses max for limit
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