ericlomm

Hello, I am currently in the process of creating some reports for a new client that will be showing captured images from paper documents as the details that are shown in the report. I am currently storing the images that I want to have as the details as BLOB data in a MySQL database. When I try and add the images to a report in Ireport however I am not able to get the results that I am looking for. The first thing that I have tried is to just include the field from the query. When I do this the result that I see is the first 10 hexidecimal characters of the image file. Next I tried adding an image object to the report and setting its source to be the column in the Database that stores the image. I have tried this with various settings for the expression class but whatever I am using I get an error similar to the one below, (the details change slightly based on the expression class I use) Is it possible to included an image that is stored in a database as a part of a report in jasperreports? Eric Lommatsch Code:Error filling print... Error evaluating expression :     Source text : $F{pcxImage} Setting up the file resolver... net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression :     Source text : $F{pcxImage}     at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:195)     at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:589)     at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:557)     at net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:929)     at net.sf.jasperreports.engine.fill.JRFillImage.evaluateImage(JRFillImage.java:1023)     at net.sf.jasperreports.engine.fill.JRFillImage.evaluate(JRFillImage.java:1004)     at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:258)     at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:499)     at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2036)     at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:760)     at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:270)     at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:128)     at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:946)     at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:845)     at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:58)     at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:417)     at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247)     at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:878)     at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)     at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused by: org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast object '[b@1a12d23' with class '[b' to class 'java.awt.Image'     at org.codehaus.groovy.runtime.typehandling.DefaultTypeTransformation.castToType(DefaultTypeTransformation.java:327)     at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.castToType(ScriptBytecodeAdapter.java:602)     at CourseComments_1304459981811_919575.evaluate(calculator_CourseComments_1304459981811_919575:185)     at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:182)     ... 19 more Print not filled. Try to use an EmptyDataSource...

Hello, I am looking at some bar chart reports that we are creating for a client. In developing these reports I have found that for some datasets that I am reporting on the way bars on the chart look is not the most visually appealing. I have looked at the options available and have not seen what I am looking for. So I am asking to see if someone knows if I can do either of these with the bar charts. Is there a way to control how wide the bars are when they appear the chart? If I can't control the width of the charts can I have it be a case where instead of the bars being a solid color, I can make them them into a cross hatch pattern? If anyone know if I can do this I will look forward to hearing from you.

I guess I can take the lack of replies one of two ways. Either I didn't make my problem clear enough or nobody else has encountered this problem and I will need to figure this out on my own.

Hello, Based on the PHP sample and client needs I have developed a PHP client front end to the Web services repository on our jasperserver box. Using the PHP front end that I have developed I am now able to get access to client specific reports working from computers that are behind our local firewall. I have now started opening up external access to the jasperserver so that our clients can get into the reports we have created for them. This is where I seem to be running into an issue. When I try to connect to the web service through my PHP pages from the external website I am now getting the error message "Connect error to hostname:8080" when I try to connect to the server. If I enter the address "http://hostname:8080/jasperserver/services/repository" I am getting the login screen and when I login I am seeing the initial repository page for jasperserver. So it seems that I have all of the firewall settings setup correctly. Why would the PHP login screen be giving an error message when I am logging in from an external computer? Do I need to add that external computers IP to some file somewhere? Eric Lommatsch

Hello, I don't know if this is more of an Ireports question or a JasperReports question. But I am hoping that if I am posting this in the wrong place someone will point me in the correct dirrection We have requirement where we are trying to include stored images form scaned documents in a report. I have been able in the past to get the images that I am working with to display in another reporting tool. But when I try to include images in jasper reports files I keep getting compilation errors. Can I use iReports to add stored images to the detail section of a jasper report? If I can is there a sample of how to do this? Eric Lommatsch

I guess I can take the lack of reply one of two ways. Either my question is so complex no one has read all the way through or nobody else has tried to use a PHP front end with the jasper server interface. If I am wrong about either of these please let me know.

