3.3.9 Can't find count method in createCriteria()

[hanyou]

    def c = User.createCriteria()
    def queryString = "ilike('username', '%ad%')"
    def query = ParamsHelper.buildparams(params)
    def rows = c.list(offset: query.offset, max: query.limit) {
        queryString
        order(query.sort, query.order)
    }


    def total = c.count() {
        queryString
        order(query.sort, query.order)
    }

->> 211 | invoke in org.grails.core.DefaultGrailsControllerClass$ReflectionInvoker

---

| 188 | invoke in org.grails.core.DefaultGrailsControllerClass | 90 | handle . . . . . in org.grails.web.mapping.mvc.UrlMappingsInfoHandlerAdapter | 967 | doDispatch in org.springframework.web.servlet.DispatcherServlet | 901 | doService . . . in '' | 970 | processRequest in org.springframework.web.servlet.FrameworkServlet | 861 | doGet . . . . . in '' | 846 | service in '' | 55 | doFilterInternal in org.springframework.boot.web.filter.ApplicationContextHeaderFilter | 317 | doFilter in org.springframework.security.web.FilterChainProxy$VirtualFilterChain | 127 | invoke . . . . . in org.springframework.security.web.access.intercept.FilterSecurityInterceptor | 91 | doFilter in '' | 331 | doFilter . . . . in org.springframework.security.web.FilterChainProxy$VirtualFilterChain | 114 | doFilter in org.springframework.security.web.access.ExceptionTranslationFilter | 64 | doFilter . . . . in grails.plugin.springsecurity.web.UpdateRequestContextHolderExceptionTranslationFilter | 331 | doFilter in org.springframework.security.web.FilterChainProxy$VirtualFilterChain | 54 | doFilterInternal in grails.plugin.springsecurity.web.filter.GrailsHttpPutFormContentFilter | 331 | doFilter in org.springframework.security.web.FilterChainProxy$VirtualFilterChain | 54 | doFilter . . . . in grails.plugin.springsecurity.web.filter.GrailsAnonymousAuthenticationFilter | 331 | doFilter in org.springframework.security.web.FilterChainProxy$VirtualFilterChain | 158 | doFilter . . . . in org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter | 331 | doFilter in org.springframework.security.web.FilterChainProxy$VirtualFilterChain | 170 | doFilter . . . . in org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter | 331 | doFilter in org.springframework.security.web.FilterChainProxy$VirtualFilterChain | 139 | doFilter . . . . in grails.plugin.springsecurity.rest.RestAuthenticationFilter | 331 | doFilter in org.springframework.security.web.FilterChainProxy$VirtualFilterChain | 200 | doFilter . . . . in org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter | 331 | doFilter in org.springframework.security.web.FilterChainProxy$VirtualFilterChain | 64 | doFilter . . . . in grails.plugin.springsecurity.web.authentication.logout.MutableLogoutFilter | 331 | doFilter in org.springframework.security.web.FilterChainProxy$VirtualFilterChain | 82 | doFilter . . . . in grails.plugin.springsecurity.rest.RestLogoutFilter | 331 | doFilter in org.springframework.security.web.FilterChainProxy$VirtualFilterChain | 105 | doFilter . . . . in org.springframework.security.web.context.SecurityContextPersistenceFilter | 331 | doFilter in org.springframework.security.web.FilterChainProxy$VirtualFilterChain | 58 | doFilter . . . . in grails.plugin.springsecurity.web.SecurityRequestHolderFilter | 331 | doFilter in org.springframework.security.web.FilterChainProxy$VirtualFilterChain | 214 | doFilterInternal in org.springframework.security.web.FilterChainProxy | 177 | doFilter in '' | 77 | doFilterInternal in org.grails.web.servlet.mvc.GrailsWebRequestFilter | 67 | doFilterInternal in org.grails.web.filters.HiddenHttpMethodFilter | 33 | doFilterInternal in org.grails.plugins.springsession.web.http.HttpSessionSynchronizer | 171 | doFilterInternal in org.springframework.session.web.http.SessionRepositoryFilter | 80 | doFilter . . . . in org.springframework.session.web.http.OncePerRequestFilter | 1149 | runWorker in java.util.concurrent.ThreadPoolExecutor | 624 | run . . . . . . in java.util.concurrent.ThreadPoolExecutor$Worker ^ 748 | run in java.lang.Thread

