This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes b(very)lob Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "b(very)lob" Watch "b(very)lob" New topic
Author

b(very)lob

jeroen dijkmeijer
Ranch Hand

Joined: Sep 26, 2003
Posts: 131
Hi, I have the following usecase: every monday 7:00 we have to download a very large (220 mb) file from a webserver, zip it and store it in a oracle 9 db. (yeah yeah dont ask, storing it in the db is not giving any advantage above file storage).
What would be the most easiest way to do this?
We currently store it to a filesystem using:

I'm hoping for some code to connect the (zip)outputstream to a argument in a prepared statement. And write the chunks to it. If somebody could point me in the right directions I'm very happy.
regards,
Jeroen.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: b(very)lob
 
Similar Threads
Creation of .zip file???
ZipOutputStream
Windows does not recognize Java created ZIP
Opening a zip file from JSP page
Zipping files