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

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

    Stack Overflow | 7 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 | 3 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 | 3 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 | 11 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 7 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