HQL for Single Select Input Control Not Working

[vishal29bhp]

Code:

Hi,

   I am Trying to make Single Select Input control using HQL But get JRRuntimeException. I made Hibernate Datasource on jasperserver for report Viewing.

Stack Trace:



net.sf.jasperreports.engine.JRRuntimeException: The HQL query returns only one non-entity and non-component result but there are more than one fields.

	at net.sf.jasperreports.engine.data.JRHibernateAbstractDataSource.assignReaders(JRHibernateAbstractDataSource.java:110)

	at net.sf.jasperreports.engine.data.JRHibernateAbstractDataSource.<init>(JRHibernateAbstractDataSource.java:69)

	at net.sf.jasperreports.engine.data.JRHibernateListDataSource.<init>(JRHibernateListDataSource.java:55)

	at net.sf.jasperreports.engine.query.JRHibernateQueryExecuter.createResultDatasource(JRHibernateQueryExecuter.java:161)

	at net.sf.jasperreports.engine.query.JRHibernateQueryExecuter.createDatasource(JRHibernateQueryExecuter.java:132)

	at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRQueryExecuterAdapter.executeQuery(JRQueryExecuterAdapter.java:95)

	at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeQuery(EngineServiceImpl.java:914)

	at com.jaspersoft.jasperserver.war.action.ReportParametersAction.executeQuery(ReportParametersAction.java:514)

	at com.jaspersoft.jasperserver.war.action.ReportParametersAction.createWrappers(ReportParametersAction.java:477)

	at com.jaspersoft.jasperserver.war.action.ReportParametersAction.createWrappers(ReportParametersAction.java:414)

	at com.jaspersoft.jasperserver.war.action.ReportParametersAction.createWrappers(ReportParametersAction.java:123)

	at com.jaspersoft.jasperserver.war.action.ViewReportAction.checkForParams(ViewReportAction.java:148)

	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

	at java.lang.reflect.Method.invoke(Method.java:585)

	at org.springframework.webflow.util.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:103)

	at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:136)

	at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:203)

	at org.springframework.webflow.engine.AnnotatedAction.execute(AnnotatedAction.java:142)

	at org.springframework.webflow.engine.ActionExecutor.execute(ActionExecutor.java:61)

	at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:180)

	at org.springframework.webflow.engine.State.enter(State.java:200)

	at org.springframework.webflow.engine.Flow.start(Flow.java:557)

	at org.springframework.webflow.engine.impl.RequestControlContextImpl.start(RequestControlContextImpl.java:195)

	at org.springframework.webflow.engine.impl.FlowExecutionImpl.start(FlowExecutionImpl.java:189)

	at org.springframework.webflow.executor.FlowExecutorImpl.launch(FlowExecutorImpl.java:206)

	at sun.reflect.GeneratedMethodAccessor218.invoke(Unknown Source)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

	at java.lang.reflect.Method.invoke(Method.java:585)

	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)

	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)

	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)

	at org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66)

	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)

	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)

	at $Proxy13.launch(Unknown Source)

	at org.springframework.webflow.executor.support.FlowRequestHandler.handleFlowRequest(FlowRequestHandler.java:131)

	at org.springframework.webflow.executor.mvc.FlowController.handleRequestInternal(FlowController.java:170)

	at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)

	at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:45)

	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:820)

	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755)

	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396)

	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350)

	at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)

	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)

	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

	at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86)

	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)

	at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335)

	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

	at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)

	at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)

	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

	at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)

	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

	at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)

	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

	at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:141)

	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

	at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97)

	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

	at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181)

	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

	at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165)

	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

	at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)

	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

	at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165)

	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

	at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191)

	at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

	at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)

	at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90)

	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

	at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70)

	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138)

	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)

	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)

	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)

	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)

	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)

	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)

	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)

	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)

	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)

	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)

	at java.lang.Thread.run(Thread.java:595)



Can the same Hibernate datasource connection is not applicable for input control query .



Plz Guide



Vishal

[swood]

Looks could be a problem with the HQL or a bug. Can you show the HQL and the input control set up?

 

Sherman

Jaspersoft

Post Edited by swood at 07/03/2009 22:49

[vishal29bhp]

Hi Sherman,

 

What i did is described below.

 

HQL : select distinct time.id.calenderYear as Year from TimeDimension as time

 

Input Control setup :

 

Parameter Name - yearValue(Same as Report Parameter)

Type - Single Select query

 

Query Locate Datasource - Other than as i used for Report

 

Query Information

 

Value Column - Year

Visible Column - Year

 

Plz Guide me , Waiting for your Valuable Suggestion.

 

Vishal

 

[lucianc]

What JS version are you using?  I think this was fixed in 3.5 as a side effect of another bug.

In any case, you can workaround this by changing your HQL to select another value (which you don't need to use in any way), e.g. select distinct time.id.calenderYear as Year, time.id.calenderYear as Year2 from TimeDimension as time.

Regards,

Lucian

[vishal29bhp]

Thanks Lucian,

 

I am using Jasperserver 3.0 . When i tried your solution i got Java.lang.ClassCastException : Java.lang.Long Exception.

 

this report running properly on iReport . Vishal

StackTrace:

 

Code:

Post Edited by vishal29bhp at 07/06/2009 08:01

Post Edited by vishal29bhp at 07/06/2009 09:26

[lucianc]

vishal29bhp
Wrote:

When i tried your solution i got Java.lang.ClassCastException : Java.lang.Long Exception.

That's strange.  Are you using Year2 as visible column?

In any case, try to use the following HQL instead: select distinct time.id.calenderYear as Year, str(time.id.calenderYear) as Year2 from TimeDimension as time

Regards,

Lucian

[vishal29bhp]

 

Thanks Lucian

 

Its working properly but report running is too slow and when next time i run the report with same parameter value is also take time. Is there not any support Hibernate Caching in Jasperserver 3.0.

 

Plz clear me this confusion.

 

Vishal

 

[swood]

The Hibernate caching configuration is up to you.

 

Sherman

Jaspersoft