Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Java > Java and JDK > Pro JSP
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Pro JSP Advanced JSP coding questions. Beginning questions will be redirected to the Beginning JSP forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Pro JSP section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old July 8th, 2003, 12:38 AM
Registered User
 
Join Date: Jul 2003
Location: , , .
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to add attachment facility with JSP page.

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 ft212@rediffmail.com, monika_jain_99@yahoo.com

Best Regards,
Monika
Reply With Quote
  #2 (permalink)  
Old July 8th, 2003, 12:48 AM
Registered User
 
Join Date: Jul 2003
Location: , , .
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

Best regards,
Monika
Reply With Quote
  #3 (permalink)  
Old July 8th, 2003, 01:22 AM
Authorized User
 
Join Date: May 2003
Location: New Delhi, Delhi, India.
Posts: 50
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #4 (permalink)  
Old July 8th, 2003, 02:49 AM
Registered User
 
Join Date: Jul 2003
Location: , , .
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #5 (permalink)  
Old July 8th, 2003, 07:32 AM
Registered User
 
Join Date: Jul 2003
Location: , , .
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #6 (permalink)  
Old December 7th, 2004, 03:07 AM
Registered User
 
Join Date: Dec 2004
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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 phredus@rediffmail.com)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


Reply With Quote
  #7 (permalink)  
Old December 8th, 2004, 01:50 PM
Friend of Wrox
 
Join Date: Jul 2004
Location: , , .
Posts: 204
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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!

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Collection facility AnjuSujith ASP.NET 2.0 Professional 6 November 27th, 2007 01:13 PM
how to send email with attachment using JSP kirtesh4u J2EE 0 May 19th, 2007 01:17 AM
Add GIU in JSP Befekadu Java GUI 0 March 10th, 2005 12:55 PM
Next Page >> facility crmpicco Classic ASP Databases 7 March 10th, 2005 08:59 AM
How to add attachment facility with JSP page. monika_jain_99 J2EE 2 July 9th, 2003 12:34 AM



All times are GMT -4. The time now is 10:11 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.