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]
