| Category: | Bug report |
Priority: | High |
Status: | Assigned |
| Project: | Severity: | Major |
Resolution: | Open |
|
| Component: | Reproducibility: | Always |
Assigned to: |
Using Ireports 2.0.4 and SQL server 2005 and the spring loaded hibernate connection.
When doing a subselect:
select g.idno as idno,
isNull(g.vendorName, 'No Vendor Selected') as derivedName,
g.cgName as projectName,
g.authAmt as authAmount,
isNull(g.disbTotal,'0.00') as disburseAmount,
g.termDate as termDate,
g.authDate as authDate,
(select sum(aah.authorizeAmount) as sumOriginalAuth
from AuthorizationAmountHistory as aah,
AuthorizationTranRelated as atr
where aah.authorizeId = atr.authorizationId
and aah.authorizationType = 'original'
and atr.relatedId = $P{grantId}) as originalAuthAmount
from Grant as g
where g.grantId = $P{grantId}
I get the following:
java.lang.NullPointerException
at org.hibernate.hql.antlr.HqlSqlBaseWalker.aliasedSelectExpr(HqlSqlBaseWalker.java:1703)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectExprList(HqlSqlBaseWalker.java:1474)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectClause(HqlSqlBaseWalker.java:1041)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:380)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:201)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:151)
at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:189)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:130)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:83)
at org.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:427)
at org.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:884)
at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:920)
at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41)
at it.businesslogic.ireport.data.hibernate.HQLFieldsReader.readFields(HQLFieldsReader.java:178)
at it.businesslogic.ireport.data.BeanInspectorPanel.queryChanged(BeanInspectorPanel.java:467)
at it.businesslogic.ireport.gui.ReportQueryDialog$FieldReader.run(ReportQueryDialog.java:498)
java.lang.NullPointerException
at org.hibernate.hql.antlr.HqlSqlBaseWalker.aliasedSelectExpr(HqlSqlBaseWalker.java:1703)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectExprList(HqlSqlBaseWalker.java:1474)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectClause(HqlSqlBaseWalker.java:1041)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:380)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:201)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:151)
at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:189)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:130)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:83)
at org.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:427)
at org.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:884)
at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:920)
at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41)
at it.businesslogic.ireport.data.hibernate.HQLFieldsReader.readFields(HQLFieldsReader.java:178)
at it.businesslogic.ireport.data.BeanInspectorPanel.queryChanged(BeanInspectorPanel.java:467)
at it.businesslogic.ireport.gui.ReportQueryDialog$FieldReader.run(ReportQueryDialog.java:498)
1 Comment:
I found a workaround. I remove all entries of cache from my hbm files (<cache usage="read-only"/>) that are copied into a temp directory specifically for IReports.
I then copied a new hibernate.jar (3.2.5.ga) to the \\iReport-2.0.4\\lib directory. I then fired up IReports and the subqueries began working!!!