Grails

sqlProjections is not implemented in HibernateCriteriaBuilder

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Duplicate
  • Affects Version/s: 1.0.2
  • Fix Version/s: 1.2-RC1
  • Component/s: Persistence
  • Labels:
    None

Description

According to the docs here: http://grails.codehaus.org/Hibernate+Criteria+Builder we are supposed to be able to use sqlProjection() to add an arbitrary SQL-based projection as specifed here: http://www.hibernate.org/hib_docs/v3/api/org/hibernate/criterion/Projections.html

This doesn't seem to be implemented.

I am trying a work around using this method:

def myThings = Thing.createCriteria().list() {
            projections {
                property("id")
                sqlProjection("count(*) as rel",
                        ["rel"] as String[],
                        [Hibernate.INTEGER] as Type[])
           }
}

but to no avail. I get the following error:

Caused by: groovy.lang.MissingMethodException: No signature of method: grails.orm.HibernateCriteriaBuilder.sqlProjection() is applicable for argument types: (java.lang.String, [Ljava.lang.String;, [Lorg.hibernate.type.Type;) values: {"count(*) as rel", ["rel"], [org.hibernate.type.IntegerType@30571b]}

Any idea when it will be possible to add such Projections?

Issue Links

relates to

New Feature - A new feature of the product, which has yet to be developed. GRAILS-9402 sqlProjection is not supported

  • Major - Major loss of function.
  • Closed - The issue is considered finished, the resolution is correct. Issues which are closed can be reopened.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Graeme Rocher added a comment -

duplicates GRAILS-5431

Show
Graeme Rocher added a comment - duplicates GRAILS-5431
Hide
Permalink
Stephen Swensen added a comment -

This is not a duplicate of issue 5431 (which concerns sqlRestriction, not sqlProjection) and has not been fixed at least as of Grails v1.3.2.

Show
Stephen Swensen added a comment - This is not a duplicate of issue 5431 (which concerns sqlRestriction, not sqlProjection) and has not been fixed at least as of Grails v1.3.2.
Hide
Permalink
Christopher A. Petro added a comment -

This is still not a duplicate of GRAILS-5431. It still needs to be fixed.

Show
Christopher A. Petro added a comment - This is still not a duplicate of GRAILS-5431 . It still needs to be fixed.

People

  • Assignee:
    Graeme Rocher
    Reporter:
    Nick Atkins
Vote (2)
Watch (3)

Dates

  • Created:
    Updated:
    Resolved: