vishal29bhp

Thanks for your reply , I want the SQL run once not to be rerun again if it has same filter criteria or parameter value passed to it. That data and query will be avalible from the cache so that DB not hit again. and performance of the jasperserver boost for no of users. Give your valuable suggestion plz. Vishal

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

Hi Everybody, As JasperAnalysis and JasperServer Profession both uses the JasperPrint object in the user session So that the next request comes for the same report not generate the JasperPrint object again it serves the request from the pool. My question is Can we do the same thing in JasperServer Community Edtion so that report containing complex queries run fast on the browser after first request. One more issue regarding this when data changes in the database tables the report shows old data . Can we make Intelligent Caching System so that whenever the data changes in the database it reflects on the report without reloading the tomcat server. Plz give your valuable suggestion on the topics. Vishal

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

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

Very Much Thanks Lucian I Saw One of Post In Which Hibernate Datasource use the property "net.sf.jasperreports.hql.field.mapping.descriptions" set to false my reports run properly on iReport. When I tried to run the report using parameter value the Report not run means No Output. Vishal

Thanks Lucian for the reply I tried Hibernate Connection on Jasperserver it is working properly. When i tried complex query on iReport it is validating the query but not fething any data says "This document has no pages". I tried same query on Eclipse HQL editor it is fetching data properly. What do i do now. Vishal

Post Edited by vishal29bhp at 06/29/2009 12:51

Any pointer Thanks in Advance

Hi, I succussfully viewing the reports via Hibernate Connection on iReport. Can any body tell me how do we create Hibernate Connection on jasperserver. Will the data retrived by this connection will be available in the second level cache . Plz Answer Vishal Post Edited by vishal29bhp at 06/23/2009 10:35

How & Where do we configure hibernate.cfg.xml and *.hbm.xml files and are we have to create DTO per table of the Database. Plz Help Vishal

Code:Hi Every body, Can anybody tell me what are the performance parameter of jasperserver on tweaking them we can improve the performance of jasperserver . So that report viewing be possible in less than 10 seconds . Any pointer Plz help. Vishal

Hi you need to make Scriptlet for executing PL/SQL using Java Callable Statements. Vishal

Have you able to run Scriptlet now Vishal

Hi Lucian Do you help me on this issue

Hi , I am using Single Value Input Control to show the date value. But I need to show the value of this date , default from the database. Can is this possible in jasperserver 3.1.0. Thanks is Advance. Vishal

Any Body any pointer on this. Vishal

I no more workaround on cascading busy with some Dashboard Stuff but you have given some indication in one of the post that "we have no of input controls and 15 may was the releasing date". Any way but if you give me some guidelines via mail then i could do this for the community. Vishal Email:vishal29bhp@gmail.com

Hi Guilio, How do i set the default value of Date Input Control fetching from the database query. Do i need to make Scriptlet for this . I tried the sample Scriptlet but it didnt work . Is this the only way to set the default value of any input control from the database. Plz guide me Vishal

also when i export report as HTML format ,the Report name appears only and nothing else. vishal

Thanks Srikant for your reply , For this solution i have to change default landing page as a jsp and on that jsp multiple iFrame must be there as i making Dashboard . But when i do this Jasperserver not give any output when changes default landing page to jsp . Any Suggestion I am using JS 3.1.0 Comunity Edition. Vishal

Hi, Can i display jasperreport in iframe using jasperserver. suppose a report is bigger in height and width . I want this report in IFrame so that rendering of this big report in a scrollble format at browser end. Any Body any pointer. Vishal

Hi Madhavi, I trying to export a report which contains chart but nothing appeared on browser except report name. No images and Data displayed.I am using my own web application to display the report. Vishal

Can any body give some suggestion. Vishal

Hi I tried a lot to make Scriptlet working in iReport but no luck. Every time when i add jar to the classpath and run the report it shows nothing also no error. How do you make scriplet can you explain me the steps for creating it in iReport. Vishal Post Edited by vishal29bhp at 05/27/2009 10:11