[hibernate-issues] [Hibernate-JIRA] Created: (HHH-3700) add support for DB2 feature OPTIMIZE FOR xx ROWS in SELECT

[Simon Jongsma (JIRA)]

add support for DB2 feature OPTIMIZE FOR xx ROWS in SELECT
----------------------------------------------------------

                 Key: HHH-3700
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3700
             Project: Hibernate Core
          Issue Type: Improvement
          Components: core
         Environment: DB2 UDB for ISeries 5.4
            Reporter: Simon Jongsma


It would be nice to have support for the (new) DB2 feature OPTIMIZE FOR xx ROWS.
This clause can be added at the end of a SELECT statement.

Hibernate could use the setMaxResults() value for xx (if it was provided).

Hooks for this type of functionality could be implemented in the Dialect class.

Example:

public String addOptimizationClause(int maxResults, String select) {
   return select;
}

I tried to use the transformSelectString method that is in the Dialect class to add the suffix myself,
but this did not work. transformSelectString  is not consitently called (see HHH-3307).


-- 
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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira