Java : Read / Write Excel file (.xls or .xlsx) using Apache POI

We will see how we can read or write excel file (.xls or .xlsx) using Apache POI. To know more about Apache POI, click here.

You can download latest version of JAR files from http://poi.apache.org/download.html.

In our case we are using Apache POI 3.8. To run below example you will need to download poi-bin-3.8-20120326.zip file from http://poi.apache.org/download.html. You will get below JAR files, add those in your claspath.

• dom4j-1.6.1.jar
• xmlbeans-2.3.0.jar
• poi-3.8-20120326.jar
• poi-ooxml-3.8-20120326.jar
• poi-ooxml-schemas-3.8-20120326.jar

Please see the self explanatory Java code.

java.lang.NoSuchMethodError: com.caucho.server.connection.CauchoRequest.isInitial()Z

500 Servlet Exception


[show] java.lang.NoSuchMethodError: com.caucho.server.connection.CauchoRequest.isInitial()Z

java.lang.NoSuchMethodError: com.caucho.server.connection.CauchoRequest.isInitial()Z
   at com.caucho.server.connection.AbstractHttpResponse.finishInvocation(AbstractHttpResponse.java:2271)
   at com.caucho.server.connection.AbstractHttpResponse.finishInvocation(AbstractHttpResponse.java:2237)
   at com.caucho.server.connection.AbstractHttpResponse.sendError(AbstractHttpResponse.java:567)
   at com.caucho.server.connection.AbstractHttpResponse.sendError(AbstractHttpResponse.java:525)
   at com.caucho.server.connection.HttpServletResponseImpl.sendError(HttpServletResponseImpl.java:277)
   at com.caucho.servlets.FileServlet.service(FileServlet.java:274)
   at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:103)
   at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:189)
   at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:266)
   at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:292)
   at com.caucho.server.port.TcpConnection.handleRequests(TcpConnection.java:577)
   at com.caucho.server.port.TcpConnection$AcceptTask.doAccept(TcpConnection.java:1211)
   at com.caucho.server.port.TcpConnection$AcceptTask.run(TcpConnection.java:1152)
   at com.caucho.util.ThreadPool$Item.runTasks(ThreadPool.java:759)
   at com.caucho.util.ThreadPool$Item.run(ThreadPool.java:681)
   at java.lang.Thread.run(Thread.java:619)

Resin/3.2.1 Server: ''




Hi friends,
I am getting this error on my Resin 3.2.1 web server, i tried lot to solve this error but could not succeed. This error comes when i refresh my pages, many times images does not appears or css not supported.
I tried reinstalling JAVA also reinstalling Resin but could not succeed to solve this error. I searched on net to solve this exception but did not found any source.

Any one getting same exception??
What reason it could be??
How to solve this Exception??