HBK32

springilu Wrote: I would look at your report like it will always contain even number of pages the 2nd page will be address and all the other even numbered pages will be blank. The odd numbered pages will be the regular report contents. Once again thanks. How can I handle printing of this ? only 1st page should print duplex means two sided/flipside. Other pages should print normally means not duplex or two sided. As I mentioned earlier "Question is how can I handle printing of the first page i.e. two sided(flipside/duplex) from application or setting in report template ? As user will print is with default printer settings. How can I handle from application or report template setting ? e.g. report will have 4 pages. Now 1st page should print two side(duplex) conetent on front & address on the back of 1st page & other pages i.e. 2,3 & 4 should be single sided." Will appreciate your earliest response. Regards.

springilu Wrote: I would insert a subreport for address into the details section conditionally. The condition would be insert sub report when the page number is 2. Thanks a lot for the response. My requirement is such that only 1st page should be two sided i.e. content on the front & address on the back of 1st page. I can achieve that as per your suggestion. But other pages should come one sided only as normally. Question is how can I handle printing of the first page i.e. two sided(flipside) from application or setting in report template ? As user will print is with default printer settings. How can I handle from application or report template setting ? e.g. report will have 4 pages. Now 1st page should print two side(duplex) conetent on front & address on the back of 1st page & other pages i.e. 2,3 & 4 should be single sided. Will greatly appreciate your earliest response. Regards.

Hello, I have a requirement where I have to develop report which will have multiple pages. Now in that I need to print address on the back side(flipside) of the first page only not all pages. Means 1st page should have report content on the front side & address on the back side of the first page. How can I achieve this ? I am using iReport & jasper reports 1.3.0 version. I will really appreciate your earliest help/response on this. Regards.

swood Wrote: You can create a set of parameters that do this. <parameter name="parameter1" class="java.lang.String"/> <parameter name="parameter2" class="java.lang.String"/> <parameter name="queryExpression" class="java.lang.String"> <defaultExpression>if both parameters entered, generate "columnName between ${parameter1} and ${parameter2} else generate "1=1" </defaultExpression> </parameter> <queryString> ... where $P!{queryExpression} </queryString> Sherman Jaspersoft Hello Sherman, Thanks a lot for the response. Please correct me if understand wrong here. Let me know following right or wrong. If its wrong can you plz correct it ? <parameter name="param1" class="java.lang.String"/> <parameter name="param2" class="java.lang.String"/> <parameter name="queryExpression" class="java.lang.String"> // following defaultExpression is for the parameter queryExpression <defaultExpression> ($P{param1} != null && $P{param}!=null) ? "Column_Name BETWEEN $P{param1} AND {param2}" : " 1 = 1 " </defaultExpression> What is the meaning of generate(i.e. generate "1=1") in your code ? I will greatly appreciate your response. Thanks.

Hello, Can anyone tell me how to use BETWEEN clause in where clause of JasperServer report? e.g. there are two input(textbox) control to enter value which is NOT manadatory means its optional.Suppose user enter 10 in one textbox & 500 in second textbox then it should come as COLUMN_NAME BETWEEN 10 AND 500. If user don't enter anything then it should replace BETWEEN clause with 1=1 I will greatly appreciate your response. Thanks.

lshannon wrote: Using subreports is a good way to query more than one datasource since the datasource expression for the subreport can be a JDBC Connection (which can be passed in as a parameter to the main report at fill time) or a JRDataSource object (which can be created in a separate java class). Hello, Thanks a lot for the response. In my case, master report query is against SQL server DB & subreport query is against Oracle DB. So in that case I need to open two DB connections in JSP. SQL server DB connection will go to master report at fill time & Oracle DB connection for subreport need to pass as a parameter to master report at fill time. I have defined one parameter with type of java.sql.Connection in master report for the oracle DB connection for subreport. this very same parameter is set as Data Source Expression in the subreport element of master report. Master report & sub report will have their own queries & there will be a common field with same data type & value from master report which will connect query in the subreport. e.g subreport query will be select * from test where dept_id = $P{MasterReportDept_ID} Please find attached JSP & JRxml files for the same & let me know where I am doing wrong in it. I will really appreciate your response. Please reply me ASAP. Its really urgent. Thanks. [file name=Test-f1b9402295be099b552ffbb9f739ad2a.zip size=3533]

szaboaz wrote: In index.jsp lines 35-43 and lines 52-57 are for the usage of datasources in relation of a subreport. I used datasources for both the master (masterreport_ds.jrxml) and the subreport (subreport_ds.jrxml). Subreport's datasource is put into the parameters of the master report, and this very same parameter is set as Data Source Expression in the subreport element of masterreport_ds.jrxml. Lines 59-64 (now commented out) demonstrates the usage of subreports without datasources (using only the Connection object). This time, masterreport_sql.jrxml and subreport_sql.jrxml contain their own sql query string. If you watch the two result pdfs carefully, you can notice one important thing about datasources: result_with_connection.pdf contains three records from master report, and every record has its own subreport section containing several records from the subreport. However, result_with_datasources.pdf contains the three records from the master report also, but only the first record has its own subreport section, the second and third one doesn't. This is because the subreport datasource is consumed first time. If you want to give a datasource to a subreport, you have to be careful, to assure that your subreport will appear only once. Best regards, Arpad [file name=subreport_with_datasource.zip size=16476] Post edited by: szaboaz, at: 2008/07/16 09:30 Post edited by: szaboaz, at: 2008/07/16 09:32 Hello, Thanks a lot for the response. In my case, master report query is against SQL server DB & subreport query is against Oracle DB. So in that case I need to open two DB connections in JSP. SQL server DB connection will go to master report at fill time & Oracle DB connection for subreport need to pass as a parameter to master report at fill time. I have defined one parameter with type of java.sql.Connection in master report for the oracle DB connection for subreport. this very same parameter is set as Data Source Expression in the subreport element of master report. Master report & sub report will have their own queries & there will be a common field with same data type & value from master report which will connect query in the subreport. e.g subreport query will be select * from test where dept_id = $P{MasterReportDept_ID} Please find attached JSP & JRxml files for the same & let me know where I am doing wrong in it. I will really appreciate your response. Please reply me ASAP. Its really urgent. Thanks. [file name=Test-3819e8ab74998b012570d0135bdcbb72.zip size=3533]

