org.springframework.dao.InvalidDataAccessResourceUsageException: Queries of type NotIn are not supported by this implementation

GitHub | snimavat | 8 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Queries of type NotIn are not supported when doing updateAll

    GitHub | 8 months ago | snimavat
    org.springframework.dao.InvalidDataAccessResourceUsageException: Queries of type NotIn are not supported by this implementation

    Root Cause Analysis

    1. org.springframework.dao.InvalidDataAccessResourceUsageException

      Queries of type NotIn are not supported by this implementation

      at org.grails.datastore.mapping.query.jpa.JpaQueryBuilder.buildWhereClauseForCriterion()
    2. Grails GORM
      JpaQueryBuilder.buildUpdate
      1. org.grails.datastore.mapping.query.jpa.JpaQueryBuilder.buildWhereClauseForCriterion(JpaQueryBuilder.java:763)
      2. org.grails.datastore.mapping.query.jpa.JpaQueryBuilder$3.handle(JpaQueryBuilder.java:292)
      3. org.grails.datastore.mapping.query.jpa.JpaQueryBuilder.buildWhereClauseForCriterion(JpaQueryBuilder.java:749)
      4. org.grails.datastore.mapping.query.jpa.JpaQueryBuilder.buildWhereClause(JpaQueryBuilder.java:717)
      5. org.grails.datastore.mapping.query.jpa.JpaQueryBuilder.buildUpdate(JpaQueryBuilder.java:128)
      5 frames
    3. Grails
      HibernateSession$2.doInHibernate
      1. org.codehaus.groovy.grails.orm.hibernate.HibernateSession$2.doInHibernate(HibernateSession.java:125)
      2. org.codehaus.groovy.grails.orm.hibernate.HibernateSession$2.doInHibernate(HibernateSession.java:121)
      2 frames
    4. Hibernate
      HibernateTemplate.execute
      1. org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
      2. org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:341)
      2 frames
    5. Grails
      HibernateSession.updateAll
      1. org.codehaus.groovy.grails.orm.hibernate.HibernateSession.updateAll(HibernateSession.java:121)
      1 frame
    6. Grails GORM
      DetachedCriteria.updateAll_closure8
      1. grails.gorm.DetachedCriteria.updateAll_closure8(DetachedCriteria.groovy:927)
      1 frame
    7. Springloaded
      ReflectiveInterceptor.jlrMethodInvoke
      1. org.springsource.loaded.ri.ReflectiveInterceptor.jlrMethodInvoke(ReflectiveInterceptor.java:1270)
      1 frame
    8. Groovy
      Closure.call
      1. groovy.lang.Closure.call(Closure.java:423)
      2. groovy.lang.Closure.call(Closure.java:439)
      2 frames
    9. Grails GORM
      GormStaticApi.withDatastoreSession_closure23
      1. org.grails.datastore.gorm.GormStaticApi.withDatastoreSession_closure23(GormStaticApi.groovy:700)
      1 frame
    10. Springloaded
      ReflectiveInterceptor.jlrMethodInvoke
      1. org.springsource.loaded.ri.ReflectiveInterceptor.jlrMethodInvoke(ReflectiveInterceptor.java:1270)
      1 frame
    11. Groovy
      Closure.call
      1. groovy.lang.Closure.call(Closure.java:423)
      1 frame
    12. Grails GORM
      DatastoreUtils.execute
      1. org.grails.datastore.mapping.core.DatastoreUtils.execute(DatastoreUtils.java:302)
      1 frame
    13. Grails GORM
      DetachedCriteria.updateAll
      1. org.grails.datastore.gorm.AbstractDatastoreApi.execute(AbstractDatastoreApi.groovy:37)
      2. org.grails.datastore.gorm.GormStaticApi.withDatastoreSession(GormStaticApi.groovy:699)
      3. grails.gorm.DetachedCriteria.updateAll(DetachedCriteria.groovy:926)
      3 frames