hmm... so i completely took it other way round. i though the other problem couldn't be that BIG as the entire control is with you. Whatever output is being generated by servlet, you CAN use it anyway, + throw it to browser. + write to database. + or send it other servlet.
Or is there anything i am completely overlooking at? You may also like to see ServletOutputStream rather than PrintWriter. navjot |-----Original Message----- |From: Rajesh P [mailto:[EMAIL PROTECTED] |Sent: Tuesday, June 03, 2003 7:54 PM |To: Struts Users Mailing List |Subject: RE: Storing the Output of a Servlet to Database | | |Hi, |I am aware of how to store the contents to the database. What i am |really interested is how to capture the output of the servlet. |Forget PDF, assume that the Servlet is just serving a normal html |content. After the servlet has given this to the response, how to |capture this as a byte stream is my real question. |Thanks, |Rajesh | |-----Original Message----- |From: Navjot Singh [mailto:[EMAIL PROTECTED] |Sent: Tuesday, June 03, 2003 7:44 PM |To: Struts Users Mailing List |Subject: RE: Storing the Output of a Servlet to Database | | | |Ideally, you should store the document on file system, the better place for |PDF BUT you may some weird requirement |Anyway, if you are adamant on doing this. | |--first way-- | |0. create a field in your database with blob data type. (I have MySQL) but |oracle/ mssql7 all have this data type. |1. generated pdf document needs to converted into binary data. ( it is be |default ;-) |2. write it down to that field as normal query. | |you may wish to see java.sql.Blob and java.sql.prepraedStatement.setBlob | |--second way-- |0. create a field in your database with varbinary type. |1. generated pdf document. read it as byte stream and get arrys of bytes. |2. write it down to that field as normal query. | |see java.sql.prepraedStatement.setBytes | |HTH |navjot | | | ||-----Original Message----- ||From: Rajesh P [mailto:[EMAIL PROTECTED] ||Sent: Tuesday, June 03, 2003 5:28 PM ||To: Struts Users Mailing List ||Subject: Storing the Output of a Servlet to Database || || ||Hello Everyone, ||I have a requirement wherein a Servlet class is used to generate a ||PDF document. This output should be stored into a database table ||for future retrieval. Can somebody tell me how this output of the ||Servlet can be captured and stored into a database table? Or ||rather, how to capture the response outputstream, convert it to ||bytes so that it can be persisted in the datbase. Please note that ||we are not allowed to write to a File and then upload it. ||Thanks, ||Rajesh || ||--------------------------------------------------------------------- ||To unsubscribe, e-mail: [EMAIL PROTECTED] ||For additional commands, e-mail: [EMAIL PROTECTED] || || | | |--------------------------------------------------------------------- |To unsubscribe, e-mail: [EMAIL PROTECTED] |For additional commands, e-mail: [EMAIL PROTECTED] | | |--------------------------------------------------------------------- |To unsubscribe, e-mail: [EMAIL PROTECTED] |For additional commands, e-mail: [EMAIL PROTECTED] | | --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
