[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-3362) NullPointerException in org.hibernate.dialect.Dialect$2.getReturnType

[Giridhar Nandigam (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3362?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=32328#action_32328 ] 

Giridhar Nandigam commented on HHH-3362:
----------------------------------------

I had a similar issue and quickly solved this by giving using the right parameter for the avg function. I put in the wrong column name.

Try checking the column name of your hibernate class for "Shop_Product_Stock". 

I don't think this is an issue still, and it is safe to close it.

> NullPointerException in org.hibernate.dialect.Dialect$2.getReturnType
> ---------------------------------------------------------------------
>
>                 Key: HHH-3362
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3362
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 3.2.6
>         Environment: Hibernate Core 3.6.2 GA, hsqldb
>            Reporter: Istvan Kovacs
>         Attachments: bug_src.zip
>
>
> java.lang.NullPointerException
>         at org.hibernate.dialect.Dialect$2.getReturnType(Dialect.java:85)
>         at org.hibernate.hql.ast.util.SessionFactoryHelper.findFunctionReturnType(SessionFactoryHelper.java:382)
>         at org.hibernate.hql.ast.tree.AggregateNode.getDataType(AggregateNode.java:21)
>         at org.hibernate.hql.ast.tree.SelectClause.initializeExplicitSelectClause(SelectClause.java:143)
>         at org.hibernate.hql.ast.HqlSqlWalker.useSelectClause(HqlSqlWalker.java:705)
>         at org.hibernate.hql.ast.HqlSqlWalker.processQuery(HqlSqlWalker.java:529)
>         at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:645)
>         at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:281)
>         at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:229)
>         at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:228)
>         at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:160)
>         at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
>         at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
>         at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
>         at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
>         at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
>         at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
>         at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)
>         at org.hibernate.console.HQLQueryPage.setSession(HQLQueryPage.java:106)
>         at org.hibernate.console.ConsoleConfiguration$4.execute(ConsoleConfiguration.java:388)
>         at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:65)
>         at org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:383)
> [...] 
> 3 classes:
> Employee: Long ID; String name; Shop shop
> Shop: Long ID; String name; Set<Employee> employees; Map<Product, Integer> stock
> Product: Long ID; String name
> I mapped them to RDBMS using Hibernate. There's a table to hold stock info:
> SHOP_PRODUCT_STOCK - has fields SHOP_ID, PRODUCT_ID, AMOUNT
> SQL to query the average stock of each product:
> select p.name as name, avg(sps.amount) as avg_stock
> from Shop s, Shop_Product_Stock sps, Product p
> where sps.product_id=p.product_id and sps.product_id=p.product_id
> group by p.name
> order by p.name;
> Attempt in HQL that the produces exception:
> select p, avg(s.stock[p])
> from Shop s, Product p
> group by p
> I've also tried SELECTing and GROUPing BY p.id and p.name. None of the three variants work.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira