Re: insert retrieve (text, image) jsp oracle ??
See DB taglib from Coldtags suite: http://www.servletsuite.com/jsp.htm This taglib do support operations with BLOB fields (see examples) Hi, I want to upload images and text document to an oracle database, and then retrieve them from the database , 1)how to do it in JSP ? 2) is there any taglib for doing that ? -- Coldbeans Software - server-side Java (tm) components http://www.servletsuite.com __ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ === To unsubscribe: mailto [EMAIL PROTECTED] with body: signoff JSP-INTEREST. For digest: mailto [EMAIL PROTECTED] with body: set JSP-INTEREST DIGEST. Some relevant archives, FAQs and Forums on JSPs can be found at: http://java.sun.com/products/jsp http://archives.java.sun.com/jsp-interest.html http://forums.java.sun.com http://www.jspinsider.com
Re: insert retrieve (text, image) jsp oracle ??
snip 1)how to do it in JSP ? See the getBlob method in the ResultSet object of the JDBC API 2.0. Pranav My own experience with trying to store and retrieve binary data from Oracle was very painful. What I discovered was that there are different ways to do it, many of which ALMOST work, or work if the data is not too large. I believe there is a method in one of the Oracle classes that will do it. I wanted to stay away from that and just use JDBC. What I wound up doing was: Declare the binary data column as LONG RAW. Get it via a SELECT into a ResultSet. Create a new InputStream from resultSet.getBinaryStream(column_no). Create a new ObjectInputStream on it. Read from the ObjectInputStream. What you do after that is up to you. I went through many painful experiments before finding this method. Good luck with it. -- Alan Meyer AM Systems, Inc. Randallstown, MD, USA [EMAIL PROTECTED] === To unsubscribe: mailto [EMAIL PROTECTED] with body: signoff JSP-INTEREST. For digest: mailto [EMAIL PROTECTED] with body: set JSP-INTEREST DIGEST. Some relevant archives, FAQs and Forums on JSPs can be found at: http://java.sun.com/products/jsp http://archives.java.sun.com/jsp-interest.html http://forums.java.sun.com http://www.jspinsider.com
insert retrieve (text, image) jsp oracle ??
Hi, I want to upload images and text document to an oracle database , and then retrieve them from the database , 1)how to do it in JSP ? 2) is there any taglib for doing that ? thank you, your help is appreciated. sufi _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus === To unsubscribe: mailto [EMAIL PROTECTED] with body: signoff JSP-INTEREST. For digest: mailto [EMAIL PROTECTED] with body: set JSP-INTEREST DIGEST. Some relevant archives, FAQs and Forums on JSPs can be found at: http://java.sun.com/products/jsp http://archives.java.sun.com/jsp-interest.html http://forums.java.sun.com http://www.jspinsider.com