Hi Vikramjit
Could you please send me an example of code (java, jsp) for for inserting
and displaying images from database (oracle or Mysql).
Thanks lot your help is appreciated.
Sufi
>From: Vikramjit Singh <[EMAIL PROTECTED]>
>Reply-To: A mailing list about Java Server Pages specification and
>reference <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: query image to my database and showing in jsp
>Date: Sat, 22 Sep 2001 12:19:48 +0530
>
>hi christian,
>for inserting pictures in Oracle database you have to use
>PreparedStatements.
>How i have done is first i have executed the query in that i have to write
>EMPTY_BLOB(). and then using PreparedStatements you have to update the
>record. the picture has to be converted into an InputStream.
>You can use FileInputStream for converting into InputStream.
>like-->
>pstmt.setBinaryStream(1,fis,(int)file.length());
>
>and for reading you have to read using OutputStream.
>If still you dont get it feel free to ask.
>
>Vikramjit singh,
>eAngel Team,
>Global Tele-systems Ltd.
>Ph. 7612929-3140
>
>
>-----Original Message-----
>From: Christian Hamann L [mailto:[EMAIL PROTECTED]]
>Sent: Friday, September 21, 2001 10:46 AM
>To: [EMAIL PROTECTED]
>Subject: query image to my database and showing in jsp
>
>
>Hi All
>i want to store some pics in my database using BLOB but i dont know how can
>i do with java, besides how can i get from my database and show them with
>jsp..
>have you done this?
>atte
>Christian Hamann L.
>
>===========================================================================
>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
>JSP-INTEREST".
>For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
>DIGEST".
>Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
>===========================================================================
>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
>JSP-INTEREST".
>For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
>DIGEST".
>Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
