Bruce Houghton wrote:
False alarm;([EMAIL PROTECTED]&*()_+)
My test bed works fine now, but when I deployed it to
my ISP I still get this error.
I don't know which come first, "ExceptionInInitializerError", or the security error.
I suspect it's Access denied: "java.util.PropertyPermission poi.deserialize.escher read"
Any thoughts?
Log below. Bruce Houghton
Code;
HSSFWorkbook Read() throws IOException { URL url = new URL(Url_Name); URLConnection uc = url.openConnection(); POIFSFileSystem is = new POIFSFileSystem((uc.getInputStream())); HSSFWorkbook wb = new HSSFWorkbook(is); *** 103 This is where the error happens return wb; }
Java(TM) Plug-in: Version 1.4.2_06 Using JRE version 1.4.2_06 Java HotSpot(TM) Client VM User home directory = C:\Documents and Settings\Bruce's
Proxy Configuration: No proxy ---------------------------------------------------- c: clear console window f: finalize objects on finalization queue g: garbage collect h: display this help message l: dump classloader list m: print memory usage o: trigger logging p: reload proxy configuration q: hide console r: reload policy configuration s: dump system properties t: dump thread list v: dump thread stack x: clear classloader cache 0-5: set trace level to <n> ---------------------------------------------------- java.lang.ExceptionInInitializerError at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at org.apache.poi.hssf.record.RecordFactory.class$(RecordFactory.java:50) at org.apache.poi.hssf.record.RecordFactory.<clinit>(RecordFactory.java:48) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:163) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:130) at barry.Excel_Page.Read(Excel_Page.java:103) ***** 103 where error is happening at barry.Excel_Page.Excel(Excel_Page.java:73) at barry.Excel_Page.<init>(Excel_Page.java:50) at barry.Home_Page.MyInit(Home_Page.java:48) at barry.Home_Page.<init>(Home_Page.java:36) at barry.Begin.init(Begin.java:34) at sun.applet.AppletPanel.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.security.AccessControlException: access denied (java.util.PropertyPermission poi.deserialize.escher read) at java.security.AccessControlContext.checkPermission(Unknown Source) at java.security.AccessController.checkPermission(Unknown Source) at java.lang.SecurityManager.checkPermission(Unknown Source) at java.lang.SecurityManager.checkPropertyAccess(Unknown Source) at java.lang.System.getProperty(Unknown Source) at org.apache.poi.hssf.record.AbstractEscherHolderRecord.<clinit>(AbstractEscherHolderRecord.java:40) ... 14 more
_____________________________________________________________________________________________________________
----- Original Message ----- From: "Bruce Houghton" <[EMAIL PROTECTED]>
To: "Bruce Houghton" <[EMAIL PROTECTED]>; "POI Users List" <[email protected]>
Sent: Monday, January 10, 2005 6:54 AM
Subject: Re: ExceptionInInitializerError
The problem,
My program was set up to read files using FileInputStream to open the POIFSFileSystem,
or Url.getInputStream to open the POIFSFileSystem.
If FileInputStream failed, I would use HTTP.
Everything worked fine until I deployed the applet
to my ISP where the POIFSFileSystem with FileInputStream caused an IOEXception(of course)
and it would then open the POIFSFileSystem with
url.getInputStream.
I changed the program to use url.getInputStream "only", where the file name could be either "file:/C:/filename" or "http://www......./filename";. And both work fine. BTW, I FTP the .xls file in "Binary" mode.
Bruce Houghton
----- Original Message ----- From: "Bruce Houghton" <[EMAIL PROTECTED]>
To: "POI Users List" <[email protected]>
Sent: Friday, January 07, 2005 7:46 AM
Subject: Re: ExceptionInInitializerError
HTTP Transmission? If you mean does it run on my PC under JBuilder not using HTTP, the answer is yes. If you mean after deploy the applet to my ISP and logon to it through the Internet... Q. Is there another way than HTTP Transmission?
I changed the "SafePOIStream" to "POIFSFileSystem" with no change.
However, when I "FTP" the .xls file to my ISP using ASCII instead of BINARY I get a different error.
"java.io.IOException: Unable to read entire block; 502 bytes read; expected 512 bytes"
Bruce Houghton
----- Original Message ----- From: "Danny Mui" <[EMAIL PROTECTED]>
To: "POI Users List" <[email protected]>
Sent: Thursday, January 06, 2005 1:05 PM
Subject: Re: ExceptionInInitializerError
Does the excel file get parsed correctly without the HTTP Transmission?
I'm not sure you need to the safe stream anymore, the heavy lifters (thanks guys!) patched it to accept slow streams.
http://issues.apache.org/bugzilla/show_bug.cgi?id=13478
Can you also provide a more detailed stack trace so we can guess a little better?
Bruce Houghton wrote:
To all;
I get ExceptionInInitializerError at HSSFWorkbook.
I'm using poi...20040804.jar, and JRE1.4.2_04.
The URL generated "HTTP://www....../.../barry/images/excel.xls";
is correct. Printing the header field shows "HTTP 1.1 200 ok",
more messages, then "application/msexcel", date twice
then the length of the file. Everything I read points to
a compatibility issue.
Any thoughts.
Bruce Houghton
HSSFWorkbook Read1() throws IOException { URL url = new URL(codeBase, "barry/Images/Excel.xls"); URLConnection uc = url.openConnection(); String field = uc.getHeaderField(0); for (int i=0;field != null; i++) { JOptionPane.showMessageDialog(null, field); field = uc.getHeaderField(i); } SafePOIStream is = new SafePOIStream(uc.getInputStream()); HSSFWorkbook wb = new HSSFWorkbook(is); return wb; }
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