Hello, After some analysis of what our customers needs are, we have decided that for our clients needs what we need to do is develop our own PHP interface that should allow our clients to log in to our PHP portal and select information what specific combination of parameters they want to pass to the reports they are running. (Currently for one there are over 1200 possible combinations of parameter they can choose for one report) I used the PHP sample application as a starting and I was able to create a page that can pass the needed parameters based on a URL. When I was passing this information to executeReport.php I was able to get the report to execute correctly. However In talking thing over with a co worker it would be desirable to instead of having to either include an additional PHP page where the user selects the format they want the report in or having to force the user to accept a predefined format I put into the link, allow the user to see the portal interface that the jasper server provides so the can choose which format they want to see the report in. But when I modified the link URL to point the the jasperserver portal when I click on a link for one of the reports, I am taken to the jasperserver login screen. As I understand how the PHP sample works the user has already been authenticated by the index.php page. Apparently the session information that PHP is not being passed to the portal and the portal is asking the user for a second time to authenticate themselves. Does the session information I already have in the PHP application not get passed to the portal? If not is there another way to get the functionality of allowing the user to select what format they want the report in after the report has been Generated? Eric Lommatsch

OK, I finally was able to bet back to this issue. When I went to a browser on the liferay machine I was able get access to the jasper server. But I am still getting a connection refused message when I am trying to use the liferay portal. Any suggestions on what might be happening?

Hello, I am trying to get The JasperServer Portlet in LifeRay. I have the portlet all setup in LifeRay. However when I try to use the portlet to connect I am getting the message: Connection Refused The portal cannot connect to JasperServer. Please contact your JasperServer administrator. I have looked at other posts and I have checked to make sure that the portlet.xml file is pointing to the correct IP address in the JasperServer Portlet. I have made sure that the IP address of the LifeRay server is set as a Trusted address in the applicationContext-security.xml file. I can go to a web browser and access the repository from a Browser. I have tried everything that I have seen in posts and I am still not connecting. What else could be keeping me from connecting to JasperServer?

suedonne123 Wrote: edit this file and find the axis2.ManagementServer entry...it is probably commented out "#" at beginning is comment... I am using the community edition and I don't appear to have an "...axis2.ManagementServer..." entry to uncomment. If it was just a case of that line being commented out I would not have been asking for the syntax for how to write the statement. I did a search in my file for simply the word "axis" and had no results. One thing I know from my search efforts is that the syntax is not: log4j.logger.org.apache.axis=debug As I had found when I first did a search for possible syntax. I do have ROLE_PORTLET defined and I have the user name that I setup for my user setup as a user of the ROLE_PORTLET.

