Databases
StackOverflow2013
Postsdbo
PONoClassDefFound Exception
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PONoClassDefFound Exception
    primarykey
    data
    text
    <p>I am using apache poi to open an existing excel file.</p> <pre><code>public static int generateReport(Calendar csdate,Calendar cedate) throws Exception { FileInputStream fileIn =null; FileOutputStream fileOut = null; int sum=0;//For calculating the total number of tickets final Workbook wb; fileIn =new FileInputStream("d:\\excelfiles\\TicketsReport.xlsm"); wb = org.apache.poi.ss.usermodel.WorkbookFactory.create(fileIn);&lt;-- Exception final Sheet sheet = wb.getSheet("Report"); //rest of stuff } </code></pre> <p>I have a servlet which takes the dates from an html page and call <code>generateReport()</code>. The problem is this program was running previously with same <code>tomcat 6</code> version and <code>servlet2.4</code> version.In eclipse there is no compile time error at the <code>WorkbookFactory.create()</code> line. Here's the stack trace.</p> <pre><code>java.lang.NoClassDefFoundError: org/apache/poi/ss/usermodel/WorkbookFactory at ReportFromJira.generateReport(ReportFromJira.java:59) at JiraReportServlet.doPost(JiraReportServlet.java:52) at JiraReportServlet.doGet(JiraReportServlet.java:36) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) 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.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) 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:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454) at java.lang.Thread.run(Unknown Source) </code></pre> <p>When I manually explored the jar files I found out that.</p> <pre><code>poi-3.8-20120326.jar contains org.apache.poi.ss.usermodel-&gt;Workbook.class file and poi-ooxml-3.8-20120326.jar contains org.apache.poi.ss.usermodel-&gt;WorkbookFactory.class file </code></pre> <p>I have both the jar files included in my class path.</p> <p>any idea why the exception?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USBhavik Shah
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PONoClassDefFound Exception
      1. This table or related slice is empty.
      1. VTUpMod
    1. COit seems that you are mistaken about having them in ur classpath, they have to be in ur tomcat classpath and not just eclipse classpath. Suggest putting one of the jars in WEB-INF/lib manually.
      singulars
      1. PONoClassDefFound Exception
      1. USMozenRath
    2. COSee [other](http://stackoverflow.com/questions/779650/where-on-the-file-system-was-my-java-class-loaded-from) [questions](http://stackoverflow.com/questions/947182/how-to-explore-which-classes-are-loaded-from-which-jars) on SO regarding how to debug class loading.
      singulars
      1. PONoClassDefFound Exception
      1. USMr Moose
    3. CO@MozenRath : I think you are right post an answer so that I can accept it
      singulars
      1. PONoClassDefFound Exception
      1. USBhavik Shah
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload