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