szaboaz wrote: Yeah, subreports are your friends, just like lshannon suggested in the other thread. Arpad Hello, Thanks a lot for your response. If possible can you please give an example for passing datasource connection as a parameter to main report?If possible do attach sample jrxml file for the same. I will really appreciate your response. Please reply me ASAP. Its really urgent. Thanks.

lshannon wrote: Using subreports is a good way to query more than one datasource since the datasource expression for the subreport can be a JDBC Connection (which can be passed in as a parameter to the main report at fill time) or a JRDataSource object (which can be created in a separate java class). Hello, Thanks a lot for your response. If possible can you please give an example for passing datasource connection as a parameter to main report?If possible do attach sample jrxml file for the same. I will really appreciate your response. Please reply me ASAP. Its really urgent. Thanks.

szaboaz wrote: This worked for me: Code: <%@ page contentType="text/plain;charset=UTF-8" language="java" errorPage="" %> <%@ page import="java.io.IOException"%> <%@ page import="java.io.InputStream"%> <%@ page import="java.io.PrintWriter"%> <%@ page import="java.io.StringWriter"%> <%@ page import="java.util.HashMap"%> <%@ page import="java.util.Map"%> <%@ page import="javax.servlet.ServletException"%> <%@ page import="javax.servlet.ServletOutputStream"%> <%@ page import="javax.servlet.http.HttpServlet"%> <%@ page import="javax.servlet.http.HttpServletRequest"%> <%@ page import="javax.servlet.http.HttpServletResponse"%> <%@ page import="net.sf.jasperreports.engine.JRExporterParameter"%> <%@ page import="net.sf.jasperreports.engine.JasperFillManager"%> <%@ page import="net.sf.jasperreports.engine.JasperPrint"%> <%@ page import="net.sf.jasperreports.engine.export.JRTextExporter"%> <%@ page import="net.sf.jasperreports.engine.export.JRTextExporterParameter"%> <% try { response.setContentType("text/plain"«»); response.setHeader("Content-Disposition", "inline; filename=xyz.txt"«»); ServletOutputStream servletOutputStream = response.getOutputStream(); InputStream reportStream = getServletConfig().getServletContext().getResourceAsStream("/reports/example.jasper"«»); Map parameters = new HashMap(); JasperPrint jasperPrint = JasperFillManager.fillReport(reportStream, parameters); JRTextExporter exporter = new JRTextExporter(); exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); exporter.setParameter(JRTextExporterParameter.OUTPUT_STREAM, servletOutputStream); exporter.setParameter(JRTextExporterParameter.CHARACTER_WIDTH, new Integer(10)); exporter.setParameter(JRTextExporterParameter.CHARACTER_HEIGHT, new Integer(10)); exporter.exportReport(); servletOutputStream.flush(); servletOutputStream.close(); } catch (Exception e) { // display stack trace in the browser StringWriter stringWriter = new StringWriter(); PrintWriter printWriter = new PrintWriter(stringWriter); e.printStackTrace(printWriter); response.setContentType("text/plain"«»); response.getOutputStream().print(stringWriter.toString()); } %> Best regards, Arpad Hi, I come across requiremt in which I need to connect to the multiple data sources in one report. Can you give me example/code on how to pass/connect to multiple datasources in one report? I will really appreciate the response. Please reply me ASAP. It really urgent. Thanks.

Hi All, I come across requiremt in which I need to connect to the multiple data sources in one report. Can some one give me example/code on how to pass/connect to multiple datasources in one report? I will really appreciate the response. Please reply me ASAP. It really urgent. Thanks.

Hi Everyone, How to pull data from web service using jasper reports? As I need to generate report by pulling data from web service. If possible give me some example or steps to do it. I will really appreciate response. Plz help me its very urgent. Thanks. Post edited by: HBK32, at: 2008/07/10 18:24

d Post edited by: HBK32, at: 2008/07/10 13:52

szaboaz wrote: Your server basically gives two kinds of things to your browser: the headers, and the data. You always have to set the headers first, and after that, you can put your data to the output stream. You indeed call response.setContentType("application/vnd.ms-excel"); before you send the data, BUT look what happens: your JSP contains lines like <HTML><BODY>. Your server actually starts to give these (as data) to the browser, so any call of setContentType inside the code block is too late. Since you won't put html tags to the output in this situation, you can use a servlet for this as well. But I was interested, if a jsp has anything wrong to it, so I created a short example, as a servlet first, then I put the code into a jsp. I put both of them here. They are working for me, I hope you will find them useful. Best regards, Arpad First, the servlet: Code: /* * To change this template, choose Tools | Templates * and open the template in the editor. */ package com.example; import java.io.IOException; import java.io.InputStream; import java.io.PrintWriter; import java.io.StringWriter; import java.util.HashMap; import java.util.Map; import javax.servlet.ServletException; import javax.servlet.ServletOutputStream; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import net.sf.jasperreports.engine.JRExporterParameter; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.JasperPrint; import net.sf.jasperreports.engine.export.JRXlsExporter; import net.sf.jasperreports.engine.export.JRXlsExporterParameter; /** * * @author szaboaz */ public class BrowseExcelServlet extends HttpServlet { /** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods. * @param request servlet request * @param response servlet response */ protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { try { response.setContentType("application/vnd.ms-excel"«»); response.setHeader("Content-Disposition", "inline; filename=xyz.xls"«»); ServletOutputStream servletOutputStream = response.getOutputStream(); InputStream reportStream = getServletConfig().getServletContext().getResourceAsStream("/reports/example.jasper"«»); Map parameters = new HashMap(); JasperPrint jasperPrint = JasperFillManager.fillReport(reportStream, parameters); JRXlsExporter exporter = new JRXlsExporter(); exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); exporter.setParameter(JRXlsExporterParameter.OUTPUT_STREAM, servletOutputStream); exporter.exportReport(); servletOutputStream.flush(); servletOutputStream.close(); } catch (Exception e) { // display stack trace in the browser StringWriter stringWriter = new StringWriter(); PrintWriter printWriter = new PrintWriter(stringWriter); e.printStackTrace(printWriter); response.setContentType("text/plain"«»); response.getOutputStream().print(stringWriter.toString()); } } // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code."> /** * Handles the HTTP <code>GET</code> method. * @param request servlet request * @param response servlet response */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { processRequest(request, response); } /** * Handles the HTTP <code>POST</code> method. * @param request servlet request * @param response servlet response */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { processRequest(request, response); } /** * Returns a short description of the servlet. */ public String getServletInfo() { return "Short description"; }// </editor-fold> } And the jsp: Code:[code] <%@ page contentType="application/vnd.ms-excel;charset=UTF-8" language="java" import="java.sql.*" errorPage="" %> <%@ page import="java.io.IOException"%> <%@ page import="java.io.InputStream"%> <%@ page import="java.io.PrintWriter"%> <%@ page import="java.io.StringWriter"%> <%@ page import="java.util.HashMap"%> <%@ page import="java.util.Map"%> <%@ page import="javax.servlet.ServletException"%> <%@ page import="javax.servlet.ServletOutputStream"%> <%@ page import="javax.servlet.http.HttpServlet"%> <%@ page import="javax.servlet.http.HttpServletRequest"%> <%@ page import="javax.servlet.http.HttpServletResponse"%> <%@ page import="net.sf.jasperreports.engine.JRExporterParameter"%> <%@ page import="net.sf.jasperreports.engine.JasperFillManager"%> <%@ page import="net.sf.jasperreports.engine.JasperPrint"%> <%@ page import="net.sf.jasperreports.engine.export.JRXlsExporter"%> <%@ page import="net.sf.jasperreports.engine.export.JRXlsExporterParameter"%> <% try { response.setContentType("application/vnd.ms-excel"«»); response.setHeader("Content-Disposition", "inline; filename=xyz.xls"«»); ServletOutputStream servletOutputStream = response.getOutputStream(); InputStream reportStream = getServletConfig().getServletContext().getResourceAsStream("/reports/example.jasper"«»); Map parameters = new HashMap(); JasperPrint jasperPrint = JasperFillManager.fillReport(reportStream, parameters); JRXlsExporter exporter = new JRXlsExporter(); exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); exporter.setParameter(JRXlsExporterParameter.OUTPUT_STREAM, servletOutputStream); exporter.exportReport(); servletOutputStream.flush(); servletOutputStream.close(); } catch (Exception e) { // display stack trace in the browser StringWriter stringWriter = new StringWriter(); PrintWriter printWriter = new PrintWriter(stringWriter); e.printStackTrace(printWriter); response.setContentType("text/plain"«»); response.getOutputStream().print(stringWriter.toString()); } %> Post edited by: szaboaz, at: 2008/07/08 19:38<br><br>Post edited by: szaboaz, at: 2008/07/08 19:41 Hello, Thanks a bunch for your reply. Your JSP code works for me for xls & pdf. Simillarly I want to open txt file in browser, in that case what code change is required in jsp(jsp code which you have provided)?? I have changed code as following & its opening in browser but could't maintain the report format. Code:[code] <%@ page contentType="text/plain;charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %> <jsp:useBean id="db" class="ConnDB.DB" scope="request" > <jsp:«»setProperty name="db" property="*" /> </jsp:useBean> <%@ page import="ConnDB.*"%> <%@ page import="java.io.IOException"%> <%@ page import="java.io.InputStream"%> <%@ page import="java.io.PrintWriter"%> <%@ page import="java.io.StringWriter"%> <%@ page import="java.util.HashMap"%> <%@ page import="java.util.Map"%> <%@ page import="javax.servlet.ServletException"%> <%@ page import="javax.servlet.ServletOutputStream"%> <%@ page import="javax.servlet.http.HttpServlet"%> <%@ page import="javax.servlet.http.HttpServletRequest"%> <%@ page import="javax.servlet.http.HttpServletResponse"%> <%@ page import="java.util.*" %> <%@ page import="java.io.*" %> <%@ page import="java.sql.Connection"%> <%@ page import="net.sf.jasperreports.engine.*" %> <%@ page import="net.sf.jasperreports.engine.util.*" %> <%@ page import="net.sf.jasperreports.engine.export.*" %> <%@ page import="net.sf.jasperreports.engine.JRExporterParameter"%> <%@ page import="net.sf.jasperreports.engine.JasperFillManager"%> <%@ page import="net.sf.jasperreports.engine.JasperPrint"%> <%@ page import="net.sf.jasperreports.engine.export.JRXlsExporter"%> <%@ page import="net.sf.jasperreports.engine.export.JRXlsExporterParameter"%> <% try { String BuildID = (String)session.getAttribute("BuildingID"«»); Map parameters = new HashMap(); parameters.put("InputValue1",BuildID); response.setContentType("text/html"«»); Connection conn=(new DB()).connect("Weblogic","svrabm"«»); ServletOutputStream servletOutputStream = response.getOutputStream(); InputStream reportStream = getServletConfig().getServletContext().getResourceAsStream("/InfactAdhoc.jasper"«»); JasperPrint jasperPrint = JasperFillManager.fillReport(reportStream, parameters, conn); response.setHeader("Content-Disposition", "inline; filename="+jasperPrint.getName().toString()+".txt"«»); //File destFile = new File(reportFile.getParent()+"/TXT", jasperPrint.getName() + ".txt"«»); JRTextExporter exporter = new JRTextExporter(); exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); exporter.setParameter(JRTextExporterParameter.OUTPUT_STREAM, servletOutputStream); exporter.setParameter(JRTextExporterParameter.PAGE_WIDTH, new Integer(150)); exporter.setParameter(JRTextExporterParameter.PAGE_HEIGHT, new Integer(100)); exporter.exportReport(); servletOutputStream.flush(); servletOutputStream.close(); } catch (Exception e) { // display stack trace in the browser StringWriter stringWriter = new StringWriter(); PrintWriter printWriter = new PrintWriter(stringWriter); e.printStackTrace(printWriter); response.setContentType("text/plain"«»); response.getOutputStream().print(stringWriter.toString()); } %> I will really appreciate your response. Thanks.

lshannon wrote: I just took a very fast look at your code. It looks like you are creating the FileOutputStream before you actually export the report. Try moving that line down to after you call exporter.exportReport()? Hope that helps. Hello, Thanks a bunch for yr quick reply.I appreciate it. As per yr suggestion I did(moved FileOutputStream line after exporter.exportReport) it but still it didn't open. If possible for you than can you plz look at my code again tell me what should I do? I will really appreciate yr response. Thanks.

Hi Everyone, I am trying to open Excel file in browser. I am getting dialogbox(with Open, Save & Cancel options) but when click on open it opens black excel file. Excel file generated on disk. I am using Tomact 4.1, Eclipse 3.2, JSP & Oracle. Following is the code(JSP file) I am using to create & open excel file. Code: <%@ page contentType="application/vnd.ms-excel;charset=UTF-8" language="java" import="java.sql.*" errorPage="" %> <jsp:useBean id="db" class="ConnDB.DB" scope="request" > <jsp:«»setProperty name="db" property="*" /> </jsp:useBean> <html> <head> <title>Export</title> <meta http-equiv="Content-Type" content="application/vnd.ms-excel; charset=UTF-8"> </head> <body bgcolor="#F5F7F0"> <%@ page import="ConnDB.*"%> <%@ page import="java.awt.*"%> <%@ page import="java.sql.Connection"%> <%@ page import="net.sf.jasperreports.engine.*" %> <%@ page import="net.sf.jasperreports.engine.util.*" %> <%@ page import="net.sf.jasperreports.engine.export.*" %> <%@ page import="com.lowagie.text.pdf.PdfWriter" %> <%@ page import="java.util.*" %> <%@ page import="java.io.*" %> <%@ page import="java.io.OutputStream" %> <%@ page import="java.io.ByteArrayOutputStream" %> <% String BuildID = (String)session.getAttribute("BuildingID"«»); Map parameters = new HashMap(); parameters.put("InputValue1",BuildID); File reportFile = new File(application.getRealPath("/WEB-INF/Jasper/InfactAdhoc.jasper"«»)); JasperReport jasperReport = (JasperReport)JRLoader.loadObject(reportFile.getPath()); //Get Connection object Connection conn=(new DB()).connect("Weblogic","svrabm"«»); //Filling Report JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport,parameters,conn); // Create Destination File File destFile = new File(reportFile.getParent()+"/Excel_Output", jasperPrint.getName() + ".xls"«»); String Destination = destFile.toString(); //System.out.println("Destination :"+Destination); //code For EXCEL View.... JRXlsExporter exporter = new JRXlsExporter(); ByteArrayOutputStream output = new ByteArrayOutputStream(); OutputStream outputXLS = new FileOutputStream(application.getRealPath("/WEB-INF/Jasper/Excel_Output/InfactAdhoc.xls"«»)); exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); //exporter.setParameter(JRXlsExporterParameter.OUTPUT_STREAM, outputXLS); exporter.setParameter(JRXlsExporterParameter.OUTPUT_FILE, destFile); exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.TRUE); exporter.setParameter(JRXlsExporterParameter.IS_AUTO_DETECT_CELL_TYPE , Boolean.TRUE); exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE); exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE); //exporter.setParameter(JRExporterParameter.OUTPUT_FILE, destFile); //exporter.setParameter(JRExporterParameter.OUTPUT_WRITER, response.getWriter()); exporter.exportReport(); response.setContentType("application/vnd.ms-excel"«»); //response.setHeader("Content-disposition","inline; filename="+jasperPrint.getName().toString()+".xls"«»); outputXLS.write(output.toByteArray()); outputXLS.flush(); outputXLS.close(); %> </body> </html> Please tell me what I am doing wrong here.As I mention file is generated on disk at specified location. Plz reply me ASAP.Its Urgent I will really appreciate response. Thanks.

jmurray wrote: Class is missing or cannot be found in your classpath. Check that your classpath is complete for all the libraries you wish to use. Hello, Thanks a lot for your reply. I really appreciate it. the problem which I described with error(java.lang.NoClassDefFoundError: java/lang/Enum) in my previous post is it because I am using JDK 1.4? I am using Following components for installation. 1. j2sdk1.4.2_05 2. Tomcat 5.5 3. MySQL 5.0 4. JasperServer 2.1 Which version of jasperserver is compitable with j2sdk1.4.2_05? As you already installed JS 2.1 with oracle than can you please tell me from where can I download WAR file of JasperServer for Websphere & Oracle installation? I am going to use WebSphere 6.0. Can you plz help me for this? I will really appreciate your response. Plz reply me ASAP. Thanks in advance.

lucianc wrote: What Tomcat version do you use? Regards, Lucian Hell0, I have installed jasperserver 2.1 on tomcat 5.5 using WAR file. I am using following component. 1. j2sdk1.4.2_05 2. Tomcat 5.5 3. MySQL 5.0 4. JasperServer 2.1 I have changed context.xml(C:jakarta-tomcat-5.5.0webappsjasperserverMETA-INF) Also changed jasperserver.xml(same as context.xml) Also made required changes in hibernate.properties(as per installation guide) When I am starting tomact using startup.bat at that time getting following error.(jasperserver.log) Following is the error description. Code: 20:49:26,191 ERROR ContextLoader,main:205 - Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'olapConnectionService' defined in ServletContext resource [/WEB-INF/applicationContext-olap-connection.xml]: Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: java/lang/Enum Caused by: java.lang.NoClassDefFoundError: java/lang/Enum at java.lang.Class.getDeclaredConstructors0(Native Method) at java.lang.Class.privateGetDeclaredConstructors(Class.java:1618) at java.lang.Class.getConstructor0(Class.java:1930) at java.lang.Class.getDeclaredConstructor(Class.java:1301) at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:60) at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:45) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:701) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:687) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:388) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:273) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3618) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4095) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:755) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:586) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1063) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1011) at org.apache.catalina.core.StandardHost.start(StandardHost.java:718) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1003) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:420) at org.apache.catalina.core.StandardService.start(StandardService.java:450) at org.apache.catalina.core.StandardServer.start(StandardServer.java:1967) at org.apache.catalina.startup.Catalina.start(Catalina.java:545) 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:324) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409) 20:49:26,201 ERROR [/jasperserver],main:662 - Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'olapConnectionService' defined in ServletContext resource [/WEB-INF/applicationContext-olap-connection.xml]: Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: java/lang/Enum Caused by: java.lang.NoClassDefFoundError: java/lang/Enum at java.lang.Class.getDeclaredConstructors0(Native Method) at java.lang.Class.privateGetDeclaredConstructors(Class.java:1618) at java.lang.Class.getConstructor0(Class.java:1930) at java.lang.Class.getDeclaredConstructor(Class.java:1301) at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:60) at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:45) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:701) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:687) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:388) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:273) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3618) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4095) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:755) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:586) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1063) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1011) at org.apache.catalina.core.StandardHost.start(StandardHost.java:718) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1003) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:420) at org.apache.catalina.core.StandardService.start(StandardService.java:450) at org.apache.catalina.core.StandardServer.start(StandardServer.java:1967) at org.apache.catalina.startup.Catalina.start(Catalina.java:545) 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:324) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409) 20:49:26,231 ERROR [/jasperserver],main:662 - Exception sending context initialized event to listener instance of class com.jaspersoft.jasperserver.war.util.SpringBeanServletContextPlublisher org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'olapConnectionService' defined in ServletContext resource [/WEB-INF/applicationContext-olap-connection.xml]: Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: java/lang/Enum Caused by: java.lang.NoClassDefFoundError: java/lang/Enum at java.lang.Class.getDeclaredConstructors0(Native Method) at java.lang.Class.privateGetDeclaredConstructors(Class.java:1618) at java.lang.Class.getConstructor0(Class.java:1930) at java.lang.Class.getDeclaredConstructor(Class.java:1301) at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:60) at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:45) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:701) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:687) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:388) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:273) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3618) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4095) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:755) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:586) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1063) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1011) at org.apache.catalina.core.StandardHost.start(StandardHost.java:718) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1003) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:420) at org.apache.catalina.core.StandardService.start(StandardService.java:450) at org.apache.catalina.core.StandardServer.start(StandardServer.java:1967) at org.apache.catalina.startup.Catalina.start(Catalina.java:545) 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:324) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409) Can you plz help me with this? I will really appreciate yr response. Plz reply me ASAP. Thanks in advance.

