tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pid <...@pidster.com>
Subject Re: POI/XML issues in server environment
Date Thu, 17 Jun 2010 13:47:13 GMT
On 17/06/2010 14:33, David Fisher wrote:
> Hi All,
> 
> Over here from POI where I helped Jorge track things down in Tomcat. I suggested he come
over here for help, but he seems to have started at the beginning and is getting the exact
same initial questions that were asked on POI User.
> 
> Here's what was determined. One of the webapps on his production server uses an older
XercesImpl Jar in his endorsed directory. This causes a conflict with POI that is not handled
very well. I've opened a bugzilla in POI so that we'll eventually have a more informative
error message. We'll need to check to see versions of XML Parser implementations active in
the JVM to find out what POI OOXML's minimum requirement really is. Any suggestions about
how to do that would be very helpful.
> 
> The thread should be easy enough to find on the POI User list. In it Jorge provided a
screenshot of his production server's common/lib and it was packed with jars. No surprise
there is a conflict.

OK. Useful.

Was there some particular aspect of Tomcat / deployment that you had in
mind that we could help with?


p

> Regards,
> Dave
> 
> On Jun 16, 2010, at 5:05 PM, Terence M. Bandoian wrote:
> 
>> Any possibility that the Excel file was modified (e.g. FTP)?  I've used POI in a
Tomcat 5.5 webapp on Windows Server and didn't see any problems like this.
>>
>> -Terence Bandoian
>>
>>
>> Jorge Moya wrote:
>>> Hello guys.
>>>
>>> For the past couple of days, I've been working as an intern in a local
>>> company and I'd like to mention I'm kind of new with Tomcat and POI. My
>>> first task was to update a java code they had to extract information of
>>> excel 97-2003 files to the new POI so that I could also extract and work
>>> with Excel 2007+ files. I got it working with a local .class test and
>>> ant.xml build. I then proceeded to update the webservice app in our server
>>> to function along with Tomcat and this is where the problems began that have
>>> been bothering me for the past week. Whenever I try to extract .xlsx files I
>>> get the following error:
>>>
>>> org.apache.poi.openxml4j.exceptions.InvalidFormatException: Can't read
>>> content types part !
>>>        at
>>> org.apache.poi.openxml4j.opc.internal.ContentTypeManager.<init>(ContentTypeManager.java:107)
>>>        at
>>> org.apache.poi.openxml4j.opc.internal.ZipContentTypeManager.<init>(ZipContentTypeManager.java:56)
>>>        at
>>> org.apache.poi.openxml4j.opc.ZipPackage.getPartsImpl(ZipPackage.java:136)
>>>        at
>>> org.apache.poi.openxml4j.opc.OPCPackage.getParts(OPCPackage.java:585)
>>>
>>>        at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:222)
>>>        at
>>> org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:63)
>>>        at com.msights.core.utils.ExcelFile.loadFile(ExcelFile.java:84)
>>>        at com.msights.core.utils.GroupLoader.loadFiles(GroupLoader.java:50)
>>>        at
>>> com.msights.core.validation.ValidationModule.run(ValidationModule.java:154)
>>>        at java.lang.Thread.run(Thread.java:595)
>>>
>>> Now, I've established a long conversation with the POI userlist and came to
>>> the conclusion I'm having some issues with some of the .jar files and
>>> classes. This is notably so because I established a local Tomcat environment
>>> and I can extract the information just fine. I'm kind of at odds on how I
>>> could fix that issues (Tomcat in the server manipulates a couple of webapps)
>>> and maybe you guys could offer me a solution.
>>>
>>> Java version is 1.5.0_18-b02
>>> Windows version is Windows Server 2003 SP2
>>> Tomcat version: 5.5.20
>>>
>>> Libraries:
>>> *http://bit.ly/casaPs*
>>> Shared only has cewcanative.jar
>>>
>>> Any idea of what's causing the problem?
>>>
>>> Thanks in advance.
>>>
>>>  
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>> For additional commands, e-mail: users-help@tomcat.apache.org
>>
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
> 



Mime
View raw message