This week's book giveaway is in the Agile and other Processes forum. We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line! See this thread for details.
I am working on a application which has an requirement like uploading a word/excel document into a database table from a jsp view using hibernate or JDBC API .(Like the user browses the file to upload and clicks on a upload button).Can anyone help me with some suggestion and tips on the ways to upload /download documents to a table.
Thanks in advance.. [ December 04, 2008: Message edited by: Bala'J'i Rags ]
SCJP 1.5,SCWCD 1.5
Bala'J'i
Ulf Dittmer
Marshal
Joined: Mar 22, 2005
Posts: 35241
7
posted
0
What do you have so far? Is the problem the uploading of the file to the servlet container, or the saving of the uploaded file to the database?
It focuses on saving the file in an oracle table..Sorry if the post was ambiguios
Ulf Dittmer
Marshal
Joined: Mar 22, 2005
Posts: 35241
7
posted
0
You can use an attribute of type BLOB to store binary data in a database. JDBC supports this through the setBlob and setBinaryStream methods in PreparedStatement, and the getBinaryStream in ResultSet.
I generally advise against storing files in a database. I'd store them somewhere in the file system, and just keep the filename and directory information in the database.
0
