Excel Download Error

[Former Member]

Hi All,

while downloading the data from wd table i am getting the error

java.lang.NoSuchMethodError:org/apache/poi/POIDocument.<init>

(Lorg/apache/poi/poifs/filesystem/DirectoryNode;Lorg/apache/poi/poifs/filesystem/POIFSFilesystem;)V

i am added poi jarfiles as a External JAR's and i pasted those files under lib directory also.

can anyone gime the solution.

Thanks&Regards

Murthy

[Former Member]

Hi Murthy.

Which version of NWDS are you using?

If you are using version 7.0.11 or earlier, make sure you use the latest POI jar files.

The older versions ( of POI i.e. ) dont get recognized during runtime, check the error

if you encounter NoClassDefFoundError or NoSuchMethodError upgrade to latest version of POI jar.

use poi-3.0.1-FINAL-20070705.jar or later versions if any.

Warm Regards,

Shibin

[Former Member]

Hi Shibin

Thanks for your reply,just now i downloaded that jar file.Let me check.

Thanks

Murthy

[Former Member]

Hi,

At runtime that jar is not available that is why you are getting this error.

If you are using noraml WebDynpro project (not DC) then adding to build path works i guess.

There are two ways of using the external jars in WebDynpro DCs.

First you need to create one external library dc then you need to add the external jar to that dc.

You need to create two public parts for this jar.

1. API (design time purpose) 2. SDA (run time purpose)

Approach1:

After this you need to add these two public parts in WebDynpro DC as Used DCs. Now you should not deploy using RightClick > Deploy/ Deploy New Archieve and Run. You should deploy using RightClick>Development Component --> Deploy. Then only it works.

See the below blog for the same:

/people/bala.krishnan2/blog/2006/09/25/bid-adieu-to-bots--using-captchas

Approach2:

Add the API public part to WebDynpro DC for design time purpose as Used DC. Create J2EE Lib DC and add SDA public part to this DC and deploy this J2EE Lib DC. Now give the library reference to this J2EE Lib DC in WebDynpro DC properties.

See the below blog for the same:

/people/bertram.ganz/blog/2008/11/24/how-to-use-external-jar-files-in-web-dynpro-development-components

Regards,

Charan

[Former Member]

Hi Charan,

I am not using DC's.what is the build path.now it is giving the error

/sapmnt/EP3/excel.xls (A file or directory in the path name does not exist.)

This is already we are using in Production,earlier it is working.Today only we are getting the error like this.

Thanks

Murthy

[Former Member]

Hi,

If it is normay WebDynpro project then add that external DC to build path and deploy and check.

How to add:

Right click on the project --> Properties --> Java build path --> Libraries --> Add External jar

Regards,

Charan

[Former Member]

I did the same thing and i pasted those jars under lib folder also.

earlier we tested the same,everything is working fine.

suddenly we got this error.I think so this is not a problem of jar's.

can u pls guess what are other possibilities.

thanks

Murthy