java.lang.IllegalStateException: No data type for node: org.hibernate.hql.internal.ast.tree.NullNode +-[NULL] NullNode: 'null' at org.hibernate.hql.internal.ast.tree.SelectClause.initializeExplicitSelectClause(SelectClause.java:160) ~[OrmClient-16.5.0.40-RC1.jar:na]

Stack Overflow | Akash Agrawal | 3 months ago
  1. 0

    java.lang.IllegalStateException: No data type for node: org.hibernate.hql.internal.ast.tree.NullNode +-[NULL] NullNode: 'null'

    Stack Overflow | 3 months ago | Akash Agrawal
    java.lang.IllegalStateException: No data type for node: org.hibernate.hql.internal.ast.tree.NullNode +-[NULL] NullNode: 'null' at org.hibernate.hql.internal.ast.tree.SelectClause.initializeExplicitSelectClause(SelectClause.java:160) ~[OrmClient-16.5.0.40-RC1.jar:na]
  2. 0

    JPQL query - inner join no data type for node

    Stack Overflow | 2 years ago | user2987444
    java.lang.IllegalArgumentException: Validation failed for query for method public abstract java.util.List com.tvfreakz.repository.ChannelProgrammeRepository.findScheduledPerformerProgrammes(java.lang.Long,java.util.Date,java.util.Date)!
  3. 0

    Hibernate HQL Join Query DOT node with no left-hand-side

    Stack Overflow | 2 years ago | iCode
    java.lang.IllegalStateException: DOT node with no left-hand-side!
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    When trying to apply an aggregate function on a subquery an error occurs during query compilation for all aggregate functions. I tested this with the following query (for other aggregate functions by replacing AVG): SELECT d.id, AVG((SELECT COUNT(localized) FROM Person p LEFT JOIN p.localized localized WHERE p.id = c.id)) AS localizedCount FROM Document d LEFT JOIN d.contacts c GROUP BY d.id Also, COUNT(subquery) seems not to be supported by the HQL grammar. The corresponding stack traces are: - for AVG Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected AST node: query [SELECT d.id, AVG((SELECT COUNT(localized) FROM hibernate.bug.model.Person p LEFT JOIN p.localized localized WHERE p.id = c.id)) AS localizedCount FROM hibernate.bug.model.Document d LEFT JOIN d.contacts c GROUP BY d.id] at org.hibernate.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54) at org.hibernate.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47) at org.hibernate.hql.internal.ast.ErrorCounter.throwQueryException(ErrorCounter.java:79) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:257) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:138) at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:105) at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:80) at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:168) at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:222) at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:200) at org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1703) at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:291) - for MAX (and likewise for MIN) java.lang.IllegalStateException: No data type for node: org.hibernate.hql.internal.ast.tree.AggregateNode \-[AGGREGATE] AggregateNode: 'MAX' at org.hibernate.hql.internal.ast.tree.SelectClause.initializeExplicitSelectClause(SelectClause.java:153) at org.hibernate.hql.internal.ast.HqlSqlWalker.useSelectClause(HqlSqlWalker.java:860) at org.hibernate.hql.internal.ast.HqlSqlWalker.processQuery(HqlSqlWalker.java:650) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:663) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:299) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:247) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:250) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:138) at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:105) at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:80) at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:168) at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:222) at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:200) at org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1703) at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:291) - for SUM java.lang.NullPointerException at org.hibernate.dialect.function.StandardAnsiSqlAggregationFunctions$SumFunction.determineJdbcTypeCode(StandardAnsiSqlAggregationFunctions.java:145) at org.hibernate.dialect.function.StandardAnsiSqlAggregationFunctions$SumFunction.getReturnType(StandardAnsiSqlAggregationFunctions.java:157) at org.hibernate.hql.internal.ast.util.SessionFactoryHelper.findFunctionReturnType(SessionFactoryHelper.java:406) at org.hibernate.hql.internal.ast.tree.AggregateNode.getDataType(AggregateNode.java:83) at org.hibernate.hql.internal.ast.tree.SelectClause.initializeExplicitSelectClause(SelectClause.java:151) at org.hibernate.hql.internal.ast.HqlSqlWalker.useSelectClause(HqlSqlWalker.java:860) at org.hibernate.hql.internal.ast.HqlSqlWalker.processQuery(HqlSqlWalker.java:650) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:663) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:299) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:247) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:250) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:138) at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:105) at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:80) at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:168) at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:222) at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:200) at org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1703) at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:291)

    Hibernate JIRA | 2 years ago | Moritz Becker
    java.lang.IllegalStateException: No data type for node: org.hibernate.hql.internal.ast.tree.AggregateNode \-[AGGREGATE] AggregateNode: 'MAX'
  6. 0

    Custom Mysql query on Spring Boot not working

    Stack Overflow | 7 months ago | r007
    org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'respuestaController' defined in file [/home/r007/Git/encuestaSNR/target/classes/ar/gob/snr/encuestaSNR/controller/RespuestaController.class]: Unsatisfied dependency expressed through constructor argument with index 0 of type [ar.gob.snr.encuestaSNR.service.RespuestaService]: Error creating bean with name 'respuestaServiceImpl': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: ar.gob.snr.encuestaSNR.dao.RespuestaRepository ar.gob.snr.encuestaSNR.service.impl.RespuestaServiceImpl.respuestaRepository; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'respuestaRepository': Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Validation failed for query for method public abstract java.lang.Integer ar.gob.snr.encuestaSNR.dao.RespuestaRepository.obtenerCodigoRespusetaMax()!; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'respuestaServiceImpl': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: ar.gob.snr.encuestaSNR.dao.RespuestaRepository ar.gob.snr.encuestaSNR.service.impl.RespuestaServiceImpl.respuestaRepository; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'respuestaRepository': Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Validation failed for query for method public abstract java.lang.Integer ar.gob.snr.encuestaSNR.dao.RespuestaRepository.obtenerCodigoRespusetaMax()!

  1. marcbouvierdav 3 times, last 3 months ago