jmurray wrote: I'm stuck trying to get JasperServer to work on Linux using Oracle for the data source. Here's what I've done so far: Installed JS2.01 on the server and unpacked the WAR file, then renamed the WAR file so it doesn't get unpacked again. Made sure that ojdbc14.jar was in the lib directory. Modified META-INF/context.xml so that the resources point at Oracle instead of MySQL. The resource definitions were changed to Tomcat 5.0 format (refer to http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&id=16735&catid=10). Modified hibernate.properties to use Oracle9Dialect instead of MySQLInnoDBDialect Made sure that context.xml is copied to jasperserver.xml. Created database schema, created tables, and added some base user data/roles/etc. Jasperserver starts without error (finally!!) and I can get the login page up, but now I can't login. Fails with Oracle "Table or view does not exist" error, as if it's pointing in the wrong place. Unfortunately the error logging is pathetically ameteurish and doesn't specify the name of the offending table or view. Any ideas on what the problem might be? .<br><br>Post edited by: jmurray, at: 2007/10/09 05:27 Hell0, I have installed jasperserver 2.1 on tomcat 5.5 using WAR file. I am using following component. 1. j2sdk1.4.2_05 2. Tomcat 5.5 3. MySQL 5.0 4. JasperServer 2.1 I have changed context.xml(C:jakarta-tomcat-5.5.0webappsjasperserverMETA-INF) Also changed jasperserver.xml(same as context.xml) Also made required changes in hibernate.properties(as per installation guide) When I am starting tomact using startup.bat at that time getting following error.(jasperserver.log) Following is the error description. Code: 20:49:26,191 ERROR ContextLoader,main:205 - Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'olapConnectionService' defined in ServletContext resource [/WEB-INF/applicationContext-olap-connection.xml]: Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: java/lang/Enum Caused by: java.lang.NoClassDefFoundError: java/lang/Enum at java.lang.Class.getDeclaredConstructors0(Native Method) at java.lang.Class.privateGetDeclaredConstructors(Class.java:1618) at java.lang.Class.getConstructor0(Class.java:1930) at java.lang.Class.getDeclaredConstructor(Class.java:1301) at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:60) at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:45) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:701) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:687) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:388) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:273) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3618) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4095) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:755) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:586) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1063) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1011) at org.apache.catalina.core.StandardHost.start(StandardHost.java:718) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1003) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:420) at org.apache.catalina.core.StandardService.start(StandardService.java:450) at org.apache.catalina.core.StandardServer.start(StandardServer.java:1967) at org.apache.catalina.startup.Catalina.start(Catalina.java:545) 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:324) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409) 20:49:26,201 ERROR [/jasperserver],main:662 - Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'olapConnectionService' defined in ServletContext resource [/WEB-INF/applicationContext-olap-connection.xml]: Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: java/lang/Enum Caused by: java.lang.NoClassDefFoundError: java/lang/Enum at java.lang.Class.getDeclaredConstructors0(Native Method) at java.lang.Class.privateGetDeclaredConstructors(Class.java:1618) at java.lang.Class.getConstructor0(Class.java:1930) at java.lang.Class.getDeclaredConstructor(Class.java:1301) at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:60) at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:45) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:701) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:687) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:388) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:273) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3618) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4095) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:755) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:586) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1063) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1011) at org.apache.catalina.core.StandardHost.start(StandardHost.java:718) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1003) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:420) at org.apache.catalina.core.StandardService.start(StandardService.java:450) at org.apache.catalina.core.StandardServer.start(StandardServer.java:1967) at org.apache.catalina.startup.Catalina.start(Catalina.java:545) 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:324) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409) 20:49:26,231 ERROR [/jasperserver],main:662 - Exception sending context initialized event to listener instance of class com.jaspersoft.jasperserver.war.util.SpringBeanServletContextPlublisher org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'olapConnectionService' defined in ServletContext resource [/WEB-INF/applicationContext-olap-connection.xml]: Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: java/lang/Enum Caused by: java.lang.NoClassDefFoundError: java/lang/Enum at java.lang.Class.getDeclaredConstructors0(Native Method) at java.lang.Class.privateGetDeclaredConstructors(Class.java:1618) at java.lang.Class.getConstructor0(Class.java:1930) at java.lang.Class.getDeclaredConstructor(Class.java:1301) at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:60) at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:45) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:701) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:687) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:388) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:273) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3618) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4095) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:755) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:586) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1063) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1011) at org.apache.catalina.core.StandardHost.start(StandardHost.java:718) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1003) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:420) at org.apache.catalina.core.StandardService.start(StandardService.java:450) at org.apache.catalina.core.StandardServer.start(StandardServer.java:1967) at org.apache.catalina.startup.Catalina.start(Catalina.java:545) 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:324) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409) Can you plz help me with this? I will really appreciate yr response. Plz reply me ASAP. Thanks in advance.