Caused by IllegalArgumentException: call to [count] not supported here ->> 1607 | invokeMethod in org.grails.orm.hibernate.query.AbstractHibernateCriteriaBuilder

---

| 28 | list in UserController.groovy | 211 | invoke . . . . . in org.grails.core.DefaultGrailsControllerClass$ReflectionInvoker | 188 | invoke in org.grails.core.DefaultGrailsControllerClass | 90 | handle . . . . . in org.grails.web.mapping.mvc.UrlMappingsInfoHandlerAdapter | 967 | doDispatch in org.springframework.web.servlet.DispatcherServlet | 901 | doService . . . in '' | 970 | processRequest in org.springframework.web.servlet.FrameworkServlet | 861 | doGet . . . . . in '' | 846 | service in '' | 55 | doFilterInternal in org.springframework.boot.web.filter.ApplicationContextHeaderFilter | 317 | doFilter in org.springframework.security.web.FilterChainProxy$VirtualFilterChain | 127 | invoke . . . . . in org.springframework.security.web.access.intercept.FilterSecurityInterceptor | 91 | doFilter in '' | 331 | doFilter . . . . in org.springframework.security.web.FilterChainProxy$VirtualFilterChain | 114 | doFilter in org.springframework.security.web.access.ExceptionTranslationFilter | 64 | doFilter . . . . in grails.plugin.springsecurity.web.UpdateRequestContextHolderExceptionTranslationFilter | 331 | doFilter in org.springframework.security.web.FilterChainProxy$VirtualFilterChain | 54 | doFilterInternal in grails.plugin.springsecurity.web.filter.GrailsHttpPutFormContentFilter | 331 | doFilter in org.springframework.security.web.FilterChainProxy$VirtualFilterChain | 54 | doFilter . . . . in grails.plugin.springsecurity.web.filter.GrailsAnonymousAuthenticationFilter | 331 | doFilter in org.springframework.security.web.FilterChainProxy$VirtualFilterChain | 158 | doFilter . . . . in org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter | 331 | doFilter in org.springframework.security.web.FilterChainProxy$VirtualFilterChain | 170 | doFilter . . . . in org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter | 331 | doFilter in org.springframework.security.web.FilterChainProxy$VirtualFilterChain | 139 | doFilter . . . . in grails.plugin.springsecurity.rest.RestAuthenticationFilter | 331 | doFilter in org.springframework.security.web.FilterChainProxy$VirtualFilterChain | 200 | doFilter . . . . in org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter | 331 | doFilter in org.springframework.security.web.FilterChainProxy$VirtualFilterChain | 64 | doFilter . . . . in grails.plugin.springsecurity.web.authentication.logout.MutableLogoutFilter | 331 | doFilter in org.springframework.security.web.FilterChainProxy$VirtualFilterChain | 82 | doFilter . . . . in grails.plugin.springsecurity.rest.RestLogoutFilter | 331 | doFilter in org.springframework.security.web.FilterChainProxy$VirtualFilterChain | 105 | doFilter . . . . in org.springframework.security.web.context.SecurityContextPersistenceFilter | 331 | doFilter in org.springframework.security.web.FilterChainProxy$VirtualFilterChain | 58 | doFilter . . . . in grails.plugin.springsecurity.web.SecurityRequestHolderFilter | 331 | doFilter in org.springframework.security.web.FilterChainProxy$VirtualFilterChain | 214 | doFilterInternal in org.springframework.security.web.FilterChainProxy | 177 | doFilter in '' | 77 | doFilterInternal in org.grails.web.servlet.mvc.GrailsWebRequestFilter | 67 | doFilterInternal in org.grails.web.filters.HiddenHttpMethodFilter | 33 | doFilterInternal in org.grails.plugins.springsession.web.http.HttpSessionSynchronizer | 171 | doFilterInternal in org.springframework.session.web.http.SessionRepositoryFilter | 80 | doFilter . . . . in org.springframework.session.web.http.OncePerRequestFilter | 1149 | runWorker in java.util.concurrent.ThreadPoolExecutor | 624 | run . . . . . . in java.util.concurrent.ThreadPoolExecutor$Worker ^ 748 | run in java.lang.Thread

[jameskleeh]

Which GORM implementation? Edit: n/m I see hibernate in the stacktrace