Ok, I can get to the repository and see the window. Is there someplace I can find an example of the syntax for turning on axis debuging. (I hate to sound like I don't know what I am doing, but up to this point in my career I have not done much with Java) I am just trying to make sure I get all of the correct Information so that I am really loggin the axis information. Post Edited by ericlomm at 12/10/2009 21:12

OK, that post provided me with some useful information. But after going through all of the changes in the link what I can say is that my problem appears to be unrelated to the installation issues the the link refered to. I have the jasperserver portlet installed and it is running on the server. The problem is that when I try to connect to my jasperserver I am getting a "Connection Refused..." message. I have looked at the catalina.out file and from what I am seeing it appears that my problem AxisFault. I have posted the full text that is in the catalina.out file related to the error message as code. Can someone tell me how to fix this Axis Fault? Or should I post this as a seperate message Code:AxisFault faultCode: {http://xml.apache.org/axis/}HTTP faultSubcode: faultString: (404)Not Found faultActor: faultNode: faultDetail: {}:return code: 404<html><head> <title></title> <meta content="1; url=http://localhost:8080/web/guest;jsessionid=3ADA8ABD0A267AA7F58ECE24508A6B9A" http-equiv="refresh" /></head><body onload="javascript: location.replace('http://localhost:8080/web/guest;jsessionid=3ADA8ABD0A267AA7F58ECE24508A6B9A')"><!--The numbers below are used to fill up space so that this works properly in IE.See http://support.microsoft.com/default.aspx?scid=kb;en-us;Q294807 for moreinformation on why this is necessary.123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890--></body></html> {http://xml.apache.org/axis/}HttpErrorCode:404(404)Not Found at org.apache.axis.transport.http.HTTPSender.readFromSocket(HTTPSender.java:744) at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:144) at com.liferay.util.axis.SimpleHTTPSender.invoke(SimpleHTTPSender.java:77) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165) at org.apache.axis.client.Call.invokeEngine(Call.java:2784) at org.apache.axis.client.Call.invoke(Call.java:2767) at org.apache.axis.client.Call.invoke(Call.java:2443) at org.apache.axis.client.Call.invoke(Call.java:2366) at org.apache.axis.client.Call.invoke(Call.java:1812) at com.jaspersoft.jasperserver.portlet.engine.ws.RepositorySoapBindingStub.list(RepositorySoapBindingStub.java:263) at com.jaspersoft.jasperserver.portlet.engine.ws.WSClient.list(WSClient.java:161) at com.jaspersoft.jasperserver.portlet.engine.ws.WSClient.list(WSClient.java:151) at com.jaspersoft.jasperserver.portlet.controller.JSPortletEditController.getAllReports(JSPortletEditController.java:217) at com.jaspersoft.jasperserver.portlet.controller.JSPortletEditController.handleRenderRequest(JSPortletEditController.java:77) at org.springframework.web.portlet.mvc.SimpleControllerHandlerAdapter.handleRender(SimpleControllerHandlerAdapter.java:52) at org.springframework.web.portlet.DispatcherPortlet.doRenderService(DispatcherPortlet.java:750) at org.springframework.web.portlet.FrameworkPortlet.processRequest(FrameworkPortlet.java:421) at org.springframework.web.portlet.FrameworkPortlet.doDispatch(FrameworkPortlet.java:391) at javax.portlet.GenericPortlet.render(GenericPortlet.java:233) at com.sun.portal.portletcontainer.appengine.filter.FilterChainImpl.doFilter(FilterChainImpl.java:126) at com.liferay.portal.kernel.portlet.PortletFilterUtil.doFilter(PortletFilterUtil.java:69) at com.liferay.portal.kernel.servlet.PortletServlet.service(PortletServlet.java:100) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:535) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:472) at com.liferay.portlet.InvokerPortletImpl.invoke(InvokerPortletImpl.java:618) at com.liferay.portlet.InvokerPortletImpl.invokeRender(InvokerPortletImpl.java:700) at com.liferay.portlet.InvokerPortletImpl.render(InvokerPortletImpl.java:419) at org.apache.jsp.html.portal.render_005fportlet_jsp._jspService(Unknown Source) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:535) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:472) at com.liferay.portal.util.PortalImpl.renderPortlet(PortalImpl.java:2884) at com.liferay.portal.util.PortalUtil.renderPortlet(PortalUtil.java:897) at com.liferay.portlet.layoutconfiguration.util.RuntimePortletUtil.processPortlet(RuntimePortletUtil.java:170) at com.liferay.portlet.layoutconfiguration.util.RuntimePortletUtil.processPortlet(RuntimePortletUtil.java:103) at com.liferay.portlet.layoutconfiguration.util.RuntimePortletUtil.processTemplate(RuntimePortletUtil.java:281) at com.liferay.portlet.layoutconfiguration.util.RuntimePortletUtil.processTemplate(RuntimePortletUtil.java:190) at org.apache.jsp.html.portal.layout.view.portlet_jsp._jspService(Unknown Source) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:535) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:472) at com.liferay.portal.action.LayoutAction.includeLayoutContent(LayoutAction.java:294) at com.liferay.portal.action.LayoutAction.processLayout(LayoutAction.java:471) at com.liferay.portal.action.LayoutAction.execute(LayoutAction.java:195) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) at com.liferay.portal.struts.PortalRequestProcessor.process(PortalRequestProcessor.java:157) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at com.liferay.portal.servlet.MainServlet.callParentService(MainServlet.java:608) at com.liferay.portal.servlet.MainServlet.service(MainServlet.java:846) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302) at com.liferay.portal.servlet.FriendlyURLServlet.service(FriendlyURLServlet.java:143) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:154) at com.liferay.portal.servlet.filters.strip.StripFilter.processFilter(StripFilter.java:142) at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:154) at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:94) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:154) at com.liferay.portal.servlet.filters.gzip.GZipFilter.processFilter(GZipFilter.java:140) at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:154) at com.liferay.portal.servlet.filters.secure.SecureFilter.processFilter(SecureFilter.java:282) at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:154) at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:94) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:154) at com.liferay.portal.servlet.filters.cache.CacheFilter.processFilter(CacheFilter.java:425) at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:154) at com.liferay.portal.servlet.filters.autologin.AutoLoginFilter.processFilter(AutoLoginFilter.java:257) at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:154) at com.liferay.portal.servlet.filters.sso.opensso.OpenSSOFilter.processFilter(OpenSSOFilter.java:73) at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:154) at com.liferay.portal.sharepoint.SharepointFilter.processFilter(SharepointFilter.java:193) at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:154) at com.liferay.portal.servlet.filters.virtualhost.VirtualHostFilter.doFilter(VirtualHostFilter.java:191) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:154) at com.liferay.portal.servlet.filters.threadlocalcache.ThreadLocalCacheFilter.processFilter(ThreadLocalCacheFilter.java:55) at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:154) at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:94) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:738) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) at java.lang.Thread.run(Thread.java:595)

Hello, OK, so I now had the jasperserver portlet installed in liferay and I have added it as an application to liferay. But I now I have an issue where when I am trying to connect to the JasperServer through Liferay I am getting a message about the "Connection Refused ..." I have checked through the documentation and I have made sure that JasperServer has the IP address of my Liferay server as a trusted address. I have double checked to make that the portlet is pointing to the correct server address. But I am still having my connection attempts refused. What else can I try to make sure that this is working corrently?

OK, I now have a valid portlet.xml file and It did not appear to give me any error messages. But I am still not seeing the jasperserver Portlet as an available application would I just look in /var/logs to find any error logs?

I suspect what you mean is I will have edit the portlet.xml in the war file, rather then the one on the webserver after I try and install the war file. Is that correct?

Hello, Ok, since I never had any replys on this message I have figured the answers to my second and third questions on my own. I was able to find the jasperServerPortlet.war file at source forge and download it and I have learned enough about the version of liferay we have installed that I am able to to upload the war file into liferay. I think I also have a handle on the first question as well, but I am not positive. I believe from what I am looking at, the <context_name> I am looking for is going to be the directory that was created when I installed the the WAR file. But I am not sure. Can someone please verify this? Also after I have installed the JasperServerPortlet.WAR into liferay and I try to add the application the JasperServer Portlet is not available in the list of applications I can install. However I do see a number of categories available that I can use. I have added an image of what I am seeing below. Can someone save me some time and tell me where to look to add the JasperServer Portlet to liferay as an application.

Hello, I am trying to follow the documentation for integrating Jasperserver and the liferay Portal that is available in the JasperServer Users Guide for the community edition. I have found that I am totally confused in following the examples in the documentation I have available. First, I am confused as to what the correct <context_name> is when I am looking for the portlet.xml file. I am not seeing anything that looks like it would be a default for the context_name, where would I be able to find this? Second, where can i find the war file for the jasperserverportlet at? Third, We have a newer, or at least a different version of Liferay then is described in the documentation that we have for our version of JasperServer. Is there something available that describes the what the differences in configuration are for liferay 5.2.0? Thanks

Hello, I am looking into setting up web services to allow users to access and view reports from another system. I am currently reading through the web services guide, But I was wondering if someone can point me to actual examples of web services that are simply allowing user to run and view reports. Eric Lommatsch

The version of Jasperserver that I am using is 3.5.0. When I did some looking the problem I found was that I had entered: com.mysql.jdbc.driver instead of com.mysql.jdbc.Driver I am working on a linux box and I found that an Upper D is what makes it work.

OK, I finally figured out what the issue was. I had com.mysql.jdbc.driver instead of com.mysql.jdbc.Driver as the driver in the connection I was setting up. This is running on a linux system and case sensitivity is important.

I am guessing that since nobody responded to this over a 4 day weekend I will have to figure this out on my own.

Hello, I am trying to create a JDBC MySQL data source for some reports to our MySQL Database. However, when I try to test the connection I am getting a "Test failed" Message, Nothing more then that. So I then created a simple test report so that I could see what the error might be. When I did this I was able to figure out what the error appears to be. When I try to run the report the main error message of revelance is: java.lang.ClassNotFoundException: com.mysql.jdbc.driverI looked through this fourm and found that it suggested looking looking for the "mysql-connector-java-5.*.*-bin.jar" in the "*tomcat/common/lib" directory. When I looked there I found a file mysql-connector-java-5.1.6-bin.jar located in that file. I have also found the same file located in "*tomcat/webapps/jasperserver/WEB-INF/lib" It would seem to me that this file is in the path. What Have I done wrong in setting up this JDBC connection? The same information works fine in Ireport and jasperreports.

OK, that was exactly the information that I was looking for. I am now not having to re login if I get distracted.

Hello, I am now working on figuring out how to set up our jasperserver that we have installed in our office. But one thing that I have found that for me is annoying is that fact that after, it seems like 15-20 minutes of inactivity but It could be more or less, I am having to login to jasperserver again. I know that there are security reasons for wanting to log users out after a cretain amount of inactivity. But what I want to know is is there any way that I can change the time period that a user need to be inactive before they are logged out? Eric Lommatsch

Hello, I am developing a report with bar charts. I have found that when I print the report to a Black and white printer the bars for the different categories print so that they look the same. I Have search through the ultimate Guides I have and I have not seen an way to set any type of gray scale or cross hatch for when the images are being printed to a black and white printer. Is there an easy way to do this? Eric Lommatsch