hummm.... wget http://jakarta.apache.org/builds/jakarta-poi/release/bin/jakarta-poi-1.5.1-final-bin.zip [andy@localhost jakarta-poi]$ unzip -e /home/andy/downloads/jakarta-poi-1.5.1-final-bin.zip build/jakarta-poi-1.5.1-final-20020615.jar Archive: /home/andy/downloads/jakarta-poi-1.5.1-final-bin.zip inflating: build/jakarta-poi-1.5.1-final-20020615.jar [andy@localhost jakarta-poi]$ jar -tf build/jakarta-poi-1.5.1-final-20020615.jar [andy@localhost jakarta-poi]$ jar -tf build/jakarta-poi-1.5.1-final-20020615.jar |grep -i usermodel org/apache/poi/hssf/usermodel/ org/apache/poi/hssf/usermodel/HSSFCell.class org/apache/poi/hssf/usermodel/HSSFCellStyle.class org/apache/poi/hssf/usermodel/HSSFColorConstants.class org/apache/poi/hssf/usermodel/HSSFDataFormat.class org/apache/poi/hssf/usermodel/HSSFDateUtil.class org/apache/poi/hssf/usermodel/HSSFErrorConstants.class org/apache/poi/hssf/usermodel/HSSFFont.class org/apache/poi/hssf/usermodel/HSSFRow.class org/apache/poi/hssf/usermodel/HSSFSheet.class org/apache/poi/hssf/usermodel/HSSFWorkbook.class org/apache/poi/hssf/usermodel/package.html [andy@localhost jakarta-poi]$
[andy@localhost jakarta-poi]$ jar -tf build/jakarta-poi-1.5.1-final-20020615.jar |grep -i util <snip/> org/apache/poi/util/BinaryTree$1.class org/apache/poi/util/BinaryTree$10.class org/apache/poi/util/BinaryTree$11.class org/apache/poi/util/BinaryTree$12.class org/apache/poi/util/BinaryTree$2.class org/apache/poi/util/BinaryTree$3.class org/apache/poi/util/BinaryTree$4.class org/apache/poi/util/BinaryTree$5.class org/apache/poi/util/BinaryTree$6.class org/apache/poi/util/BinaryTree$7.class org/apache/poi/util/BinaryTree$8.class org/apache/poi/util/BinaryTree$9.class org/apache/poi/util/BinaryTree$BinaryTreeIterator.class org/apache/poi/util/BinaryTree$Node.class org/apache/poi/util/BinaryTree.class org/apache/poi/util/BitField.class org/apache/poi/util/ByteField.class org/apache/poi/util/FixedField.class org/apache/poi/util/HexDump.class org/apache/poi/util/HexRead.class org/apache/poi/util/IntegerField.class org/apache/poi/util/IntList.class org/apache/poi/util/LittleEndian$BufferUnderrunException.class org/apache/poi/util/LittleEndian.class org/apache/poi/util/LittleEndianConsts.class org/apache/poi/util/LongField.class org/apache/poi/util/package.html org/apache/poi/util/POILogFactory.class org/apache/poi/util/POILogger.class org/apache/poi/util/ShortField.class org/apache/poi/util/ShortList.class org/apache/poi/util/StringUtil.class They look there for me. -Andy On Thu, 2002-10-10 at 12:51, Sabrina L Landis wrote: > > It was the jakarta-poi-1.5.1-final-bin.zip from 6/17/02. > > > > > > "Andrew C. Oliver" <[EMAIL PROTECTED]> on 10/10/2002 11:30:31 AM > > Please respond to "POI Users List" <[EMAIL PROTECTED]> > > To: POI Users List <[EMAIL PROTECTED]> > cc: > > Subject: Re: access errors when trying to write out Excel file > > > Really??? Which version? > > -Andy > > On Thu, 2002-10-10 at 07:42, Sabrina L Landis wrote: > > > > Yes, this is the only version in the classpath. I did have a problem > with > > the build, though - The JAR file for the final build didn't include the > > HSSF usermodel & util classes, so I had to download the source, recompile > > everything, and then JAR it up again. Maybe there is some inconsistency > > between the bin and the src? Maybe I included something in the JAR that > > shouldn't be in there? > > > > > > > > > > > > "Andrew C. Oliver" <[EMAIL PROTECTED]> on 10/10/2002 07:21:13 AM > > > > Please respond to "POI Users List" <[EMAIL PROTECTED]> > > > > To: POI Users List <[EMAIL PROTECTED]> > > cc: > > > > Subject: Re: access errors when trying to write out Excel file > > > > > > Oh yuck. This is actually something else. Its saying you can't > > access the class from the other class and its happening inside of POIFS. > > > > Is this the ONLY version of POI in your classpath? (I could see maybe > > getting this error with two versions in the classpath) > > > > Anyone have any clues? This error is totally weird. (it may even be a > > JVM bug) > > > > > > On Thu, 2002-10-10 at 07:18, Sabrina L Landis wrote: > > > > > > > > > > > > > > > > > > > > > "Andrew C. Oliver" <[EMAIL PROTECTED]>@main.gmane.org> on > > > 10/09/2002 04:17:51 PM > > > > > > Please respond to "POI Users List" <[EMAIL PROTECTED]> > > > > > > Sent by: news <[EMAIL PROTECTED]> > > > > > > > > > To: [EMAIL PROTECTED] > > > cc: > > > > > > Subject: Re: access errors when trying to write out Excel file > > > > > > > > > On Wed, 09 Oct 2002 06:59:27 -0400, Sabrina L Landis wrote: > > > > > > > Hi, > > > > I am working on a project that requires simple query list screens to > be > > > > exported to Excel. The spreadsheet format is very simple, and I've > > been > > > > able to generate the file with no problem using a standalone Java > > class. > > > > > > > > However, when I try to generate the same file using a servlet or JSP > > > > within our application, I get error messages. The serlvet produces > the > > > > error message "java.lang.IllegalAccessError: try to access class > > > > org.apache.poi.poifs.storage.BigBlock from class > > > > org.apache.poi.poifs.filesystem.POIFSDocument$BigBlockStore". The > JSP > > > > produces the error message "?CAL4MX9N.xls? cannot be accessed. The > > file > > > > may be read-only, or you may be trying to access a read-only > location. > > > > Or, the server the document is stored on may note be responding." > > > > > > > > I put in a bunch of debug statements and found out that the program > > runs > > > > fine up to the point where it calls the HSSFWorkbook.write method to > > > > output the file. We think it may be a problem with the code trying > to > > > > write to a restricted area of our file system. I am using the POI > 1.5 > > > > final release (HSSF usermodel API), JDK 1.3.1_04, my application > server > > > > is Oracle 9ias (OC4J), and I've tried to run the code on both NT and > > > > Unix boxes. Any advice on how to resolve this problem would be > greatly > > > > appreciated. > > > > > > > > > > > > > > Just a couple of suggestions. By itself HSSFWorkbook writes to a > stream. > > > So if the stream is pointing to a restricted area of your > > filesystem...you > > > did it. > > > > > > ----> When I tested with the servlet, I explicitly pointed the stream > to > > > areas that the application has access to. When I tested with the JSP, > I > > > tried to use the ServletOutputStream. Neither scenario worked. > > > > > > You need to supply a stack trace, perhaps a JSP with the minimum amount > > > of code necessary to replicate the problem (maybe a "Hello World" > > > spreadsheet). > > > > > > ----> Here is is: > > > java.lang.IllegalAccessError: try to access class > > > org.apache.poi.poifs.storage.BigBlock from class > > > org.apache.poi.poifs.filesystem.POIFSDocument$BigBlockStore > > > at > > > > > > >org.apache.poi.poifs.filesystem.POIFSDocument$BigBlockStore.writeBlocks(POIFSDocument.java:639) > > > > > > at > > > > > > org.apache.poi.poifs.filesystem.POIFSDocument.writeBlocks(POIFSDocument.java:311) > > > > > > at > > > > > > >org.apache.poi.poifs.filesystem.POIFSFileSystem.writeFilesystem(POIFSFileSystem.java:296) > > > > > > at > > > org.apache.poi.hssf.usermodel.HSSFWorkbook.write(HSSFWorkbook.java:469) > > > at > > > > > > >com.itvsdr.web.sit.commands.SITGenExcelCommand.generateExcelData(SITGenExcelCommand.java:340) > > > > > > at > > > > > > com.itvsdr.web.sit.commands.SITGenExcelCommand.execute(SITGenExcelCommand.java:121) > > > > > > at SITAdmin.service(SITAdmin.java:180) > > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:336) > > > at com.evermind[Oracle9iAS (1.0.2.2.1) Containers for > > > > > > J2EE].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:508) > > > > > > at com.evermind[Oracle9iAS (1.0.2.2.1) Containers for > > > > > > >J2EE].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:177) > > > > > > at com.evermind[Oracle9iAS (1.0.2.2.1) Containers for > > > > > > J2EE].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:576) > > > > > > at com.evermind[Oracle9iAS (1.0.2.2.1) Containers for > > > J2EE].server.http.HttpRequestHandler.run(HttpRequestHandler.java:189) > > > at com.evermind[Oracle9iAS (1.0.2.2.1) Containers for > > > J2EE].util.ThreadPoolThread.run(ThreadPoolThread.java:62) > > > > > > I'm not sure whether IllegalAccessError refers to POIFS trying to read > > > your input stream or some temp file written in your "work" directory by > > > your app server. (which would probably mean someone has tweaked the > > > permissions incorrectly). > > > > > > Lastly, please upgrade to 1.5.1 as it contains bugfixes to 1.5.0 (none > of > > > which have anything to do with the problem you're having, but certainly > > > might help with any future issues you may encounter). > > > > > > ----> Sorry, I mistyped - I am using 1.5.1. > > > > > > Thanks, > > > > > > Andy > > > > > > > > > > Regards, > > > > Sabrina > > > > > > > > > > > > -- > > > To unsubscribe, e-mail: < > mailto:[EMAIL PROTECTED] > > > > > > For additional commands, e-mail: < > mailto:[EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > -- > > > To unsubscribe, e-mail: < > mailto:[EMAIL PROTECTED] > > > > > > For additional commands, e-mail: < > mailto:[EMAIL PROTECTED] > > > > > > > > -- > > http://www.superlinksoftware.com - software solutions for business > > http://jakarta.apache.org/poi - Excel/Word/OLE 2 Compound Document in > > Java > > http://krysalis.sourceforge.net/centipede - the best build/project > > structure > > a guy/gal could have! - Make Ant simple on complex > Projects! > > The avalanche has already started. It is too late for the pebbles to > > vote. > > -Ambassador Kosh > > > > > > -- > > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED] > > > > For additional commands, e-mail: <mailto:[EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > -- > > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED] > > > > For additional commands, e-mail: <mailto:[EMAIL PROTECTED] > > > > > -- > http://www.superlinksoftware.com - software solutions for business > http://jakarta.apache.org/poi - Excel/Word/OLE 2 Compound Document in > Java > http://krysalis.sourceforge.net/centipede - the best build/project > structure > a guy/gal could have! - Make Ant simple on complex Projects! > The avalanche has already started. It is too late for the pebbles to > vote. > -Ambassador Kosh > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > > > > > > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > -- http://www.superlinksoftware.com - software solutions for business http://jakarta.apache.org/poi - Excel/Word/OLE 2 Compound Document in Java http://krysalis.sourceforge.net/centipede - the best build/project structure a guy/gal could have! - Make Ant simple on complex Projects! The avalanche has already started. It is too late for the pebbles to vote. -Ambassador Kosh -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
