You can store the data as a BLOB (Binary Long OBject, or the source as a CLOB (Character Long OBject). There is also another option known as a BFILE that stores a pointer, but I usually go with the other two. This is a great book with examples on how to do it: http://shop.osborne.com/cgi-bin/oraclepress/0072222549.html
You can also download the Java/Blob/Clob examples in the book from the site, but I'd recommend purchasing the book if you do a lot of Oracle JDBC Programming. It will give meaning to the code. http://www.osborne.com/products/0072222549/0072222549_code.zip thank you! Troy Campano -----Original Message----- From: Adrian Janssen [mailto:[EMAIL PROTECTED]] Sent: Monday, August 12, 2002 7:21 AM To: [EMAIL PROTECTED] Subject: Re: Java objets in oracle Earth to Steven.... Anyway, to answer Joshy's question in the absence of Stevens lucidity. I believe it is possible. What you would need to do though, is serialize the object first to a byte stream and then write this to a BLOB-type field in your DB. I have not done personally done this in JSP (yet), a while back though I did something simmilar from ASP - I saved an images raw binary to a DB. The database in question was Sybase (groan), and it did require some special use of the ODBC driver. So, if that can be done in ASP with a Sybase DB, I am pretty sure you should be able to save serialized objects to just about any major DB using JDBC. In fact if it is Oracle with thier 300% java promise then it should definately be possible. For the details you may have to STW or BAB. Cheers Adrian > -----Original Message----- > From: Stephan [SMTP:[EMAIL PROTECTED]] > Sent: 08 August 2002 06:58 > To: [EMAIL PROTECTED] > Subject: Re: Java objets in oracle > > Yes. > As always a slice of Heaven... > > Stephan Fowler > > ----- Original Message ----- > From: "JOSHY MON M C" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, August 08, 2002 9:11 AM > Subject: Re: Java objets in oracle > > > > Hi Stephen, > > Actually I meant storing java objects in a table as a record field. > > Is > this > > possible stephen? > > Thanks in Advance > > Joshy > > > > > > -----Original Message----- > > From: Stephan [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, August 08, 2002 7:54 PM > > To: [EMAIL PROTECTED] > > Subject: Re: Java objets in oracle > > > > > > Joshy, > > When you mean storing Java objects in Oracle do you mean as in a > > record field in a table or as a stored proceedure? > > ----- Original Message ----- > > From: "JOSHY MON M C" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Wednesday, August 07, 2002 10:58 PM > > Subject: Java objets in oracle > > > > > > > Hi all > > > How can I store Java objects in Oracle? Is storing Objects in > > > Oracle > > affect > > > the performance? Eg: I ve an exception object from Java, and that > needs > to > > > be stored in the Oracle db. > > > Can Anyone explain how to? > > > Thanks > > > Joshy > > > > > > > > > ====================================================================== > ==== > = > > > 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://archives.java.sun.com/jsp-interest.html > > > http://java.sun.com/products/jsp/faq.html > > > http://www.esperanto.org.nz/jsp/jspfaq.jsp > > > http://www.jguru.com/faq/index.jsp > > > http://www.jspinsider.com > > > > > > > > ====================================================================== > ==== > = > > 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://archives.java.sun.com/jsp-interest.html > > http://java.sun.com/products/jsp/faq.html > > http://www.esperanto.org.nz/jsp/jspfaq.jsp > > http://www.jguru.com/faq/index.jsp > > http://www.jspinsider.com > > > > > ====================================================================== > ==== > = > > 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://archives.java.sun.com/jsp-interest.html > > http://java.sun.com/products/jsp/faq.html > > http://www.esperanto.org.nz/jsp/jspfaq.jsp > > http://www.jguru.com/faq/index.jsp > > http://www.jspinsider.com > > > > ====================================================================== > ==== > = > 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://archives.java.sun.com/jsp-interest.html > http://java.sun.com/products/jsp/faq.html > http://www.esperanto.org.nz/jsp/jspfaq.jsp > http://www.jguru.com/faq/index.jsp > http://www.jspinsider.com -- It is the strict policy of Truworths that its e-mail facility and all e-mail communications emanating therefrom, should be utilised for business purposes only and should conform to high professional and business standards. Truworths has stipulated certain regulations in terms whereof strict guidelines relating to the use and content of e-mail communications are laid down. The use of the Truworths e-mail facility is not permitted for the distribution of chain letters or offensive mail of any nature whatsoever. Truworths hereby distances itself from and accepts no liability in respect of the unauthorised use of its e-mail facility or the sending of e-mail communications for other than strictly business purposes. Truworths furthermore disclaims liability for any unauthorised instruction for which permission was not granted. Truworths Limited accepts no liability for any consequences arising from or as a result of reliance on this message unless it is in respect of bona fide Truworths business for which proper authorisation has been granted. Any recipient of an unacceptable communication, a chain letter or offensive material of any nature is requested to notify the Truworths e-mail administrator ([EMAIL PROTECTED]) immediately in order that appropriate action can be taken against the individual concerned. =========================================================================== 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://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com ==========================================================================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://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
