org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select count(*) from document where current_date - cast(image_indexing_date as date) >= 20]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

hsqldb | dma_k | 6 years ago
  1. 0

    A subtraction of two dates leads to exception

    hsqldb | 6 years ago | dma_k
    org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select count(*) from document where current_date - cast(image_indexing_date as date) >= 20]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
  2. 0

    SpringDataJpa - Cannot use Pageable with an Entity that has a composite key & Oracle - Spring Forum

    spring.io | 11 months ago
    org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select distinct count((laborderco0_.ANCILLARY_ABBR, laborderco0_.ORDER_CODE)) as col_0_0_ from LAB_ORDER_CODE laborderco0_]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
  3. 0

    Unexpected Token Error when Creating an XML Backup - Atlassian Documentation

    atlassian.com | 5 months ago
    org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    [SAK-16451] DB2 - Glossary tool gets SqlGrammarException - Sakai

    sakaiproject.org | 1 year ago
    org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
  6. 0

    Wrong hibernate SQL query: ElementCollection included as column

    Stack Overflow | 5 years ago | Thiagarajan Hariharan
    org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select wifinetwor0_.id as id0_, wifinetwor0_.ssid as ssid0_, wifinetwor0_.priority as priority0_, wifinetwor0_.auth_algorithms as auth4_0_, wifinetwor0_.group_cipher as group5_0_, wifinetwor0_.key_management as key6_0_, wifinetwor0_.pairwise_cipher as pairwise7_0_, wifinetwor0_.protocol as protocol0_, wifinetwor0_.vpn_type as vpn9_0_, wifinetwor0_.vpn_url as vpn10_0_, wifinetwor0_.authAlgorithm as authAlg11_0_ from wifi_network_config wifinetwor0_]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.springframework.dao.InvalidDataAccessResourceUsageException

      could not execute query; SQL [select count(*) from document where current_date - cast(image_indexing_date as date) >= 20]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

      at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException()
    2. Hibernate
      HibernateTemplate.findByNamedQuery
      1. org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:629)
      2. org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
      3. org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
      4. org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
      5. org.springframework.orm.hibernate3.HibernateTemplate.findByNamedQuery(HibernateTemplate.java:979)
      6. org.springframework.orm.hibernate3.HibernateTemplate.findByNamedQuery(HibernateTemplate.java:971)
      6 frames