Hi Everyone, I have installed jasperserver 2.1 on tomcat 5.5 using WAR file. I am using following component. 1. j2sdk1.4.2_05 2. Tomcat 5.5 3. MySQL 5.0 4. JasperServer 2.1 I have changed context.xml(C:jakarta-tomcat-5.5.0webappsjasperserverMETA-INF) Also changed jasperserver.xml(same as context.xml) Also made required changes in hibernate.properties(as per installation guide) When I am starting tomact using startup.bat at that time getting following error.(jasperserver.log) Following is the error description. Code: 20:49:26,191 ERROR ContextLoader,main:205 - Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'olapConnectionService' defined in ServletContext resource [/WEB-INF/applicationContext-olap-connection.xml]: Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: java/lang/Enum Caused by: java.lang.NoClassDefFoundError: java/lang/Enum at java.lang.Class.getDeclaredConstructors0(Native Method) at java.lang.Class.privateGetDeclaredConstructors(Class.java:1618) at java.lang.Class.getConstructor0(Class.java:1930) at java.lang.Class.getDeclaredConstructor(Class.java:1301) at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:60) at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:45) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:701) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:687) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:388) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:273) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3618) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4095) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:755) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:586) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1063) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1011) at org.apache.catalina.core.StandardHost.start(StandardHost.java:718) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1003) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:420) at org.apache.catalina.core.StandardService.start(StandardService.java:450) at org.apache.catalina.core.StandardServer.start(StandardServer.java:1967) at org.apache.catalina.startup.Catalina.start(Catalina.java:545) 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:324) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409) 20:49:26,201 ERROR [/jasperserver],main:662 - Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'olapConnectionService' defined in ServletContext resource [/WEB-INF/applicationContext-olap-connection.xml]: Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: java/lang/Enum Caused by: java.lang.NoClassDefFoundError: java/lang/Enum at java.lang.Class.getDeclaredConstructors0(Native Method) at java.lang.Class.privateGetDeclaredConstructors(Class.java:1618) at java.lang.Class.getConstructor0(Class.java:1930) at java.lang.Class.getDeclaredConstructor(Class.java:1301) at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:60) at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:45) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:701) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:687) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:388) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:273) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3618) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4095) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:755) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:586) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1063) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1011) at org.apache.catalina.core.StandardHost.start(StandardHost.java:718) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1003) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:420) at org.apache.catalina.core.StandardService.start(StandardService.java:450) at org.apache.catalina.core.StandardServer.start(StandardServer.java:1967) at org.apache.catalina.startup.Catalina.start(Catalina.java:545) 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:324) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409) 20:49:26,231 ERROR [/jasperserver],main:662 - Exception sending context initialized event to listener instance of class com.jaspersoft.jasperserver.war.util.SpringBeanServletContextPlublisher org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'olapConnectionService' defined in ServletContext resource [/WEB-INF/applicationContext-olap-connection.xml]: Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: java/lang/Enum Caused by: java.lang.NoClassDefFoundError: java/lang/Enum at java.lang.Class.getDeclaredConstructors0(Native Method) at java.lang.Class.privateGetDeclaredConstructors(Class.java:1618) at java.lang.Class.getConstructor0(Class.java:1930) at java.lang.Class.getDeclaredConstructor(Class.java:1301) at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:60) at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:45) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:701) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:687) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:388) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:273) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3618) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4095) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:755) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:586) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1063) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1011) at org.apache.catalina.core.StandardHost.start(StandardHost.java:718) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1003) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:420) at org.apache.catalina.core.StandardService.start(StandardService.java:450) at org.apache.catalina.core.StandardServer.start(StandardServer.java:1967) at org.apache.catalina.startup.Catalina.start(Catalina.java:545) 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:324) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409) Can anyone help me with this? I will really appreciate response. Plz reply me ASAP. Thanks in advance.