7 unregistered visitors
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. java.lang.IllegalStateException

    No data type for node: org.hibernate.hql.internal.ast.tree.NullNode +-[NULL] NullNode: 'null' at org.hibernate.hql.internal.ast.tree.SelectClause.initializeExplicitSelectClause(SelectClause.java:160) ~[OrmClient-16.5.0.40-RC1.jar:na]

    at org.hibernate.hql.internal.ast.HqlSqlWalker.useSelectClause()
  2. Hibernate
    SessionImpl.createQuery
    1. org.hibernate.hql.internal.ast.HqlSqlWalker.useSelectClause(HqlSqlWalker.java:991)[OrmClient-16.5.0.40-RC1.jar:na]
    2. org.hibernate.hql.internal.ast.HqlSqlWalker.processQuery(HqlSqlWalker.java:759)[OrmClient-16.5.0.40-RC1.jar:na]
    3. org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:675)[OrmClient-16.5.0.40-RC1.jar:na]
    4. org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:311)[OrmClient-16.5.0.40-RC1.jar:na]
    5. org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:259)[OrmClient-16.5.0.40-RC1.jar:na]
    6. org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:262)[OrmClient-16.5.0.40-RC1.jar:na]
    7. org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:190)[OrmClient-16.5.0.40-RC1.jar:na]
    8. org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:142)[OrmClient-16.5.0.40-RC1.jar:na]
    9. org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:115)[OrmClient-16.5.0.40-RC1.jar:na]
    10. org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:76)[OrmClient-16.5.0.40-RC1.jar:na]
    11. org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:150)[OrmClient-16.5.0.40-RC1.jar:na]
    12. org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:302)[OrmClient-16.5.0.40-RC1.jar:na]
    13. org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:240)[OrmClient-16.5.0.40-RC1.jar:na]
    14. org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1907)[OrmClient-16.5.0.40-RC1.jar:na]
    14 frames