File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes How to store and retrieve PDF files for Access Database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to store and retrieve PDF files for Access Database" Watch "How to store and retrieve PDF files for Access Database" New topic
Author

How to store and retrieve PDF files for Access Database

Clara Hall
Greenhorn

Joined: Nov 24, 2001
Posts: 16
Hi,
I need to develop a system in which the client can send a file (pdf, doc, ppt, ps, etc) to the servlet, the servlet gets the file and stores it in a database. When the client request the file, the servlet need to get the file from the database and then send it to the client. And the client use applet.
Now the question is what kind of type should I define for the file? Will Blob do the work? If so, how to do it? Thank you.
Clara
Brent Worden
Ranch Hand

Joined: Nov 26, 2001
Posts: 50
To upload your file, look into using the MultipartRequest from http://www.servlets.com/cos/index.html.
To store your file, a BLOB should be suffecient.

------------------
Brent Worden
http://www.brent.worden.org/


Brent Worden
 
jQuery in Action, 2nd edition
 
subject: How to store and retrieve PDF files for Access Database
 
Similar Threads
Streams and EJB
Servlet to Backing bean
PDF plugin problem
sending xml file from server to client dynamically.
Sending an XML file form servlet to client