uploading file to database

[kishore naidu]

how to upload an entire .doc file into oracle database using struts

when clicked on browse button and select the file from the list and when click on submit the entire file(resume) should be stored in the database

[Merrill Higginson]

Look at the struts-examples.war file that comes with the Struts download, and you will find an example that shows you how to upload a file.

Once you have uploaded the file, you will probably want to store it in a BLOB (Binary Large OBject) in your Oracle database. I'd suggest searching on "Oracle BLOB Java" to find examples of how to read and write a BLOB in Oracle.

[Kem Broder]

Hi,
I've been looking at a similar issue so I hope nobody minds me piggy-backing on this thread.
I've used the example struts upload code before, but now I'm trying to use a
DynaValidatorForm instead of handcrafting an actionForm. I've set my form property to this:

<form-property name="myFile"type="org.apache.struts.upload.CommonsMultipartRequestHandler$CommonsFormFile" />

This config executes fine, but I've run out of ideas of how to cast the org.apache.struts.upload.CommonsMultipartRequestHandler$CommonsFormFile back to a FormFile object in my action class. I had though something like this would work:

FormFile myFile = (CommonsMultipartRequestHandler$CommonsFormFile) dvf.get("myFile");

I've also tried creating a CommonsMultipartRequestHandler object and inspecting its properties, but no luck there either.

Any ideas, pointers, hints or tips greatly appreciated.
Cheers,
Kem