saving word doc in database and retrieving

[Former Member]

hai all,

Is it possible to save a word file in database and retrieve the word file in web dynpro application?

Thanks n Regards

Sharanya.R

[Former Member · Accepted solution]

Hi,

To save the wordfile to the database make use of lob types.

Make use of JDBC to do this.

retreiving

Make use of JDBC to fetch the previously saved doc.

Populate a context of type IWDResource(Nw04s onwards) or Binary(Nwo4).

Set the appropriate mime type

Create a filedownload and bind this.

Regards

Ayyapparaj

[Former Member · Accepted solution]

hai Ayyapparaj and Sunitha,

Can you plz provide me the codings that should be used in web dynpro to retrieve a word file that is stored in database.Also say me how this file will be available in web dynpro ??Plz help me in doing that.

Thanks n Regards

Sharanya.R

[Former Member · Accepted solution]

Hi,

When you want to store a word file , Portal provides you the better option of savaing in KM .

It is also very easy , also you can put permissions for security reasons.

Thanks and Regards,

Srini

[former_member751941]

Hi Sharanya,

Check this.

http://www.java-samples.com/showtutorial.php?tutorialid=204

Regards,

Mithu

[Former Member]

Hi ,

you can save the word document in to a folder in server and

save this folders path in R/3 to retrieve the file get the path from R/3 and use filedownload UI to retrieve.

Regards,

Sunitha Hari