aspose file tools*
The moose likes JDBC and the fly likes Download a file from the server using Java Servlet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Download a file from the server using Java Servlet" Watch "Download a file from the server using Java Servlet" New topic
Author

Download a file from the server using Java Servlet

Bhasker Reddy
Ranch Hand

Joined: Jun 13, 2000
Posts: 176
I am executing a Stored PRocedure by passing the parameters
using JDBC and Java Servlets. After the execution, the stored procedure generates a data and that data is stored on oracle on unix. I want the ability to download that data(or file) onto
my local machine(user's local machine).
Do anyone has any code that does that or any ideas.
thanks


Bhasker Reddy
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

what is the Oracle column type that you are trying to retrieve?
Bhasker Reddy
Ranch Hand

Joined: Jun 13, 2000
Posts: 176
it's a file, like export.out, i need to get that file onto my
local machine from the oracle on unix box.
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

you said "and that data is stored on oracle on unix. I want the ability to download that data(or file)." I assume that you have already written to a database and you just want to extract the file that you've stored. I don't know of any file datatype. The only oracle data types that I know of are CHAR, NCHAR, VARCHAR2, NVARCHAR2, NUMBER, DATE, RAW, BLOB, CLOB, NCLOB, BFILE, LONG, LONGRAW and ROWID...but no file type. I'll assume BLOB/CLOB? you can find source code put out by oracle at http://otn.oracle.com/sample_code/tech/java/sqlj_jdbc/content.html . Look for the "JDBC Advanced Features Samples" link.

Jamie
[This message has been edited by Jamie Robertson (edited September 24, 2001).]
Bhasker Reddy
Ranch Hand

Joined: Jun 13, 2000
Posts: 176
you got me wrong. I don't want to extract the file. I want the
file to download onto my local machine IN OTHER WORDS I WANT IT
FTP THE FILE FROM ORACLE/UNIX TO MY LOCAL MACHINE.
i WANT TO HAVE A BUTTON, WHICH WHEN CLICKED SHOULD BE ABLE TO
POP UP A DIALOG BOX ASKING TO SPECIFY THE DIRECTORY ON THE LOCAL MACHINE TO SAVE THE FILE.
THE FILE
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Download a file from the server using Java Servlet