Hi Everyone, First of all from where Can I download WAR file for JasperServer-pro edition? I check the website http://www.jaspersoft.com/downloads.html but there is no download available for JasperServer-pro.WAR file? I am using following for jasperserver setup. j2sdk1.4.2_05 MySQL 5.0 JasperServer 2.1(War File) When I am starting tomcat at that time I am getting following error. Code: 11:06:18,988 WARN JDBCExceptionReporter,main:77 - SQL Error: 0, SQLState: null 11:06:18,998 ERROR JDBCExceptionReporter,main:78 - Cannot load JDBC driver class 'null' 11:06:18,998 WARN SettingsFactory,main:109 - Could not obtain connection metadata java.sql.SQLException: Cannot load JDBC driver class 'null' at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:529) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:312) at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceCo nnectionProvider.java:81) at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:76) at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2006) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1289) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean .java:804) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBe an.java:744) at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFact oryBean.java:131) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(Abstr actAutowireCapableBeanFactory.java:1118) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(Abstract AutowireCapableBeanFactory.java:1085) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAuto wireCapableBeanFactory.java:429) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java: 250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingleton BeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(Defaul tListableBeanFactory.java:270) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.ja va:346) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRef reshableWebApplicationContext.java:156) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java: 49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3411) at org.apache.catalina.core.StandardContext.start(StandardContext.java:3749) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:821) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632) at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:259) at org.apache.catalina.core.StandardHost.install(StandardHost.java:825) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:623) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:463) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:930) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:420) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:166) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1196) at org.apache.catalina.core.StandardHost.start(StandardHost.java:791) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:347) at org.apache.catalina.core.StandardService.start(StandardService.java:497) at org.apache.catalina.core.StandardServer.start(StandardServer.java:2290) at org.apache.catalina.startup.Catalina.start(Catalina.java:516) at org.apache.catalina.startup.Catalina.execute(Catalina.java:402) at org.apache.catalina.startup.Catalina.process(Catalina.java:180) 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:324) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:202) 11:06:21,131 ERROR ContextLoader,main:205 - Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'olapConnectionService' defined in ServletContext resource [/WEB-INF/applicationContext-olap-connection.xml]: Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: java/lang/Enum Caused by: java.lang.NoClassDefFoundError: java/lang/Enum at java.lang.Class.getDeclaredConstructors0(Native Method) at java.lang.Class.privateGetDeclaredConstructors(Class.java:1618) at java.lang.Class.getConstructor0(Class.java:1930) at java.lang.Class.getDeclaredConstructor(Class.java:1301) at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:60) at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiatio nStrategy.java:45) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(Abstrac tAutowireCapableBeanFactory.java:701) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(Abst ractAutowireCapableBeanFactory.java:687) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAuto wireCapableBeanFactory.java:388) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java: 250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingleton BeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(Defaul tListableBeanFactory.java:273) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.ja va:346) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRef reshableWebApplicationContext.java:156) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java: 49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3411) at org.apache.catalina.core.StandardContext.start(StandardContext.java:3749) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:821) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632) at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:259) at org.apache.catalina.core.StandardHost.install(StandardHost.java:825) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:623) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:463) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:930) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:420) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:166) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1196) at org.apache.catalina.core.StandardHost.start(StandardHost.java:791) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:347) at org.apache.catalina.core.StandardService.start(StandardService.java:497) at org.apache.catalina.core.StandardServer.start(StandardServer.java:2290) at org.apache.catalina.startup.Catalina.start(Catalina.java:516) at org.apache.catalina.startup.Catalina.execute(Catalina.java:402) at org.apache.catalina.startup.Catalina.process(Catalina.java:180) 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:324) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:202) I did put mysql-connector-java-3.1.12-bin.jar file in C:/jakarta-tomcat-5.0.0/common/lib. Also have changed source definitions as following in context.xml as per tomcat 5.0 Syntax. Code:[code] <Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource"/> <ResourceParams name="jdbc/jasperserver"> <parameter> <name>maxActive</name> <value>100</value> </parameter> <parameter> <name>maxIdle</name> <value>30</value> </parameter> <parameter> <name>maxWait</name> <value>10000</value> </parameter> <parameter> <name>username</name> <value>jasperadmin</value> </parameter> <parameter> <name>password</name> <value>jasperadmin</value> </parameter> <parameter> <name>driverClassName</name> <value>com.mysql.jdbc.Driver</value> </parameter> <parameter> <name>url</name> <value>jdbc:mysql://localhost:3306/jasperserver?autoReconnect=true</value> </parameter> </ResourceParams> Can someone help me with this? I will really appreciate your response. Please reply ASAP. Thanks in adavnce.

