> <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
