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

GitHub | snimavat | 6 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Queries of type NotIn are not supported when doing updateAll

    GitHub | 6 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