swood wrote: Our professional edition has support for WebSphere and Oracle. There are no installers for these. Instead you take the WAR file and configure according to the installation guides. You can download the professional edition from http://www.jaspersoft.com/downloads.html . The Community Edition can be configured to work with WebSphere and Oracle. You would need to convert the database creation scripts to Oracle and do the WebSphere configuration. Sherman Jaspersoft Thanks a lot for your reply. I appreciate it. From where Can I download WAR file for JasperServer-pro edition? I check the website http://www.jaspersoft.com/downloads.html but there is no download available for JasperServer-pro.WAR file? I am using following for jasperserver setup. j2sdk1.4.2_05 MySQL 5.0 JasperServer 2.1(War File) I am getting following error. 11:06:18,988 WARN JDBCExceptionReporter,main:77 - SQL Error: 0, SQLState: null 11:06:18,998 ERROR JDBCExceptionReporter,main:78 - Cannot load JDBC driver class 'null' 11:06:18,998 WARN SettingsFactory,main:109 - Could not obtain connection metadata java.sql.SQLException: Cannot load JDBC driver class 'null' at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:529) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:312) at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81) at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:76) at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2006) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1289) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:804) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:744) at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:131) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1118) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1085) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:429) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:270) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3411) at org.apache.catalina.core.StandardContext.start(StandardContext.java:3749) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:821) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632) at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:259) at org.apache.catalina.core.StandardHost.install(StandardHost.java:825) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:623) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:463) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:930) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:420) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:166) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1196) at org.apache.catalina.core.StandardHost.start(StandardHost.java:791) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:347) at org.apache.catalina.core.StandardService.start(StandardService.java:497) at org.apache.catalina.core.StandardServer.start(StandardServer.java:2290) at org.apache.catalina.startup.Catalina.start(Catalina.java:516) at org.apache.catalina.startup.Catalina.execute(Catalina.java:402) at org.apache.catalina.startup.Catalina.process(Catalina.java:180) 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:324) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:202) 11:06:21,131 ERROR ContextLoader,main:205 - Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'olapConnectionService' defined in ServletContext resource [/WEB-INF/applicationContext-olap-connection.xml]: Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: java/lang/Enum Caused by: java.lang.NoClassDefFoundError: java/lang/Enum at java.lang.Class.getDeclaredConstructors0(Native Method) at java.lang.Class.privateGetDeclaredConstructors(Class.java:1618) at java.lang.Class.getConstructor0(Class.java:1930) at java.lang.Class.getDeclaredConstructor(Class.java:1301) at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:60) at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:45) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:701) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:687) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:388) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:273) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3411) at org.apache.catalina.core.StandardContext.start(StandardContext.java:3749) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:821) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632) at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:259) at org.apache.catalina.core.StandardHost.install(StandardHost.java:825) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:623) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:463) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:930) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:420) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:166) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1196) at org.apache.catalina.core.StandardHost.start(StandardHost.java:791) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:347) at org.apache.catalina.core.StandardService.start(StandardService.java:497) at org.apache.catalina.core.StandardServer.start(StandardServer.java:2290) at org.apache.catalina.startup.Catalina.start(Catalina.java:516) at org.apache.catalina.startup.Catalina.execute(Catalina.java:402) at org.apache.catalina.startup.Catalina.process(Catalina.java:180) 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:324) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:202) -------------------Error complete-------------------- I did put mysql-connector-java-3.1.12-bin.jar file in C:jakarta-tomcat-5.0.0commonlib. Also have changed source definitions as following in context.xml as per tomcat 5.0 Syntax. ---------context.xml-------------<Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource"/> <ResourceParams name="jdbc/jasperserver"> <parameter> <name>maxActive</name> <value>100</value> </parameter> <parameter> <name>maxIdle</name> <value>30</value> </parameter> <parameter> <name>maxWait</name> <value>10000</value> </parameter> <parameter> <name>username</name> <value>jasperadmin</value> </parameter> <parameter> <name>password</name> <value>jasperadmin</value> </parameter> <parameter> <name>driverClassName</name> <value>com.mysql.jdbc.Driver</value> </parameter> <parameter> <name>url</name> <value>jdbc:mysql://localhost:3306/jasperserver?autoReconnect=true</value> </parameter> </ResourceParams> ----------End context.xml------------- Can you help me with this? I will really appreciate your response. Please reply ASAP. Thanks in adavnce.

