Download microsoft office document from DB

Ranch Hand

Posts: 63

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi

I would like to download the microsoft office document (may be doc or docx or xls) from the database. I have to download almost 4000 files based SQL condition. I would like to know the best way (interms of good performances) to download the files from SQL Server.

Let me know if additional info has needed..

Regards
Mohan

Thanks and Regards
Chandra Mohan

Paul Clapham

Marshal

Posts: 27999

I like...

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Stream the data directly from the database to wherever you want to put it. ResultSet has a getBinaryStream() method which returns an InputStream so just read from that and write to some suitable OutputStream.

Java 8 (verified skill)
Skill verified by Paul Clapham

Chandra Mohan

Ranch Hand

Posts: 63

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Paul Clapham wrote:Stream the data directly from the database to wherever you want to put it. ResultSet has a getBinaryStream() method which returns an InputStream so just read from that and write to some suitable OutputStream.

Thanks.. The files are downloading really fast.

Thanks and Regards
Chandra Mohan

There are 29 Knuts in one Sickle, and 17 Sickles make up a Galleon. 42 tiny ads in a knut:

a bit of art, as a gift, the permaculture playing cards

https://gardener-gift.com