Martin, Does JDeveloper work with any database or just with Oracle ?
Marcus Em Ter, 2003-12-23 Ãs 18:53, Martin Gainty escreveu: > 1)you're going to have to download and install JDeveloper > http://otn.oracle.com/software/products/jdev/index.html > The nice thing about JDeveloper is you can create a WebTier/Struts from > File/New > > 2)then read up on the Oracle Blob manipulation > http://otn.oracle.com/sample_code/products/jdev/files/images/sample.html > > Both of these downloads take a while..you might want to try it during lunch > assuming you have an unobstructed 100 MB/s connection > Follow the instructions on the 2nd link for downloading, Install, Create and > populate DB Tables, creating connection, developing and deploy > This is the only way I know how to capture BLOB and persist to an Oracle DB > Get in touch if you need any help..Been there done that! > Good Luck, > -Martin > NB: I had to torque up to 1.5 GB Ram on my box so JDeveloper would run in an > expeditious manner.. > > ----- Original Message ----- > From: "Claire Wall" <[EMAIL PROTECTED]> > To: "Struts Users Mailing List" <[EMAIL PROTECTED]> > Sent: Tuesday, December 23, 2003 9:43 AM > Subject: converting a FormFile to a Blob object > > > hi, > > I have a jsp page which uploads a file to a database. I have no problems > storing the file in an SQLServer or MySQL database by using the > setBinaryStream() method of a PreparedStatement. The file gets upload no > problem. > > However, when I try to upload this file to an oracle database (BLOB column) > it does not work. I'm sure that i have to use the setBlob() method of the > PreparedStatement, however, my dilemma is that I cannot find a way to > convert my file from FormFile format to sql Blob format. Does anybody know > how to do this as I've looked everywhere and haven't come up with a > solution. > > Any help would be much appreciated > > > thanks > claire > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] -- Marcus Peixoto <[EMAIL PROTECTED]> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