Hello, I am planning to use JasperServer 2.1 with Websphere 6 & Oracle. Can you help me by providing the procedure/configuration method to make JasperServer 2.1 working with Websphere & Oracle? What is the procedure to make JS 2.1 working with Websphere & Oracle? What is War Distribution File? From where can I get it? I have downloaded JasperServer 2.1 from Jasperforge site but its coming with Tomcat & MySQL. I have also downloaded docs for the same & read the docs but it has no configuration/installation steps for Websphere & Oracle. I will really appreciate your response. Please reply me ASAP. Its really urgent. Thanks in advance.

swood wrote: The JasperSoft team and the broader community are active on these forums to help you with news, questions and issues with JasperServer and JasperAnalysis. We will try to respond within a week, and often sooner. If you want guaranteed support, please check out our support options at http://www.jaspersoft.com/ss_subscriptionservices-details.html . JasperSoft provides individual request support on the JasperServer and JasperAnalysis open source versions and annual subscription support on our professional versions. Sherman JasperSoft Hello, I am planning to use JasperServer 2.1 with Websphere 6 & Oracle. Can you help me by providing the procedure/configuration method to make JasperServer 2.1 working with Websphere & Oracle? What is the procedure to make JS 2.1 working with Websphere & Oracle? What is War Distribution File? From where can I get it? I have downloaded JasperServer 2.1 from Jasperforge site but its coming with Tomcat & MySQL. I have also downloaded docs for the same & read the docs but it has no configuration/installation steps for Websphere & Oracle. I will really appreciate your response. Please reply me ASAP. Its really urgent. Thanks in advance.

Hello Everyone, I am planning to use JasperServer 2.1 with Websphere 6 & Oracle. Can anyone help me by providing the procedure/configuration method to make JasperServer 2.1 working with Websphere & Oracle? What is the procedure to make JS 2.1 working with Websphere & Oracle? What is War Distribution File? From where can I get it? I have downloaded JasperServer 2.1 from Jasperforge site but its coming with Tomcat & MySQL. I have also downloaded docs for the same & read the docs but it has no configuration/installation steps for Websphere & Oracle. I will really appreciate your response. Please reply me ASAP. Its really urgent. Thanks in advance.