Hello All,

I made a database driven JSP page, now i am takeing
some data in text from user and save it to database it works fine.

now i want to give facility of attachment,

means user can attach the file and i can store that
file in database (MS SQL Server 7.0)

so please tell how i can do that thing.

1] how to save attachment file to database.

If you have code then please write to me.


Please do replay at [email protected], [email protected]

Best Regards,
Monika

Please tell me the complit thing for file upload and download
from client to Server and Server to Client.

Best regards,
Monika

Hi
If I am not wrong with file attachment your are referring to file upload. This can be done in JSP by reading the file form the request input stream and after that you can perform any of the operations like write the file to some path on the server or store it in database. The following HTML code has to be inserted to make the user select a file and upload it in database:

<FORM METHOD=Post ENCTYPE='multipart/form-data' ACTION=”some jsp or servlet”>
<INPUT TYPE="file" name="uploadfile">
<INPUT TYPE="submit" value="Upload">
</FORM>

In the action attribute of the FORM tag you can specify the JSP or Servlet which will handle the file read write code.

For file reading
ServletInputStream stream = Request.getInputStream();
byte [] data = new byte[128];
int byteread;
StringBuffer buffer = new StringBuffer();
while((byteread = readstream.readLine(data,0,data.length)) != -1)
{
String str1 = new String(data);
buffer = buffer.append(str1);
}

The above code will read the content of the file and store it in a StringBuffer and it is up to you to use it. The browser also send some extra information(like the file name, it’s content type etc.) with the file content so make sure you remove this information before storing the file contents.

Hope this helps
Best Regards

Yashraj Chauhan
Java\J2EE Specialist
Wiley Support Team

Thanks a lot for replay!

but please tell me how I can store it to database,for
storing files i have Binary type column in MS Sql
Server.

please tell me how to store it in Database, from
client machine, and who we can send back to user while
when he wants to download the file.

basically i am tring to make Customer Support System.

Please do replay
Regards,
Monika

Hello

Reading file is ok, but can you tell me how I can store it into Database.

Here there is 2 possibility.

[1] I can store in Database ( MS SQL Server have Binary data type) .
[2] at server having folder there we can store.

So please tell me how I can store the complete file to database, ( file may have any type , rem.doc,
 Rem.jpg, rem.fax) after reading it in buffer how to insert into database.

Insert into dbo.personal ( file ) value ( file )

May be it can be done by BLOB but I don’t know how ? please tell me with code.

Do replay !
Regards,
Monika

hi there,
 i have been able to upload a file on the server side and also able to bput the file in the database in a varchar field..(if anyone needs the code mail me at [email protected])but things start to fail when the blob's come into picture.

What i did was i created a table with column of type BLOB in oracle sql database. but when i try putting the file n the blob it gives an error "Error in getting request param-->ORA-01465".. if someone knows how to do the stuff , ur help would truly be appriciated.

varun

I have done this with blobs (jpegs).
The real pain was stripping the headers out after the POST action.
I used a tutorial on the SUN Java site to learn how to parse the data, and got some other bits of code to put it into a database.
Come to think of it, putting it in the database was a pain as well.
I outlined what I did in the following thread:

http://p2p.wrox.com/topic.asp?TOPIC_ID=20969

Hope this helps, ultimately I dont think you are going to find a complete solution posted anywhere, believe me I looked!