aspose file tools*
The moose likes JDBC and the fly likes Working with Oracle BFiles... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Working with Oracle BFiles..." Watch "Working with Oracle BFiles..." New topic
Author

Working with Oracle BFiles...

Franck Tranchant
Ranch Hand

Joined: Aug 07, 2003
Posts: 75
Hi,
Did someone here already tried to develop something based on Oracle's BFILE (used to store a locator to a file outside the database, stored somewhere on the filesystem of the data server) ?
I found some basic infos on Advanced JDBC Samples @ Technet.oracle.com but all samples seem to use that kind of query :
INSERT INTO BFILE_TABLE VALUES (BFILENAME('BFILEDIR', 'myFile.gif'))
In this case, myFile.gif need to reside in the server in which database is running
So, I wonder if it's possible to manipulate Streams instead of files stored on the Database server...
Basically, I would like allow a user to upload a file from his Internet Explorer to the Database.
Do you think the 3 following steps are required ?
1- Upload from Client side to Server Side (WebLogic)
2- Upload from Server Side to Database Side (Oracle)
3- Execute the Insert query
Any info is welcome


Franck<p>--------------------
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Working with Oracle BFiles...
 
Similar Threads
image storage in a database table
File Upload Contents
Storing large image files
Java Upload file into database field
help needed